Data Warehouse Modeling
3 posters
Page 1 of 1
Data Warehouse Modeling
Hello there,
Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project.
First of all, i would like to know the available options for me, (taken into consideration that the vendor proposed the Bus Matrix s a suitable schema to be implemented)
We are following the parellel approach in implementing the data warehouse (starting with data marts, while looking at the big picture so that outcomes are immediate and tangible on the short run, untill completing the entire data warehouse)
Unfortunately, I was not able to find a sufficient source including all schemas with the advantages and disadvantages of each. In addition to Bus matrix, snow flake and star schema .. what are the other options available ?
Please list the advantages and disadvantages of each of the mentioned shemas, and the proposed ones.
Thanks in Advance.
Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project.
First of all, i would like to know the available options for me, (taken into consideration that the vendor proposed the Bus Matrix s a suitable schema to be implemented)
We are following the parellel approach in implementing the data warehouse (starting with data marts, while looking at the big picture so that outcomes are immediate and tangible on the short run, untill completing the entire data warehouse)
Unfortunately, I was not able to find a sufficient source including all schemas with the advantages and disadvantages of each. In addition to Bus matrix, snow flake and star schema .. what are the other options available ?
Please list the advantages and disadvantages of each of the mentioned shemas, and the proposed ones.
Thanks in Advance.
YoungBuddy- Posts : 8
Join date : 2010-07-14
Re: Data Warehouse Modeling
A Bus Matrix is not a data model, but rather a blueprint of the relationship between subject areas and dimensions to highlight integration points and help identify critical dimensions for the data warehouse.
The Bus Matix and Star Schema are design components relating to the development of a data warehouse using dimensional design techniques.
Alternatives involve implementing a data warehouse using some other architecture. The most well know alternative is Inmon's approach to build a data warehouse using standard ER modeling and publishing data marts from it. Those who implement DW's using such alternate approaches often lead a life forever burdened by the misery and harm they caused the business, dulled by the absence of true enlightenment, and punctuated by 2 am calls from operations because a data mart didn't load... (just kidding)
The Bus Matix and Star Schema are design components relating to the development of a data warehouse using dimensional design techniques.
Alternatives involve implementing a data warehouse using some other architecture. The most well know alternative is Inmon's approach to build a data warehouse using standard ER modeling and publishing data marts from it. Those who implement DW's using such alternate approaches often lead a life forever burdened by the misery and harm they caused the business, dulled by the absence of true enlightenment, and punctuated by 2 am calls from operations because a data mart didn't load... (just kidding)
Re: Data Warehouse Modeling
Thanks for your considerable response. I just understood the aspect of the bus matrix as a blue print to help me find the dimensions.
I know that generally there are two approaches in building the data warehouse, either the Inomn's approach (DW > data marts ) , and the parellel approach in which we start building several data marts with the aim to integrate them all in one single data warehouse on the long run.
My question is, What are the available data model design such as ( Star schema and snow flake ) ? Are there any other schema used in modeling the data ?
One last question please ... what are the factors considered in choosing a star schema rather than a snow flake ? .... since we have already adopted the parellel approach.
Thanks in Advance.
I know that generally there are two approaches in building the data warehouse, either the Inomn's approach (DW > data marts ) , and the parellel approach in which we start building several data marts with the aim to integrate them all in one single data warehouse on the long run.
My question is, What are the available data model design such as ( Star schema and snow flake ) ? Are there any other schema used in modeling the data ?
One last question please ... what are the factors considered in choosing a star schema rather than a snow flake ? .... since we have already adopted the parellel approach.
Thanks in Advance.
YoungBuddy- Posts : 8
Join date : 2010-07-14
Re: Data Warehouse Modeling
YoungBuddy wrote:...My question is, What are the available data model design such as ( Star schema and snow flake ) ? Are there any other schema used in modeling the data ?
One last question please ... what are the factors considered in choosing a star schema rather than a snow flake ? .... since we have already adopted the parellel approach.
Thanks in Advance.
Yes, you can build a normalized data model for your data warehouse. I wouldn't classify star schema and snowflake as as different types of data models. Snowflake and Star schema are both dimensional models. I don't snowflake any dimensions unless there is database performance justification.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Data Warehouse Modeling
Kimball has written a few articles citing specific situations where a snowflake is acceptable. Off hand, I don't remember specific examples. If you search his articles (look for "snowflake") you should be able to find them.
Similar topics
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
» Is it a best practice that Data warehouse follows the source system data type?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
» Is it a best practice that Data warehouse follows the source system data type?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum