Sql server - What are OLAP and OLTP?

What are OLAP and OLTP?

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 are OLAP and OLTP?

An IT system can be divided into Analytical Process and Transactional Process.

OLTP – categorized by short online transactions. The emphasis is query processing, maintaining data integration in multi-access environment.

OLAP – Low volumes of transactions are categorized by OLAP. Queries involve aggregation and very complex. Response time is an effectiveness measure and used widely in data mining techniques.
Sql server - What are the different problems that “Data mining” can solve?
Data mining can be used in a variety of fields/industries like marketing, advertising of goods, products, services, AI, government intelligence......
Sql server - What are different stages of “Data mining”?
A stage of data mining is a logical process for searching large amount information for finding important data......
Sql server - What is Discrete and Continuous data in Data mining world?
"Discreet data can be considered as defined or finite data. E.g. Mobile numbers, gender. Continuous data can be considered.....
Post your comment