A Method for Join Ordering Problem using Harmony Search Algorithm

Chintal Upendra Raval; Prof. Kaushal M Madhu

A Method for Join Ordering Problem using Harmony Search Algorithm

May 2016

Vol-2, Issue-3

Paper ID: 2455

ISSN: 2395-4396

Downloads: 0

Abstract & Details

Research Area

Information Technology

Keywords

Query optimization join ordering relational databases: query execution plan deterministic algorithms randomized algorithms genetic algorithms hybrid algorithms Multi Join Query Ordering Harmony Search Algorithm.

Abstract

Finding the optimal join ordering for a database query is a complex combinatorial optimization problem which has been approached by a wide variety of strategies and algorithms, ranging from simple deterministic search to complex hybrid algorithms based on genetic search and incorporating domain-specific heuristics. In this report we review a set of join ordering algorithms and classify them according to the nature of the search strategy they implement. We also briefly discuss the relative advantages and applicability of different algorithms. In this report, a meta-heuristic method based on the Harmony Search Algorithm will be adapted to resolve the join-ordering problem.

License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Author Information

#	Name	Institute / Affiliation
1	Chintal Upendra Raval	L. J. Institute of Engineering and Technology
2	Prof. Kaushal M Madhu	L. J. Institute of Engineering and Technology

How to Cite

Use the following formats to cite this article in your research.

APA Style

Raval, Chintal Upendra & Madhu, Prof. Kaushal M (2016). A Method for Join Ordering Problem using Harmony Search Algorithm. International Journal of Advance Research and Innovative Ideas In Education, 2(3), 2407-2415.

MLA Style

Raval, Chintal Upendra, and Prof. Kaushal M Madhu. "A Method for Join Ordering Problem using Harmony Search Algorithm." International Journal of Advance Research and Innovative Ideas In Education, vol. 2, no. 3, 2016, pp. 2407-2415.

IEEE Style

Chintal Upendra Raval and Prof. Kaushal M Madhu, "A Method for Join Ordering Problem using Harmony Search Algorithm," International Journal of Advance Research and Innovative Ideas In Education, vol. 2, no. 3, pp. 2407-2415, 2016.

Vancouver Style

Raval Chintal Upendra, Madhu Prof. Kaushal M. A Method for Join Ordering Problem using Harmony Search Algorithm. International Journal of Advance Research and Innovative Ideas In Education. 2016;2(3):2407-2415.

Harvard Style

Raval, Chintal Upendra & Madhu, Prof. Kaushal M (2016) 'A Method for Join Ordering Problem using Harmony Search Algorithm', International Journal of Advance Research and Innovative Ideas In Education, 2(3), pp. 2407-2415.

Chicago Style

Raval, Chintal Upendra and Prof. Kaushal M Madhu. "A Method for Join Ordering Problem using Harmony Search Algorithm." International Journal of Advance Research and Innovative Ideas In Education 2, no. 3 (2016): 2407-2415.

Turabian Style

Raval, Chintal Upendra and Prof. Kaushal M Madhu. "A Method for Join Ordering Problem using Harmony Search Algorithm." International Journal of Advance Research and Innovative Ideas In Education 2, no. 3 (2016): 2407-2415.