WO2004099941A3 - Method of recursive objects for representing hierarchies in relational database systems - Google Patents

Method of recursive objects for representing hierarchies in relational database systems Download PDF

Info

Publication number
WO2004099941A3
WO2004099941A3 PCT/US2004/000395 US2004000395W WO2004099941A3 WO 2004099941 A3 WO2004099941 A3 WO 2004099941A3 US 2004000395 W US2004000395 W US 2004000395W WO 2004099941 A3 WO2004099941 A3 WO 2004099941A3
Authority
WO
WIPO (PCT)
Prior art keywords
relation
record
aggregate
records
relational database
Prior art date
Application number
PCT/US2004/000395
Other languages
French (fr)
Other versions
WO2004099941A8 (en
WO2004099941A2 (en
Inventor
Robert Pecherer
Original Assignee
Robert Pecherer
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Robert Pecherer filed Critical Robert Pecherer
Priority to PCT/US2004/000395 priority Critical patent/WO2004099941A2/en
Publication of WO2004099941A2 publication Critical patent/WO2004099941A2/en
Publication of WO2004099941A3 publication Critical patent/WO2004099941A3/en
Publication of WO2004099941A8 publication Critical patent/WO2004099941A8/en

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/284—Relational databases
    • G06F16/288—Entity relationship models

Abstract

A method is described for creating and managing a two-level hierarchical data structure. Parent and child object relation tables, an aggregate relation table and a link relation table having records are created wherein each link relation record has an aggregate identity field and a child object identity field and the aggregate relation records have a parent object identity field pointing to a parent object relation record. The link relation records have an aggregate identity field pointing to an aggregate relation record and to a child object relation record whereby zero or more child object relation records are linked to a parent object record relation record.
PCT/US2004/000395 2004-01-08 2004-01-08 Method of recursive objects for representing hierarchies in relational database systems WO2004099941A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
PCT/US2004/000395 WO2004099941A2 (en) 2004-01-08 2004-01-08 Method of recursive objects for representing hierarchies in relational database systems

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/US2004/000395 WO2004099941A2 (en) 2004-01-08 2004-01-08 Method of recursive objects for representing hierarchies in relational database systems

Publications (3)

Publication Number Publication Date
WO2004099941A2 WO2004099941A2 (en) 2004-11-18
WO2004099941A3 true WO2004099941A3 (en) 2006-06-22
WO2004099941A8 WO2004099941A8 (en) 2006-06-22

Family

ID=33434822

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/000395 WO2004099941A2 (en) 2004-01-08 2004-01-08 Method of recursive objects for representing hierarchies in relational database systems

Country Status (1)

Country Link
WO (1) WO2004099941A2 (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP2074531A1 (en) 2006-10-10 2009-07-01 Richard Chappuis Information processing method

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5974407A (en) * 1997-09-29 1999-10-26 Sacks; Jerome E. Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus
US6064999A (en) * 1994-06-30 2000-05-16 Microsoft Corporation Method and system for efficiently performing database table aggregation using a bitmask-based index
US6236988B1 (en) * 1997-09-05 2001-05-22 International Business Machines Corp. Data retrieval system
US20030004959A1 (en) * 1999-10-15 2003-01-02 University Of Strathclyde Database processor
US6704744B1 (en) * 1994-12-07 2004-03-09 Next Computer, Inc. Method and apparatus for mapping objects to multiple tables of a database

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6064999A (en) * 1994-06-30 2000-05-16 Microsoft Corporation Method and system for efficiently performing database table aggregation using a bitmask-based index
US6704744B1 (en) * 1994-12-07 2004-03-09 Next Computer, Inc. Method and apparatus for mapping objects to multiple tables of a database
US6236988B1 (en) * 1997-09-05 2001-05-22 International Business Machines Corp. Data retrieval system
US5974407A (en) * 1997-09-29 1999-10-26 Sacks; Jerome E. Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus
US20030004959A1 (en) * 1999-10-15 2003-01-02 University Of Strathclyde Database processor

Also Published As

Publication number Publication date
WO2004099941A8 (en) 2006-06-22
WO2004099941A2 (en) 2004-11-18

Similar Documents

Publication Publication Date Title
EP1164511A3 (en) Method of managing slowly changing dimensions
WO2002025471A3 (en) Method and apparatus for structuring, maintaining, and using families of data
WO2005098593A3 (en) Custom entities and fields in a multi-tenant database system
WO2008060860A3 (en) A method of improving a query to a database system
WO2006059251A3 (en) Electronic mail indexing systems and methods
CA2477126A1 (en) Support for multiple content-management data models
WO2005029364A8 (en) System and method for managing dynamic content assembly
WO2005031514A3 (en) Query optimization in a multi-tenant database system
Kim et al. A spatiotemporal database model and query language
CN101719135A (en) Administrative resource catalog control system and method
EP1081611A3 (en) Query engine and method for Querying data using metadata model
WO2003054694A3 (en) Method and system for attribute management in a namespace
WO2005043291A3 (en) Automated financial transaction due diligence systems and methods
CN104462361B (en) The method and apparatus of data in a kind of matched data table
WO2000062195A3 (en) Computer system
WO2003079139A3 (en) System, method, and computer program product for network-based part management system
WO2003021483A3 (en) Database systems, methods and computer program products using type based selective foreign key association to represent multiple but exclusive relationships in relational databases
SE0202593D0 (en) A Computer program product and associated methods for searching a database of objects, connecting objects in such a database, and exporting data from at least arbitrary database
CN104731908A (en) ETL-based data cleaning method
WO2004099941A8 (en) Method of recursive objects for representing hierarchies in relational database systems
CN100547591C (en) Method for calling relational database-based database abstraction layer by application layer
CN205158357U (en) Farmland contracting power of management database management system
Vermeer Semantic interoperability for legacy databases.
Nadi et al. Toward a general spatio-temporal database structure for GIS applications
Wang et al. A spatio-temporal data model based on the parcel in cadastral

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
CFP Corrected version of a pamphlet front page
CR1 Correction of entry in section i

Free format text: IN PCT GAZETTE 47/2004 UNDER (30) DELETE "10/428,594, 2 MAY 2003 (02.05.2003), US"

122 Ep: pct application non-entry in european phase