A HYBRID APPROACH TO OPTIMIZING QUERY PROCESSING IN DISTRIBUTED DATABASE SYSTEMS

Abstract

The issue of optimizing query is a cost sensitive process and with respect to the number of associated tables in a query.  Its number of permutations grows exponentially. Major model for server-client query evaluation are data shipping and query shipping techniques thus, are conventionally used despite some limitations like speed. Based on this, this study was intended to actualize hybrid technique using a combination of these existing techniques. This present work adopted constructive research which aided the hybrid technique for optimizing query processing in a distributed database as a designed. In this study, object oriented design for software development and hardware materials were used. The data shipping techniques was fast in query retrieval as opposed to the query shipping technique however, the had a synergic strength from the two existing techniques to actualize an efficient performance (runtime) This result was similar with previous finding. For server machine, query shipping technique is recommended while for client machine, data shipping technique. Query shipping technique is good for the sever machine while data shipping is good for the client machine however, the proposed hybrid technique is recommended for distributed database to achieve best results for the smooth running.