I think data warehouse consists of more than one database. Anything else?
"I just use my muscles as a conversation piece, like someone walking a cheetah down 42nd Street." - Arnold Schwarzenegger
Joined: Jun 16, 2008
Data warehouse consists of data from different databases(used by different applications in an enterprise). The data is de-normalized for analytical and reporting functions.
Joined: Oct 29, 2007
A Database is primarily used for record. Like application databases which work as Online Transaction Processing System where in every transaction has to be recorded, and it is highly optimized for write operations to make sure that every transaction gets recorded. The tables and joins in tables are complex as they are normalized to save storage space. A database uses Entity Relationship model for design.
A Data Warehouse is also a kind of database which is designed to speed up the process of querying and analysis. These databases are read optimized. A data warehouse works as Online Analytical Processing System where in tables and joins are highly de normalized to reduce the response time of queries. It uses data modeling techniques for design and is primarily used to maintain historical data to aid in taking quality business decisions.