APR 2, 2003 1:00am ET

Related Links

Which CDC method is the best to achieve staging database with changed data?
March 7, 2008
Apart from bloated dimension, what are the negatives of using all known attributes in your SCD?
March 7, 2008
When is it better to have normalized data to create data marts and when is it better to have dimensional data?
March 7, 2008

Web Seminars

Essential Guide to Using Data Virtualization for Big Data Analytics
September 24, 2014
Integrating Relational Database Data with NoSQL Database Data
October 23, 2014

What is a DOLAP?



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.

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?

Filed under:


Comments (0)

Be the first to comment on this post using the section below.

Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
Please note you must now log in with your email address and password.