Sciweavers

867 search results - page 59 / 174
» SQL Server 2005
Sort
View
221
Voted
SIGMOD
2006
ACM
170views Database» more  SIGMOD 2006»
16 years 2 months ago
COLT: continuous on-line tuning
Self-tuning is a cost-effective and elegant solution to the important problem of configuring a database to the characteristics of the query load. Existing techniques operate in an...
Karl Schnaitter, Serge Abiteboul, Tova Milo, Neokl...
126
Voted
SIGMOD
2004
ACM
150views Database» more  SIGMOD 2004»
16 years 2 months ago
Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design
In addition to indexes and materialized views, horizontal and vertical partitioning are important aspects of physical design in a relational database system that significantly imp...
Sanjay Agrawal, Vivek R. Narasayya, Beverly Yang
SIGMOD
2002
ACM
120views Database» more  SIGMOD 2002»
16 years 2 months ago
Exploiting statistics on query expressions for optimization
Statistics play an important role in influencing the plans produced by a query optimizer. Traditionally, optimizers use statistics built over base tables and assume independence b...
Nicolas Bruno, Surajit Chaudhuri
SIGMOD
2001
ACM
147views Database» more  SIGMOD 2001»
16 years 2 months ago
Optimizing Queries Using Materialized Views: A practical, scalable solution
Materialized views can provide massive improvements in query processing time, especially for aggregation queries over large tables. To realize this potential, the query optimizer ...
Jonathan Goldstein, Per-Åke Larson
ICDE
2010
IEEE
292views Database» more  ICDE 2010»
16 years 2 months ago
Exploring Power-Performance Tradeoffs in Database Systems
With the total energy consumption of computing systems increasing in a steep rate, much attention has been paid to the design of energy-efficient computing systems and applications...
Zichen Xu, Yi-Cheng Tu, Xiaorui Wang