What is a DOLAP?


Les Barbusinski’s Answer: It’s an acronym for Desktop OLAP (Online analytical processing). It’s an arcane term used to denote single- tier, desktop-based business intelligence software. Its most distinguishing feature is its ability to download a relatively small hypercube from a central point (usually a data mart or data warehouse) and perform multidimensional analyses while disconnected from the source. This functionality is particularly useful for mobile users who can’t always connect to the data warehouse. DOLAP is often contrasted with MOLAP (i.e., cube-based) and ROLAP (i.e., star schema based) business intelligence tools. Hope this helps.

Chuck Kelley’s Answer: DOLAP is desktop OLAP. There can be some inferences made on what desktop OLAP is but I think it is an OLAP product that does everything on the desktop (after extracting the data). I am sure there are others who will have a differing opinion. The big question to me is what does the business community need to do their job? Whatever that is called, that’s what I want to provide them.

Clay Rehm’s Answer: First of all, OLAP stands for online analytical processing. There are different types of OLAP, which usually have another letter in front of it to describe the data storage option for a business intelligence tool. These include:

  • Relational OLAP (ROLAP) – Computation occurs in virtual cubes in the relational database management system (RDBMS).
  • Multidimensional OLAP (MOLAP) – Computation occurs in proprietary cubes on a middle tier.
  • Desktop OLAP (DOLAP) – Computation occurs in proprietary cubes on the client.