WO1999013419B1 - Method and system for managing information using a relational database - Google Patents
Method and system for managing information using a relational databaseInfo
- Publication number
- WO1999013419B1 WO1999013419B1 PCT/US1998/018767 US9818767W WO9913419B1 WO 1999013419 B1 WO1999013419 B1 WO 1999013419B1 US 9818767 W US9818767 W US 9818767W WO 9913419 B1 WO9913419 B1 WO 9913419B1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- storing
- data items
- relational database
- associating
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/289—Object oriented databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method and system for managing information by storing object data in a relational database. The method includes the steps of storing a separate data table in a relational database for each of a plurality of data types; associating a unique object identifier (OID) to an object; and defining the object using a plurality of data items. Each of the plurality of data items is one of the plurality of data types. After the object has been assigned an OID, the OID is associated with each of the plurality of data items defining the object. Each of the plurality of data items and the associated OID are stored in respective ones of the data tables according to data type.
Claims
- 20 - AMENDED CLAIMS
[received by the International Bureau on 9 March 1999 (09.03.99); original claims 1-7 amended; new claims 10-19 added, remaining claims unchanged (5 pages)] 1 A method for managing data, comprising the steps of storing a separate data table in a relational database for each of a plurality of data types. associating a first unique object identifier with a first object, defimng the first object usmg a first plurality of data items, each of the first plurality of data items bemg one of the plurality of data types, associating the first umque object identifier with each of the first plurality of data items, and stoπng each of the first plurality of data items m respective ones of the data tables according to data type
2 The method of claim 1, further comprising the steps of defimng the first object usmg an additional data item, the addiUonal data item bemg one of the plurality of data types, associating the first umque object identifier with the addiUonal data item, and stoπng the addiUonal data item m one of the data tables accordmg to data type
3 The method of claim 1, further compπsmg the step of generating, subsequent to the stoπng of the first plurality of data items, a representanon of the first object by collecting each data item associated with the first umque object identifier
4 The method of claim 1 , further compπsmg the steps of associating a second umque object identifier with a second object, defimng the second object usmg a second plurality of data items, each of the second plurality of data items bemg one of the plurality of data types, associating the second umque object identifier with each of the second plurality of data items, and - 21 -
storing each of the second plurality of data items in respective ones of the data tables according to data type.
5. A method for managing data, comprising the steps of: storing a separate data table in a relational database for each of a plurality of data types; associating a unique object identifier with each of a plurality of objects; defining each of the plurality of objects using a plurality of data items, each of the plurality of data items being one of the plurality of data types; for each of the plurality of objects, associating the unique object identifier associated with the object with each of the plurality of data items defining the object; and storing each of the plurality of data items in respective ones of the data tables according to data type.
6. A method of building a hierarchy of objects in a relational database, comprising the steps of: stormg a separate data table in a relational database for each of a plurality of data types; associating a unique object identifier with each of a plurality of objects; defining each of the plurality of objects using a plurality of data items, each of the plurality of data items being one of the plurality of data types; for each of the plurality of objects, associating the unique object identifier associated with the object with each of the plurality of data items defining the object; storing each of the plurality of data items in respective ones of the data tables according to datatype; and defining a relationship between selected ones of the plurality of objects to create a hierarchy of objects.
7. An apparatus for managing data, comprising: a first memory storing a first object and an associated object identifier; and - 22 -
a second memory storing a separate data table in a relational database for each of a plurality of data types; wherein the first object is defined by a plurality of data items, each of the plurality of data items being associated with a respective one of the plurality of data types; and wherein each of the plurality of data items is stored in a respective one of the plurality of data tables and is associated with the object identifier.
8. The apparatus of claim 7, further comprising: a processor in electrical communication with the first memory and the second memory, the processor generating a representation of the first object by accessing each data item associated with the object identifier.
9. The apparatus of claim 7 wherein the first memory further stores a second object and an indicia of relationship with the first object.
10. The method of claim 1 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing an attribute data table for attributes which may be used to define the first object.
11. The method of claim 1 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing a policy data table for policies which may be used to define the first object.
12. The method of claim 1 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing a state data table for states which may be used to define a status of the first object.
13. The method of claim 1 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing a method table for methods which may be used to operate on the first plurality of data items def ing the first object.
14. The method of claim 13, further comprising the steps of: - 23 -
storing in the method table a method for operating on the first plurality of data items; and associating the method with the first object.
15. The method of claim 1 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing a relationship data table for relationships which may be used to relate the first object to other objects in the relational database.
16. The method of claim 1 further comprising the step of storing an information table which inteπelates the data tables and wherein the step of associating the first unique object identifier with each of the first plurality of data items further comprises the step of associating the first unique object identifier with each of the first plurality of data items through entries in the information table.
17. A method for creating a new object type from an existing object type stored in a relational database, comprising the steps of: storing a separate data table in a relational database for each of a plurality of data types; associating a unique object identifier with a first object type; defining the first object type using a plurality of data items, each of the plurality of data items being one of the plurality of data types; associating the unique object identifier with each of the plurality of data items; storing each of the plurality of data items in respective ones of the data tables according to data type; creating a second object type by inheriting the plurality of data items defining the first object type; and further defining the second object type using a data item not within the plurality of data items.
18. The method of claim 17 wherein the step of storing a data table in a relational database for each of a plurality of data types further comprises the step of storing a method data table for - 24 -
methods which may be used to operate on the plurality of data items defining the first object type, the method further comprising the steps of: storing in the method table a method for operating on the plurality data items; and associating the method with the first object type, wherein the step of creating a second object type further comprises the step of inheriting the method associated with the first object type.
19. The method of claim 6 wherein the step of storing a separate data table for each of a plurality of data types further comprises the step of storing a relationship table for relationships which may be used to relate the plurality of objects in the relational database and wherein the step of defining a relationship between selected ones of the plurality of objects further comprises the steps of: creating an entry in the relationship table which interrelates two of the plurality of objects; and storing an additional data item with the entry.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| AU93812/98A AU9381298A (en) | 1997-09-09 | 1998-09-09 | Method and system for managing information using a relational database |
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US92614997A | 1997-09-09 | 1997-09-09 | |
| US08/926,149 | 1997-09-09 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| WO1999013419A1 WO1999013419A1 (en) | 1999-03-18 |
| WO1999013419B1 true WO1999013419B1 (en) | 1999-05-06 |
Family
ID=25452819
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| PCT/US1998/018767 WO1999013419A1 (en) | 1997-09-09 | 1998-09-09 | Method and system for managing information using a relational database |
Country Status (2)
| Country | Link |
|---|---|
| AU (1) | AU9381298A (en) |
| WO (1) | WO1999013419A1 (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7003524B1 (en) * | 2001-03-14 | 2006-02-21 | Polymorphic Data Corporation | Polymorphic database |
| EP1585032A1 (en) | 2004-04-05 | 2005-10-12 | Sap Ag | A computer system, method and program for the uniform access to configurable objects derived from disparate sources |
| WO2009144942A1 (en) * | 2008-05-30 | 2009-12-03 | 日本電気株式会社 | Database system, database management method, database structure, and computer program |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5295256A (en) * | 1990-12-14 | 1994-03-15 | Racal-Datacom, Inc. | Automatic storage of persistent objects in a relational schema |
| US5261098A (en) * | 1991-08-28 | 1993-11-09 | Sun Microsystems, Inc. | Method and apparatus for deriving object type and obtaining object type attribute values |
-
1998
- 1998-09-09 WO PCT/US1998/018767 patent/WO1999013419A1/en active Application Filing
- 1998-09-09 AU AU93812/98A patent/AU9381298A/en not_active Abandoned
Also Published As
| Publication number | Publication date |
|---|---|
| AU9381298A (en) | 1999-03-29 |
| WO1999013419A1 (en) | 1999-03-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5357631A (en) | Method and system for creating and maintaining multiple document versions in a data processing system library | |
| DE60220676T2 (en) | CONSISTENT READING IN A DISTRIBUTED DATABASE ENVIRONMENT | |
| CA2259544A1 (en) | Extensible indexing | |
| CA2117846A1 (en) | Computer Method and Storage Structure for Storing and Accessing Multidimensional Data | |
| CA2493269A1 (en) | Method and system of unifying data | |
| CA2244627A1 (en) | Method and apparatus for managing electronic money and storage medium for storing an electronic money management program | |
| WO1996021324A3 (en) | Method for comparing attribute values of controllable object expressions in a network element | |
| EP1030494B1 (en) | Communication unit and communication method with profile management | |
| CA2149467A1 (en) | Temporary Storage of Authentication Information Throughout a Personal Communication System | |
| CA2296114A1 (en) | Database structure and management | |
| US6957234B1 (en) | System and method for retrieving data from a database using a data management system | |
| WO1999013419B1 (en) | Method and system for managing information using a relational database | |
| US7953756B1 (en) | Unified high-performance database connectivity system and method | |
| US7409380B1 (en) | Facilitated reuse of K locations in a knowledge store | |
| JP2827562B2 (en) | Management of a subset of database objects | |
| CN107729579A (en) | Database separate design method and device | |
| US20060083178A1 (en) | System and method for processing performance management data using single table | |
| US6622146B1 (en) | System managing method and apparatus for decreasing a load applied to a common processing unit | |
| CA2607495A1 (en) | System and method for efficient hosting of wireless applications by encoding application component definitions | |
| CN116303458B (en) | Management method for data objects in handle system | |
| CN101989280A (en) | Method and system for managing configuration resources | |
| KR100345445B1 (en) | Method for managing t-tree index key in main memory dbms | |
| JP2872340B2 (en) | Network configuration management method | |
| JPH06232867A (en) | User service profile information access system | |
| JPH05307501A (en) | Distributed management method for duplicate data information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| AK | Designated states |
Kind code of ref document: A1 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HR HU ID IL IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG UZ VN YU ZW |
|
| AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
| AK | Designated states |
Kind code of ref document: B1 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HR HU ID IL IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG UZ VN YU ZW |
|
| AL | Designated countries for regional patents |
Kind code of ref document: B1 Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
| 121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
| DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
| NENP | Non-entry into the national phase in: |
Ref country code: KR |
|
| REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
| 122 | Ep: pct application non-entry in european phase | ||
| NENP | Non-entry into the national phase in: |
Ref country code: CA |