20-06-2012, 05:24 PM
Database Interface
Database Interface .docx (Size: 1.59 MB / Downloads: 37)
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.
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.
Project Advantages:
Flexibility: The end-user should be able to use any major commercial (or open-source) database on the market. Moreover, the end-user should be able to customize the look-and-feel of the front-end; this includes the ability to internationalize the application.
Maintenance: Both external documentation (like this) and inline java docs should explain how things work. I've tried to write clean Java code so that developers who build on database interface will have a clear, easily extensible starting point.
Ease of Use: Installation is simple; you just have to create a .war file and drop it in the right directory/folder. The Java search engine interface is text-based, and intended to provide easy access to search operations
Introduction
Objective:
The objective is to provide a user-friendly interface to communicate with any database.
The application allows a user to query the database and execute any operation on the database.
Need for the study:
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
Search for objects
Find and fix database problems with constraints, triggers, extents, indexes, and grants
System Analysis
Existing System:
Each database system provides its own interface or tool to enable users to interact with the database.
A user is required to learn the mechanisms of that tool before querying the database.
When the database system is changed, a new tool will be used and user is supposed to learn this tool.
Proposed System:
The proposed system is an industry-standard application for database development for any software project.
Using this application, developers can interact with any database such as Oracle, My Sql or SQL Server.
The application can be used to build and test SQL.
It can be used to create and modify database objects such as tables, views, constraints, users and others.
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.
Study of the system:
To provide flexibility to the users, the interfaces have been developed that are accessible through a browser. The GUI’S at the top level have been categorized as
1.Administrative user interface
2.The operational or generic user interface
The ‘administrative user interface’ concentrates on the consistent information that is practically, part of the organizational activities and which needs proper authentication for the data collection. These interfaces help the administrators with all the transactional states like Data insertion, Data deletion and Date updation along with the extensive data search capabilities.
The ‘operational or generic user interface’ helps the end users of the system in transactions through the existing data and required services. The operational user interface also helps the ordinary users in managing their own information in a customized manner as per the included flexibilities.