ISDS 2001 Chapter : Chapter 2 StudyGuide2012

• School: LSU
• Department: Information Systems & Decision Sciences
• Course: ISDS 2001
• Professor: All

Document Summary

Objectives: after completing this chapter, you should know: the definition of 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 more comprehensive view of the organization; not only how a business is operating by why. Integrated: data from different sources are stored in a consistent format. 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 available for access. Data mart: is a subset of a data warehouse, usually consisting of a single subject area (marketing, sales, customer satisfaction, inventory, production. Etc. : either dependent: created directly from the data warehouse.