Patent US775258A successfully refreshed from Google Patents.
US6047291A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database extenders for handling complex data types
Assignee: International Business Machines Corp
•
Filing: 1998-07-13
•
Granted: 2000-04-04
•
Expires: 2018-07-13
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 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.
Inventors
- 👤 Matthew Paul Anderson
- 👤 Siyi Terry Donn
- 👤 David Couttie Fallside
- 👤 Tri Quac 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-30 01:54
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: 18
Claim 1
Independent Claim
181 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 of a complex data type, comprising: a first table having a user defined application database, and at least one column dedicated to containing an object handle uniquely identifying an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; a second table containing at least one column defining a unique characteristic associated with said 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 the object data associated with said object; and a function strongly typed against the complex data type wherein the function takes the object handle as a parameter and manipulates the object data.
Claim 2
Dependent Claim
181 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 of a complex data type, comprising: a first table having a user defined application database, and at least one column dedicated to containing an object handle uniquely identifying an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; a second table containing at least one column defining a unique characteristic associated with said 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 the object data associated with said object; and a function strongly typed against the complex data type wherein the function takes the object handle as a parameter and manipulates the object data.
Claim 3
Dependent Claim
28 words
A relational extender according to claim 1, further comprising a fourth table storing the object handle and its associated complex data type as defined in said first table.
Claim 4
Dependent Claim
29 words
A relational extender according to claim 2, further comprising a fifth table containing the names of said second and third tables for the object defined in said first table.
Claim 5
Dependent Claim
46 words
A relational extender according to claim 3, further comprising a sixth table containing a reference to an object handle removed from said first table and including one column dedicated to containing a reference to a location of the object data associated with said removed object handle.
Claim 6
Dependent Claim
29 words
A relational extender according to claim 4, further comprising a seventh table having at least one column which describes a property of the object defined in said first table.
Claim 7
Independent Claim
173 words
A method of providing a computer-based relational database access to object data of a complex data type, said method comprising the steps of: dedicating at least one column of a first table having a user defined application database to containing an object handle uniquely identifyingy an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; dedicating one column to containing said object handle in a second table containing at least one column defining a unique characteristic associated with said object; dedicating at least one column to containing a reference to the object data associated with said object in 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 manipulating the object data by a function strongly typed against the complex data type wherein the function takes the object handle as a parameter.
Claim 8
Independent Claim
173 words
A method of providing a computer-based relational database access to object data of a complex data type, said method comprising the steps of: dedicating at least one column of a first table having a user defined application database to containing an object handle uniquely identifyingy an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; dedicating one column to containing said object handle in a second table containing at least one column defining a unique characteristic associated with said object; dedicating at least one column to containing a reference to the object data associated with said object in 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 manipulating the object data by a function strongly typed against the complex data type wherein the function takes the object handle as a parameter.
Claim 9
Dependent Claim
27 words
A method according to claim 6, further comprising a fourth table storing the object handle and its associated complex data type as defined in said first table.
Claim 10
Dependent Claim
28 words
A method according to claim 7, further comprising a fifth table containing the names of said second and third tables for the object defined in said first table.
Claim 11
Dependent Claim
45 words
A method according to claim 8, further comprising a sixth table containing a reference to an object handle removed from said first table and including one column dedicated to containing a reference to a location of the object data associated with said removed object handle.
Claim 12
Dependent Claim
28 words
A method according to claim 9, further comprising a seventh table having at least one column which describes a property of the object defined in said first table.
Claim 13
Dependent Claim
168 words
A relational database system for accessing object data of a complex data type, said relational database system comprising: a first table having a user defined application database, and at least one column dedicated to containing an object handle uniquely identifying an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; a second table containing at least one column defining a unique characteristic associated with said 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 the object data associated with said object; and a function strongly typed against the complex data type wherein the function takes the object handle as a parameter and manipulates the object data.
Claim 14
Dependent Claim
168 words
A relational database system for accessing object data of a complex data type, said relational database system comprising: a first table having a user defined application database, and at least one column dedicated to containing an object handle uniquely identifying an object associated with the object data, the object handle and the at least one column of the first table both having a data type of the complex data type; a second table containing at least one column defining a unique characteristic associated with said 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 the object data associated with said object; and a function strongly typed against the complex data type wherein the function takes the object handle as a parameter and manipulates the object data.
Claim 15
Dependent Claim
29 words
A relational database system according to claim 11, further comprising a fourth table storing the object handle and its associated complex data type as defined in said first table.
Claim 16
Dependent Claim
30 words
A relational database system according to claim 12, further comprising a fifth table containing the names of said second and third tables for the object defined in said first table.
Claim 17
Dependent Claim
47 words
A relational database system according to claim 13, further comprising a sixth table containing a reference to an object handle removed from said first table and including one column dedicated to containing a reference to a location of the object data associated with said removed object handle.
Claim 18
Dependent Claim
30 words
A relational database system according to claim 14, further comprising a seventh table having at least one column which describes a property of the 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
US5799310A
Cited
US5813014A
Cited
US5765147A
Cited
US5857182A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-04-04 | 2003-10-04 | 2004-04-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-04-04 | 2007-10-04 | 2008-04-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-04-04 | 2011-10-04 | 2012-04-04 | $7700.00 | Window Closed / Lapsed |