OLAP and OLTP

Explain the following term:

a) OLAP

b) OLTP

E

Expert

Verified

OLTP:

In case, an on-line operational database system is utilized for the proficient retrieval and storage and management of the huge amounts of data, then the system is known as on-line transaction processing.

OLAP:

Data warehouse systems serves users (or) knowledge workers within the role of data analysis and decision-making. Such systems may organize and represent the data in several formats. These systems are called as the on-line analytical processing systems.

   Related Questions in Database Management System