Data warehousing: What is an OLTP system and OLAP system?

Answer
OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data. Typical example of a transaction is commonly observed in Banks, Air tickets etc. Because OLTP uses client server architecture, it supports transactions to run cross a network.

OLAP: Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data coming from different sources (multi dimensional).

NEXT>>

More Related Links

What is snow flake scheme design in database?

Answer - A snowflake Schema in its simplest form is an arrangement of fact tables.........
Explain the difference between Data warehousing and Business Intelligence.

Answer - Data Warehousing helps you store the data while business intelligence.....
What is Dimensional Modeling?

Answer - Dimensional modeling is often used in Data warehousing.......
What are fundamental stages of Data Warehousing?

Answer - Stages of a data warehouse helps to find and understand.......

Data warehousing

NEXT>>

What is an OLTP system and OLAP system?

NEXT>>

More Related Links

What is snow flake scheme design in database?

Explain the difference between Data warehousing and Business Intelligence.

What is Dimensional Modeling?

What are fundamental stages of Data Warehousing?