Share on Facebook Tweet on Twitter Share on LinkedIn Share by email
Primitives for Workload Summarization and Implications for SQL

Surajit Chaudhuri, Prasanna Ganesan, and Vivek Narasayya

Abstract

Workload information has proved to be a crucial component for database-administration tasks as well as for analysis of query logs to understand user behavior and system usage. These tasks require the ability to summarize large SQL workloads. In this paper, we identify primitives that are important to enable many important workload-summarization tasks. These primitives also appear to be useful in a variety of practical scenarios besides workload summarization. Today’s SQL is inadequate to express these primitives conveniently. We discuss possible extensions to SQL and the relational engine to efficiently support such summarization primitives.

Details

Publication typeInproceedings
Published inVLDB
PublisherVery Large Data Bases Endowment Inc.
> Publications > Primitives for Workload Summarization and Implications for SQL