Vertica Flattened Tables and Live Aggregate Projections: A Column-based Alternative to Materialized Views for Analytics.
Yuanzhe BeiThao PhamAkshay AggarwalNga TranJaimin DaveChuck BearMichael LeuchtenburgPublished in: IEEE BigData (2019)
Keyphrases
- materialized views
- column oriented
- data warehouse
- data warehousing
- incremental maintenance
- aggregate views
- business intelligence
- storage space
- database management systems
- query processing
- data management
- information sources
- physical database design
- view selection
- xml databases
- xml documents
- data sources
- view maintenance
- maintenance cost
- historical data
- data mining
- query execution plans
- decision support
- database systems
- data analysis
- object oriented
- databases
- join algorithms
- relational databases
- vertical partitioning