Scribd Logo
Upload

Welcome to Scribd!

  • 39 views

    What Is A Data Warehouse?

    Uploaded by

    chitu1992
    A data warehouse is a relational or multi-dimensional database used for quick searching, retrieval, and analysis of large amounts of data extracted periodically from operational databases. The five stages of the data warehousing process are modeling, extraction, cleansing, transformation, and loading data - which involves de-normalizing, standardizing, and summarizing data to optimize it for analysis in the data warehouse database separate from operational databases. A data warehouse system architecture typically involves extracting legacy and operational data, cleansing it, transforming it into the data warehouse model, and loading it into the separate data warehouse for analysis.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd

    What Is A Data Warehouse?

    Uploaded by

    chitu1992
    39 views8 pages
    A data warehouse is a relational or multi-dimensional database used for quick searching, retrieval, and analysis of large amounts of data extracted periodically from operational databases. The five stages of the data warehousing process are modeling, extraction, cleansing, transformation, and loading data - which involves de-normalizing, standardizing, and summarizing data to optimize it for analysis in the data warehouse database separate from operational databases. A data warehouse system architecture typically involves extracting legacy and operational data, cleansing it, transforming it into the data warehouse model, and loading it into the separate data warehouse for analysis.

    Original Description:

    good

    Original Title

    Data Warehouse

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    A data warehouse is a relational or multi-dimensional database used for quick searching, retrieval, and analysis of large amounts of data extracted periodically from operational databases. The five stages of the data warehousing process are modeling, extraction, cleansing, transformation, and loading data - which involves de-normalizing, standardizing, and summarizing data to optimize it for analysis in the data warehouse database separate from operational databases. A data warehouse system architecture typically involves extracting legacy and operational data, cleansing it, transforming it into the data warehouse model, and loading it into the separate data warehouse for analysis.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    39 views8 pages

    What Is A Data Warehouse?

    Uploaded by

    chitu1992
    A data warehouse is a relational or multi-dimensional database used for quick searching, retrieval, and analysis of large amounts of data extracted periodically from operational databases. The five stages of the data warehousing process are modeling, extraction, cleansing, transformation, and loading data - which involves de-normalizing, standardizing, and summarizing data to optimize it for analysis in the data warehouse database separate from operational databases. A data warehouse system architecture typically involves extracting legacy and operational data, cleansing it, transforming it into the data warehouse model, and loading it into the separate data warehouse for analysis.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 8

    What is a Data Warehouse?

    A relational or multi-dimensional database that may consume hundreds of gigabytes or even terabytes of disk storage
    The data is normally extracted periodically from operational database or from a public information service.

    A database constructed for quick searching, retrieval, ad-hoc queries, and ease of use An ERP system could exist without having a data warehouse. The trend, however, is that organizations that are serious about competitive advantage deploy both. The recommended data architecture for an ERP implementation includes separate operational and data warehouse databases

    Data Warehouse Process


    The five essential stages of the data warehousing process are:
    Modeling data for the data warehouse Extracting data from operational databases Cleansing extracted data Transforming data into the warehouse model Loading the data into the data warehouse database

    Data Warehouse Process: Stage 1


    Modeling data for the data warehouse
    Because of the vast size of a data warehouse, the warehouse database consists of de-normalized data.
    Relational theory does not apply to a data warehousing system. Wherever possible normalized tables pertaining to selected events may be consolidated into denormalized tables.

    Data Warehouse Process: Stage 2


    Extracting data from operational databases
    The process of collecting data from operational databases, flat-files, archives, and external data sources. Snapshots vs. Stabilized Data:
    a key feature of a data warehouse is that the data contained in it are in a non-volatile (stable) state.

    Data Warehouse Process: Stage 3


    Cleansing extracted data
    Involves filtering out or repairing invalid data prior to being stored in the warehouse
    Operational data are dirty for many reasons: clerical, data entry, computer program errors, misspelled names, and blank fields.

    Also involves transforming data into standard business terms with standard data values

    Data Warehouse Process: Stage 4


    Transforming data into the warehouse model
    To improve efficiency, data is transformed into summary views before they are loaded. Unlike operational views, which are virtual in nature with underlying base tables, data warehouse views are physical tables.
    OLAP, however, permits the user to construct virtual views from detail data when one does not already exist.

    Data Warehouse Process: Stage 5


    Loading the data into the data warehouse database
    Data warehouses must be created and maintained separately from the operational databases.
    Internal Efficiency Integration of Legacy Systems Consolidation of Global Data

    Data Warehouse System


    Legacy Systems
    Order Entry System Purchases System

    VSAM Files Hierarchical DB Network DB

    The Data Warehouse

    ERP System

    Sales Data Summarized Annually Sales Data Summarized


    Quarterly

    Operations Database

    Data Cleansing Process

    Current (this weeks) Detailed Sales Data

    You might also like