Database VS Data warehousing

[Former Member]

pls help me in knowing the differences between database and data warehousing in detail

send me links and PDF if u have

thanks

[Former Member · Accepted solution]

Hi,

A data base is a structured collection of records or data. A computer database relies upon software to organize the storage of data. The software models the database structure in what are known as database models.

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. 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.

Regards.

[Former Member]

Hi Ranjith:

Database is a general concept

What you need to know is:

- OLTP Database: DB that this designed to support transaction processing (i.e. SAP ECC, JDEdwards, PeopleSoft, other ERPs systems...)

- OLAP Database: DB for Datawarehousing. Is a DB that is designed to support reporting and analysis processing.

A tipical architecture in BI is that you take data from an OLTP DB to an OLAP DB for reporting and analysis purposes.

This White Paper could be very useful to you

http://help.sap.com/bp_biv270/documentation/Multi-dimensional_modeling_EN.doc

Hope this helps. (Assing points if helpful)

Kind regards,

Francisco.

[Former Member]

Hi,

Have a look on below link

[Former Member]

Hi,

Database is the place where data is store in tables - oracle,DB2 are the database

Datawarhouse - effective storing and retrive of data from the database - SAP Bw, informatica are datawarehouse tools.

Ramesh