Author : Yasmeen R. M. Umar and Amit R. Welekar

Distributed database is emerging as a boon for large organizations as it provides better flexibility and ease compared to centralized database. As the data is growing over the distributed environment day by day, a better distributed management system is required to manage this large data. Query optimization is a process of finding out better query execution plan from multiple available options. As there a multiple sites in distributed database having parts of the data, query optimization is one of the challenging tasks in distributed database. In this review paper query optimization challenges in distributed database and its basic steps have been studied. And a review of some proposed systems has been done.

Keywords: Distributed database, query optimization, query execution engine, semijoin, ant colony algorithm etc.

Article published in International Journal of Current Engineering and Technology, Vol.4, No.6 (Dec-2014)