US5799310A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database extenders for handling complex data types
Assignee: International Business Machines Corp
•
Filing: 1995-11-01
•
Granted: 1998-08-25
•
Expires: 2015-11-01
Abstract
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, and a fifth table containing the names of the second and third tables for each object defined in the first table.
Inventors
- 👤 Matthew Paul Anderson
- 👤 Siyi Terry Donn
- 👤 David Couttie Fallside
- 👤 Tri Q. Ha
- 👤 Douglas Michael Hembry
- 👤 Jean C. Ho
- 👤 Jing-Song Jang
- 👤 Nelson Mattos
- 👤 Carlton Wayne Niblack
- 👤 Dragutin Petkovic
- 👤 Frank Chin Tung
- 👤 Peter Paval Uhrowczik
- 👤 Mimi Phuong-Thao Thi Vo
- 👤 Gerald Johann Wilmot
- 👤 Peter C. Yanker
- 👤 Josephine Min-Kung Cheng
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 08:43
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/961; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 4
Claim 1
Independent Claim
171 words
A computer-readable storage medium storing a relational extender for a computer-based relational database, the relational extender providing the relational database with access to object data, comprising: a first table having a user defined application database, and at least one column dedicated to an object handle created by the user for defining the complex data type of an object; a second table containing at least one column defining a unique characteristic associated with said one object and one column dedicated to containing said object handle; a third table containing at least one column defining a common characteristic associated with all objects defined within said first table and one column dedicated to containing said object handle and at least one column dedicated to containing a reference to object data associated with said object; a fourth table storing each object handle and its associated complex data type as defined in said first table; and a fifth table containing the names of said second and third tables for each object defined in said first table.
Claim 2
Dependent Claim
171 words
A computer-readable storage medium storing a relational extender for a computer-based relational database, the relational extender providing the relational database with access to object data, comprising: a first table having a user defined application database, and at least one column dedicated to an object handle created by the user for defining the complex data type of an object; a second table containing at least one column defining a unique characteristic associated with said one object and one column dedicated to containing said object handle; a third table containing at least one column defining a common characteristic associated with all objects defined within said first table and one column dedicated to containing said object handle and at least one column dedicated to containing a reference to object data associated with said object; a fourth table storing each object handle and its associated complex data type as defined in said first table; and a fifth table containing the names of said second and third tables for each object defined in said first table.
Claim 3
Dependent Claim
51 words
A computer-readable storage medium storing a relational extender according to claim 1, further comprising a sixth table containing a reference to each object handle removed from said first table and including one column dedicated to containing a reference to the location of the object data associated with said removed object handle.
Claim 4
Dependent Claim
34 words
A computer-readable storage medium storing a relational extender according to claim 2, further comprising a seventh table having at least one column which describes a property of an object defined in said first table.
References Cited (Backward Citations)
US4819152A
Cited
US4959776A
Cited
US5335346A
Cited
US5313630A
Cited
US5652882A
Cited
US5617567A
Cited
US5604899A
Cited
US5303367A
Cited
US5446575A
Cited
US5579471A
Cited
US5499371A
Cited
US5615362A
Cited
US5627979A
Cited
US5611076A
Cited
US5553234A
Cited
US5546576A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-08-24 | 2002-02-23 | 2002-08-25 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-08-24 | 2006-02-23 | 2006-08-25 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-08-24 | 2010-02-23 | 2010-08-25 | $7700.00 | Window Closed / Lapsed |