OLAP

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

OLAP

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.
References in periodicals archive ?
Arbor Software Corporation develops and markets multidimensional database software for business-planning, analysis and management- reporting applications.
PICK is the developer of D3(R), the firm's latest generation multi-user, multidimensional database management system.
The Andyne Integrated Solution, combining GQL, PaBLO and Rosetta technologies, will create the first Decision Support software suite capable of accessing and analyzing information from relational databases, multidimensional databases and structured text repositories, in a single view.
It supports more than 5500 users and, due to dynaSight's integration with a wide range of relational and multidimensional databases, including IBM DB2 UDB and Hyperion Essbase, links into more than 100 data sources.
Traditional technologies use an application-level approach where difficulties arise in supporting automated mining and On-Line Analytical Processing (OLAP), a model for fast analytical processing of multidimensional databases.
We have been looking for years at reporting tools and multidimensional databases," says Hoffmann, "and by far, Comshare Decision, running on Microsoft SQL Server OLAP Services, offers more flexibility, power, and ease-of-use than anything else we looked at.
Comshare products are available on the world's leading relational and multidimensional databases from Hyperion, IBM, Microsoft, and Oracle.
With this release of BudgetPLUS, which has been available since December 31, 1999, Comshare met its goal for the product to work on the world's top relational and multidimensional databases.
With this release of BudgetPLUS, which is fully Web-architected, Comshare met its goal for the product to work on the world's top relational and multidimensional databases by adding support for IBM DB2 Universal Database (UDB) version 6.
Bluestone Technology's consulting division consists of highly experienced business and technology resources with experience in data warehousing, business intelligence, data architecture, technology architecture, relational and multidimensional databases.
Ongoing research and development has enabled innovative applications that are Web-architected, exploit mainstream relational and multidimensional databases, and use advanced visualization techniques and business process automation.

Full browser ?