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

Loading...
Thumbnail Image

Authors

Meng, Yabin

Date

2007-09-25T18:15:02Z

Type

thesis

Language

eng

Keyword

DB2 , Database Performance , Database Workload Management

Research Projects

Organizational Units

Journal Issue

Alternative Title

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.

Description

Thesis (Master, Computing) -- Queen's University, 2007-09-17 22:05:05.304

Citation

Publisher

License

This publication is made available by the authority of the copyright owner solely for the purpose of private study and research and may not be copied or reproduced except as permitted by the copyright laws without written authority from the copyright owner.

Journal

Volume

Issue

PubMed ID

External DOI

ISSN

EISSN