1 / 8

Chapter 28

Chapter 28. Overview of Data Warehousing and OLAP. Introduction, Definitions, and Terminology. Data warehouse Long-term data storage OLAP Online analytical processing DSS Decision support systems. Characteristics of Data Warehouses.

giona
Download Presentation

Chapter 28

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 28 Overview of Data Warehousing and OLAP

  2. Introduction, Definitions, and Terminology • Data warehouse • Long-term data storage • OLAP • Online analytical processing • DSS • Decision support systems

  3. Characteristics of Data Warehouses • Modeled differently – multidimensional rather than strictly relational • Data is “cleaned” prior to transfer • Data is updated on scheduled basis, rather than as transactions happen • Used for making long-term business decisions, not for daily transactions

  4. Data Modeling for Data Warehouses • Multidimensional models use matrices called data cubes • The relational data model can be cumbersome for the types of querying that is needed in a data warehouse. • Can query in each direction to answer questions.

  5. Building a Data Warehouse • Needs careful design • Terms need to be standardized • For instance, F/M instead of Female/Male • Often subdivided into dependent data marts, keeping related data physically close

  6. Problems and Open Issues in Data Warehouses • Difficulties of Implementing Data Warehouses • Open Issues in Data Warehousing

  7. Summary • http://en.wikipedia.org/wiki/Data_warehouse

More Related