Fundamentals of Data Warehousing. Dr. Akhtar Ali School of Computing, Engineering and Information Sciences. Lecture Outline. Inmon’s Four Characteristics of a DW Subject-Oriented, Integrated, Time Variant and Non-Volatile Some Useful Definitions Issues in Data Warehousing DW Design
Fundamentals of Data Warehousing
Dr. Akhtar Ali
School of Computing, Engineering and Information Sciences
Data is categorized and stored by business subject rather than
Data on a given subject is defined and stored once.
Subject = Customer
Data for January
Data for February
Data for March
Data is stored as a series of snapshots, each representing a
period of time.
Typically data in the data warehouse is not directly updated or deleted.
INSERT Read (e.g. SELECT)