|
gptkbp:instanceOf
|
relational database management system
|
|
gptkbp:category
|
gptkb:software
data management
business analytics
|
|
gptkbp:contrastsWith
|
OLTP databases
|
|
gptkbp:example
|
gptkb:Microsoft_SQL_Server_Analysis_Services
gptkb:Oracle_OLAP
gptkb:SAP_BW
gptkb:IBM_Cognos_TM1
gptkb:Apache_Kylin
|
|
gptkbp:feature
|
dimensions
hierarchies
measures
data cubes
|
|
gptkbp:fullName
|
Online Analytical Processing databases
|
|
https://www.w3.org/2000/01/rdf-schema#label
|
OLAP databases
|
|
gptkbp:originatedIn
|
1990s
|
|
gptkbp:relatedConcept
|
gptkb:snowflake_schema
ETL
data warehouse
star schema
data mart
dimension table
fact table
|
|
gptkbp:standardizedBy
|
gptkb:OLAP_Council
gptkb:ISO/IEC_JTC_1/SC_32
|
|
gptkbp:supports
|
aggregation
complex queries
multidimensional data models
drill-down operations
roll-up operations
slice and dice operations
|
|
gptkbp:supportsLanguage
|
gptkb:MDX
SQL
|
|
gptkbp:type
|
gptkb:ROLAP
HOLAP
MOLAP
|
|
gptkbp:usedFor
|
business intelligence
data warehousing
analytical queries
|
|
gptkbp:bfsParent
|
gptkb:IBM_Cognos
gptkb:Information_Design_Tool
|
|
gptkbp:bfsLayer
|
6
|