An improved join-free snowflake schema for ETL and OLAP of data warehouse.
Jianmin WangWenbin ZhaoTongrang FanShilong YangLv HongweiPublished in: Concurr. Comput. Pract. Exp. (2020)
Keyphrases
- data warehouse
- dimension tables
- fact table
- data warehousing
- on line analytical processing
- databases
- query execution
- data cube
- star schema
- business intelligence
- olap queries
- data marts
- decision support
- data integration
- dimension hierarchies
- conceptual model
- data management
- external data
- online analytical processing
- data sources
- data model
- decision support system
- data mining
- olap systems
- database
- multidimensional data model
- query optimization
- database schema
- materialized views
- incremental view maintenance
- data warehouse design
- data analysis
- query processing
- olap query processing
- multidimensional databases
- aggregate queries
- join algorithms
- metadata
- olap tools
- enterprise data
- requirement analysis
- decision making
- bitmap indices
- data partitioning
- multidimensional data
- ub tree
- database systems