16-03-2011, 10:35 AM
Prepared by:
K. VINOD KUMAR
[attachment=10277]
GENERIC DATABASE EDITOR
1: Introduction
1.1 Purpose
This application ismainly intended to create the rich user interface to access different data bases. The database interface is an industry-standard tool for application development. Using this application, developers can interact with any back end software like Oracle, MY-SQL, MS-Access, MY_SQL.etc. this application interface can be used to build, test, and debug PL/SQL packages, procedures, triggers and functions.
Through this application 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 quires. And its powerful data grid provides an easy way to view and edit data related to any DBMS/RDBMS tools.
For example, a programmer perfect in all the Databases and he need to interact with different Database then he want to open the every Database interface and log out from the every Database interface after work is completed. By the GENERIC DATABASE EDITOR application, the person who is interested to interact with different Databases.
1.2 Document Conventions
We have used Times New Roman (text size 12). Bold Font is used for Main Headings (text size of 14). Bold, Underline and Italicized font is used for Modules (text size of 14). Underlining is done for technically important words.
1.3 Intended Audience and Reading Suggestions
This document is for better understanding of Blood Donor Symbiosis. Mainly intended for Head of the Dept., Internal guide, External guide, Staff members, Users and colleagues. This detail given below guides every normal user to how to go through this document for better understanding. The sequence to follow for better understanding is here Purpose, Scope , Features of the Blood Donor Symbiosis software, Operating requirements, Modules present in the project, Advantages, References etc.
1.4 Project Scope
This software is not only used for the industry based Database applications but also used for the normal user or programmer who has expertise in more than one Database then they use this application effectively.
2: Overall Description
2.1 Product Perspective
This is an effective tool for interacting with different Databases from single interface. It deals complete about managing database and its content and structures.
1.2 Product Features
Interact through single interface
Flexibility
Maintenance
Ease of use
Importing and exporting table data
Alter the table structure
2.3 User Classes and Characteristics
As it is fully user compatible software that maintains rich user interaction. It plays a good role in accessing or editing Database. And it is also enhanced in updating the Database whenever the user needs.
2.4 Operating Environment
Software Requirements used are Windows XP/LINUX/MAC any other latest versions. HTML, Cascading Style Sheets, AJAX and Java Script is used to build client side environment. For the server side, we use the Java, Java Server Pages and Servlets and Tomcat 5.5 as the Web Server. For the back end software we use the MS-Access, MY-SQL, oracle etc databases. Hardware Requirements used are P4 processor, 512MB of main memory (RAM) and 100MB hard disk and data base memory.
2.5 Design and Implementation Constraints
The software is designed in such a way that the user can easily interact with the screen because they are GUI. We first select the structure of the Database and enter the query of related Database structure. And, since the operation deals with complete DML and DDL I need to do a lot of survey on Data Manipulation Language in different databases and Data Definition Language.
2.6 Assumptions and Dependencies
This software is to be used in the each system as individual. So that the person who are interested to done the Database works then that system must having this application Each user must be loaded into the primary memory and then manipulates the contents of Database.
3: System Features
3.1 Structure Module:
This module havs the details about the Database that means how many tables are there, Structure about the table and also we can view all the tables in the selected Database.
3.2 Properties Module:
The properties module has the details about the Database user selects. This module has details like Database version, name, Naming Conversions, Supported file data types and other properties.
3.3 SQL Querying Module:
The SQL querying module replies the response to the related submitted query where query consists of access, edit and manipulate commands.
3.4 Insert Database Module:
Insert Database module does the word of inserting the any table or table structure. In this module has options like Table Structure, Table Data and both of them is another option.
3.5 Export Database Module:
This module helps to copy the Database from one place to another place that means copying the Table data from place to another place.
3.6 DML Operations Module:
The DML Operation Module is used to perform the operations on the Database tables. Operations are Alter table column, Rename table and Drop the entire table.
3.7 Search Operation Module
This module can help to search the data in the selected table of any Database.
4: External Interface Requirements
4.1 User Interfaces
This application include sample screen images such as user login, interacting with database, any GUI standards or product family style guides that are to be followed, screen layout constraints, standard buttons and functions that will appear on every screen, error message display standards, and so on.
4.2 Hardware Interfaces
We require internet connection for interacting with database and local computers for any help or any other requirement. We use TCP/IP protocol for communicating with local hosts. We also need system with P2 or above processor; 128MB+ RAM and database memory.
4.3 Software Interfaces:
We use Java, JSP and Servlets as Programming language for writing the code for the project. HTML, CSS and JavaScript are for creating the web pages. MYSQL server, Oracle, MS Access, SQL Server will be databases on which this application works on. ECLIPSE IDE for writing the programs. Operating system will be Windows XP.
