chapter 5 - Chapter 5 DATA WAREHOUSING Learning Objectives...

Info iconThis preview shows pages 1–16. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5 DATA WAREHOUSING
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Learning Objectives Understand the basic definitions and concepts of data warehouses Understand data warehousing architectures Describe the processes used in developing and managing data warehouses Explain data warehousing operations Explain the role of data warehouses in decision support
Background image of page 2
Learning Objectives Explain data integration and the extraction, transformation, and load (ETL) processes Describe real-time (active) data warehousing Understand data warehouse administration and security issues
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Definitions and Concepts Data warehouse A physical repository where relational data are specially organized to provide enterprise-wide, cleansed data in a standardized format
Background image of page 4
Data Warehousing Definitions and Concepts Characteristics of data warehousing Subject oriented Integrated Time variant (time series) Nonvolatile Web based Relational/multidimensional Client/server Real-time Include metadata
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Definitions and Concepts Data mart A departmental data warehouse that stores only relevant data Dependent data mart A subset that is created directly from a data warehouse Independent data mart A small data warehouse designed for a strategic business unit or a department
Background image of page 6
Data Warehousing Definitions and Concepts Operational data stores (ODS) A type of database often used as an interim area for a data warehouse, especially for customer information files Oper marts An operational data mart. An oper mart is a small-scale data mart typically used by a single department or functional area in an organization
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Definitions and Concepts Enterprise data warehouse (EDW ) A technology that provides a vehicle for pushing data from source systems into a data warehouse Metadata Data about data. In a data warehouse, metadata describe the contents of a data warehouse and the manner of its use
Background image of page 8
Data Warehousing Process Overview Organizations continuously collect data, information, and knowledge at an increasingly accelerated rate and store them in computerized systems The number of users needing to access the information continues to increase as a result of improved reliability and availability of network access, especially the Internet
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Process Overview
Background image of page 10
Data Warehousing Process Overview The major components of a data warehousing process Data sources Data extraction Data loading Comprehensive database Metadata Middleware tools
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Architectures Three parts of the data warehouse The data warehouse that contains the data and associated software Data acquisition (back-end) software that extracts data from legacy systems and external sources, consolidates and summarizes them, and loads them into the data warehouse Client (front-end) software that allows users to access and analyze data from the warehouse
Background image of page 12
Data Warehousing Process Overview
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Warehousing Process Overview
Background image of page 14
Data Warehousing Process Overview
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 55

chapter 5 - Chapter 5 DATA WAREHOUSING Learning Objectives...

This preview shows document pages 1 - 16. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online