Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.