• Publications
  • Influence
An overview of business intelligence technology
BI technologies are essential to running today's businesses and this technology is going through sea changes.
  • 649
  • 66
  • PDF
Automated Selection of Materialized Views and Indexes in SQL Databases
Automatically selecting an appropriate set of materialized views and indexes for SQL databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the workload experiencedExpand
  • 627
  • 56
  • PDF
An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server
In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database. The tool takes asExpand
  • 385
  • 42
  • PDF
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 impact performance.Expand
  • 409
  • 28
  • PDF
Optimized stratified sampling for approximate query processing
The ability to approximately answer aggregation queries accurately and efficiently is of great benefit for decision support and data mining tools. In contrast to previous sampling-based studies, weExpand
  • 192
  • 24
  • PDF
On random sampling over joins
A major bottleneck in implementing sampling as a primitive relational operation is the inefficiency of sampling the output of a query. It is not even known whether it is possible to generate a sampleExpand
  • 329
  • 20
  • PDF
Self-Tuning Database Systems: A Decade of Progress
In this paper we discuss advances in self-tuning database systems over the past decade, based on our experience in the AutoAdmin project at Microsoft Research. This paper primarily focuses on theExpand
  • 291
  • 17
  • PDF
Towards estimation error guarantees for distinct values
We consider the problem of estimating the number of distinct values in a column of a table. For large tables without an index on the column, random sampling appears to be the only scalable approachExpand
  • 234
  • 16
  • PDF
Database Tuning Advisor for Microsoft SQL Server 2005
Publisher Summary This chapter provides an overview of Database Tuning Advisor's (DTA's) novel functionality, the rationale for its architecture, and demonstrates DTA's quality and scalability onExpand
  • 204
  • 16
Overcoming limitations of sampling for aggregation queries
Studies the problem of approximately answering aggregation queries using sampling. We observe that uniform sampling performs poorly when the distribution of the aggregated attribute is skewed. ToExpand
  • 159
  • 11
  • PDF