Research any topic before you write.

Find related topics. | Discover entities. | See connections. | Build a topical map.

Online analytical processing

In computing, online analytical processing (OLAP) (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term OLAP was created as a slight modification of the traditional database term online transaction processing (OLTP). OLAP is part of the broader category of business intelligence, which also encompasses…

Products & Art

Use the mouse wheel or two fingers (on touchscreens) to zoom in and out of the map.

Research this topic

Explore the main themes, entities and connections around Online analytical processing. Start with the topic map, then use the sections below for research and deeper semantic analysis.

Explore this topic

Start with a few of the strongest sections from the source topic. These are research directions, not a list of keywords you must use.

Topics to explore

Browse the full topic structure. Each item opens a new analysis centered on that subject.

Overview

Overview of OLAP systems

Types

APIs and query languages

Products

Advanced semantic analysis

Deeper signals for content research, entity SEO and topical coverage. The plain-language headings explain what each technical view is useful for.

Map overview Semantic statistics

Online analytical processing

Nodes88
Edges87
Triples57
Avg. degree1.98
Density0.022727
Components1

How this topic connects Entity context

See the strongest relationship patterns around the current topic before diving into the raw triples.

Online analytical processing

Top relations

related to history · 21
Online analytical processing → Arbor, Arbor Software, As, Codd, Codd's, Computerworld, Edgar, Essbase, Express, However, Hyperion Solutions, In, Information Resources, Microsoft, Microsoft Analysis Services, OLAP, OLAP Server, Oracle, The, The OLAP
related to Multidimensional OLAP (MOLAP) · 8
Online analytical processing → As, MOLAP, OLAP, On, Pre-computation, Some MOLAP, Such MOLAP, The
related to Multidimensional databases · 7
Online analytical processing → Analytical, Data, Each, Even, Multidimensional, OLAP, The

Important terminology Word statistics

Use these terms to understand the vocabulary surrounding the topic, not as a checklist for keyword stuffing.

Important terminology

olap data rolap molap database relational tools dimensions query performance queries also sql processing databases cube time users multidimensional use

Entity relationships Subject–Predicate–Object triples

SubjectPredicateObjectConfidenceSrc
row-level securityinstance ofit is possible to successfully model data that would not otherwise fit into a strict dimensional model.The ROLAP approach can leverage database authorization controls0.80text
whereby the query results are filtered depending on preset criteria appliedinstance ofit is possible to successfully model data that would not otherwise fit into a strict dimensional model.The ROLAP approach can leverage database authorization controls0.80text
for exampleinstance ofit is possible to successfully model data that would not otherwise fit into a strict dimensional model.The ROLAP approach can leverage database authorization controls0.80text
to a given user or group of usersinstance ofit is possible to successfully model data that would not otherwise fit into a strict dimensional model.The ROLAP approach can leverage database authorization controls0.80text
CUBEinstance ofmodern ROLAP tools take advantage of latest improvements in SQL language0.80text
ROLLUP operatorsinstance ofmodern ROLAP tools take advantage of latest improvements in SQL language0.80text
DB2 Cube Viewsinstance ofmodern ROLAP tools take advantage of latest improvements in SQL language0.80text
as well as other SQL OLAP extensionsinstance ofmodern ROLAP tools take advantage of latest improvements in SQL language0.80text
Microsoft Analysis Servicesinstance ofbut the technology also became available in other commercial products0.80text
Oracle Database OLAP Optioninstance ofbut the technology also became available in other commercial products0.80text
MicroStrategyinstance ofbut the technology also became available in other commercial products0.80text
SAP AG BI Acceleratorinstance ofbut the technology also became available in other commercial products0.80text

Related concept clusters Concept neighborhoods

These clusters group vocabulary that occurs around closely connected concepts in the source material.

    Connections between topic areas Semantic bridges

    Bridges can reveal useful research angles that are easy to miss in a flat list of related terms.

    Min side: 3
    For writers, content strategists, SEOs, marketers and creators — from quick topic research to advanced semantic analysis.