Online analytical processing (OLAP) is an approach to answering queries about data arrays using the multidimensional analysis principle. The first product that dealt with OLAP was Express, released in 1970, the term was only coined by Edgar Codd in 1993. It is an evolution of online transaction processing (OLTP). Microsoft released its first OLAP server, Microsoft Analysis Services, in 1998, driving wider adoption. The three main categories are multidimensional, relational and hybrid. Popular implementations include reporting, marketing, budgeting, forecasting and business process management.
CRM system for a law firm, maintaining a list of contractors and automatically creating dozens of document types. Analysis of a database with 10,000,000 entries for geographical audit, evaluation of peak database load and daily, weekly and monthly access graphs. Tracking of compliance with license commitments. Automation of letter, envelope, order and notification creation.
2002–2024