Ask the Expert

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

I understand the debate between data marts and data warehouses. But what about operational data stores? Where do those fit in that discourse?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: