11-04-2013, 03:04 PM
ABSTRACT ON Common Database Browser & Data Manipulation System
Common Database.pptx (Size: 83.45 KB / Downloads: 26)
ABSTRACT :
Common Database Browser & Data Manipulation System Interface which provides an easy to use Web-Based based common interface for viewing, adding, editing, or deleting entries in almost all the databases. The user should never have to write SQL to view the data although a SQL window is provided. All user tables and basic data type fields are available for access in the selected database.
This tool can be used to build, test, and debug PL/SQL packages, procedures and functions. Using this 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 or RDBMS
Features :
Connects to any database
Get the meta-data regarding database product, databases, tables
It gives the structure information regarding a database or a table
He can browse through the table data.
It allows us to export or import a database or a table
It allows us to perform different SQL operations (like insert, update, delete etc).
Search for a keyword in the database.
EXISTING SYSTEM :
In the existing system, all the database application developers are using client softwares to managing the databases.
For example to manage the oracle database, oracle database vendor providing one stand alone client software. In the same way all the database vendors are providing their own client software to manage the databases.
DISADVANTAGES:
We have to install all the client software inside
our systems.
In the existing system we have to write queries to
create / alter / drop / delete / insert like operations.
In this system we have installing all client
software's in all system in the organization.
Developers have to write all queries at all times
and it is a stand alone application.
PROPOSED SYSTEM :
COMMON DATABASE BROWSER & DATA MANIPULATION SYSTE INTERFACE is an industry-standard tool for application development.
Using Database Interface, developers can interact with any back end software (i.e. Oracle, SQL Server, MS-Access, My-SQL etc).
ADVANTAGES:
The COMMON DATABASE BROWSER & DATA MANIPULATION SYSTEM INTERFACE can be used to build, test, and debug PL/SQL packages, procedures and functions.
In this system 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.