Multiple query optimization with depth-first branch-and-bound and dynamic query ordering

Ahmet Cosar, Ee Peng Lim, Jaideep Srivastava

Research output: Chapter in Book/Report/Conference proceedingConference contribution

12 Citations (Scopus)

Abstract

In certain database applications such as deductive databases, batch query processing, and recursive query processing etc., a single query can be transformed into a set of closely related database queries. Great benefits can be obtained by executing a group of related queries all together in a single unified multi-plan instead of executing each query separately. In order to achieve this, Multiple Query Optimization (MQO) identifies common task(s) (e.g. common subexpressions, joins, etc.) among a set of query plans and creates a single unified plan (multiplan) which can be executed to obtain the required outputs for all queries at once. In this paper, a new heuristic function (fc), dynamic query ordering heuristics, and Depth-First Branch-and-Bound (DFBB) are defined and experimentally evaluated, and compared with existing methods which use A* and static query ordering. Our experiments show that all three of fc, DFBB, and dynamic query ordering help to improve the performance of our MQO algorithm.

Original languageEnglish
Title of host publicationProc 2 Int Conf Inf Knowl Manage
EditorsBharat Bhargava, Timothy Finin, Yelena Yesha
PublisherPubl by ACM
Pages433-438
Number of pages6
ISBN (Print)0897916263
Publication statusPublished - 1 Dec 1993
EventProceedings of the 2nd International Conference on Information and Knowledge Management - Washington, DC, USA
Duration: 1 Nov 19935 Nov 1993

Publication series

NameProc 2 Int Conf Inf Knowl Manage

Other

OtherProceedings of the 2nd International Conference on Information and Knowledge Management
CityWashington, DC, USA
Period1/11/935/11/93

    Fingerprint

ASJC Scopus subject areas

  • Engineering(all)

Cite this

Cosar, A., Lim, E. P., & Srivastava, J. (1993). Multiple query optimization with depth-first branch-and-bound and dynamic query ordering. In B. Bhargava, T. Finin, & Y. Yesha (Eds.), Proc 2 Int Conf Inf Knowl Manage (pp. 433-438). (Proc 2 Int Conf Inf Knowl Manage). Publ by ACM.