Data processing: database and file management or data structures – Database design – Data structure types
Patent
1995-06-07
2000-06-20
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707 2, 707 3, G06F 1730
Patent
active
060789255
ABSTRACT:
This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, a fifth table containing the names of the second and third tables for each object defined in the first table, a sixth table containing a reference to each object handle removed from the first table and including one column dedicated to containing a reference to the location of the object data associated with the removed object handle, and a seventh table having at least one column which describes a property of the data type of each object defined in the first table. The relational extender further includes an eighth table as a temporary holding table for the second table, and a ninth table as a temporary holding table for the third table. Both the eighth and ninth tables are used in conjunction with the extender triggers to ensure data integrity.
REFERENCES:
patent: 4819152 (1989-04-01), Deerfield et al.
patent: 4959776 (1990-09-01), Deerfield et al.
patent: 5313630 (1994-05-01), Namioka et al.
patent: 5335346 (1994-08-01), Fabbio
patent: 5446575 (1995-08-01), Lysakwski, Jr.
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5553234 (1996-09-01), Cotner et al.
patent: 5579471 (1996-11-01), Barber et al.
patent: 5604899 (1997-02-01), Doktor
patent: 5617567 (1997-04-01), Doktor
patent: 5627979 (1997-05-01), Chang et al.
patent: 5652882 (1997-07-01), Doktor
patent: 5765159 (1998-06-01), Srinivasan
patent: 5893108 (1999-04-01), Srinivasan et al.
Farris, A. "Modeling Complex Astrophysics Data", Scientific and Statistical Database, Jan. 1994 7th Int'l Working Conference, pp. 149-158.
Schlatter et al. "The Business Object Management System", IBM Systems Journal, v. 33, n2, pp. 239-263., Jan. 1994.
Dai, Haihong "An Extended Object-Oriented Data Model for Complex Inter-Entity Relationships", TENCON Jan. 1994 IEEE Region 10 Conf. on Frontiers, pp. 402-406.
Chang et al. "A Universal Relation Data Model with Semantic Abstractions", IEEE Transactions on Knowledge and Data Engineering, v.4, n.1, pp. 23-33, Feb. 1992.
DeFazio et al. "Database Extensions for Complex Domains", Data Engineering, Jan. 1996 12th Int'l. Conf., pp. 200-202.
Cheng et al. "An Efficient Hybrid Join Algorithm: A DB2 Prototype", Data Engineering, Jan. 1991 7th In't. Conf., pp. 171-180.
Gardarin et al. "Extending A Relational DBMS to Support Complex Objects", IEEE, pp. 131-137, Jan. 1989.
Anderson Matthew Paul
Cheng Josephine Min-Kung
Donn Siyi Terry
Fallside David Couttie
Ha Tri Quac
Amsbury Wayne
International Business Machines - Corporation
Johnson Prentiss
Lewis Cheryl
LandOfFree
Computer program product for database relational extenders does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Computer program product for database relational extenders, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer program product for database relational extenders will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1863282