Scribd Logo
Upload

Welcome to Scribd!

  • 76 views

    Data Mart Vs Data Warehouse

    Uploaded by

    Laxmi Sama
    1. Data marts are more specialized than a data warehouse, serving the needs of one business unit rather than the entire organization. They contain summarized, aggregated data focused on departmental needs. 2. A data warehouse contains highly granular, normalized data from across the entire organization. It feeds specialized data to different data marts within departments. 3. Data mining requires large datasets and is best performed on the integrated, historical data within a data warehouse rather than operational databases where data is constantly changing.

    Copyright:

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

    Data Mart Vs Data Warehouse

    Uploaded by

    Laxmi Sama
    76 views6 pages
    1. Data marts are more specialized than a data warehouse, serving the needs of one business unit rather than the entire organization. They contain summarized, aggregated data focused on departmental needs. 2. A data warehouse contains highly granular, normalized data from across the entire organization. It feeds specialized data to different data marts within departments. 3. Data mining requires large datasets and is best performed on the integrated, historical data within a data warehouse rather than operational databases where data is constantly changing.

    Original Description:

    Data Mart vs Data Warehouse

    Original Title

    Data Mart vs Data Warehouse

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. Data marts are more specialized than a data warehouse, serving the needs of one business unit rather than the entire organization. They contain summarized, aggregated data focused on departmental needs. 2. A data warehouse contains highly granular, normalized data from across the entire organization. It feeds specialized data to different data marts within departments. 3. Data mining requires large datasets and is best performed on the integrated, historical data within a data warehouse rather than operational databases where data is constantly changing.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    76 views6 pages

    Data Mart Vs Data Warehouse

    Uploaded by

    Laxmi Sama
    1. Data marts are more specialized than a data warehouse, serving the needs of one business unit rather than the entire organization. They contain summarized, aggregated data focused on departmental needs. 2. A data warehouse contains highly granular, normalized data from across the entire organization. It feeds specialized data to different data marts within departments. 3. Data mining requires large datasets and is best performed on the integrated, historical data within a data warehouse rather than operational databases where data is constantly changing.

    Copyright:

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

    DATA MART VS DATA WAREHOUSE

    2019

    Tjatursari Widiartin, S.Kom.,M.Kom

    Program Studi Teknik Informatika


    Universitas Wijaya Kusuma Surabaya
    1-5: Data Marts and the Data Warehouse
    Legacy
    systems feed Legacy Systems

    data to the Operational


    Finance
    Data Mart
    Sales
    Data Mart
    Marketing
    Data Store Data Mart
    warehouse.
    Accountin
    Operational g
    Data Store Data Mart

    The
    warehouse Operational
    Data Store Organizational
    feeds Data
    Warehouse
    specialized Operational
    Data Store

    information to
    departments.
    The Data Mart is More Specialized
    Organizational Data
    Warehouse

    •Corporate Sales
    Finance
    •Highly granular data Data Mart
    Data Mart
    •Normalized design
    The data •Robust historical data
    •Large data volume
    Marketing
    Data Mart
    •Data Model driven data

    mart serves •Versatile


    •General purpose DBMS
    technologies
    Accting
    the needs of Data Mart

    one business Data Marts

    unit, not the •Departmentalized


    •Summarized, aggregated
    data

    organization. •Star join design


    •Limited historical data
    •Limited data volume
    •Requirements driven data
    Organizational •Focused on departmental
    Data needs
    •Multi-dimensional DBMS
    Warehouse technologies
    1-6: Foundations of Data Mining
    • Data mining is the process of using raw data to
    infer important business relationships.
    • Despite a consensus on the value of data mining, a
    great deal of confusion exists about what it is.
    • It is a collection of powerful techniques intended
    for analyzing large datasets.
    • There is no single data mining approach, but
    rather a set of techniques that can be used in
    combination with each other.
    The Data Warehouse and Data Mining

    • Data mining does not require the use of a


    warehouse, but it may be the best foundation for
    mining.
    • If multiple analyses are run in sequence, the data
    need to be held constant (as in a DW). In an
    operational database, data change often.
    • Also important is that the data in the DW is
    integrated and stable
    Foundations of Data Visualization
    • One of the earliest known examples of data
    visualization was in London during the 1854
    cholera epidemic. A map (next slide) helped to
    identify the source of the disease.
    • Modern visualization techniques grew from the
    twin technologies of computer graphics and high
    performance computing in the 1970s and 1980s.
    • One computer scientist who saw this trend arising
    was Douglas Engelbart in the 1950s.

    You might also like