jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Difference between database and data warehouse Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Difference between database and data warehouse" Watch "Difference between database and data warehouse" New topic
Author

Difference between database and data warehouse

Matt Brown
Ranch Hand

Joined: Jan 26, 2004
Posts: 70
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
kiran mathew
Greenhorn

Joined: Jun 16, 2008
Posts: 16
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

Joined: Oct 29, 2007
Posts: 8
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.


Bharat Mehta
oana sorina
Greenhorn

Joined: May 19, 2014
Posts: 1
You can visit the following blog: Soriana Data Warehouse
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Difference between database and data warehouse