Stanford InfoLab Publication Server

Primitives for Workload Summarization and Implications for SQL

Chaudhuri, Surajit and Ganesan, Prasanna and Narasayya, Vivek (2003) Primitives for Workload Summarization and Implications for SQL. In: 29th International Conference on Very Large Databases (VLDB 2003), September 9-12, 2003, Berlin, Germany.




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.

Item Type:Conference or Workshop Item (Paper)
Subjects:Computer Science > Databases and the Web
ID Code:614
Deposited By:Import Account
Deposited On:13 Aug 2003 17:00
Last Modified:24 Dec 2008 08:55

Download statistics

Repository Staff Only: item control page