• Jun 14, 2017 News!Vol.8, No.5 has been indexed by EI (Inspec).   [Click]
  • Nov 09, 2017 News!Vol.9, No.5 has been published with online version. 16 peer reviewed articles from 11 specific areas are published in this issue.   [Click]
  • Jul 19, 2017 News!Vol.9, No.4 has been published with online version. 16 peer reviewed articles from 16 specific areas are published in this issue.   [Click]
General Information
Editor-in-chief
Prof. Wael Badawy
Department of Computing and Information Systems Umm Al Qura University, Canada
I'm happy to take on the position of editor in chief of IJCTE. We encourage authors to submit papers concerning any branch of computer theory and engineering.
IJCTE 2017 Vol.9(5): 329-333 ISSN: 1793-8201
DOI: 10.7763/IJCTE.2017.V9.1161

Embedded Database Query Processing Plan Generation Using Dynamic Programming

B. Selmi, H. Gharsellaoui, and S. Bouamama
Abstract—Abstract—The efficiency of processing queries in an embedded database is critical for the system performance. The principal mechanism through which an embedded database maintains an optimal level of performance is the database query optimizer. It reduces the response time of a given query and the total time of processing queries. Nevertheless, because of the optimizer’s importance to the robustness and flexibility of an embedded database, we outline the embedded database query optimization by generating an optimal query processing plan. In this paper, an approach is presented which is able to generate an optimal query processing plans for a given user query. The approach uses dynamic programming to determine optimal query plans for a given query.

Index Terms—Index Terms—Embedded databases system, optimization, query plan, query cost.

B. Selmi is with the National Engineering School of Manouba, Manouba University, Tunisia (e-mail: boubaker.selmi@hotmail.fr). H. Gharsellaoui was with National Engineering School of Carthage, Carthage University, Tunisia (e-mail: gharsellaoui.hamza@gmail.com). S. Bouamama is with FCIT, University of Jeddah, KSA, National Engineering School of Manouba, Manouba University, Tunisia (e-mail: Sbouamama@uj.edu.sa).

[PDF]

Cite:B. Selmi, H. Gharsellaoui, and S. Bouamama, "Embedded Database Query Processing Plan Generation Using Dynamic Programming," International Journal of Computer Theory and Engineering vol. 9, no. 5, pp. 329-333, 2017.

Copyright © 2008-2015. International Journal of Computer Theory and Engineering. All rights reserved.
E-mail: ijcte@vip.163.com