ABSTRACT
The Automatic Database Schema
Generation is a system, which allows the developers to focus on creating the
database using the GUI interface .The user needs to fulfill the requirements in
the interface and he can perform the database operations which he wants and can
create the database.
This
project aims at creation of an automatic database schema generation. This
project will be accessible to all developers and its facility allows developers
to focus on creating the database schema on the basis of JSP while letting the
application server define table based on the fields in JSP and relationships
between them. This system provides the following facilities.
This facilitates the user to focus much on
application aspects leaving behind the
database aspects.
This project
allows users to generate database schema generation without having much
knowledge of database Aspects.
MODULES:
Number of Modules:5
1) SQL Query Pane Module
This module is used to retrieve data from
the database by using SQL Queries. The User interface is designed with a query
pane to type the query, where a user can type the sql query. The sql query is
taken by the module as input and generates the output of that query. The output
is displayed in a tabular manner.
2) Import Option Module
This module is developed to retrieve schema
from the external files. The supported files are .sql files. .sql files
contains the set of queries that can be executed. This module uses the FTP
protocol which will enable the web server to load the files.
3) Export Option Module
The user can export sql Structure, sql Data or both based on some
conditions into 3 types of files.
- .sql files
- .html files
- .csv
files(Excel Files)
4) Operations Module
The user can create table with
constraints, Alter the table, Rename the Table, Drop table.
The user can Alter the existing
table like by using following keys.
o
Alter column
- Rename
column
- Drop
column
- Empty
column
The
user can rename the table by giving the old name and new name. The user can
drop the table by selecting the table name from the select box.
5)
Search Database Module
The user must search based on keywords
o Search looks for column names only
o Search looks for data only
EXISTING
SYSTEM:
There are many Database Management
systems available today. The Database designer is familiar with any one of the
database Management Systems. Let us consider a condition when a database
designer required to design the schema for an application on different DBMS. He
required to learn all the DBMS User Interfaces. Where some of them are GUI
(Graphic User Interface) based and others are CUI(Character User Interface).
Drawbacks
of Existing System:
Through this approach to alter or to edit a
large database schema, It consumes more time for a Database Designer. The
operations like altering the table structure, Editing the table, Dropping columns, searching for a column
name, searching for a data in the table.. etc.,
To Design and alter the Database schema there
exists different user interfaces for different DBMS.
PROPOSED
SYSTEM:
The Automatic Database Schema
Generation System provides the following features.
1. The Automatic Database Schema
Generation System provides a Common User Interface to interact with all the
databases.
2. Here the user interface is
Graphical User Interface.
3. This application is a Web based
Application.
4. Being a web based application it
doesn’t require any client side installation.
5. Any number of users can interact
with the system simultaneously.
6. Centralized database
connectivity.
7. Using Session management the
interaction more flexible and secure.
SYSTEM REQUIREMENT SPECIFICATION:
Software Requirements:
Technology : J2EE Technologies i.e. JSP, Servlets
Front End : Html, JavaScript and
Backend : Oracle 8i/SQL-Server 2000
Hardware Requirements:
Processor : Pentium
4
RAM : 1GB
& above
Hard Disk : 40GB
No comments:
Post a Comment