OLAP

From Oracle FAQ

Jump to: navigation, search

OLAP (Online Analytical Processing) is a type of system that allows workers to, quickly, and flexibly manipulate operational data using familiar business terms, in order to provide analytical insight.

The term OLAP (On-Line Analytical Processing) was first used by E.F. Codd in 1993. It refers to a type of application that allows a user to interactively analyze data. An OLAP system is often contrasted with an OLTP (On-Line Transaction Processing) system that focuses on processing orders, invoices or general ledger transactions. OLAP applications were previously called Decision Support Systems.

Note: Oracle likes using the term "Business Intelligence" instead of OLAP.

Also see

  • DSS - Decision Support System
  • OLTP - On-Line Transaction Processing

External links


Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Personal tools