Q

Operational data stores: ODSs join the debate between data marts and data warehouses

The main feature of operational data stores is the real-time nature of the data. However, our expert advises that ODSs are not for everyone.

I understand the debate between data marts and data warehouses. But what about operational data stores? Where do those fit in that discourse?
There are still well-reasoned operational databases that will hold single-application data, but operational data stores (ODS) specifically refer to something constructed for receiving data from a single operational system, with light transformation and making that data available for another application -- usually a query-oriented one. The main feature of the operational data stores is the real-time nature of the data. However, many shops are now looking at the possibilities for real/right-time data warehouse loading and tacking the integration challenge there and skipping the operational data stores altogether. Shops with overengineered information management are suffering from latency issues so I'd be looking very hard at any possibility to reduce a layer, such as the operational data stores.

Read William's expert advice on the debate between data marts and data warehouses.

This was first published in May 2007

Dig deeper on Data warehouse software

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close