datawarehouse concepts

Sat, 21 Mar 2015 15:24:56 GMT

what is differance between database and datawarehouse?

Re: datawarehouse concepts

fred_s — Sat, 21 Mar 2015 21:26:45 GMT

Ask Google exactly the same question, there are some really nice pages.

Of course I'd like to answer your question, but it's gonna be a story and those stories are on the web already.

Grtz Fred

robert_mika — Sat, 21 Mar 2015 22:11:49 GMT

Database

Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history.
The tables and joins are complex since they are normalized (for RDMS). This is done to reduce redundant data and to save storage space.
Entity – Relational modeling techniques are used for RDMS database design.
Optimized for write operation.
Performance is low for analysis queries.

Data Warehouse

Used for Online Analytical Processing (OLAP). This reads the historical data for the Users for business decisions.
The Tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries.
Data – Modeling techniques are used for the Data Warehouse design.
Optimized for read operations.
High performance for analytical queries.
Is usually a Database