Integrated db server
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
project topics
Active In SP

Posts: 2,492
Joined: Mar 2010
22-04-2010, 04:07 PM


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.


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 and implimentation to

project and implimentation. 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


To clearly identify the need of this application, it is exemplified with one situation.
A project and implimentation 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.

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.

The following hardware using for developing the project and implimentation

(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
Use Search at wisely To Get Information About Project Topic and Seminar ideas with report/source code along pdf and ppt presenaion

Important Note..!

If you are not satisfied with above reply ,..Please


So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page

Quick Reply
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  chat server full report project report tiger 10 16,567 06-11-2015, 07:20 PM
Last Post: Guest
Brick V3 MAIL SERVER full report project report tiger 4 6,497 04-10-2014, 02:39 PM
Last Post: GaCcBuH
  intranet mail server mechanical engineering crazy 2 3,849 23-08-2014, 10:00 PM
Last Post: cb644
  Chat Server project topics 3 3,788 10-01-2014, 04:29 PM
Last Post: seminar project topic
  ONLINE CHAT SERVER PROJECT REPORT study tips 2 1,961 10-01-2014, 01:59 PM
Last Post: seminar project topic
  REPORT ON CHAT SERVER seminar projects maker 0 457 28-09-2013, 04:56 PM
Last Post: seminar projects maker
  Educational Multimedia Server – A Java Approach Abstract seminar projects maker 0 432 19-09-2013, 03:41 PM
Last Post: seminar projects maker
  Implementation of Secured password for Web applications using two server model pdf study tips 0 397 12-07-2013, 02:04 PM
Last Post: study tips
  REMOTE LOGIN FOR SQL SERVER project topics 5 2,939 08-07-2013, 10:41 AM
Last Post: study tips
  Design and Implementation of a Web-based Internet/Intranet Mail Server pdf study tips 0 741 26-06-2013, 03:15 PM
Last Post: study tips