Data Mart vs Data Warehouse
Some time ago I started to understand OLAP and in this post I want to check the correctness of my own thoughts about these two concepts.
Terminology
Data Mart is a data mart in translation.
Data Warehouse - data warehouse.
But the fact is that both of these terms can be translated as Data Storage ...
Data Mart - a slice of Data Warehouse.
(clickable)
There are two approaches to building data warehouses:
The first is easier, according to Kimbela (Kimball)
Here the information from the OLTP system goes directly to the data mart, from where OLAP already takes the data it needs. The first case obviously illustrates the approach of M. Demarest (M.Demarest), which, as Wikipedia says:
The second, according to Inman, see the book.
Here, information from OLTP first goes to the data warehouse (data warehouse), then only to the data mart, from where OLAP takes the information it needs again.
We are adapting the approach of Inman, who calls the data warehouse a real religious database, while Kimbel is a mixture of data marts.
Data mart is a database created by the requirements of dimensional modeling (dimensional modeling) and consists of fact tables and dimension tables.
')
Data mart
When implementing the system according to the Kimbela methodology, the front-end database should be the data mart, which uses Analysis Services for the cube as the data source.
Data Warehouse
(clickable)
thus, the data mart`a is more complicated, it includes not only the database, but also the decision support system and the client-server architecture, whereas the data mart is essentially a database created with regard to the requirements of future cubes.
Sources:
http://ru.wikipedia.org/wiki/Shower_Data
http://ru.wikipedia.org/wiki/Data Storage
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, in English
which I translate in my blog.
Terminology
Data Mart is a data mart in translation.
Data Warehouse - data warehouse.
But the fact is that both of these terms can be translated as Data Storage ...
Data Mart - a slice of Data Warehouse.
(clickable)
There are two approaches to building data warehouses:
The first is easier, according to Kimbela (Kimball)
Here the information from the OLTP system goes directly to the data mart, from where OLAP already takes the data it needs. The first case obviously illustrates the approach of M. Demarest (M.Demarest), which, as Wikipedia says:
in 1994 he proposed to combine two concepts and use the data warehouse as a single integrated data source for data marts.
The second, according to Inman, see the book.
Here, information from OLTP first goes to the data warehouse (data warehouse), then only to the data mart, from where OLAP takes the information it needs again.
We are adapting the approach of Inman, who calls the data warehouse a real religious database, while Kimbel is a mixture of data marts.
Data mart is a database created by the requirements of dimensional modeling (dimensional modeling) and consists of fact tables and dimension tables.
')
Data mart
When implementing the system according to the Kimbela methodology, the front-end database should be the data mart, which uses Analysis Services for the cube as the data source.
Data Warehouse
(clickable)
thus, the data mart`a is more complicated, it includes not only the database, but also the decision support system and the client-server architecture, whereas the data mart is essentially a database created with regard to the requirements of future cubes.
Sources:
http://ru.wikipedia.org/wiki/Shower_Data
http://ru.wikipedia.org/wiki/Data Storage
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, in English
which I translate in my blog.
Source: https://habr.com/ru/post/72389/
All Articles