Logical groupings within a database

• US 6,006,234 A
• Filed: 10/31/1997
• Issued: 12/21/1999
• Est. Priority Date: 10/31/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Kotsovolos, Susan, Krishnan, Ramkumar, Wijaya, Joyo, Govindarajan, Rajagopalan
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US08/962,531
• Time in Patent Office: 781 Days
• Field of Search: 707/3, 707/4, 707/10, 707/101, 707/102, 707/103, 707/104, 370/249, 709/303, 341/65
• US Class Current: 1/1
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method, system and computer-readable medium is provided for grouping database objects into logical groupings in order to simplify administrative and other operations that need to be performed by the database server. Such operations can be performed once at the logical group level for a group of related objects, as opposed to at the individual database object level. For increased flexibility, the logical groupings need not dictate the format, schema or location of their members. A hierarchy may be established between the logical groupings, where child groupings inherit some or all of the properties of the parent groupings. A correspondence may be established between some groupings and operating system directories, allowing identifiers associated with the groupings to be used as aliases for the full operating system paths to the corresponding directories.

Claims

1. A method for grouping database objects in a database, the method comprising the steps of:

establishing within a database a plurality of logical groups whose memberships are not restricted by schema boundaries;

receiving data that identifies one or more database objects, and

a logical group, of said plurality of logical groups, to which said one or more database objects are to belong;

in response to receiving said data, performing the steps of

establishing said one or more database objects as members of said logical group, and

storing data within said database to indicate that said one or more database objects are members of said logical group.

2. The method of claim 1 wherein said step of establishing said one or more database objects as members of said logical group includes establishing a subset of schema objects of a particular schema as members of said logical group.

3. The method of claim 1 wherein said step of establishing said one or more database objects as members of said logical group includes establishing schema objects from a plurality of schemas as members of said logical group.

4. The method of claim 1 wherein said step of establishing said one or more database objects as members of said logical group includes establishing at least one but not all of the data items within a schema object as a member of said logical group.

5. The method of claim 1 wherein:

said step of receiving data includes the steps of

receiving data that specifies a first database object that is stored outside said database in a first operating system directory; and

receiving data that specifies a second database object that is stored outside said database in a second operating system directory that is different than said first operating system directory; and

said step of establishing includes establishing both said first database object and said second database object as members of said logical group.

6. The method of claim 1 wherein:

said step of receiving data includes the step of receiving data that specifies a first database object that is stored outside said database in a first operating system directory;

said step of establishing includes establishing said first database object as a member of said logical group;

the method further includes the steps of

receiving data that identifies

a second database object that is stored outside said database in said first operating system directory; and

a second logical group; and

establishing said second database object as a member of said second logical group.

7. The method of claim 1 further comprising the steps of:

receiving a statement that specifies an operation and said logical group; and

performing said operation on all members of said logical group.

8. The method of claim 1 further comprising the steps of:

receiving data that identifies a second logical group of said plurality of logical groups;

receiving data that specifies a relationship between said logical group and said second logical group; and

storing data that indicates that said relationship exists between said logical group and said second logical group.

9. The method of claim 8 wherein:

said relationship specifies that said logical group is a parent of said second logical group; and

said logical group is considered to include all members of said second logical group in response to said logical group being a parent of said second logical group.

10. The method of claim 8 wherein said relationship causes said second logical group to inherit properties of said logical group.

11. The method of claim 10 wherein said second logical group overrides at least one property of said logical group.

12. The method of claim 1 further comprising the step of establishing a correlation between said logical group and an operating system directory.

13. The method of claim 12 further comprising the step of performing an operation on a database object that belongs to said logical group in response to a statement that uses an identifier of said logical group as an alias to identify said operating system directory as the location storing said database object.

14. The method of claim 8 wherein:

said relationship specifies that said logical group is a parent of said second logical group; and

the method further comprises the step of establishing a third logical group as a second parent of said second logical group.

15. A computer-readable medium carrying one or more sequences of instructions for grouping database objects in a database, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

establishing, within said database, a plurality of logical groups whose memberships are not restricted by schema boundaries;

receiving data that identifies

one or more database objects, and

a logical group, of said plurality of logical groups, to which said one or more database objects are to belong;

in response to receiving said data, performing the steps of

establishing said one or more database objects as members of said logical group, and

storing data within said database to indicate that said one or more database objects are members of said logical group.

16. The computer-readable medium of claim 15 wherein:

said step of receiving data includes the steps of

receiving data that specifies a first database object that is stored outside said database in a first operating system directory; and

receiving data that specifies a second database object that is stored outside said database in a second operating system directory that is different than said first operating system directory; and

said step of establishing includes establishing both said first database object and said second database object as members of said logical group.

17. The computer-readable medium of claim 15 wherein:

said step of receiving data includes the step of receiving data that specifies a first database object that is stored outside said database in a first operating system directory;

said step of establishing includes establishing said first database object as a member of said logical group;

the computer-readable medium further includes instructions for performing the steps of

receiving data that identifies

a second database object that is stored outside said database in said first operating system directory; and

a second logical group; and

establishing said second database object as a member of said second logical group.

18. The computer-readable medium of claim 15 further comprising instructions for performing the steps of:

receiving a statement that specifies an operation and said logical group; and

performing said operation on all members of said logical group.

19. The computer-readable medium of claim 15 further comprising instructions for performing the steps of:

receiving data that identifies a second logical group;

receiving data that specifies a relationship between said logical group and said second logical group; and

storing data that indicates that said relationship exists between said logical group and said second logical group.

20. The computer-readable medium of claim 19 wherein:

said relationship specifies that said logical group is a parent of said second logical group; and

said logical group is considered to include all members of said second logical group in response to said logical group being a parent of said second logical group.

21. The computer-readable medium of claim 19 wherein said relationship causes said second logical group to inherit properties of said logical group.

22. The computer-readable medium of claim 21 wherein said second logical group overrides at least one property of said logical group.

23. The computer-readable medium of claim 15 further comprising instructions for performing the step of establishing a correlation between said logical group and an operating system directory.

24. The computer-readable medium of claim 23 further comprising instructions for performing an operation on a database object that belongs to said logical group in response to a statement that uses an identifier of said logical group as an alias to identify said operating system directory as the location storing said database object.

25. The computer-readable medium of claim 19 wherein:

said relationship specifies that said logical group is a parent of said second logical group; and

the computer-readable medium further comprises instructions for performing the step of establishing a third logical group as a second parent of said second logical group.