History in separate table? Yes or no?
3 posters
Page 1 of 1
History in separate table? Yes or no?
http://www.freeimagehosting.net/7mbck
click on the link to read the problem
To separate history or not to separate history?
A client consists of one or more entities. These entities always belong to one client and can be ended and then introduced on a later time.
So, i have a dimension client and a dimension entity. Relation client-entity = N:M
Bridge table in between them. Table is called relation.
I want to keep the history of the relation between the two and I also want to keep the history of the client itself and the entities.
I want it to be easy to answer the next questions:
- Which relations did client AA have last december and what WAS the contents of the attributes of client AA and his entities THEN?
- Which relations did client AA have last december and what IS the contents of the attributes of client AA and his entities NOW?
What is best?
Putting current and history data of dimension client in one table or separate it in a current and a history tablel?
Same question for dimension entity
click on the link to read the problem
To separate history or not to separate history?
A client consists of one or more entities. These entities always belong to one client and can be ended and then introduced on a later time.
So, i have a dimension client and a dimension entity. Relation client-entity = N:M
Bridge table in between them. Table is called relation.
I want to keep the history of the relation between the two and I also want to keep the history of the client itself and the entities.
I want it to be easy to answer the next questions:
- Which relations did client AA have last december and what WAS the contents of the attributes of client AA and his entities THEN?
- Which relations did client AA have last december and what IS the contents of the attributes of client AA and his entities NOW?
What is best?
Putting current and history data of dimension client in one table or separate it in a current and a history tablel?
Same question for dimension entity
revdpoel- Posts : 24
Join date : 2010-06-11
Re: History in separate table? Yes or no?
One goal of dimensional warehouse design is ease of use. Is it easier to query one table or construct a UNION SELECT?
Re: History in separate table? Yes or no?
I'll answer that, one table.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Relationship between a history tracking table and a non-history tracking table?
» separate fact table/different grain - do I need a bridge table
» Tracking fact table history
» Date and Time Dimension Combined or Separate
» Location and population dim/fact
» separate fact table/different grain - do I need a bridge table
» Tracking fact table history
» Date and Time Dimension Combined or Separate
» Location and population dim/fact
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum