O'Reilly logo

Introduction to Database Systems by ITL Education Solutions Limited

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required