Tag Archives: online

OLTP vs OLAP

We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.

OLAP

OLAP (online analytical processing): is computer processing that enables a user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all … Continue reading

oltp

OLTP ( Online transaction processing) : is a class of information systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.