Contelligent

Note: Please Scroll Down to See the Download Link.

Abstract

SQL Workbench is the project that goes around the development of GUI Universal Database Client.  It is the project that is intended to make the connections to different databases from single interface in an easy, fair, faster and reliable way.

This software to be designed deals with different databases and execute different kinds of SQL statements from a single Tool. Users can create the connections for each and every database and store it in the Tool. Later on the user can select connection name to connect to a particular database and start executing SQL statements. User can also execute select statements and see the results in the Tool only. All the statements which are executed can be stored in .SQL file and at a later point of time the user can use that .SQL file to execute the same statements. Users can Commit or rollback the SQL statements.                                    

Existing system

The present system is a console-based system for each and every database separately and the user has to learn how to use that console to connect to a particular database and how to work on console to execute SQL statements. In the real time project development each and every user has a need to connect to different kinds of databases that are at different locations (systems). Whenever the user wants to connect to a database then the client libraries that are required to connect to that database server has to be installed at the client. This process repeats in each and every user system.

  • Connecting to a database from a Java Program without using installing client libraries also involves several steps:
  • Getting the appropriate driver for that database
  • Setting the classpath to that driver
  • Specify the Driver Name to register the driver
  • Specify the URL for getting the connection
  • Write the logic for executing select statements and displaying the results.
  • Write the commands for executing non-select statements and display the information that how many rows are updated
  • After executing the SQL statements, some consoles display the data in a manner that is not a better look and feel.

Limitations of the existing system

The drawbacks in the existing system are as follows:

  • More learning work
  • Command driven environment consoles
  • Adjusting the console to display the results effectively
  • Installing the client libraries in user system
  • User can’t store the statements what he is executing
  • Manually storing the results in a file
  • Repeated execution of the same statements
  • Maintenance of schemas from consoles
  • Doesn’t switch over to different easily
  • Executing commit and rollback statements manually
  • Can’t use undo, redo, cut, paste options effectively from consoles

Proposed System

The proposed system will be developed on client/server architecture. The user can run this tool at their system and get connected to different database servers that are different locations (systems) very easily.

On creation of connection, the users can connect to a database by using that connection. For creating the connection the user has to fill out the parameters only once. This allows the user to connect and work with any no of databases from GUI environment. It provides a single GUI interface for managing different kinds of databases. This type of environment is mainly useful for Project Managers, Project Leaders and the user who interacts and works with different databases. This tool allows the user to store all the statements what he has executed to be stored as .SQL file. Later on the user can use that .SQL file to repeatedly execute the same set of statements.

Merits of the Proposed System

  • GUI environment

  • Storing the SQL statements in .SQL file

  • Using the predefined connections

  • Connecting to multiple databases in the same way

  • Providing the operations like cut, copy and paste inside Text Area

  • Providing Overall Reliability

  • Easy to use, effective and efficient

  • Easy to install

Logical Design:

The system has to be developed from the existing manual system. Study of the manual system is done thoroughly

  • All the entries (both internal & external) that affect the system are identified.
  • Relationships between the entities are identified.
  • All attributes and constraints of each attribute are determined.
  • All the entities are normalized for eliminating redundancy and to achieve functional dependency.

These are the Modules in this system:

GUI Module: This module provides a graphical interface to make use of the features available in this tool. It catches the events and executes the functionality by coordinating with other modules.

Connections Module: This module provides a facility to create, edit and delete different connections and connects to a database if the user selects a connection. It allows the user to switch over different connections by making use of the same interface at the front end.

SQL Module: This module allows the users to execute any SQL statement using this tool and execute those statements on a particular database based on the selected connection. It allows us to make use of editing option cut, copy and paste in the SQL area. It also allows us to store the executed SQL statements into a file.

Transactions Module: It allows us to store support the transactions by making use commit and rollback options from this tool. It also allows us to store the result of an SQL statement in .CSV format for later use.

Export & Module: It allows us to export the database elements into a file and import the same also.

System Requirements Specification

Hardware specifications

Processor                           :              Pentium(R) 4 CPU 1.8GHz           

Memory                               :              256 MB RAM    

Hard Disk Capacity         :              40GB                    

Software specifications

Operating System                                          :    Windows-XP Professional/Linux

Technologies                                                   :   J2SE, JFC –Swing

Parser                                                                 :   SAX Parser

Back End                                                            :   XML and Any Database       

Click here to download Contelligent source code