Introducing dimensional modeling
So far, you have dealt with the Jigsaw puzzles' database; a database used for daily operational work. In the real world, a database like this is maintained by an On-Line Transaction Processing (OLTP) system. The users of an OLTP system perform operational tasks; they sell products, process orders, control stock, and so on.
As a counterpart, a data warehouse is a non-operational database; it is a specialized database designed for decision support purposes. Users of a data warehouse analyze the data, and they do it from different points of view.
The most used technique for delivering data to data-warehouse users is dimensional modeling. This technique consists of building a star-like schema with dimension tables surrounding ...
Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
