Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,520,608,154 visitors served.
forum mailing list For webmasters
?
New: Language forums
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

OLAP

   Also found in: Acronyms, Wikipedia 0.07 sec.

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.

OLAP - On-Line Analytical Processing


How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
 Email
Feedback
? Mentioned in ? References in periodicals archive
 
ShowCase Corporation (Nasdaq: SHWC), a provider of Enterprise Intelligence solutions for business users and AS/400 IT professionals, will significantly extend its offerings to thousands of AS/400 organizations with the launch of the new IBM DB2 OLAP (On-Line Analytical Processing) Server for the AS/400 - a joint development effort between IBM and ShowCase.
IBM LAUNCHES DB2 OLAP SERVER by Online Product News
The web seminar will focus on Pentaho's Mondrian OLAP project, showcasing the world's most popular open source OLAP project in tandem with the world's most popular open source database platform.
Pentaho's Mondrian OLAP Project Featured on MySQL Web Seminar Series by Business Wire
ShowCase Corporation (Nasdaq: SHWC), a provider of Enterprise Intelligence solutions for business users and AS/400 IT professionals, will significantly extend its offerings to thousands of AS/400 organizations with the launch of the new IBM DB2 OLAP (On-Line Analytical Processing) Server for the AS/400 - a joint development effort between IBM and ShowCase.
IBM LAUNCHES DB2 OLAP SERVER by Online Product News
More results
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2009 Farlex, Inc.
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. Terms of Use.