Property extensions

• US 6,810,399 B2
• Filed: 12/07/2000
• Issued: 10/26/2004
• 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
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Mahmoudi, Hassan
• Application Number:
  US09/730,724
• Publication Number:
  US 20020046211A1
• Time in Patent Office: 1,419 Days
• Field of Search: 707/10, 707/514, 707/101, 707/202, 707/200, 707/204, 707/500, 707/1, 707/2, 707/3, 707/104.1, 707/513, 707/5, 709/201
• US Class Current: 1/1
• 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 objects, the repository including:

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

b. a second store for storing additional properties, the first store and the second store being provided within the repository, 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, wherein the additional properties of each object are provided as an XML file, wherein the XML file is divided into one or more segments, each segment being stored in a respective row of the segmented table structure, wherein the entire XML file is stored in the segmented table structure, and wherein each segment has an associated sequence identifier indicating a sequence of the segments in the XML file 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 processor is adapted to extract the additional properties from the second data store by extracting and recombining the segments of the XML file in accordance with the sequence identifiers associated with the segments.

3. A repository according to claim 2, 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.

4. A repository according to claim 3, 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.

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

6. 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.

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

8. 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.

9. A relational database system according to claim 8, 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.