Query Optimization In Distributed Rdbms

Published in Journal

International Journal of Information Technology and Management [IJITM] (Vol:10/ Issue: 15) DOI: 10.29070/IJITM
Authors: Md. Mustfa Alam, Dr. Saket Bihari Singh,
Subjects: IT & Management

Year: May, 2016
Volume: 10 / Issue: 15
Pages: 0 - 0 (0)
Publisher: Ignited Minds Journals
Source:
E-ISSN: 2249-4510
DOI:
Published URL: http://ipublisher.in/p/3933
Published On: May, 2016

Article Details

Query Optimization In Distributed Rdbms |

Md. Mustfa Alam, Dr. Saket Bihari Singh, in International Journal of Information Technology and Management | IT & Management

Download PDF

View HTML

ABSTRACT:

Database queries havebecome increasingly complex in the age of the distributed DBMS (DDBMS). Thisposes a difficulty for the programmer but also for the DDBMS. Queryoptimization is a difficult enough task in a non-distributed environment.Anyone who has tried to study and understand a cost-based query optimizer for arelational DBMS (such as DB2 or Sybase SQL Server) can readily attest to thisfact. When adding distributed data into the mix, query optimization becomeseven more complicated. This paper focuses query optimization in distributedRDBMS.