Method and apparatus for extending a relational database management system using a federated coordinator

• US 5,873,083 A
• Filed: 10/03/1997
• Issued: 02/16/1999
• Est. Priority Date: 10/20/1995
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Luck, Colin, Kaufmann, Arthur F., Jones, William Phillip, Saukkonen, Jukka I.
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): RONES, CHARLES
• Application Number:
  US08/943,837
• Time in Patent Office: 501 Days
• Field of Search: 395/326, 707/1, 707/2, 707/4, 707/3, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

1. 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.

2. 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.

3. 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.

4. The method of claim 1, wherein the second communication path is higher bandwidth than the first communication path.

5. The method of claim 1, wherein the second communication path is more secure than the first communication path.

6. 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.

7. The method of claim 6, wherein the second communication path is of higher bandwidth than the first communication path.

8. 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.

9. 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.

10. The method of claim 9, wherein the auxiliary server is communicatively coupled to the client via a second communication path.

11. 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.

12. 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.

13. The apparatus of claim 11, wherein the second communication path is higher bandwidth than the first communication path.

14. The apparatus of claim 11, wherein the second communication path secure communication path and the first communication path is an insecure communication path.

15. 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.

16. The apparatus of claim 15, wherein the second communication path is of higher bandwidth than the first communication path.

17. The apparatus of claim 15, wherein the second communication path is more secure than the first communication path.

18. 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.

19. The apparatus of claim 15, wherein the auxiliary server is coupled to the federated coordinator via a second communication path.