SQL Query Disassembler: An Approach to Managing the Execution of Large SQL Queries

Loading...
Thumbnail Image
Date
2007-09-25T18:15:02Z
Authors
Meng, Yabin
Keyword
DB2 , Database Performance , Database Workload Management
Abstract
In this thesis, we present an approach to managing the execution of large queries that involves the decomposition of large queries into an equivalent set of smaller queries and then scheduling the smaller queries so that the work is accomplished with less impact on other queries. We describe a prototype implementation of our approach for IBM DB2™ and present a set of experiments to evaluate the effectiveness of the approach.
External DOI