ABSTRACT

Aim:

The project aims to develop an application which could query multiple heterogeneous Databases in a distributed fashion.

The project would provide me familiarity with the RMI mechanism as implemented in Java. It will also give me an insight into some of the challenges involved with designing and building a distributed application.

Objective:

The problem involves developing a distributed database querying system. The system has three databases. These databases are MS Access databases as used in this Implementation. However, these databases could be of varying architectures like Oracle or MS SQL server and so on.

The system has three Access databases on three different machines. The database structures are as described in the problem statement earlier. Just above the databases on each machine is a Query Database object. The Query Database object can talk to the Database and make queries on it. Since the Query Database objects are on the same Machine as the database they are interacting with, it is assumed that the individual Query Database objects would know the structure of the database they are querying. The Query Database object talks to the database using JDBC (Java Database Connectivity) calls. Unfortunately, the Access databases do not recognize JDBC calls. However, Access understands another standard i.e. ODBC (Open Database Connectivity). Thus the Query Database objects use a JDBC-ODBC bridge to connect to the database.

Each machine implements a server that implements a MyServer interface. These servers have the job of binding the name of the particular machine with the RMI registry. The servers implement among other things, a method called ProcessData. The Process Data method is the remote method that would be called using RMI.

So the execution goes on like this,

1. A client takes a query from the user. This query is a sid of a student whose information is required.
2. The client calls the ProcessData method of the second machine remotely and passes it the query string and a result string (which is initially null). The ProcessData calls the corresponding QueryDatabase method and store the results got into the result string. It then calls the ProcessData of the third machine remotely.

The ProcessData method on the third machine does a similar job and calls the ProcessData method on the first machine (on which the client was run). It then contacts the QueryDatabase object and gets the results from the first database which are appended to the result string and finally, the ProcessData method on the first machine will write out the result string to a file which is named as query.

EXISTING SYSTEM:

We can’t access more than one databases existing in different servers.

PROPOSED SYSTEM:

By using this we can overcome the drawback of existing one.

SOFTWARE REQUIREMENTS:
• Web Technologies : HTML, CSS, JS. JSP
• Programming Language : Java
• Database Connectivity : JDBC
• Backend Database : MySQL
• Operating System : Windows 08/10
HARDWARE REQUIREMENTS:
• Pentium processor : Core I3
• RAM Capacity : 2GB
• Hard Disk : 250GB
• Monitor : 15’’ Color Monitor