Query Optimization In Distributed Rdbms

Challenges and techniques in query optimization for distributed RDBMS

Authors

  • MD. Mustfa Alam Magadh University, Bodhgaya Author
  • Dr. Saket Bihari Singh Author

Keywords:

query optimization, distributed DBMS, complexity, programmer, DDBMS, cost-based query optimizer, relational DBMS, distributed data, complication

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.

Downloads

Download data is not yet available.

Downloads

Published

2016-05-01

Issue

Vol. 10 No. 15 (2016): International Journal of Information Technology and Management (IJITM)

Section

Articles