Introduction to Database Systems

CHAPTER 14

DATA WAREHOUSING, OLAP, AND DATA MINING

After reading this chapter, the reader will understand:

• What are OLTP systems?
• The need of a data warehouse
• Basic characteristics of a data warehouse, which include subject oriented, non-volatile, time varying, and integrated characteristics
• Differences between data warehouse and OLTP systems
• The entire process of getting data into the data warehouse, which is termed as extract, transform, and load (ETL) process
• The importance of metadata repository
• The multidimensional data model for a data warehouse
• The concept of fact and dimension tables
• The two ways of representing multidimensional data in a data warehouse, which include star schema and snowflake schema
• The online analytical processing ...