US 12,450,235 B2
Method and apparatus for representing a group hierarchy structure in a relational database
Paul-Vlad Tatavu, Ontario (CA); and Joseph Paul Wigglesworth, Ontario (CA)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Nov. 6, 2019, as Appl. No. 16/675,483.
Application 16/675,483 is a continuation of application No. 11/491,427, filed on Jul. 21, 2006, granted, now 10,503,736.
Prior Publication US 2020/0073870 A1, Mar. 5, 2020
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/245 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24553 (2019.01) 24 Claims
OG exemplary drawing
 
1. A computer implemented method for managing a database, the computer implemented method comprising:
receiving a request for a list of members for a given group of objects associated with the database;
identifying a set of static members for the given group of objects, wherein the set of static members for the given group of objects includes all direct static members of the given group and all indirect static members of the given group;
identifying a set of dynamic members for the given group of objects defined by a set of common attributes, wherein the set of dynamic members includes all direct dynamic members of the given group and all indirect static members of the given group; and
generating the list of members using a single query to the database, wherein the list of members includes the set of static members and the set of dynamic members and wherein the list of members is used to manage the database.