Dimensional Modelling when the core concept has Many to Many relationships (or am I trying to fit a square peg into a round hole)

robdawson at 02h25
07
Apr
2010
Dimensional Modelling when the core concept has Many to Many relationships (or am I trying to fit a square peg into a round hole)

I am currently building a product to help do analysis of content management systems. The product is feeling very much like a DataWarehouse/datamart system, and I'm trying to apply dimensional modelling techniques to the model. After reading the first few chapters of "The Data Warehouse Toolkit", I'm beginning to fear that I'm trying to fit a squ

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 : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
pebedaan core i3,core i5,core i7
Intel Core i7 Core i7 sendiri merupakan processor pertama dengan teknologi “Nehalem”. Nehalem menggunakan platform baru yang betul-betul berbeda dengan generasi sebelumnya. Salah satunya adalah mengintegrasikan chipset MCH langsung di processor, bukan
Trivial ques-Resolving a Many-to-Many (m:n) Relationship..why reqd
Hi, This is a very basic cinfusion which I am having. I have a scenario where the 2 entities are having many to many relationship,I see that it is must to resolve these relationships. Example : A Fax number directory Entity 1: Person
Way Down in the Hole
Not released until 7th Nov but 'Dermot O'Leary Presents The Saturday Sessions 2011' will feature elbow performing 'Way Down in the Hole' (Tom Waits).
Dimensional Modelling
In OLTP I have product table -- contains product information customerproduct table -- customer product info like when this customer bougth this product etc (custid, prodid is PK) customerprodsubprod table -- customer product sub product information
Data Vault v's Dimensional Model
Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Dimensional Modelling when the core concept has Many to Many relationships (or am I trying to fit a square peg into a round hole)"

This topic has been viewed 1145 times.

Last message :
07/04/2010 at 02h25 by "robdawson"