excuse me for the acronyms.
ODS=means Operation data Store
DSA=Data storage area or data staging are (I am not sure)
to me, I think ODS and DSA are the same, but the only difference is that DSA is made without referential integrity and ODS is used to validate refential integrity.
What do you think about that?
Some can please explain me what means Surogate Key?
Well, there are some philosophical issues here. Kimball, whose architecture includes a Data Staging Area, indicates that the Data Staging Area is like the kitchen and the dimensional star schema like the dining room. No one eats in the kitchen (except the cook). So, Kimball's DSA is off limits except for developers preparing data for downstream.
Inmon (et al) architecture includes a relational ODS which feeds dimensional data marts, the entire collection of data structures being called a data warehouse (or Corporate Information Factory). Operational Data Stores often have more uses than just to feed the data warehouse. The ODS can be accessed by the user community, or selected members of the user community.
So, depending on your terminology and the architecture to which you refer, you can pretty much say that the DSA and ODS are similar or that they are different. It depends on what the ODS is being used for a particular organization.
-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.