Search notes:

OLAP

OLAP stands for Online Analytical Processing.
OLAP databases are designed and optimized for querying data, typically for reporting purposes.
An OLAP database is usually fed with data from an OLTP database. The data is then organized and aggregated in (multidimensional) cubes rather than tables which allows to analyse the data fast.
There are two fundamental types of data in an OLAP database: measures and dimensions.
The term OLAP was created in 1993 by Edgar F. Codd.
Better performance might be achieved if the data is stored in column format.

See also

OLAP vs OLTP
OLAP glossary
OLAP cube, OLAP dimension
Oracle Option: OLAP
Microsoft SQL Server Analysis Services
SQL standard: the features T611 (Elementary) and T612 (Advanced OLAP operations)
Oracle's In-Memory Area

Index