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

What is an OLTP system and OLAP system?

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).

What is an OLTP system and OLAP system?

OLTP stands for OnLine Transaction Processing. Applications that supports and manges transactions which involve high volumes of data are supported by OLTP system. OLTP is based on client-server architecture and supports transactions across networks.

OLAP stands for OnLine Analytical Processing. Business data analysis and complex calculations on low volumes of data are performed by OLAP. An insight of data coming from various resources can be gained by a user with the support of OLAP.

Data warehousing cubes: What are cubes?
What are cubes? - A data cube stores data in a summarized version which helps in a faster analysis of data........
Data warehousing snow flake scheme: What is snow flake scheme design in database?
What is snow flake scheme design in database? - A snowflake Schema in its simplest form is an arrangement of fact tables and dimension tables.....
Data warehousing analysis service: What is analysis service?
Data warehousing analysis service - Analysis service provides a combined view of the data used in OLAP or Data mining......
Post your comment