US6178418B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Distributed data warehouse query and resource management system
Assignee: ARIS SOFTWARE Inc
•
Filing: 1998-07-28
•
Granted: 2001-01-23
•
Expires: 2018-07-28
Abstract
Abstract An architecture and method of operation for servicing data queries within a distributed data warehouse system composed of a plurality of physical servers housing the data to be accessed. Queries are generated by data accessing and processing applications executing on client computers within the distributed data warehouse system. The method enables queried data to be requested by, and delivered to respective client computers without having to pass through a middle-tier server. The method further provides a manageable and scalable system architecture which will readily support a variety of physical servers, including legacy databases, and query format translations when required.
Inventors
- 👤 Richard E. Singer
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 02:47
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933
Claims Analysis
Total Claims: 16
Claim 1
Independent Claim
199 words
A method for servicing data queries to a distributed data warehouse system generated by at least one data accessing application executing on at least one client computer, the distributed data warehouse system being composed of a plurality of physical servers housing data to be accessed, the method comprising: a) generating a query for data required by the application executing on the client computer; b) passing the query to a connection driver of the client computer; c) forwarding the query to a query server; d) receiving the query at the query server; e) determining at the query server a specific physical server within the distributed data warehouse system to be accessed in order to resolve the query for the required data; f) transmitting back to the connection driver of the client computer information indicating the physical server to access in order to satisfy the query; g) transmitting a request from the connection driver to the physical server to satisfy the query; and h) receiving the required data at the client computer and providing said data to the application; i) wherein the required data is passed directly from the physical server to the client computer without passing through the query server.
Claim 2
Independent Claim
199 words
A method for servicing data queries to a distributed data warehouse system generated by at least one data accessing application executing on at least one client computer, the distributed data warehouse system being composed of a plurality of physical servers housing data to be accessed, the method comprising: a) generating a query for data required by the application executing on the client computer; b) passing the query to a connection driver of the client computer; c) forwarding the query to a query server; d) receiving the query at the query server; e) determining at the query server a specific physical server within the distributed data warehouse system to be accessed in order to resolve the query for the required data; f) transmitting back to the connection driver of the client computer information indicating the physical server to access in order to satisfy the query; g) transmitting a request from the connection driver to the physical server to satisfy the query; and h) receiving the required data at the client computer and providing said data to the application; i) wherein the required data is passed directly from the physical server to the client computer without passing through the query server.
Claim 3
Dependent Claim
75 words
The method according to claim 1 , wherein the query server rephrases the query, if necessary, to establish a query format that is compatible with the respective physical server to which the query is to be sent to access the required data, thereby providing a means to translate queries, which would otherwise be incompatible with the physical server having the required data, in a manner that is transparent to the application executing on the client.
Claim 4
Dependent Claim
64 words
The method according to claim 2 , wherein the query server includes at least one virtual table organized according to a plurality of business rules associated with the distributed data warehouse system and the available physical servers thereof, such that each virtual table holds mapping information to enable the query server to select a preferred physical server to be accessed to satisfy the query.
Claim 5
Dependent Claim
48 words
The method according to claim 2 , wherein the query server includes a query router that considers loading status of a plurality of the physical servers to steer queries in order to effect load balancing of queries sent to available physical servers of the distributed data warehouse system.
Claim 6
Dependent Claim
23 words
The method according to claim 4 , wherein the application executing on at least one of the clients is an internet web server.
Claim 7
Dependent Claim
22 words
The method according to claim 5 , wherein at least one physical server is accessed by way of an internet network connection.
Claim 8
Dependent Claim
45 words
The method according to claim 4 , further providing a plurality of replicated query servers, such that if a designated primary query server does not respond to a query within a predetermined period of time, a designated secondary query server will respond to the query.
Claim 9
Dependent Claim
30 words
The method according to claim 7 , wherein an alert is forwarded to a monitoring station when a primary query server does not respond within the predetermined period of time.
Claim 10
Dependent Claim
27 words
The method according to claim 8 , wherein an alternate primary query server is automatically designated should an original primary query server be determined to be non-responsive.
Claim 11
Independent Claim
270 words
A method for servicing data queries generated by at least one data accessing application executing on at least one client computer, the client computer having access to a distributed data warehouse system that is composed of a plurality of physical servers housing data to be accessed, the method comprising: a) generating a query for required data by the application executing on the client computer; b) passing the query to a connection driver of the client computer having access to a communication network; c) forwarding the query via the communication network to a query router; d) receiving the query via the communication network at the query router and determining thereat a specific physical server within the distributed data warehouse system to be accessed to resolve the query and provide the required data; e) rephrasing the query, if necessary, to establish a query format that is compatible with the physical server to which the query is to be sent to access the required data; f) transmitting back over the communication network information to the connection driver of the client computer indicating the physical server to be accessed to satisfy the query; the information including, if necessary, a rephrased query format to be sent to the physical server; g) transmitting to the physical server, also connected via a communication network, a request for the required data to satisfy the query; h) receiving the data at the client computer and providing the queried data to the application; i) wherein the required data is passed over the communication network directly from the physical server to the client computer without the need for a middle-tier server.
Claim 12
Independent Claim
270 words
A method for servicing data queries generated by at least one data accessing application executing on at least one client computer, the client computer having access to a distributed data warehouse system that is composed of a plurality of physical servers housing data to be accessed, the method comprising: a) generating a query for required data by the application executing on the client computer; b) passing the query to a connection driver of the client computer having access to a communication network; c) forwarding the query via the communication network to a query router; d) receiving the query via the communication network at the query router and determining thereat a specific physical server within the distributed data warehouse system to be accessed to resolve the query and provide the required data; e) rephrasing the query, if necessary, to establish a query format that is compatible with the physical server to which the query is to be sent to access the required data; f) transmitting back over the communication network information to the connection driver of the client computer indicating the physical server to be accessed to satisfy the query; the information including, if necessary, a rephrased query format to be sent to the physical server; g) transmitting to the physical server, also connected via a communication network, a request for the required data to satisfy the query; h) receiving the data at the client computer and providing the queried data to the application; i) wherein the required data is passed over the communication network directly from the physical server to the client computer without the need for a middle-tier server.
Claim 13
Dependent Claim
56 words
The method according to claim 10 , wherein the query server includes virtual tables that are organized according to a plurality of business rules associated with the distributed data warehouse system; wherein each virtual table holds mapping information to enable the query server to select a preferred physical server to be accessed to satisfy the query.
Claim 14
Dependent Claim
47 words
The method according to claim 11 , wherein the query router is a program executing on a query server, which considers the loading status of a plurality of physical servers to direct queries in order to effect load balancing of queries sent to the available physical servers.
Claim 15
Dependent Claim
60 words
The method according to claim 10 , such that when a query from a client computer requires access to a physical server for which the client computer connection driver is not compatible, the query server automatically transmits a replacement, updated connection driver to the client computer, as well as indicating the physical server to be accessed to satisfy the query.
Claim 16
Dependent Claim
53 words
The method according to claim 10 , such that a query from an originating client computer is directed by the query router to a particular physical server based on compatibility of the query format produced by the originating client computer in order to eliminate the need to translate the format of the query.
References Cited (Backward Citations)
US5812639A
Cited
US5898780A
Cited
US6009081A
Cited
US6023695A
Cited
US6023696A
Cited
US6026391A
Cited
US6012067A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-01-23 | 2004-07-24 | 2005-01-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-01-23 | 2008-07-24 | 2009-01-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-01-23 | 2012-07-24 | 2013-01-23 | $7700.00 | Window Closed / Lapsed |