Optimizing Star Join Queries for Data Warehousing in Microsoft SQL Server.
César A. Galindo-LegariaTorsten GrabsSreenivas GukalSteve HerbertAleksandras SurnaShirley WangWei YuPeter ZabbackShin ZhangPublished in: ICDE (2008)
Keyphrases
- data warehousing
- microsoft sql server
- business intelligence
- join queries
- query processing
- data warehouse
- query optimization
- database management systems
- sql server
- query execution
- conjunctive queries
- database technology
- data management
- database management
- spatial databases
- parallel processing
- join algorithms
- distributed databases
- complex queries
- decision support
- database development
- r tree
- data modeling
- materialized views
- data analysis
- efficient processing
- database systems
- decision making
- data mining
- database administrators
- case study
- knowledge management
- database applications
- web databases
- end users
- data access
- data types
- data integration
- cost model
- knowledge discovery
- data sources
- database
- join operations
- multi dimensional
- spatial data
- query evaluation
- databases