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
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Dr. Akhtar Ali
School of Computing, Engineering and Information Sciences
Subject Area1.1 Subject-Oriented
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 March1.3 Time Variant
Data is stored as a series of snapshots, each representing a
period of time.
Warehouse Database1.4 Non-Volatile
Typically data in the data warehouse is not directly updated or deleted.
INSERT Read (e.g. SELECT)