Question Re: Database VS Data warehousing in Technology Q&A

Database VS Data warehousing

Former Member — Fri, 23 May 2008 05:40:39 GMT

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

send me links and PDF if u have

thanks

Re: Database VS Data warehousing

Former Member — Fri, 23 May 2008 05:49:04 GMT

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

Re: Database VS Data warehousing

Former Member — Fri, 23 May 2008 06:27:07 GMT

Hi,

Have a look on below link

Re: Database VS Data warehousing

Former Member — Sat, 24 May 2008 16:50:09 GMT

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.

Re: Database VS Data warehousing

Former Member — Sat, 24 May 2008 23:15:57 GMT

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.