Patent US6058394A successfully refreshed from Google Patents.
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
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.
References Cited (Backward Citations)
US5379419A
Cited
US5526492A
Cited
US5583997A
Cited
US5596744A
Cited
US5592626A
Cited
US5560005A
Cited
US5561769A
Cited
US5623605A
Cited
US5590321A
Cited
US5675785A
Cited
US5761663A
Cited
US5754841A
Cited
US5781911A
Cited
US5765147A
Cited
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 |