ABSTRACT

The Database interface tool is designed and developed to test the database

connectivity features of JDBC drivers and their supported databases .The

environment chosen to develop this tool is ORACLE,. My-SQL .The tool

provides in depth control of the API sequence of the driver. The DBI tool

covers all methods defined in the JDBC specification. DBI tool provides

facility for processing queries .The tool provides an abstract format and

interface to submit an SQL statement and view the results.This mechanism

is further simplified with Load and Gocommand . For instance when a

Load & Go is used, the tool automatically takes SQL statement and view

the results creates a JDBC statement object ,executes the statement and

displays the result set. During the above sequence of operation the tool

doesnËœt wait for any user action or input block .This tool has other

additional useful feature for exporting the data in html or excel format.





1.1 AIM

Enterprise applications are changing more rapidly and the needs of enterprise is
increasing enormously, as the needs are growing towards decision making ,obtaining
accurate data in time plays a major role to withstand the fray .Ultimately the success lies
in how fast can we retrieve data and manipulate the information .To send queries and
process them quite efficiently is the task of drivers which lead us to connect to the
databases. When different companies provide different drivers to connect to their
databases ,we seldom found a server side application to interact with any database like
oracle , my -sql offered by a database providers and also there is a need to have an
user friendly interface to query the database and obtain the results from the server.

1.2 INTRODUCTION

Database Interface is an industry-standard tool for application development . Using

Database Interface, developers can interact with any back end software (i.e. Oracle,

MS-Access, My-SQL etc). The database interface can be used to build, test and

debug PL/SQL packages, procedures, triggers, and functions. Database Interface

users can create and edit database objects such as tables, views, indexes, constraints, and

users. Database Interfaceâ„¢s SQL Editor provides an easy and efficient way to write and

test scripts and queries, and its powerful data grids provide an easy way to view and edit

data related to any DBMS/RDBMS tool.

The requirements of a database application developer will vary from project to

project. On a large team where DBAs manage the DDL, a developer may spend 90 of

development time coding and testing SELECT queries to issue from 3GL or 4GL

application code. In such an environment, a developer might be concerned only with

viewing the DDL and database code. On smaller teams, a developer might be responsible

for maintenance of the development schema, movement of test data between schemas,

writing procedure code, populating tables from legacy sources, and more. Database

Interface facilitates all of these needs.

For example if you are working with oracle, you donâ„¢t have to be a PL/SQL expert

to access database objects with Database Interface. You can view the Oracle Dictionary,

tables, indexes, stored procedures, and more - all through a multi-tabbed browser.

Database Interface utilizes direct Oracle OCI calls for full access to the Oracle API.

Advanced editing features save time and increase productivity. Code can be created from

shortcuts and code templates. You can even create your own code templates.

1.2.1 Use Database Interface to
¢ Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE objects

¢ Graphically build, execute, and tune queries

¢ Edit and Debug PL/SQL and profile stored procedures including functions, packages, and triggers

¢ Find and fix database problems with constraints, triggers, extents, indexes, and grants


1.3 IDENTIFICATION OF NEED

To clearly identify the need of this application, it is exemplified with one situation.
A project manager is dealing with an enterprise application, which is in the development
phase. This application has got different faces such as a desktop interface, a web interface
and mobile interface. Initially all these applications are not integrated. Once these entire
interfaces are working well, they are going to be integrated. In such occasion the
database which is being used must be same. But while designing these individual
modules, creating a sample database for each module and perform the test, it is not
possible practically. So for that reason, there must be a kind of tool, using which we
can carry the database to any another location and use the database there very easily.
The present application will fulfill the requirement. The current application can be

used just as a brief case of database.

1.4 PRELIMINARY INVESTIGATION:
The present application can be differentiated into the following modules, which are
closely integrated with one another.
1.Structure: It gives the list of all tables which are present in the current/selected user. This module is used to browse and view the structure of an existing database object.
2.Properties: The properties module enables us to modify data types, size and constraints assigned to each field.
3.SQL: Using this module, we can use and implement different kinds of SQL statements. The result of the SQL statement will be displayed immediately after executing the statement.
4.Import: This module gives an exclusive feature of importing the existing SQL scripts to the existing schema.
5.Export: This module gives the feature of exporting existing schema object(s) to an SQL file. Here the facility is there to export only tables, only single user or the entire schema.

SOFTWARE AND HARDWARE SPECIFICATIONS
The following hardware using for developing the project

(i) Hardware requirement for developing

1. Pentium III Processor with @ 800 Mhz Speed

2. 128 RAM


3. 20 GB HDD

4. 14 Color Monitor

5. 1.44 MB FDD

6. CD ROM drive

7. 105 keys keyboard

8. 4 Serial + 4 Parallel ports

9. Mouse

10. Printer

11. Ethernet card

12. Internet Modem

(ii) Software requirement for developing

1. Windows 2000 Operating system

2. Jdk 1.4

3. Tomcat Web Server 5.0.25