Maintaining a Data Warehouse

Maintaining a Data Warehouse

SQL Server 2000

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.

© 2016 Microsoft