ABSTRACT
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-SQL Server, 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.
The requirements of a database application developer will vary from project to project. On a large team where DBAs manage the DDL, a developer may spend 90% of development time coding and testing SELECT queries to issue from 3GL or 4GL application code. In such an environment, a developer might be concerned only with viewing the DDL and database code. On smaller teams, a developer might be responsible for maintenance of the development schema, movement of test data between schemas, writing procedure code, populating tables from legacy sources, and more. Database Interface facilitates all of these needs.
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.
Advanced editing features save time and increase productivity. Code can be created from shortcuts and code templates. You can even create your own code templates.
Use Database Interface to
- 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
SOFTWARE REQUIREMENTS:
• Web Technologies : HTML, CSS, JS. JSP
• Programming Language : Java
• Database Connectivity : JDBC
• Backend Database : MySQL
• Operating System : Windows 08/10
HARDWARE REQUIREMENTS:
• Pentium processor : Core I3
• RAM Capacity : 2GB
• Hard Disk : 250GB
• Monitor : 15’’ Color Monitor
