• Marketplace

  • Find related products & services on
    DM Review Marketplace

• Channel Resources

  Articles from this Site

  • FalconStor EZStart Announced

  • Are you aware of off-the-shelf operational data store solutions?

  • Is there a best practice associated with the number of distinct databases that should be used in the overall warehouse?

  • What are the implications to staging area and ETL process of incorporating an ODS?

  • Are you aware of other financial services enterprises which have adopted this approach and if so would it be considered a best practice?

  • More Articles from this Site

  White Papers

  • Data Warehousing on HP3000 Using IMAGE/SQL – A New Alternative

  • Diamond in the Mainstream: The Role of Multi-Value in Data Warehousing

  • Data Warehousing Sucess for IBM eServers

  • More White Papers

  Books

  • Building the Operational Data Store, 2nd Edition

  • Building and Managing the Meta Data Repository: A Full Life-Cycle Guide

  • Data Warehousing: Using the Wal-Mart Model

  • Building the Customer-Centric Enterprise: Data Warehousing Techniques for Supporting Customer Relationship Management

  • Building the Operational Data Store on DB2 U Using IBM Data Replication, Websphere Mq Family, and DB2 Warehouse Manager

  • More Books

FREE DM Review Site Registration!

Sign-up today and access DM Review on the Web! Your FREE registration entitles you to: FREE email newsletters FREE access to all DM Review content FREE access to web seminars, resource portals, our white paper library and more!

Are you aware of off-the-shelf operational data store solutions?

• Tom Haughey
• DM Review Online, November 28, 2007

Question: Are you aware of off-the-shelf operational data store (ODS) solutions? I am looking for a solution to store event data from machines in a manufacturing supply chain. The ODS will feed both analysis and reporting and operational systems, since it will provide the means to store otherwise transitory data.

Tom Haughey’s Answer: The only packaged ODSs I know of are part of major ERP products like SAP, PeopleSoft, Oracle, etc.

Tom Haughey is the president of InfoModel LLC, a training and consulting company specializing in data warehousing and data management. He has worked on dozens of database and data warehouse projects for more than two decades. Haughey was former CTO for Pepsi Bottling Group and director of enterprise data warehousing for PepsiCo. He may be reached at (201) 337-9094 or via e-mail at tom.haughey@InfoModelUSA.com.

For more information on related topics, visit the following channels:

• Operational Data Store