top of page
Writer's picturezealous-tech

OLTP vs. OLAP

What is OLAP?

Online Analytical Processing, a category of software tools which provide analysis of data for business decisions. OLAP systems allow users to analyze database information from multiple database systems at one time.


The primary objective is data analysis and not data processing.


What is OLTP?

Online transaction processing shortly known as OLTP supports transaction-oriented applications in a 3-tier architecture. OLTP administers day to day transaction of an organization.


The primary objective is data processing and not data analysis.



Difference between OLTP and OLAP:





4 views0 comments

Recent Posts

See All

Fact

Dimension

Data mart

Comentários


bottom of page