Buradasın

OLAP Overview and Differences

Yapay zekadan makale özeti

What is OLAP: OLAP is an approach to answering multi-dimensional analytical queries swiftly
Term "OLAP" is becoming less appropriate as most analytical processing is online
Basic concepts include data cubes and fast aggregation
Data Types and Needs: Applications require detailed, transaction-level data
Decision makers want summarized data in one place
OLAP bridges these two data usage approaches
Technical Differences: Analytical systems pre-aggregate data for faster query answers
Analytical systems allow redundancy for faster responses
Analytical systems process large amounts of data per operation
Implementation: Commercial solutions available from Oracle, Microsoft, SAS
New trend is OLAP as a service
Few open-source packages exist, including Cubes and Pentaho