Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Difference between database and data warehouse

 
Matt Brown
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think data warehouse consists of more than one database. Anything else?
 
kiran mathew
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bharat Mehta
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
oana sorina
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can visit the following blog: Soriana Data Warehouse
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic