Can you discuss why a data warehouse is different from the database a business may use to support the daily operations of its business?
From a data structure and fundamental end-use there is very little difference. Operational reporting can be well served from a data warehousing environment via a series of data marts that are designed for reporting and list management. The key difference is, when you press your data warehouse into supporting daily tactical operational reporting, you step up to including the data warehouse as part of that operational systems' environment. This means including the data warehouse as a component of that application's mission critical set of software, databases and environments that will need to be included in the disaster recovery list.
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Data Warehousing and Business Intelligence Web Links: tips, tutorials, scripts, and more.
- Have an DW tip to offer your fellow administrators and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical data warehousing questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle data warehousing
Related Q&A from Mike Lampa
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to ... Continue Reading
What is a surrogate key in a table? Continue Reading