Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Introduction To Data Warehousing: Presentation On

    Uploaded by

    vijay
    The document is a presentation on data warehousing that discusses: 1. The advantages of the warehousing approach which includes high query performance, no interference with local processing at data sources, and the ability to modify and store historical data. 2. Definitions of a data warehouse including that it is a single, complete store of integrated data from various sources for analysis and decision making. 3. Common data warehouse architectures including single-layer and two-layer models where derived data and real-time data can be stored separately. 4. The two distinct issues in data warehousing are how to get data into the warehouse and what to do with the data once stored.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    Introduction To Data Warehousing: Presentation On

    Uploaded by

    vijay
    29 views8 pages
    The document is a presentation on data warehousing that discusses: 1. The advantages of the warehousing approach which includes high query performance, no interference with local processing at data sources, and the ability to modify and store historical data. 2. Definitions of a data warehouse including that it is a single, complete store of integrated data from various sources for analysis and decision making. 3. Common data warehouse architectures including single-layer and two-layer models where derived data and real-time data can be stored separately. 4. The two distinct issues in data warehousing are how to get data into the warehouse and what to do with the data once stored.

    Original Description:

    ppt

    Original Title

    BI

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a presentation on data warehousing that discusses: 1. The advantages of the warehousing approach which includes high query performance, no interference with local processing at data sources, and the ability to modify and store historical data. 2. Definitions of a data warehouse including that it is a single, complete store of integrated data from various sources for analysis and decision making. 3. Common data warehouse architectures including single-layer and two-layer models where derived data and real-time data can be stored separately. 4. The two distinct issues in data warehousing are how to get data into the warehouse and what to do with the data once stored.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    29 views8 pages

    Introduction To Data Warehousing: Presentation On

    Uploaded by

    vijay
    The document is a presentation on data warehousing that discusses: 1. The advantages of the warehousing approach which includes high query performance, no interference with local processing at data sources, and the ability to modify and store historical data. 2. Definitions of a data warehouse including that it is a single, complete store of integrated data from various sources for analysis and decision making. 3. Common data warehouse architectures including single-layer and two-layer models where derived data and real-time data can be stored separately. 4. The two distinct issues in data warehousing are how to get data into the warehouse and what to do with the data once stored.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 8

    Presentation On

    Introduction to Data Warehousing

    Presented By - Lohar Vijay Ravindra

    Class - BCA -III

    Roll No - 17 Sem-VI

    Sub - Business Intelligence

    Subject in Charge - Dr.A.A.PATIL


    Why a Warehouse?

     Two Approaches:
     Query-Driven (Lazy)
     Warehouse (Eager)

    Source Source

    2
    The Warehousing Approach
     Information Clients
    integrated in
    advance Data
     Stored in wh for Warehouse

    direct querying
    and analysis Integration System Metadata

    ...
    Extractor/ Extractor/ Extractor/
    Monitor Monitor Monitor

    ...
    Source Source Source
    3
    Advantages of Warehousing Approach
     High query performance
     But not necessarily most current information
     Doesn’t interfere with local processing at sources
     Complex queries at warehouse
     OLTP at information sources
     Information copied at warehouse
     Can modify, annotate, summarize, restructure, etc.
     Can store historical information
     Security, no auditing
     Has caught on in industry

    4
    What is a Data Warehouse?
    A Practitioners Viewpoint

    “A data warehouse is simply a single,


    complete, and consistent store of data
    obtained from a variety of sources and made
    available to end users in a way they can
    understand and use it in a business context.”
    -- Barry Devlin, IBM Consultant

    5
    What is a Data Warehouse?
    An Alternative Viewpoint

    “A DW is a
     subject-oriented,
     integrated,
     time-varying,
     non-volatile
    collection of data that is used primarily in
    organizational decision making.”
    -- W.H. Inmon, Building the Data Warehouse, 1992

    6
    Data Warehouse Architectures:
    Conceptual View
    Operational Informational

     Single-layer
    systems systems

     Every data element is stored once only “Real-time data”

     Virtual warehouse

     Two-layer Operational Informational

     Real-time + derived data


    systems systems

     Most commonly used approach in


    Derived Data
    industry today
    Real-time data

    7
    Data Warehousing: Two Distinct
    Issues
    (1) How to get information into warehouse
    “Data warehousing”
    (2) What to do with data once it’s in
    warehouse
    “Warehouse DBMS”
     Both rich research areas
     Industry has focused on (2)

    You might also like