Online Analytical Processing OLAP


Short for Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining.

The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions for analyzing the data. There are OLAP servers available for nearly all the major database systems.

Read Also:

  • Object Linking and Embedding (OLE)

    Abbreviation of Object Linking and Embedding, pronounced as separate letters or as oh-leh. OLE is a compound document standard developed by Microsoft Corporation. It enables you to create objects with one application and then link or embed them in a second application. Embedded objects retain their original formatand links to the application that created them. […]

  • OLED

    Short for organic light-emitting diode, a display device that sandwiches carbon-based films between two charged electrodes, one a metallic cathode and one a transparent anode, usually being glass. The organic films consist of a hole-injection layer, a hole-transport layer, an emissive layer and an electron-transport layer. When voltage is applied to the OLED cell, the […]

  • OLE DB

    OLE DB (pronounced as separate letters) is a set of COM-based interfaces that expose data from a variety of sources, such as spreadsheets, project plans, SQL, legacy databases and more. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores. These interfaces support the amount of database […]

  • OLE for Process Control

    Abbreviated as OPC, OLE for Process Control is a series of standards specifications. The current OPC specifications form a set of standard OLE/COM interface protocols based upon the functional requirements of Microsoft’s OLE/COM technology. Such technology defines standard objects, methods and properties for servers of real-time information like distributed process systems, programmable logic controllers, smart […]

  • OLTP

    Short for On-Line Transaction Processing. Same as transaction processing.


Disclaimer: Online Analytical Processing OLAP definition / meaning 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. All content on this website is for informational purposes only.