System and method for providing a fault-tolerant data warehouse environment
First Claim
1. In a data collection and processing system including two or more premises servers for collecting data and transmitting the data to a primary data warehouse, a method for providing fault tolerant data warehousing, the method comprising:
- obtaining a set of data to be transmitted to a primary data warehouse;
obtaining an indication that the primary data warehouse is inoperable to receive the set of data;
obtaining information identifying an alternate data warehouse to receive the set of data; and
transmitting the set of data to the identified alternate data warehouse;
wherein the alternate data warehouse is selected from the two or more premises servers.
19 Assignments
0 Petitions
Accused Products
Abstract
A method and system utilizing one or more data generating computing devices as default data warehouses in the event of a primary data warehouse failure are provided. A data warehouse provides an environment in which data from one or more data servers in one or more locations, or premises, is aggregated in a central database. In the event of a system failure, in which communication between the data warehouse and one or more servers is disrupted, a warehouse ticket file, stored on secure, distributed ticket servers, is used to identify and initialize at least one of the data servers as a failover data warehouse. Once communication between the premises and its primary data warehouse is restored, the data collected during the failover is transferred to the primary data warehouse and purged from the failover data warehouse.
68 Citations
32 Claims
-
1. In a data collection and processing system including two or more premises servers for collecting data and transmitting the data to a primary data warehouse, a method for providing fault tolerant data warehousing, the method comprising:
-
obtaining a set of data to be transmitted to a primary data warehouse;
obtaining an indication that the primary data warehouse is inoperable to receive the set of data;
obtaining information identifying an alternate data warehouse to receive the set of data; and
transmitting the set of data to the identified alternate data warehouse;
wherein the alternate data warehouse is selected from the two or more premises servers. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14)
-
-
13. In a data collection and processing system including two or more premises servers for collecting data and transmitting the data to a primary data warehouse, a method for providing fault tolerant data warehousing, the method comprising:
-
obtaining a set of data to be transmitted to a primary data warehouse;
obtaining an indication that the primary data warehouse is inoperable to receive the set of data;
accessing a database associated with a premises server to obtain an identification of an alternate data warehouse associated with the premises server;
suspending transmission of data between the premises server and the primary data warehouse;
transmitting premises data to the alternate data warehouse;
wherein the alternate data warehouse is selected from the two or more premises servers. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25)
-
-
26. A system for providing fault tolerant data warehousing comprising:
-
two or more premises servers in communication with a number of data generating devices, wherein the premises servers transmit collected data for storage;
a primary data warehouse for receiving the collected data from transmitted by the premises servers;
a database server in communication with the premises server for providing an identification of an alternate data warehouse upon a failure of the primary data warehouse;
wherein the alternate data warehouse is selected from the two or more premises servers. - View Dependent Claims (27, 28, 29, 30, 31, 32)
-
Specification