On-Line Analytical Processing - meaning and definition. What is On-Line Analytical Processing
Diclib.com
ChatGPT AI Dictionary
Enter a word or phrase in any language 👆
Language:

Translation and analysis of words by ChatGPT artificial intelligence

On this page you can get a detailed analysis of a word or phrase, produced by the best artificial intelligence technology to date:

  • how the word is used
  • frequency of use
  • it is used more often in oral or written speech
  • word translation options
  • usage examples (several phrases with translation)
  • etymology

What (who) is On-Line Analytical Processing - definition

INFORMATION SYSTEM APPROACH TO FACILITATE AND MANAGE MULTI-DIMENSIONAL DATA ANALYSIS
Multidimensional database; MOLAP; ROLAP; HOLAP; Olap; Open source olap; Open Source OLAP; WOLAP; On line analytical processing; Multidimensional Analysis Tools; DOLAP; Dolap; On Line Analytical Processing; MDDB; OLAP; Online Analytical Processing; Multidimensional Online Analytical Processing

On-Line Analytical Processing      
<database> (OLAP) A category of database software which provides an interface such that users can transform or limit raw data according to user-defined or pre-defined functions, and quickly and interactively examine the results in various dimensions of the data. OLAP primarily involves aggregating large amounts of diverse data. OLAP can involve millions of data items with complex relationships. Its objective is to analyze these relationships and look for patterns, trends, and exceptions. The term was originally coined by Dr. Codd in 1993 with 12 "rules". Since then, the OLAP Council, many vendors, and Dr. Codd himself have added new requirements and confusion. Richard Creeth and Nigel Pendse define OLAP as fast analysis of shared multidimensional information. Their definition requires the system to respond to users within about five seconds. It should support logical and statistical processing of results without the user having to program in a 4GL. It should implement all the security requirements for confidentiality and concurrent update locking. The system must provide a multidimensional conceptual view of the data, including full support for multiple hierarchies. Other aspects to consider include data duplication, RAM and disk space requirements, performance, and integration with {data warehouses}. Various bodies have attempted to come up with standards for OLAP, including The OLAP Council and the {Analytical Solutions Forum} (ASF), however, the {Microsoft OLE DB for OLAP API} is the most widely adopted and has become the {de facto standard}. On-Line Analytical Processinggrimes/olap/">http://access.digex.net/On-Line Analytical Processinggrimes/olap/. Usenet newsgroup: news:comp.databases.olap. http://arborsoft.com/papers/finkTOC.html. [What's a "multidimensional conceptual view"?] (1996-09-24)
Hybrid transactional/analytical processing         
INFORMATION SYSTEM APPROACH OPTIMISED TO FACILITATE AND MANAGE BOTH TRANSACTIONS AND MULTI-DIMENSIONAL DATA ANALYSIS
User:HtownCat/sandbox; HTAP; Hybrid Transactional/Analytical Processing (HTAP); Hybrid transactional/analytical processing (HTAP); Translytical; Online transaction and analytical processing; Oltap
Hybrid transaction/analytical processing (HTAP) is a term created by Gartner Inc., an information technology research and advisory company, in its early 2014 research report Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation.
MOLAP         
Multidimensional OnLine Analytical Processing (Reference: OLAP)

Wikipedia

Online analytical processing

Online analytical processing, or OLAP (), is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture.

The term OLAP was created as a slight modification of the traditional database term online transaction processing (OLTP).

OLAP tools enable users to analyze multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing.: 402–403  Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. For example, all sales offices are rolled up to the sales department or sales division to anticipate sales trends. By contrast, the drill-down is a technique that allows users to navigate through the details. For instance, users can view the sales by individual products that make up a region's sales. Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints. These viewpoints are sometimes called dimensions (such as looking at the same sales by salesperson, or by date, or by customer, or by product, or by region, etc.).

Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad hoc queries with a rapid execution time. They borrow aspects of navigational databases, hierarchical databases and relational databases.

OLAP is typically contrasted to OLTP (online transaction processing), which is generally characterized by much less complex queries, in a larger volume, to process transactions rather than for the purpose of business intelligence or reporting. Whereas OLAP systems are mostly optimized for read, OLTP has to process all kinds of queries (read, insert, update and delete).