Property extensions

• US 20020046211A1
• Filed: 12/07/2000
• Published: 04/18/2002
• Est. Priority Date: 08/30/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Osborn, Andrew, Fragapane, Paolo, Cave, Stephen David, Lavender, Robert Lloyd, Steadman, James Adam
• Granted Patent: US 6,810,399 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The present invention relates to a repository which stores properties of database objects. The repository includes a first store for storing a number of predetermined properties, and a second store for storing additional properties. A processor is provided for determining or modifying the properties stored in the first and second stores.

Claims

1. A repository which stores properties of database objects, the repository including:

a. a first store for storing a number of predetermined properties;

b. a second store for storing additional properties; and

,

c. a processor coupled to the first and second stores for determining or modifying the properties stored in the first and second stores for at least one of the database objects.

2. A repository according to claim 1, wherein the first store comprises a fixed table structure, the predetermined properties of each object being stored in a respective portion of the fixed table structure.

3. A repository according to claim 2, wherein the properties of each object are stored in a respective row of the fixed table structure, each property being stored in a respective column.

4. A repository according to claim 1, wherein the second store comprises a segmented table structure, the additional properties of each object being stored in one or more respective portions of the segmented table structure.

5. A repository according to claim 4, wherein the additional properties of each object are provided as an XML file.

6. A repository according to claim 5, wherein the XML file is divided into one or more segments, each segment being stored in a respective row of the segmented table structure.

7. A repository according to claim 6, wherein the processor is adapted to extract the additional properties from the second data store by extracting and recombining the segments of the XML file.

8. A repository according to claim 1, wherein the properties are stored as name-value pairs.

9. A repository according to claim 1, the repository being adapted to couple to at least one end station, the processor being adapted to provide the properties of at least one database object in response to a request from the end station.

10. A repository according to claim 9, wherein the repository is adapted to couple to at least one end station via a communications network.

11. A relational database system for providing information regarding database objects comprising a database for storing the database objects, the database being coupled to a repository according to claim 1.

12. A relational database system according to claim 11, the system further comprising a number of end stations coupled to the database and the repository via a communications network, the database and repository being responsive to requests from the end stations to provide information regarding the database objects.