Manager server selects an agent server to execute query based on availability of the server connections to data source and target

• US 6,058,394 A
• Filed: 08/29/1997
• Issued: 05/02/2000
• Est. Priority Date: 08/29/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Facchetti, Giuseppe, Daudenarde, Jean-Jacques P., Bakow, Linnette M.
• Primary Examiner(s): Choules, Jack M.
• Assistant Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US08/921,196
• Time in Patent Office: 977 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 707/10, 707/100-104, 707/200-204, 395/672, 395/682, 395/200.57, 395/200.33, 395/200.54, 395/200.53, 709/203, 709/213, 709/217, 709/220, 709/223-226, 709/229-232, 709/248-252, 709/219
• US Class Current: 707/770
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method, apparatus, and article of manufacture for a scalable data warehouse architecture. A query is executed in a computer to retrieve data from a database stored on a data storage device. Under control of a manager server, one of a plurality of agent servers is selected to execute the query based upon availability of each agent server and based upon connections between each agent server and a data source and a data target required for execution of the query.

Claims

1. A method of executing a query in a computer to retrieve data from a database stored on a data storage device, comprising the steps of:

under control of a manager server;

selecting one of a plurality of agent servers to execute the query based upon availability of each agent server and based upon connections between each agent server and a data source and a data target required for execution of the query;

limiting each data transfer to data transfers between the data source and the data target, when both the data source and the data target are connected to the selected agent server; and

under control of the selected agent server, transferring data from the data source to the data target without using one of the other agent servers, wherein the data source and the data target are both connected to the selected agent server.

2. The method of claim 1 above, further comprising, under control of an agent server, the steps of:

receiving the query from the manager server;

executing the query to obtain status information; and

transmitting the status information to the manager server.

3. The method of claim 2 above, further comprising, under control of the manager server, the steps of:

receiving the status information; and

storing the status information at a central storage device.

4. The method of claim 3 above, wherein the manager server is connected to a client that requests the query, and further comprising the step of, under control of the client, accessing the stored status information.

5. The method of claim 1 above, wherein a data analysis computer is connected to the data target, further comprising the step of performing data analysis on the data target from the data analysis computer.

6. The method of claim 1 above, wherein after the step of selecting, the manager server stores the query for later forwarding to an agent server.

7. An apparatus for executing a query to retrieve data from a database, comprising:

(a) a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores the database;

(b) one or more computer programs, performed by the computer, for, under control of a manager server;

selecting one of a plurality of agent servers to execute the query based upon availability of each agent server and based upon connections between each agent server and a data source and a data target required for execution of the query, limiting each data transfer to data transfers between the data source and the data target, when both the data source and the data target are connected to the selected agent server, and, under control of the selected agent server, transferring data from the data source to the data target without using one of the other agent servers, wherein the data source and the data target are both connected to the selected agent server.

8. The apparatus of claim 7 above, wherein under control of an agent server, further comprising:

means for receiving the query from the manager server;

means for executing the query to obtain status information; and

means for transmitting the status information to the manager server.

9. The apparatus of claim 8 above, wherein under control of the manager server, further comprising:

means for receiving the status information; and

means for storing the status information in a central storage device.

10. The apparatus of claim 7 above, wherein the manager server is connected to a client that requests the query, and further comprising the means for, under control of the client, accessing the stored status information.

11. The apparatus of claim 7 above, wherein a data analysis computer is connected to the data target, further comprising the means for performing data analysis on the data target from the data analysis computer.

12. The apparatus of claim 7 above, wherein the means for selecting further comprises the means for, under control of the manager server, storing the query for later forwarding to an agent server.

13. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a database stored on a data storage device, the method comprising the steps of:

under control of a manager server;

selecting one of a plurality of agent servers to execute the query based upon availability of each agent server and based upon connections between each agent server and a data source and a data target required for execution of the query;

limiting each data transfer to data transfers between the data source and the data target, when both the data source and the data target are connected to the selected agent server; and

under control of the selected agent server, transferring data from the data source to the data target without using one of the other agent servers, wherein the data source and the data target are both connected to the selected agent server.

14. The article of manufacture of claim 13 above, further comprising, under control of the agent server, the steps of:

receiving the query from the manager server;

executing the query to obtain status information; and

transmitting the status information to the manager server.

15. The article of manufacture of claim 14 above, further comprising, under control of the manager server, the steps of:

receiving the status information; and

storing the status information at a central storage device.

16. The article of manufacture of claim 13 above, wherein the manager server is connected to a client that requests the query, and further comprising the step of, under control of the client, accessing the stored status information.

17. The article of manufacture of claim 13 above, wherein a data analysis computer is connected to the data target, further comprising the step of performing data analysis on the data target from the data analysis computer.

18. The article of manufacture of claim 13 above, wherein after the step of selecting, the manager server stores the query for later forwarding to an agent server.