Encyclopedia

OLAP

Also found in: Acronyms, Wikipedia.
(redirected from Multidimensional database)

OLAP

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

OLAP

(OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. They enable users to drill down into masses of sales statistics in order to isolate products that are the most volatile.

OLAP and MOLAP
Traditional OLAP products are also called "multidimensional OLAP" (MOLAP) because they summarize transactions into multidimensional views ahead of time. Data are organized into a cube structure that can be rotated by the user, which is particularly suited for financial summaries. Queries are fast because the consolidation has already been done.

Relational OLAP (ROLAP)
Relational OLAP tools extract data from relational databases. Using complex SQL statements against relational tables, ROLAP is able to create multidimensional views on the fly. ROLAP tends to be used on data that has a large number of attributes, where it cannot be easily placed into a cube structure. For example, customer data with numerous descriptive fields are typically ROLAP candidates, rather than financial data.

Database OLAP and Web OLAP (DOLAP and WOLAP)
A database OLAP refers to a relational DBMS that is designed to host OLAP structures and perform OLAP calculations. Web OLAP refers to OLAP data that is accessible from a Web browser. See MDX.
Copyright © 1981-2025 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
Mentioned in
References in periodicals archive
Questions were asked about a variety of student experiences and opinions regarding technical areas including advanced database querying, data integration, multidimensional databases, data mining, and data visualization.
[5.] Vassiliadis P.: "Modeling multidimensional databases, cubes and cube operations".
It also illustrates that the framework can capture the semantics of multidimensional databases in a straightforward manner: the multidimensional extensionalization mapping is obtained by a simple, but coordinated, combination of the mappings for the constituent one-dimensional databases.
They focus on particularly in the building DWs for XML data, including the design of multidimensional databases for XML data sources and the extension of traditional OLAP techniques to analyze online XML data.
There is no particular procedure or activity related with the process of the multidimensional database design, ETT process or optimization of scripts for OLAP reports.
According to the company, PowerOLAP V8 increases the productivity of Microsoft Excel users by delivering a dynamic connection to their underlying data sources, enabling them to integrate their Excel spreadsheets or browser with relational databases through an optimized multidimensional database.
The fourth edition includes coverage of several new topics, including compliance standards, such as Sarbanes Oxley, HIPAA, and Basel II; near-line storage; multidimensional database design; methods for handling unstructured data in a data warehouse; the end-user community; and operational data store (ODS) and the data warehouse.
Most products, such as Essbase, with a multidimensional database are strong.
"SRC's planning system innovatively merges Excel and multidimensional database technology," Hunt says.
"This transaction reflects our commitment to reinvigorate, reposition and re-establish PICK as the leading multidimensional database management system provider for the new economy.
to capture data from a wide variety of systems including relational databases and mainframe file systems and populate either a relational or multidimensional database. The product was initially developed for Thomson's in-house use.
Copyright © 2003-2025 Farlex, Inc Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.