1.

What is OLAP? How is it different from OLTP?

Answer»

OLAP stands for Online Analytical Processing. In every Business application, this technology is used. It helps in performing multidimensional analysis of business data and PROVIDES solutions for complex calculations and data modeling.

OLAPOLTP
OLAP CONSISTS of a software tool that is used in Data AnalysisOLTP consists of tools that support Transaction Oriented Applications.
It is characterized by a large volume of data.It is characterized by a huge number of short transactions.
In this data, the warehouse is CREATED uniquelyOLTP uses a TRADITIONAL database
Benefits WOULD be the consistency of calculations.Handles all daily transactions of an organization.
Responds in seconds to minutesResponse in milliseconds


Discussion

No Comment Found

Related InterviewSolutions