HubHip: Computers: Software: Databases: OLAP (77)

DescriptionOLAP (OnLine Analytical Processing), a technology supporting analytical capabilities against one or more of data sources. OLAP systems usually involve analyzing data that originated in a traditional database, but was then transformed into a multi-dimensional structure for easier visualization.

Relational and multi-dimensional database models usually serve very different purposes; while the former is intended for read/write, transactional, high-volume activities, the latter is suited for low-volume, complex queries that span large quantities of data at any time. Relational databases have SQL as their query language; in contrast, multi-dimensional OLAP environments have no commonly accepted language, although the proprietary MDX language created by Microsoft is gaining acceptance.

Related categories include:

- Data mining, which attempts to discover trends and patterns in the data;

- Data warehousing, which attempts to reconcile some or all of a company's data sources into a single all-encompassing database;

- Data transformation tools, which provide the means to cleanse and manipulate data while transferring it from one location to another.

   OLAP