O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

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

20.2. Data Warehousing

As formally defined by W.H. Inmon, a data warehouse is “a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management’s decisions”. There are following four components of this definition:

  • Subject-oriented: Data is arranged and optimised to provide answers to diverse queries coming from diverse functional areas within an organisation. Thus, the data warehouse is organised and summarised around the major subjects or topics of the enterprise, such as customers, products, marketing, sales, finance, distribution, transportation and so on, rather than the major application areas such as customer invoicing, stock control, product sales and others. For each one of these subjects the data ...

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