Patent US6058394A successfully refreshed from Google Patents.
← Back to Patent Explorer
US6058394A Expired / Lapsed US ⏱️ 0.0 years remaining

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

Assignee: International Business Machines Corp
•
Filing: 1997-08-29
•
Granted: 2000-05-02
•
Expires: 2017-08-29
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

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.

Inventors

  • 👤 Linnette M. Bakow
  • 👤 Jean-Jacques P. Daudenarde
  • 👤 Giuseppe Facchetti

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-08 03:46
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943

Claims Analysis

Total Claims: 21
Claim 1
Independent Claim 145 words
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.
Claim 2
Independent Claim 145 words
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.
Claim 3
Dependent Claim 40 words
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.
Claim 4
Dependent Claim 31 words
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.
Claim 5
Dependent Claim 35 words
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.
Claim 6
Dependent Claim 34 words
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.
Claim 7
Dependent Claim 25 words
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.
Claim 8
Independent Claim 165 words
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.
Claim 9
Independent Claim 165 words
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.
Claim 10
Dependent Claim 44 words
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.
Claim 11
Dependent Claim 33 words
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.
Claim 12
Dependent Claim 35 words
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.
Claim 13
Dependent Claim 34 words
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.
Claim 14
Dependent Claim 32 words
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.
Claim 15
Dependent Claim 169 words
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.
Claim 16
Dependent Claim 169 words
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.
Claim 17
Dependent Claim 42 words
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.
Claim 18
Dependent Claim 33 words
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.
Claim 19
Dependent Claim 37 words
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.
Claim 20
Dependent Claim 36 words
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.
Claim 21
Dependent Claim 27 words
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.

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2003-05-02 2003-11-01 2004-05-02 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2007-05-02 2007-11-01 2008-05-02 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2011-05-02 2011-11-01 2012-05-02 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag