This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 69
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
 
Similar Threads
Struts 1 :- Two Form submission from one jsp using one submit button
Which one has better scope Teradata Datawarehousing or Java EE?
What's data warehouse
Spatial Data Warehouse
Epiphany Java