US6502086B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Mapping binary objects in extended relational database management systems with relational registry
Assignee: International Business Machines Corp
•
Filing: 1999-01-04
•
Granted: 2002-12-31
•
Expires: 2019-01-04
Abstract
Abstract An automated data processing system includes a relational database engine, storage devices having a database table, registry and binary large objects created and updated by the relational database engine and a user defined function engine retrieving data elements stored in the binary large objects. The registry includes data element classifications. The database table includes relational information of the data elements, the data element classifications and pointers to the binary large objects, and the relational database engine creates and updates the binary large objects based on the database table and the registry.
Inventors
- 👤 Robert C. Pratt
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 02:53
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2219; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
170 words
An automated data processing system comprising: a relational database engine; at least one storage device including a database table, retisry and a data object consisting of at least one binary large object created and updated by said relational database engine, wherein said binary large objects only contain data and are devoid of header, indexing and addressing information; and a user-defined function engine retrieving at least one data element stored in said at least one binary large object, said registry including data element classifications, said database table including relational information of said at least one data element, said data element classifications and pointers to said at least one binary large object, said relational database engine creating and updating said at least one binary large object based on said database table and said registry; said database table having a current structure; and said system being dynamically extended by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 2
Dependent Claim
170 words
An automated data processing system comprising: a relational database engine; at least one storage device including a database table, retisry and a data object consisting of at least one binary large object created and updated by said relational database engine, wherein said binary large objects only contain data and are devoid of header, indexing and addressing information; and a user-defined function engine retrieving at least one data element stored in said at least one binary large object, said registry including data element classifications, said database table including relational information of said at least one data element, said data element classifications and pointers to said at least one binary large object, said relational database engine creating and updating said at least one binary large object based on said database table and said registry; said database table having a current structure; and said system being dynamically extended by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 3
Dependent Claim
22 words
The system in claim 1 , wherein said binary large object comprises an aggregate object having a plurality of similar data elements.
Claim 4
Dependent Claim
22 words
The system in claim 1 , wherein said binary large object comprises a composite object having a plurality of dissimilar data elements.
Claim 5
Dependent Claim
28 words
The system in claim 1 , wherein said at least one binary large object have distinctive sizes based on corresponding ones of said at least one data element.
Claim 6
Dependent Claim
15 words
The system in claim 4 , wherein said data element classification includes said distinctive sizes.
Claim 7
Dependent Claim
34 words
The system in claim 1 , wherein said database table has a current structure, said system being dynamically extended by defining additional data element classifications and maintaining said current structure of said database table.
Claim 8
Dependent Claim
41 words
The system in claim 1 , wherein said system comprises a distributed network and said storage device comprises a plurality of network servers, said distributed network including a data director for routing said at least one data element and user requests.
Claim 9
Independent Claim
137 words
A method of organizing data elements in a relational database, said method comprising: storing relational information about said data elements and data element classifications in a database table; defining said data element classifications in a registry; storing said data elements in objects separate from said database table and said registry, wherein said objects only contain data and are devoid of header, indexing and addressing information; wherein said objects consist of at least one binary large object created and updated by a relational database engine; and including pointers to said objects in said database table; wherein said database table has a current structure, and said method further comprises dynamically extending said relational database by expanding a size of at least one of said at least one binary large object and maintaining said current suture of said database table.
Claim 10
Independent Claim
137 words
A method of organizing data elements in a relational database, said method comprising: storing relational information about said data elements and data element classifications in a database table; defining said data element classifications in a registry; storing said data elements in objects separate from said database table and said registry, wherein said objects only contain data and are devoid of header, indexing and addressing information; wherein said objects consist of at least one binary large object created and updated by a relational database engine; and including pointers to said objects in said database table; wherein said database table has a current structure, and said method further comprises dynamically extending said relational database by expanding a size of at least one of said at least one binary large object and maintaining said current suture of said database table.
Claim 11
Dependent Claim
28 words
The method in claim 8 , wherein said storing of said data elements comprises storing said data elements as aggregate objects having a plurality of similar data elements.
Claim 12
Dependent Claim
28 words
The method in claim 8 , wherein said storing of said data elements comprises storing said data elements as composite objects having a plurality of dissimilar data elements.
Claim 13
Dependent Claim
23 words
The method in claim 8 , further comprising forming said objects to have distinctive sizes based on corresponding sizes of said data elements.
Claim 14
Dependent Claim
15 words
The method in claim 11 , further comprising storing said distinctive sizes in said registry.
Claim 15
Dependent Claim
38 words
The method in claim 8 , wherein said database table has a current structure, said method further comprising dynamically extending said relational database by defining additional data element classifications and maintaining said current structure of said database table.
Claim 16
Dependent Claim
130 words
A relational database management system comprising: at least one object storing at least one data element, wherein said object only contain data and is devoid of header, indexing and addressing information, wherein sad object consists of at least one binary large object created and updated by said relational engine; a database table storing relational information of said data element and at least one pointer to said at least one object said database table lacking said data element; and a registry having information about data element classification and data element location; wherein said database table has a current suture, and wherein said system is dynamically extended by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 17
Dependent Claim
130 words
A relational database management system comprising: at least one object storing at least one data element, wherein said object only contain data and is devoid of header, indexing and addressing information, wherein sad object consists of at least one binary large object created and updated by said relational engine; a database table storing relational information of said data element and at least one pointer to said at least one object said database table lacking said data element; and a registry having information about data element classification and data element location; wherein said database table has a current suture, and wherein said system is dynamically extended by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 18
Dependent Claim
20 words
The system in claim 14 , wherein said object comprises an aggregate object storing a plurality of similar data elements.
Claim 19
Dependent Claim
20 words
The system in claim 14 , wherein said object comprises a composite object storing a plurality of dissimilar data elements.
Claim 20
Dependent Claim
26 words
The system in claim 14 , wherein said at least one object have distinctive sizes based on corresponding ones of said at least one data element.
Claim 21
Dependent Claim
15 words
The system in claim 17 , wherein said data element classification includes said distinctive sizes.
Claim 22
Dependent Claim
34 words
The system in claim 14 , wherein said database table has a current structure, said system being dynamically extended by defining additional data element classifications and maintaining said current structure of said database table.
Claim 23
Dependent Claim
31 words
The system in claim 14 , wherein said system comprises a distributed network having a plurality of network servers and a data director for routing said data element and user requests.
Claim 24
Dependent Claim
156 words
A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform a method for organizing data elements in a relational database, said method comprising: storing relational information about said data elements and data element classifications in a database table; defining said data element classifications in a registry; storing said data elements in objects separate from said database table and said regist, wherein said objects only contain data and are devoid of header, indexing and addressing information; wherein said objects consist of at least one binary large object created and updated by a reladonal database engine; and including pointers to said objects in said database table; wherein said database table has a current structure, and said method further comprises dynamically extending said realational database by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 25
Dependent Claim
156 words
A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform a method for organizing data elements in a relational database, said method comprising: storing relational information about said data elements and data element classifications in a database table; defining said data element classifications in a registry; storing said data elements in objects separate from said database table and said regist, wherein said objects only contain data and are devoid of header, indexing and addressing information; wherein said objects consist of at least one binary large object created and updated by a reladonal database engine; and including pointers to said objects in said database table; wherein said database table has a current structure, and said method further comprises dynamically extending said realational database by expanding a size of at least one of said at least one binary large object and maintaining said current structure of said database table.
Claim 26
Dependent Claim
30 words
The program storage device in claim 21 , wherein said storing of said data elements comprises storing said data elements as aggregate objects having a plurality of similar data elements.
Claim 27
Dependent Claim
30 words
The program storage device in claim 21 , wherein said storing of said data elements comprises storing said data elements as composite objects having a plurality of dissimilar data elements.
Claim 28
Dependent Claim
28 words
The program storage device in claim 21 , wherein said method further comprises forming said objects to have distinctive sizes based on corresponding sizes of said data elements.
Claim 29
Dependent Claim
20 words
The program storage device in claim 24 , wherein said method further comprises storing said distinctive sizes in said registry.
Claim 30
Dependent Claim
40 words
The program storage device in claim 21 , wherein said database table has a current structure, said method further comprising dynamically extending said relational database by defining additional data element classifications and maintaining said current structure of said database table.
References Cited (Backward Citations)
US3670310A
Cited
EP0336580A2
Cited
US5295256A
Cited
US5263167A
Cited
US5426780A
Cited
US5499371A
Cited
US5706506A
Cited
US5694598A
Cited
US5732402A
Cited
US5682524A
Cited
US5826253A
Cited
US5918224A
Cited
US5689698A
Cited
US5778378A
Cited
US5983213A
Cited
US6004276A
Cited
US6065013A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-12-30 | 2006-07-01 | 2006-12-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-12-30 | 2010-07-01 | 2010-12-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-12-30 | 2014-07-01 | 2014-12-31 | $7700.00 | Window Closed / Lapsed |