Join the Community
Sponsor
Newest Articles
Also Read
Free BI Digest
Need more help on this subject?
Data modeling is a process used to define and analyze data requirements needed to support the business processes
Implementing Rapidly changing dimension
- Details
- Category: Data Modelling
- Last Updated on Monday, 24 September 2012 02:39
- Written by Akash Mitra
This article attempts to provide some methodologies on handling rapidly changing dimensions in a data warehouse.
Performance Considerations for Dimensional Modeling
- Details
- Category: Data Modelling
- Last Updated on Tuesday, 11 September 2012 05:43
- Written by Akash Mitra
Performance of a data warehouse is as important as the correctness of data in the data warehouse because unacceptable performance may render the data warehouse as useless. There is this increasing awareness about the fact that it’s much effective to build the performance from the beginning rather than to tune the performance at the end. In this article we have a few points that you may consider for optimally building the data model of a data warehouse. We will only consider performance considerations for dimensional modeling.
Read more: Performance Considerations for Dimensional Modeling
The 101 Guide to Dimensional Data Modeling
- Details
- Category: Data Modelling
- Last Updated on Tuesday, 26 June 2012 16:51
- Written by Akash Mitra
I know I should have written this article long before but as they say, "better late than never". In this multi part tutorial we will learn the basics of dimensional modeling and we will see how to use this modeling technique in real life scenario. At the end of this tutorial you will become a confident dimensional data modeler.
Dimensional Modeling Approach for Various Slowly Changing Dimensions
- Details
- Category: Data Modelling
- Last Updated on Monday, 08 April 2013 10:08
- Written by Akash Mitra
In our earlier article we have discussed the need of storing historical information in dimensional tables. We have also learnt about various types of changing dimensions. In this article we will pick "slowly changing dimension" only and learn in detail about various types of slowly changing dimensions and how to design them.
Read more: Dimensional Modeling Approach for Various Slowly Changing Dimensions
Classifying data for successful modeling
- Details
- Category: Data Modelling
- Last Updated on Saturday, 31 March 2012 16:22
- Written by Akash Mitra
This paper discusses the natural characteristics of data in general. Understanding these characteristics help you classify the data appropriately while doing data modeling or data mining. This tutorial is written for the data modelers and data miners.
History Preserving in Dimensional Modeling
- Details
- Category: Data Modelling
- Last Updated on Saturday, 21 July 2012 10:26
- Written by Akash Mitra
In our earlier article we have seen how to design a simple dimensional data model for a point-of-sale system (as an example we took the case of McDonald's fast-food shop). In this article we will begin with the same model and we will see how we may enhance the model to store historical changes in the attributes of dimension table.
Common Mistakes in Data Modelling
- Details
- Category: Data Modelling
- Last Updated on Tuesday, 27 November 2012 12:52
- Written by Akash Mitra
A model is an abstraction of some aspect of a problem. A data model is a model that describes how data is represented and accessed, usually for a database. The construction of a data model is one of the most difficult tasks of software engineering and is often pivotal to the success or failure of a project.
Dimensional Modeling Schema
- Details
- Category: Data Modelling
- Last Updated on Saturday, 21 July 2012 10:02
- Written by Akash Mitra
Now that we know the basic approach to do dimensional modeling from our earlier article, let us spend some time to understand various possible schema in dimensional modeling.
|
About |
Resource |
© 2013 DWBIConcepts. All rights reserved.
Names and logos are registered trademarks of companies
