Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 19th, 2011

 

In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important choices and decisions by providing them with detailed analysis on historical data.

While databases are OLTP (On-Line Transaction Processing) systems, data warehouse is an OLAP (On-Line Analytical Processing) system.

Databases are write-optimised, Data warehouse are read-optimised

Hirru

• Feb 10th, 2012

 

Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data.

It contains some sort of data and it is being used by the organization to manage or manipulate the stored data.

A data warehouse is a repository of an organizations stored bulk data which is also organized and filtered. warehouses are designed to facilitate reporting and analysis.

Hence, we can say that data warehousing includes business tools to extract, transform and load data into the repository and it can also manage and retrieve meta data.

The term data warehousing generally refers to the combination of many different databases across an entire organization.

Usually minimum DataWarehose size will be around 20 to 40 GB.