Article Details

Query Optimization In Distributed Rdbms |

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


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.