Overview of the Data Warehouse Process

• Data is loaded from multiple database sources into the Data Warehouse Server
• The original database source is not changed
• The Data Warehouse Server merges the data into an indexed file to achieve maximum speed for extremely fast queries, searches and reports
• All queries run on the Data Warehouse server and the integrated database

1. Data from remote locations is being pulled out of remote system via Transfer PC without changing original source - each update is differential, can handle deletions, restore broken connections and much more
2. The transfer PC compacts and sends the data to the Data Warehouse Server
3. The Data Warehouse Server imports this data via high-speed import into its database
4. The data is integrated into a central database for better database management
5. User queries, data mines and searches this database for information

More Info...