Creating and Using Data Warehouses
Maintaining a Data Warehouse
Data warehouses collect and organize historical business data so it can be analyzed to assist management in making business decisions. To achieve this purpose, the data warehouse is created and initially loaded with the existing historical business data. It is then periodically updated with new data from operational data systems. Much of the effort in data warehouse maintenance is involved with updating the data in the data warehouse, adjusting data presentation applications to incorporate new data, and updating data marts.
Topics in this section describe common tasks performed to maintain data warehouses.
| Topic | Description |
|---|---|
| Updating Data Warehouse Data | Describes the process and tasks involved in updating a data warehouse. |
| Administering a Data Warehouse | Describes common data warehouse administration tasks. |
| Tuning Data Warehouse Performance | Describes ways to improve data warehouse performance. |