Relational database extenders for handling complex data types

Details Relational database extenders for handling complex data types Relational database extenders for handling complex data types

1998-07-13

2000-04-04

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 4, G06F 1730

Patent

active

06047291&

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 handles 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, and a fifth table containing the names of the second and third tables for each object defined in the first table.

REFERENCES:
patent: 4819152 (1989-04-01), Deerfield et al.
patent: 4959776 (1990-09-01), Deerfield et al.
patent: 5303367 (1994-04-01), Leenstra, Sr. et al.
patent: 5313630 (1994-05-01), Namioka et al.
patent: 5335346 (1994-08-01), Fabbio
patent: 5446575 (1995-08-01), Lysakowski, Jr. et al.
patent: 5499371 (1996-03-01), Henninger et al.
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: 5611076 (1997-03-01), Durflinger et al.
patent: 5615362 (1997-03-01), Jensen et al.
patent: 5617567 (1997-04-01), Doktor
patent: 5627979 (1997-05-01), Chang et al.
patent: 5652882 (1997-07-01), Doktor
patent: 5765147 (1998-06-01), Mattos et al.
patent: 5799310 (1998-08-01), Anderson et al.
patent: 5813014 (1998-09-01), Gustman
patent: 5857182 (1999-01-01), DeMichiel et al.
DeFazio et al. "Database Extensions for Complex Domains", Data Engineering, 1996 12.sup.th Int'l Conf., pp. 200-202.
Cheng et al. "An Efficient Hybrid Join Algorithm: A DB2 Prototype", Data Engineering, 1991 7.sup.th Int'l. Conf., pp. 171-180.
Gardarin et al. "Extending A Relational DBMS to Support Complex Objects". IEEE, pp. 131-137, 1989.
Farris, A. "Modeling Complex Astrophysics Data", Scientific and Statistical Database, 1994 7.sup.th Int'l Working Conference, pp. 149-158. Feb. 1994.
Schlatter et al. "The Business Object Management System", IBM Systems Journal, v. 33, n2, pp. 239-263, 1994.
Dai, Haihong "An Extended Object-Oriented Data Model for Complex Inter-Entity Relationships", TENCON '94 IEEE Region 10 Conf. on Frontiers, pp. 402-406, 1994.
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.
"Informix to Acquire Illustra", Illustra, Illustra Information Technologies, Dec. 20, 1995.
"Illustra Information Technologies: Technical Overview; Illustra: The DBMS for all of your data", Illustra, Illustra Information Technologies, no date.
Okon, Chris, "Image Recognition Meets Content Management for Authoring, Editing & More", Advanced Imaging, Jul. 1995, pp. 60-62.

Affiliated with

Also associated with

Rating

Relational database extenders for handling complex data types does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Relational database extenders for handling complex data types, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database extenders for handling complex data types will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-374240