Important: Use custom search function to get better results from our thousands of pages

Use " " for compulsory search eg:"electronics seminar" , use -" " for filter something eg: "electronics seminar" -"/tag/" (used for exclude results from tag pages)

Tags: Integrated, server, Integrated db server, Integrated db server ppt, Integrated db server pdf, integrated body mind training, integrated behavioral health, integrated baseline review, integrated business solutions, integrated biometric technology, integrated biometrics, integrated biotherapeutics, integrated benefits, integrated benefits institute, integrated business systems, integrated circuit, integrated chinese, integrated curriculum, integrated communications, integrated capital, integrated consumer solutions, integrated community services,
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Integrated db server
Post: #1


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 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


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.

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

(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

Quick Reply
Type your reply to this message here.

Image Verification
Image Verification
(case insensitive)
Please enter the text within the image on the left in to the text box below. This process is used to prevent automated posts.

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  solution of d roy choudhary linear integrated circuit pdf Guest 1 0 15-11-2017 11:13 AM
Last Post: jaseela123
  download proxy server project in java with code Guest 1 0 07-11-2017 09:38 AM
Last Post: jaseela123
  photonic integrated circuit seminar report Guest 1 182 12-10-2017 02:27 PM
Last Post: jaseela123
  linux virtual server seminar report pdf Guest 1 201 11-10-2017 09:31 AM
Last Post: jaseela123
  ppt on photonic integrated circuit technology Guest 1 142 04-10-2017 03:35 PM
Last Post: jaseela123
Last Post: jaseela123
  mail server subine 1 91 21-09-2017 04:24 PM
Last Post: jaseela123
  Polycrystalline Germanium Enables Near-IR Photodetectors Integrated with Silicon CMOS seminar flower 1 382 20-09-2017 04:47 PM
Last Post: jaseela123
Photo photonic integrated circuit technology ppt Guest 1 156 19-09-2017 04:32 PM
Last Post: jaseela123
  Client – Server Architecture ppt project girl 1 1,143 14-09-2017 12:58 PM
Last Post: jaseela123
This Page May Contain What is Integrated db server And Latest Information/News About Integrated db server,If Not ...Use Search to get more info about Integrated db server Or Ask Here