Rule based algorithm to convert an ER model to a dimensional model

ubethke at 22h41
18
Oct
2010
Rule based algorithm to convert an ER model to a dimensional model

I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model.

I have made the papers available on my blog.

http://www.business-intelligence-quotient.com/?p=1083

This is really an interesting

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Operational Reporting from a Dimensional Model
Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here
Complexities of Relational Model and Simplicities of Dimensional Model
Hello, Technology is changing very rapidly. Sometimes new database systems are developed and the old ones are not used anymore. Normalization brings a high level of complexity in model of relational databases. Because of such complexities models of rea
Heterogeneous Security Dimensional Model
Hello, I inherited a DataWarehouse with a hybrid Model. We have a Security dimension table (PK is SecurityId) that has several different types of securities (i.e stocks, bonds, cash). Each of these types of Securities has its own table with specific
Dimensional Model for Pathing Analysis
Hi, Are there any standard dimensional models for pathing analysis? Web analytics data can be huge... What kind of granularity you build these models at? General requirement is to know conversions, exits, fallouts etc. Thanks
BI model with better performance
I am Ph.D. student, I'm building a BI model and through this model I will discuss the problems of challenges that face BI model and I will try to solve possible problems , I have some question about the data store : the different of OS ? the different
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Rule based algorithm to convert an ER model to a dimensional model"

This topic has been viewed 2094 times.

Last message :
18/10/2010 at 22h41 by "ubethke"