On-Line Analytical Processing

Four Main Characteristics of OLAP

• Use multidimensional data analysis techniques
• Provide advanced database support
• Provide easy-to-use end user interfaces
• Support client/server architecture

OLAP Architecture

• OLAP Graphical User Interface (GUI)
• OLAP Analytical Processing Logic
• OLAP Data Processing Logic

OLAP systems are designed to use both operational and Data Warehouse data.

OLAP - Online analytical processing

Activities performed by end users in online systems

• Specific, open-ended query generation

1. SQL

• Ad hoc reports
• Statistical analysis
• Building DSS applications

Modeling and visualization capabilities

Special class of tools

• DSS/BI/BA front ends
• Data access front ends
• Database front ends
• Visual information access systems