OLAP (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.
Please submit only sites dealing with consultancy around OLAP solutions. Also consider the groups Computers: Software: Databases: Data Mining: Consultants, and Computers: Software: Databases: Data Warehousing: Consultants if those groups are more appropriate to your activities.
If you sell OLAP software you have developed, consider the parent of this category.
Individuals and organizations specializing in consultancy around OLAP (online analytical processing) solutions, from any vendor.
Please submit only sites dealing with consultancy around OLAP solutions. Also consider the groups Computers: Software: Databases: Data Mining: Consultants, and Computers: Software: Databases: Data Warehousing: Consultants if those groups are more appropriate to your activities.
If you sell OLAP software you have developed, consider the parent of this category.