MOLAP
Home > SQL Server Definitions - MOLAP
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

MOLAP



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

DEFINITION - MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database. In general, an OLAP application treats data multidimensionally; the user is able to view different aspects or facets of data aggregates such as sales by time, geography, and product model. If the data is stored in a relational data base, it can be viewed multidimensionally, but only by successively accessing and processing a table for each dimension or aspect of a data aggregate. MOLAP processes data that is already stored in a multidimensonal array in which all possible combinations of data are reflected, each in a cell that can be accessed directly. For this reason, MOLAP is, for most uses, faster and more user-responsive than relational online analytical processing (ROLAP), the main alternative to MOLAP. There is also hybrid OLAP (HOLAP), which combines some features from both ROLAP and MOLAP.

MOLAP is often used as part of a data warehouse application.

CONTRIBUTORS: Chris Ruffley
LAST UPDATED: 01 Apr 2005

Read more about MOLAP:
- The Panda Project provides an overview of MOLAP and multidimensional databases.
- The OLAP Report compares ROLAP and MOLAP.


Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Ensuring high availability of SSAS databases
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on...
Building a data warehousing and BI solution
In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the...
An overview of SQL Server Report Builder 2.0
In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", find out about the interface details and controls available in Report...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
comma-separated values file  (SearchSQLServer.com)
data aggregation  (SearchSQLServer.com)




MOLAP Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts