What Is a Data Warehouse?
A data warehouse is a centralized storage facility for differing types of data throughout an enterprise. This data is subject oriented, time sensitive, and organized in a way that offers simplified analysis. For example, a data warehouse might contain customer information and sales to these customers over the past five years. It might be derived from several types of disjoint production systems in the enterprise, such as an order-processing system, which resides on a mainframe, or a sales-tracking application housed on an AS400. Querying these systems for trends might prove to be a difficult task. Data warehousing is the process of collecting, aggregating, storing, and maintaining this information so that executives ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
