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
method
records
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 WO2004099941A8 publication Critical patent/WO2004099941A8/en
Publication of WO2004099941A3 publication Critical patent/WO2004099941A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F1/00Details not covered by groups G06F3/00 – G06F13/00 and G06F21/00
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F7/00Methods or arrangements for processing data by operating upon the order or content of the data handled

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
WO2004099941A8 WO2004099941A8 (en) 2006-06-22
WO2004099941A3 true WO2004099941A3 (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
Franklin et al. From databases to dataspaces: a new abstraction for information management
Pratt Hot jobs in cool places. The material cultures of new media product spaces: the case of south of the market, San Francisco
US8131533B2 (en) Reporting model generation within a multidimensional enterprise software system
US9639814B2 (en) Automated default dimension selection within a multidimensional enterprise software system
Yuan Use of a Three‐Domain Repesentation to Enhance GIS Support for Complex Spatiotemporal Queries
Kavouras et al. A method for the formalization and integration of geographical categorizations
US7610300B2 (en) Automated relational schema generation within a multidimensional enterprise software system
US7593955B2 (en) Generation of aggregatable dimension information within a multidimensional enterprise software system
WO2006005001A3 (en) Method and system for automated intelligent electronic advertising
WO2003098479A3 (en) Managing search expressions in a database system
WO2006012316A3 (en) Methods and systems for indexing files and adding associated metadata to index and metadata databases
EP0818743A3 (en) Generalized key indexes
WO2006004680A3 (en) Ecosystem method of aggregation and search and related techniques
WO2005013157A3 (en) Dynamic reassignment of data ownership
WO2006101770A3 (en) System and method for remotely inputting and retrieving records and generating reports
WO2001098874A3 (en) Electronic virtual certification by data processing method via a communication network
WO2003067474A3 (en) Search-on-the fly report generator
Batcheller Automating geospatial metadata generation—An integrated data management and documentation approach
AU2002334721A1 (en) An index structure to access hierarchical data in a relational database system
WO2008154074A1 (en) Federated ontology index to enterprise knowledge
WO2000067194A3 (en) Method and apparatus for scalable probabilistic clustering using decision trees
WO2003088087A3 (en) Media object management
WO2004114160A3 (en) Systems and processes for automated criteria and attribute generation, searching, auditing and reporting of data
MX9709864A (en) Computer system for creating semantic object models from existing relational database schemas.
CA2303634A1 (en) System and method for instant consolidation, enrichment, delegation and reporting in a multidimensional database

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