Date of Award

Fall 12-7-2009

Document Type

Thesis

Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Sreekanth Malladi

Second Advisor

Wayne Pauli

Third Advisor

Stephen Krebsbach

Abstract

Now days every organization uses SQL plus tool to write SQL commands in oracle database or in some other databases. As an industry norms database must be under control of database administrator, which means no other user can access the database but sometimes organization will give permissions to all users in that organization to access the database for some projects and also organization has to give permissions for their clients to access database but sometimes manually it is not possible. To avoid these types of problems UNIFIED DATABASE INTERFACE was introduced. UNIFIED DAT ABASE 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). The UNIFIED DATABASE INTERFACE can be used to build, test, and debug PL/SQL packages, procedures and functions. UNIFIED 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. In general this tool will be used in software companies for development of projects which are related to database. By using this tool we can give restrictions to employees on database accessing individually.

Comments

dsu-th-093

Share

COinS