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]

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.