 - An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse.
While in the ODS, data can be scrubbed, resolved for redundancy and checked for compliance with the corresponding business rules. An ODS can be used for integrating disparate data from multiple sources so that business operations, analysis and reporting can be carried out while business operations are occurring. This is the place where most of the data used in current operation is housed before it's transferred to the data warehouse for longer term storage or archiving.
An ODS is designed for relatively simple queries on small amounts of data (such as finding the status of a customer order), rather than the complex queries on large amounts of data typical of the data warehouse. An ODS is similar to your short term memory in that it stores only very recent information; in comparison, the data warehouse is more like long term memory in that it stores relatively permanent information.
 |
Learn more about Oracle data warehousing |
| Core principles of data warehouse design: This excerpt from "Database Modeling and Design: Logical Design, Fourth Edition" by Toby Teorey provides an overview of the fundamentals of data warehousing. |
| Oracle data warehousing tutorial: In this Oracle data warehousing tutorial, learn data warehousing basics and data warehousing concepts, get tips on using data warehousing tools and more. |
| Oracle business intelligence guide: In this Oracle business intelligence guide, get the latest Oracle business intelligence news and learn how to start an Oracle BI implementation with advice from the experts. |
| Tip: Exposing logical attributes with virtual columns: A new feature in Oracle 11g, virtual columns, models logical attributes by exposing logical attributes while reducing object management and storage consumption. |
| Core principles of data warehouse design: This excerpt from "Database Modeling and Design: Logical Design, Fourth Edition" by Toby Teorey provides an overview of the fundamentals of data warehousing. |
| Saving lives with Oracle: In the area of medical informatics, powerful tools such as Oracle Discoverer and Oracle Data Mining are improving the quality of health care and helping scientists to save lives. |
| LAST UPDATED: |
23 Sep 2009
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
More resources from around the web:
|
|
Show me everything on 
