08-16-2017, 09:27 PM
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 II 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