A Generic Model for Querying Multiple Databases in a Distributed Environment Using JDBC and an Uniform Interface

摘要

This paper discusses about an algorithm for accessing and querying multiple databases in a distributed environment. It makes use of JDBC and an UNIFORM INTERFACE to validate a SQL Query initiated from a Client Site, generates sub-queries based on Global Schema information, executes sub-queries in parallel using SQL Servers at appropriate sites, assembles the results of the query at the Client Site and outputs the results. This model reduces the effort required to search multiple databases stored at various sites in a network of heterogeneous systems, using a generic approach. The proposed model can be very helpful in practical applications such as banking systems and airline enquiry systems where there is a need to execute several queries over multiple databases located in different servers.