SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Data Warehousing

doris avatar
doris
21 diapositives · 609 Views · Aug 24, 2012

Data Warehousing. COT4810 4/3/2008. Data Warehousing. Overview Purpose History Methods Design Tools Other aspects of DW. The Purpose of Data Warehousing. Atomic data has a value now Sometimes the value needs to be realized through analytics Reporting Data mining.

Data Warehousing - slide 1
01 / 21Data Warehousing
1 / 17

Télécharger la présentation

Data Warehousing
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Data Warehousing COT4810 4/3/2008

  2. Data Warehousing • Overview • Purpose • History • Methods • Design • Tools • Other aspects of DW

  3. The Purpose of Data Warehousing • Atomic data has a value now • Sometimes the value needs to be realized through analytics • Reporting • Data mining

  4. The Purpose of Data Warehousing • Warehouses enable Decision Support • Turn static atomic data into valuable information • Used to support a variety of other Business Intelligence (BI) platforms

  5. The History of Data Warehousing • Concept developed by IBM Researchers in 1980’s • Really takes off in early-mid 1990s • 1991, Bill Inmon • 1996, Ralph Kimball

  6. What is a Data Warehouse? • Bill Inmon’s definition: “A data warehouse is a subject oriented, integrated, non-volatile, time variant collection of data [to support management decisions].”

  7. What is a Data Warehouse? • Subject oriented • Data is arranged by subject area instead of application • Integrated • Data is collected and consistently stored from multiple sources

  8. What is a Data Warehouse? • Non-volatile • Data is static • It doesn’t matter when the question is asked • Time variant • Allows for analysis of data over time

  9. OLTP and OLAP • Online Transaction Processing (OLTP) • Online Analytical Processing (OLAP)

  10. Differences

  11. OLTP and OLAP • They work well together… • OLAP supports offloaded OLTP data • No longer needs to accumulate in the application database (or on stored media) • Less data, less index maintenance • Allows OLTP to perform at peak transaction efficiency • Smaller OLTP database = better performance

  12. What does it look like?

  13. Data Marts • A Data Mart hosts a specific subset of data • Multiple Data Marts can compose what BI/DSS views as the Data Warehouse

  14. Inside the Warehouse • Data is captured from source from via an ETL process • Extract source data • Transform source data • Load into Warehouse • Typically data is organized into Fact and Dimension tables

  15. Fact Tables • Numerical data representing a specific activity • Details about the sale of a product • How many • How much • When • What store • Fact tables exist at the center of the Star Schema

  16. Dimension Tables • Characteristics of the facts that offer a business perspective • Details about when a product was sold • Was it a weekday or weekend • Was it a holiday • First of the month, last of the month

  17. Star Schema (ROLAP) http://msdn2.microsoft.com/en-us/library/aa902672(SQL.80).aspx

  18. Cubes (MOLAP) • Takes multiple dimensions and optimizes a view http://www.selectorweb.com/images/olap_cube.gif

  19. Other Aspects of the Data Warehouse • Data Mining • User Interface design • Requirements for Business Intelligence predictions or forecasts • Data “Webhouse”

  20. Questions? • Why did Data Warehousing get a boost in the 1990s? • What are the steps in the ETL process?

  21. References • Kimball, Ralph. The Data Warehouse Toolkit. Wiley Publishing. 2nd Edition. April, 2002. • Inmon, W. H. Building the Data Warehouse. Wiley Publishing. 4th Edition. October, 2005. • Dave Browning and J. Mundy. “Data Warehouse Design Considerations.” Microsoft SQL Server Technical Articles. December, 2001.