Statements (27)
Predicate | Object |
---|---|
gptkbp:instanceOf |
OLAP technology
|
gptkbp:advantage |
Depends on relational database performance
Handles large data sets Leverages existing relational databases Slower query performance than MOLAP |
gptkbp:category |
Business intelligence
Data warehousing |
gptkbp:contrastsWith |
HOLAP
MOLAP |
gptkbp:example |
gptkb:Oracle_OLAP
SAP BW (ROLAP mode) Microsoft SQL Server Analysis Services (ROLAP mode) |
gptkbp:feature |
Dynamic SQL generation
No need for data pre-aggregation Scalability for large data volumes Uses snowflake schema Uses star schema |
gptkbp:fullName |
Relational Online Analytical Processing
|
https://www.w3.org/2000/01/rdf-schema#label |
ROLAP (Relational OLAP)
|
gptkbp:relatedConcept |
ETL (Extract, Transform, Load)
Data cube Dimension table Fact table |
gptkbp:supportsLanguage |
SQL
|
gptkbp:uses |
Relational database
|
gptkbp:bfsParent |
gptkb:OLAP_Services
|
gptkbp:bfsLayer |
7
|