Exclusively for you!! Trial version of Google Apps, Apply Coupon-CNHPGX6T6QRWGV!!

OLAP : On-line Analytical Processing

Database @Image courtesy of ddpavumba/ FreeDigitalPhotos.net

OLAP : On-line Analytical Processing

Welcome to CodeSpread!

What is OLAP?

We know that there are two kinds of database applications available, OLAP and OLTP. Before we go for OLAP, I would like to tell you something about OLTP.
OLTP is On-line Transaction Processing. By transaction, we mean any operation including INSERT, UPDATE, and DELETE statements. And, just like any other transaction system, the main concern here is ACID rules.

Let’s take an example of banking transaction systems, where a large number of users simultaneously perform transactions. In this case, Online Transaction processing (OLTP) applications provide optimal environment for concurrency and atomicity of transactions.

OLAP is On-line Analytical Processing and its main concern is analysis. This is how OLAP is different from OLTP, where the main concern is concurrency and atomicity.

Now, With OLTP we always have a consistent state of data but how this data can be useful to business?

OLAP has an answer to it. In OLAP, the current data is analyzed for any trends or summarize through many filters. The resultant data is not changed or tampered with anytime.

“Because of OLAP, data speaks for itself.”

For example: With the help of OLAP component; Sales, Marketing, Budgeting and Forecasting can provide multi-dimensional analysis and reporting.

What are the advantages of OLAP?

Multi-dimensional: Multi-dimensional views of various kinds of business activities.

Decision Support: Analytical capabilities promote decisions.

Complex Calculations Support: When it comes to determining future trends then complex calculations are necessary like averages and percentage growth.

Access from individual’s point of view:  Access to fast, consistent, interactive access to a wide variety of possible views of information.

What are the types of OLAP?

There are three basic types of OLAP :

MOLAP relies on a multidimensional database.

ROLAP relies on a relational database.

HOLAP is a hybrid model.

More Details are given below:

MOLAP: Multidimensional Online Analytical Processing uses a multidimensional database stored in various cubes. This information is pre-summarized and optimized, due to which, fast data retrieval is possible. Also, a range of complex calculations are already performed.

ROLAP: Relational Online Analytical Processing uses a relational database. ROLAP do not use pre-calculated data cubes like MOLAP. ROLAP uses regular SQL statement to query the standard relational database. Although, it gives the appearance of traditional OLAP’s slicing and dicing functionality.

HOLAP: Hybrid Online Analytical Processing is a hybrid approach which combines the advantages of MOLAP and ROLAP. Here, database divides data between relational and specialized storage like the small aggregated totals are stored in a multidimensional database while large quantities of detail data is stored in the relational database. So we have advantage of both pre-summarized/optimized cubes and relational database.




Author: hershey

A passion for knowledge drives me to do programming, A passion for programming drives me to create something different, A passion for creation drives me to spread the knowledge.

Share This Post On


  1. nice superb explaination

    Post a Reply
  2. thanks for the tutorial
    I am having a problem.
    The feature “Create SQL server database” isn’t available , I can’t select it.
    Can you help, please ?

    Post a Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

More from CodeSpread:

  • IQueryable: Performance boost over remote Data AccessIQueryable: Performance boost over remote Data AccessIf we also follow the inheritance principle like OOPS programming, we need to extend our previous discussion “IEnumerable: Power behind Collections”. So this will lead us to write something about I...
  • Short Note on Performance TestingShort Note on Performance TestingWikipedia says "performance testing is in general testing performed to determine how a system performs in terms of responsiveness and stability under a particular workload. It can also serve to inv...
  • Few lines about PreRender eventFew lines about PreRender eventBackground To know PreRender and understand its  importance, we should know the events before it and after it. We start with, Page object including all controls are loaded and the page is ready...
  • Functional and Non-Functional RequirementsFunctional and Non-Functional RequirementsBefore we begin a project, we are always required to document the requirements and classify them between functional requirements and non-functional requirements. This activity is beneficial wheneve...
  • Few lines on Exploratory testingFew lines on Exploratory testingWhat is Exploratory testing? Exploratory testing by far is an approach to run and learn where testers do not create test cases beforehand. They usually gets acquainted with the system first. It...
  • Simply LINQ: What,Why and How.Simply LINQ: What,Why and How.What is LINQ? LINQ is Language-Integrated Query (LINQ). It is primarily an extension to the language's capability where it adds query expressions which processes objects and data. It is a one s...
  • How To: Cross Page PostingHow To: Cross Page PostingWhat is a POST? Wikipedia says,The POST request method is designed to request that a web server accept the data enclosed in the request message's body for storage.It is often used when uploading a...
  • SQL: Usage of char, varchar and varchar(MAX)SQL: Usage of char, varchar and varchar(MAX)These are character data types in SQL. We will take an example and describe each type. Later we determine the cases where one of them can be applied. [code] Create Table testable( Name char(20...