Sir
What is DataWarehouse.
Difference between DBMS and DataWarehouse.
When to use DataWarehouse.

Pls
sir give me some details about this topics ...

Hi Yaman,

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.

This classic definition of the data warehouse focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the dictionary data are also considered essential components of a data warehousing system.

Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata.

Find this link ScienceDirect - European Journal of Operational Research : Integrated model management in the data warehouse era

Cheers,
Sridevichitthu

Database -- dwh

1)oltp -- olap

2)transaction -- analysis

3)er-diagram -- data modeling

4)normalized data -- denormalized data

5)inserts & update insert (for rows)


oltp - online transaction processsing

olap - online analytical processing

Hi..


dbms-- oltp-- online transaction processing..
here we cont analysis bcos data changes day by day...




data warehousing--- olap-- online analytical processing..
it maintains historical data..
it collects data from diff databases like oracle,sybase and so on..

it is used to find analysis and generate reports...