What is OLTP example?

What is OLTP and OLAP with examples?

OLAP stands for On-Line Analytical Processing. It is used for analysis of database information from multiple database systems at one time such as sales analysis and forecasting, market research, budgeting and etc. Data Warehouse is the example of OLAP system. OLTP stands for On-Line Transactional processing.

Where is OLTP used?

OLTP database systems are commonly used for order entry, financial transactions, customer relationship management and retail sales via the Internet. Almost any business that has a large number of users who conduct short online transactions needs an OLTP system.

Is ATM an OLTP?

The best example of OLTP system is ATM machine as shown in the figure-1 below. In ATM, transactions happen everyday and data will be stored in the system called OLTP. From the OLTP, the data is sent to OLAP system. From data stored in the OLAP, we will create the reports.

Which of them is an example of batch OLTP?

ATMs are the typical example of OLTP technology.