Developing Integrated Engine for Database Administrator and Developer

With the advances in the field of database there exist many tools and software that are operated separately by the developer and the administrator to perform their respective tasks .However, it is highly desired to accommodate both the administrator's and developer's roles in a database related tool, since there are many common activities between them.To address the issue, we developed the integrated database management tool for both database administrators (DBA) and developers.First, the integrated engine has various access functions to both DBA and developer to manage user instances, administer privileges and monitor databases.Second, the efficient accessing of the result set is developed in the engine without granting or revoking temporary privileges.Therefore, DBA does not have to provide the privileges to users who want to access the result set, which makes the system more secured.Thirdly, an optimized performance meter is triggered as a combination of all the important factors that determine the performance of the database, such as different hit ratios and CPU activity.Lastly, to provide developers a convenient tool for tuning SQL, we develop a PL/SQL editor where a user can parse the commands easily and perform basic activities such as a routine structure like editing, querying, optimizing (which includes hit ratio, type of scan, cardinality and selectivity).The effective outcome of the Integrated Engine is to provide a common platform to these engineers with alternative functionalities and faster accessibility towards different tasks.