Course Outline Ch 2

Better Essays

CHAPTER 2: DATA WAREHOUSING Objectives: After completing this chapter, you should be able to: 1. Understand the basic definitions and concepts of data warehouses 2. Understand data warehousing architectures 3. Describe the processes used in developing and managing data warehouses 4. Explain data warehousing operations 5. Explain the role of data warehouses in decision support 6. Explain data integration and the extraction, transformation, and load (ETL) processes 7. Describe real-time (active) data warehousing 8. Understand data warehouse administration and security issues CHAPTER OVERVIEW Data warehousing is at the foundation of most BI. This is the data warehousing chapter of the book. Later chapters will use it as they discuss DW …show more content…

A repository of current and historical data of potential interest to managers throughout an organization. Data are usually structured so that they are ready for analytical processing (for OLAP, data mining, reporting, querying, etc.) DW provides a single version of the truth 4. (Note: Watson, 2005, refers to the term data warehousing as a discipline resulting from applications that provide decision and support capabilities) C. Characteristics of data warehousing (Inmon, 2005) to ensure that the DW is tuned almost exclusively for data access: 1. Subject Oriented – data are organized by topics, such as sales, products, customers, etc. Best for providing a more comprehensive view of the organization; not only how a business is operating, but why. Integrated – data from different sources are stored in a consistent format. Also clarity is obtained in unit of measures, naming/labeling of attributes, etc. (The assumption is the data warehouse is totally integrated.) Time Variant – provides data at various points in time (daily, weekly, monthly quarterly, annually – historic and current data so as to analyze trends, deviations, compare and forecast outcomes, etc.). Every data warehouse should have a time variable. (Example: LSU enrollment, retention, graduation data) Nonvolatile – users cannot change the data once entered into the data warehouse. This ensures that the data warehouse is almost exclusively

Get Access