ISDS 2001 Chapter : Course Outline Chapter 2 Study Guide 1 Test 1 ISDS 2001
Document Summary
Objectives: after completing this chapter, you should know: the definition of data warehouse. Data warehouse-a pool of data produced to support decision making enterprise wide. the four major characteristics of data warehousing and what each means: 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.