Patent US270972A successfully refreshed from Google Patents.
Patent US5873083A successfully refreshed from Google Patents.
US5873083A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for extending a relational database management system using a federated coordinator
Assignee: Teradata US Inc
•
Filing: 1997-10-03
•
Granted: 1999-02-16
•
Expires: 2017-10-03
Abstract
Abstract A method and apparatus for providing access to object data stored in an object server in response to a database query. The method comprises the steps of receiving a database query comprising a relational operation with a data surrogate identifying object data stored in an object server, transforming the database query into relational database commands, transmitting the relational database commands to the relational database management system, receiving a response table from the relational database management system, compiling an answer set from the response table comprising an object locator responsive to the database query, and transmitting the answer set to the client.
Inventors
- 👤 William Phillip Jones
- 👤 Arthur F. Kaufmann
- 👤 Colin Luck
- 👤 Jukka I. Saukkonen
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 23:50
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
97 words
A method of extending a relational database management system (RDBMS) performed by a computer to manage object data, the method comprising the steps of: receiving a client message in a federated coordinator, the client message comprising a store command and object data; transforming the client message into a query plan comprising an RDBMS command and an object server command; transmitting the query plan to the RDBMS and the object server via a first communication path; receiving an object data identifier from the object server; and transmitting object data to the object server via a second communication path.
Claim 2
Independent Claim
97 words
A method of extending a relational database management system (RDBMS) performed by a computer to manage object data, the method comprising the steps of: receiving a client message in a federated coordinator, the client message comprising a store command and object data; transforming the client message into a query plan comprising an RDBMS command and an object server command; transmitting the query plan to the RDBMS and the object server via a first communication path; receiving an object data identifier from the object server; and transmitting object data to the object server via a second communication path.
Claim 3
Dependent Claim
46 words
The method of claim 1, wherein the federated coordinator is communicatively coupled to a global data dictionary (GDD) having table values and statistics and the method further comprising the steps of: inserting the object data identifier in the RDBMS; updating the GDD table values and statistics.
Claim 4
Dependent Claim
28 words
The method of claim 2 wherein the steps of inserting and updating are performed after receiving a second client message requesting that the federated coordinator end the transaction.
Claim 5
Dependent Claim
18 words
The method of claim 1, wherein the second communication path is higher bandwidth than the first communication path.
Claim 6
Dependent Claim
18 words
The method of claim 1, wherein the second communication path is more secure than the first communication path.
Claim 7
Independent Claim
141 words
A method of extending a relational database management system (RDBMS) performed by a computer to manage object data, the method comprising the steps of: receiving a message from a client in a federated coordinator, the client message comprising object data and a user-defined function executable in an object server; transmitting the object data and the user-defined function to the object server; invoking the user-defined function in the object server to process the object data to obtain a user-defined function result; creating a temporary object and an associated object data identifier in the object server to store the user-defined function result; transmitting an object data identifier to the federated coordinator; and wherein the object data is transmitted to the object server via a first communication path and the user defined function is transmitted to the object server via a second communication path.
Claim 8
Independent Claim
141 words
A method of extending a relational database management system (RDBMS) performed by a computer to manage object data, the method comprising the steps of: receiving a message from a client in a federated coordinator, the client message comprising object data and a user-defined function executable in an object server; transmitting the object data and the user-defined function to the object server; invoking the user-defined function in the object server to process the object data to obtain a user-defined function result; creating a temporary object and an associated object data identifier in the object server to store the user-defined function result; transmitting an object data identifier to the federated coordinator; and wherein the object data is transmitted to the object server via a first communication path and the user defined function is transmitted to the object server via a second communication path.
Claim 9
Dependent Claim
19 words
The method of claim 6, wherein the second communication path is of higher bandwidth than the first communication path.
Claim 10
Dependent Claim
25 words
The method of claim 6, wherein the first communication path is an insecure communication path and the second communication path is a secure communication path.
Claim 11
Dependent Claim
40 words
The method of claim 6, further comprising the steps of: generating a searchable text index entry from the object data; storing the test index entry in an auxiliary server communicatively coupled to the federated coordinator via the first communication path.
Claim 12
Dependent Claim
20 words
The method of claim 9, wherein the auxiliary server is communicatively coupled to the client via a second communication path.
Claim 13
Independent Claim
110 words
An apparatus for managing object data, comprising: a computer; means, performed by the computer, for receiving a client message in a federated coordinator, the client message comprising a store command and object data; means, performed by the computer, for transforming the client message into a query plan comprising an RDBMS command and an object server command; means, performed by the computer, for transmitting the query plan to the RDBMS and the object server via a first communication path; means, performed by the computer, for receiving an object data identifier from the object server; means, performed by the computer, transmitting object data to the object server via a second communication path.
Claim 14
Independent Claim
110 words
An apparatus for managing object data, comprising: a computer; means, performed by the computer, for receiving a client message in a federated coordinator, the client message comprising a store command and object data; means, performed by the computer, for transforming the client message into a query plan comprising an RDBMS command and an object server command; means, performed by the computer, for transmitting the query plan to the RDBMS and the object server via a first communication path; means, performed by the computer, for receiving an object data identifier from the object server; means, performed by the computer, transmitting object data to the object server via a second communication path.
Claim 15
Dependent Claim
56 words
The apparatus of claim 11, wherein the federated coordinator is communicatively coupled to a global data dictionary (GDD) having table values and statistics, and the apparatus further comprises: means, performed by the computer, for inserting the object data identifier in the RDBMS; and means, performed by the computer, for updating the GDD table values and statistics.
Claim 16
Dependent Claim
18 words
The apparatus of claim 11, wherein the second communication path is higher bandwidth than the first communication path.
Claim 17
Dependent Claim
23 words
The apparatus of claim 11, wherein the second communication path secure communication path and the first communication path is an insecure communication path.
Claim 18
Independent Claim
143 words
An apparatus for managing object data, comprising: a computer; means, performed by the computer, for receiving a message from a client in a federated coordinator, the client message comprising object data and a user-defined function executable in an object server; means, performed by the computer, for transmitting the object data and the user-defined function to the object server, user-defined function transmitted via a first communication path and the object data transmitted via a second communication path; means, performed by the computer, for invoking the user-defined function in the object server to process the object data to obtain a user-defined function result; means, performed by the computer, for creating a temporary object and an associated object data identifier in the object server to store the user-defined function result; and means, performed by the computer, for transmitting an object data identifier to the federated coordinator.
Claim 19
Independent Claim
143 words
An apparatus for managing object data, comprising: a computer; means, performed by the computer, for receiving a message from a client in a federated coordinator, the client message comprising object data and a user-defined function executable in an object server; means, performed by the computer, for transmitting the object data and the user-defined function to the object server, user-defined function transmitted via a first communication path and the object data transmitted via a second communication path; means, performed by the computer, for invoking the user-defined function in the object server to process the object data to obtain a user-defined function result; means, performed by the computer, for creating a temporary object and an associated object data identifier in the object server to store the user-defined function result; and means, performed by the computer, for transmitting an object data identifier to the federated coordinator.
Claim 20
Dependent Claim
19 words
The apparatus of claim 15, wherein the second communication path is of higher bandwidth than the first communication path.
Claim 21
Dependent Claim
18 words
The apparatus of claim 15, wherein the second communication path is more secure than the first communication path.
Claim 22
Dependent Claim
47 words
The apparatus of claim 15, further comprising: means, performed by the computer, for generating a searchable text entry from the object data; means, performed by the computer, for storing the text entry in an auxiliary server communicatively coupled to the federated coordinator via the first communication path.
Claim 23
Dependent Claim
20 words
The apparatus of claim 15, wherein the auxiliary server is coupled to the federated coordinator via a second communication path.
References Cited (Backward Citations)
US4558413A
Cited
US5369778A
Cited
US5557798A
Cited
US5181162A
Cited
US5448727A
Cited
US5377323A
Cited
US5555403A
Cited
US5564113A
Cited
US5581758A
Cited
US5717877A
Cited
US5596744A
Cited
US5511002A
Cited
US5513126A
Cited
US5548749A
Cited
US5560005A
Cited
US5557518A
Cited
US5555365A
Cited
US5548587A
Cited
US5706499A
Cited
US5694598A
Cited
US5717924A
Cited
US5634053A
Cited
US5689698A
Cited
US5754841A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-15 | 2002-08-17 | 2003-02-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-15 | 2006-08-17 | 2007-02-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-15 | 2010-08-17 | 2011-02-16 | $7700.00 | Window Closed / Lapsed |