Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-09-29
1999-10-26
Lintz, Paul R.
Data processing: database and file management or data structures
Database design
Data structure types
707 1, 707100, G06F 1730
Patent
active
059744073
ABSTRACT:
The invention is directed to a computer implemented system and apparatus for construction of a Hierarchical Database Management System (HDBMS) using a commercially available Relational Database Management System (RDBMS) as the implementing apparatus. The invention uses one or more RDBMS tables to store rows of a hierarchical database implemented by the HDBMS. Composite keys, unique over all the tables, are used to maintain hierarchical families and maintain the hierarchical parent/child relationships within families. Root conditions and child conditions may be used to determine which tables may be used for adding root row starting a new family, and which tables may be used for adding a child row of a selected parent row. SQL select queries present hierarchical views of the hierarchical database. SQL action queries are used to perform the database functions of insert root, insert child, update row, and delete row and its descendents. Both relational databases and hierarchical databases can be implemented in the same application using the RDBMS and the imbedded HDBMS together, and standard RDBMS SQL can be used to process the hierarchical and relational data in an integrated manner.
REFERENCES:
patent: 4429385 (1984-01-01), Cichelli et al.
patent: 5201046 (1993-04-01), Goldberg et al.
patent: 5201047 (1993-04-01), Maki et al.
patent: 5295261 (1994-03-01), Simonetti
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5467471 (1995-11-01), Bader
patent: 5504885 (1996-04-01), Alashqur
patent: 5581756 (1996-12-01), Nakabayashi
patent: 5724577 (1998-03-01), Exley et al.
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5787425 (1998-07-01), Bigus
Joe Celko, SQL for Smarties, 1995, pp. 333-360. Morgan Stanley Publishers, San Francisco, California.
Thomas A. Bruce, Designing Quality Databases with IDEF1X Information Models, p. 530, Dorset House Publishing, New York, New York (1992) p. 530.
Grayson George
Lintz Paul R.
LandOfFree
Method and apparatus for implementing a hierarchical database ma does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for implementing a hierarchical database ma, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for implementing a hierarchical database ma will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-775345