Question

Compare OLTP to OLAP.  Give examples.

Answer 1

OLTP stands for Online Transaction Processing. It supports transaction-oriented applications in a 3 Tier architecture. It processes the data.

OLAP stands for Online Analytical Processing. It Analyses the data.

Comparison between OLTP and OLAP are as follows:-

OLTP	OLAP
1.  It has short amount of transactions.	1.  It has long amount of transactions.
2.  It allows read and write operations.	2.  It allows only read operations.
3.   It processes simple queries.	3.  It processes complex queries.
4.  It helps in increasing user's productivity.	4.   It helps in increasing business analysts productivity.
5.   It is market-oriented.	5.  It is customer oriented.
6.  It's creation and maintenance is easy.	6.  Users can create a view by using the spreadsheet.
7.   It controls and run fundamental business tasks.	7.  It is planning, problem-solving and decision supporting.

Examples of OLTP:-

• Online Banking.
• Order entry.
• Messaging.
• Online airline ticket booking.

Examples of OLAP:-

• Marketing Analyses.
• Sales Analyses.
• Budgeting.
• Financial planning.