SQL Query Dissembler –A Self Optimizing Autonomic System
Main Article Content
Abstract
Current database workloads often consist of a mixture of short OnLine Transaction Processing (OLTP) queries and typical large
complex queries such as OnLine Analytical Processing (OLAP). OLAP queries usually involve multiple joins, arithmetic operations, nested
sub-queries, and other system or user-defined functions and they typically operate on large data sets. These resource intensive queries can
monopolize the database system resources and negatively impact the performance of smaller, possibly more important, queries. In this paper, 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. Here we implement a SQL
disassembler that actually controls the impact of the execution of large queries that has the impact on the other workload classes in a Database
Management System. The approach involved divides a large query into an equivalent set of smaller queries and later schedules the execution of
these smaller queries.
Â
Â
Keywords: Query Optimization, DBMS, Dissembler
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.