File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Difference between database and data warehouse" Watch "Difference between database and data warehouse" New topic

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

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

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

Joined: May 19, 2014
Posts: 1
You can visit the following blog: Soriana Data Warehouse
It is sorta covered in the JavaRanch Style Guide.
subject: Difference between database and data warehouse
It's not a secret anymore!