System for providing fault tolerant data warehousing environment by temporary transmitting data to alternate data warehouse during an interval of primary data warehouse failure

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;
• obtaining an indication that the primary data warehouse can receive data;
• transmitting data to the primary data warehouse upon obtaining the indication;
• and
• suspending data transmission to the alternate data warehouse.

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;
• causing data to be transmitted to the alternate data warehouse upon providing the identification of the failure;
• providing an identification that the primary data warehouse can receive data;
• suspending data transmission to the alternate data warehouse upon the identification that the primary data warehouse can receive data;
• causing data to be transmitted to the primary data warehouse;
• and
• wherein the alternate data warehouse is selected from the two or more premises servers.