DATABASE V/S DATA WAREHOUSE

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.

  • It is a type of Database which focus on very specific applications.

Advertisements

Give A message for us

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s