DBA Easy Control for Oracle

Copyright (c) 2008 DBA Inventions Ltd.
All Rights Reserved

Homepage: http://www.dbaeasy.com
E-mail: support@dbaeasy.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        
Product overview
        
DBA Easy Control is the system to automate operations of Oracle DBMS administrators. The product is positioned as the tool intended to build working environment at Oracle database administration.

The system consolidates a lot of information that Oracle database administrator uses in his/her everyday work. Besides database technical data (users, tablespaces etc.), the information includes events related to database operation, technical and service documents, description of operating system scripts, on which applications are deployed, parameters change history, granted privileges history data, statistics and other information. All these systems are bound that profitably simplifies the administrator's work and allows receiving the required information more quickly.

The system allows IT personnel to perform periodic jobs on databases making no high demands for SQL syntax competence. Such jobs are user creation and modification, access granting, tablespace creation and enhancement, partitioned objects scheduled maintenance execution on databases. The system allows executing jobs without direct providing privileged accounts.  

On the application level, in the system the user accesses are partitioned for the given data and database active actions execution. The user actions journal is maintained in the system. Access partitioning allows delivering the system interface to IT staff to perform specific actions on database administration, providing no privileged accounts.

To execute the resource planning tasks the system supports statistics storage of database sizes, database read-write and read-only partitions that allows performing an early forecast of database size grow and preparing required resources in time. 

The system stores initialization parameters change history, warnings history, database users history data and granted object and system privileges. The access history is of particular importance for the company security services related to data access check.  

The interface with external systems of monitoring is implemented to enhance warning functions to identify possible problems in database operation. The product provides the opportunity to display warnings from the external monitoring systems and organize the working process synchronized between administrators to solve arising issues. The internal monitoring functions are also realized in the system.

The critical component of the application is the SQL-task subsystem that allows automating database periodic operations.  The operations include data archiving (migration into tablespaces for the purpose of data closing for change), partitions adding/deleting in partitioned tables, tablespaces creating and adding files to existing tablespaces, object and system privileges granting, users creating/modifying. At privileges granting and users creating, binding to the reason document is performed that systematizes the process of data access granting. 

The SQL-task subsystem has the scheduler that allows performing resource-intensive operations offline in the automatic mode at hours of minimal load. The feature to execute jobs concurrently, in some cases, reduces downtime and accelerates operation execution.

To insure security, data capture and database operation execution are performed using the account with minimum-required set of object and system privileges. Passwords required for granting object and system privileges as well as executing a number of administrative tasks are stored in the encrypted form in the system. The account that executes statistics capture is created using the embedded installation wizard.

The system has built-in features for sending mail messages on different events. Such events include system warnings and SQL-task subsystem messages. Database mail lists can differ. 

The back-end designed in the form of Oracle database is at the same time the application for statistics capture and data offline storage that allows, at storage deployment on a separate Oracle instance, receiving the needed information about the exploited database even when it is not available due to different reasons.     

The data capture interval and number of simultaneously operating processes intended to capture data from different database are adjustable that provides the opportunity to control the application database server load. 

The SQL-task subsystem realizes functional to execute actions over databases. The subsystem is designed in the form of Windows service.

The client-end designed in the form of Win32 GUI is the interface for the system data storage that provides information in the form convenient for the administrator work. 

The system has the embedded SQL-Editor to create and execute SQL expressions and scripts.


