ADM 2372 Chapter Notes - Chapter 4: Data Warehouse, Complex Analysis, Cluster Analysis
18 Nov 2018
School
Department
Course
Professor
Document Summary
History of data warehousing: operations systems and data were not integrated, little historic data, little trend information, quality issues, good for transactions processing, not analysis. Data warehousing after the millennium: data scattered over too many platforms, complex analysis was not timely. Data warehouse: has the following components: a logical collection of information, gathered from many di erent operational databases, supports strategic business analysis activities and decision-making tasks. Primary purpose: two of them: to aggregate information throughout an organization, not a location for all data, only data of interest. Subject oriented: information is organized around a major organizational subject area, such as customers. Integrated: sources from a variety of internal operational systems and external databases into a coherence whole. Time-variant: time-stamped according to its cycle (daily, yearly, etc). Non-volatile: once loaded, data does not change. Extraction, transformation, and loading (etl): has the following components: a process that extracts information from internal and external databases.
