What is a Data Warehouse
By in SQL Server on Jul 26 2006
  • Jul, 2006 26

    In contrast to an OLTP database in which the purpose is to capture high rates of data changes and additions, the purpose of a data warehouse is to organize lots of stable data for ease of analysis and retrieval. A data warehouse is frequently used as the basis for a business intelligence application.

    Following is a list of what data warehouses can do:

    • Combine data from heterogeneous data sources into a single homogenous structure.
    • Organize data in simplified structures for efficiency of analytical queries instead of for transaction processing.
    • Contain transformed data that is valid, consistent, consolidated, and formatted for analysis.
    • Provide stable data that represents business history.
    • Be updated periodically with additional data instead of making frequent transactions.
    • Simplify security requirements.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS