OLAP (Online Analytical Processing)
GPTKB entity
Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
data analysis technology
|
| gptkbp:abbreviation |
Online Analytical Processing
|
| gptkbp:characterizedBy |
dimensions
measures multidimensional cubes |
| gptkbp:contrastsWith |
OLTP
|
| gptkbp:enables |
pivot
data exploration trend analysis forecasting dashboarding data consolidation ad hoc reporting what-if analysis drill-down KPI analysis roll-up slice and dice |
| gptkbp:example |
gptkb:IBM_Cognos
gptkb:Oracle_OLAP gptkb:SAP_BW gptkb:Microsoft_Analysis_Services Pentaho Mondrian |
| gptkbp:firstDefined |
gptkb:Edgar_F._Codd
1993 |
| gptkbp:focusesOn |
historical data
aggregated data analytical queries |
| gptkbp:hasType |
gptkb:ROLAP
HOLAP MOLAP |
| https://www.w3.org/2000/01/rdf-schema#label |
OLAP (Online Analytical Processing)
|
| gptkbp:relatedTo |
ETL
OLTP data warehouse |
| gptkbp:standardizedBy |
gptkb:OLAP_Council
XMLA Council |
| gptkbp:supports |
gptkb:data_visualization
data modeling trend analysis data summarization complex calculations |
| gptkbp:supportsLanguage |
gptkb:MDX
gptkb:DAX SQL |
| gptkbp:usedFor |
business intelligence
data mining multidimensional analytical queries |
| gptkbp:bfsParent |
gptkb:software
|
| gptkbp:bfsLayer |
4
|