US5864843A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for extending a database management system to operate with diverse object servers
Assignee: Teradata US Inc
•
Filing: 1995-10-20
•
Granted: 1999-01-26
•
Expires: 2015-10-20
Abstract
Abstract A method and apparatus for extending a database management system to operate with diverse object servers. The apparatus comprises a federated coordinator for accepting client commands and translating client commands into relational database commands and object server commands, a plurality of object servers coupled to the federated coordinator, each object server for storing and retrieving data objects identified by object data surrogates in response to the object server commands from the federated coordinator, and a relational database management system coupled to the federated coordinator for storing and retrieving object data surrogates and for transforming relational database commands into an answer set comprising an answer set data surrogate.
Inventors
- 👤 Felipe Carino, Jr.
- 👤 Warren M. Sterling
- 👤 Anthony L. Rollins
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 22:23
CPC Classifications
G; G06; G06Q; G06Q40/00; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99942; Y10S707/99943
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
174 words
A method of extending a relational database management system to operate with an object server commandable by execution steps, comprising the steps of: receiving a database query from a client; transforming the database query into relational database management system commands wherein the step of transforming the database query into relational database management system commands comprises the steps of obtaining parse tree information from the global data dictionary, the parse tree information comprising a database schema for the relational database management system, transforming the database query into a parse tree based upon the database schema, the parse tree defining a plurality of command sets, and transforming the parse tree into relational database management system commands and object server execution steps; transmitting the relational database management system commands to the relational database management system; receiving a response from the relational database management system, the response comprising an object locator identifying object data responsive to the database query; compiling an answer set comprising the relational database management system response; and transmitting the answer set to the client.
Claim 2
Independent Claim
174 words
A method of extending a relational database management system to operate with an object server commandable by execution steps, comprising the steps of: receiving a database query from a client; transforming the database query into relational database management system commands wherein the step of transforming the database query into relational database management system commands comprises the steps of obtaining parse tree information from the global data dictionary, the parse tree information comprising a database schema for the relational database management system, transforming the database query into a parse tree based upon the database schema, the parse tree defining a plurality of command sets, and transforming the parse tree into relational database management system commands and object server execution steps; transmitting the relational database management system commands to the relational database management system; receiving a response from the relational database management system, the response comprising an object locator identifying object data responsive to the database query; compiling an answer set comprising the relational database management system response; and transmitting the answer set to the client.
Claim 3
Dependent Claim
86 words
The method of claim 1 wherein the parse tree further comprises a plurality of parse tree nodes and the step of transforming the database query into relational database management system commands further comprises the steps of: accessing the global data dictionary to obtain a cost value for each of the parse tree nodes; binding parse tree node costs to the parse tree nodes; iterating over the relational database management system command sets to optimize the relational database management system commands and the object server execution steps.
Claim 4
Dependent Claim
26 words
The method of claim 2 further comprising the step of dispatching the relational database management system commands to the object servers and the database management system.
Claim 5
Dependent Claim
198 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps of extending a relational database management system to operate with an object server commandable by execution steps, comprising the steps of: receiving a database query from a client; transforming the database query into relational database management system commands wherein the method step of transforming the database query into relational database management system commands further comprises the steps of obtaining parse tree information from the global data dictionary the parse tree information comprising a database schema for the relational database management system, transforming the database query into a parse tree based upon the database schema, the parse tree defining a plurality of command sets, and transforming the parse tree into relational database management system commands and object server execution steps; transmitting the relational database management system commands to the relational database management system; receiving a response from the relational database management system, the response comprising an object locator identifying object data responsive to the database query; compiling an answer set comprising the relational database management system response; and transmitting the answer set to the client.
Claim 6
Dependent Claim
198 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps of extending a relational database management system to operate with an object server commandable by execution steps, comprising the steps of: receiving a database query from a client; transforming the database query into relational database management system commands wherein the method step of transforming the database query into relational database management system commands further comprises the steps of obtaining parse tree information from the global data dictionary the parse tree information comprising a database schema for the relational database management system, transforming the database query into a parse tree based upon the database schema, the parse tree defining a plurality of command sets, and transforming the parse tree into relational database management system commands and object server execution steps; transmitting the relational database management system commands to the relational database management system; receiving a response from the relational database management system, the response comprising an object locator identifying object data responsive to the database query; compiling an answer set comprising the relational database management system response; and transmitting the answer set to the client.
Claim 7
Dependent Claim
90 words
The program storage device of claim 4, wherein the parse tree further comprises a plurality of parse tree nodes and the method step of transforming the database query into relational database management system commands further comprises the steps of: accessing the global data dictionary to obtain a cost value for each of the parse tree nodes; binding parse tree node costs to the parse tree nodes; and iterating over the relational database management system command sets to optimize the relational database management system commands and the object server execution steps.
Claim 8
Dependent Claim
33 words
The program storage device of claim 5 wherein the method step further comprises the step of dispatching the relational database management system commands to the object servers and the relational database management system.
References Cited (Backward Citations)
US4558413A
Cited
US5369778A
Cited
US5408655A
Cited
US5557798A
Cited
US5181162A
Cited
US5448727A
Cited
US5377323A
Cited
US5555403A
Cited
US5564113A
Cited
US5581758A
Cited
US5511002A
Cited
US5513126A
Cited
US5548749A
Cited
US5455953A
Cited
US5560005A
Cited
US5488412A
Cited
US5557518A
Cited
US5555365A
Cited
US5548587A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-01-25 | 2002-07-27 | 2003-01-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-01-25 | 2006-07-27 | 2007-01-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-01-25 | 2010-07-27 | 2011-01-26 | $7700.00 | Window Closed / Lapsed |