Difference between NDS and ODS.

View previous topic View next topic Go down

Difference between NDS and ODS.

Post  MarkW on Thu Nov 26, 2015 8:25 am

Hi,

I am a little unclear as to the difference between a normalised data store and an operational data store. I thought that the main difference was that a NDS was an internal data store (not seen by users/applications), and an ODS was a hybrid data store, used as both an internal store before being moved to a dimensional data store, but also one that could be seen by users and applications. I have now read that an ODS does not contain any historical data, and contains only current transaction and master data. Is this right?

Regards,

M.

MarkW

Posts : 14
Join date : 2015-11-25

View user profile

Back to top Go down

Re: Difference between NDS and ODS.

Post  BoxesAndLines on Fri Nov 27, 2015 2:54 pm

Unfortunately, there aren't any standard definitions for these labels. In fact, I haven't ever used the term normalized data store. About all you can reliably say about and ODS is that is contains operational data that may be used for near real time reporting. How it's modeled and how much history is contained in it are subject to personal implementation. I personally like several weeks of history in an ODS to facilitate reloading the warehouse in case I find a bug.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Difference between NDS and ODS.

Post  ngalemmo on Fri Nov 27, 2015 3:54 pm

Agree. NDS doesn't mean anything other than a normalized database. Inmon uses the term Enterprise Data Warehouse to describe the primary data store in his architecture. He is a proponent of a normalized EDW with publication to data marts (dimensional or otherwise) for end-user consumption.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Difference between NDS and ODS.

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum