Eccox Application Quality Control for Oracle is a tool that automates the verification of SQL coding for access to ORACLE databases in the distributed environment. Studies have shown that almost 80% of problems concerning performance in a database are caused by badly prepared SQL codes and that, in general, a small number of QUERIES is responsible for most of the consumption resulting from the use of the database. In this context, it is important to have an automated process that continuously monitors the SQL coding and is capable of identifying inadequate code before it is promoted to the productive environment.
The flexibility of SQL allows a programmer to obtain the same processing result using different coding options. Despite producing the same result, these coding options can have different processing costs when executed. Consequently, programs with inadequate resource consumption (CPU, I/O etc.) may be promoted to the productive environment because programmers do not implement more adequate coding in terms of quality. In general, deadlines for the development and maintenance of programs lead the coding process to focus more on effectiveness (seeking an end-result) in detriment of efficiency (seeking better quality results).
Eccox Application Quality Control for Oracle verifies whether the code is appropriate in terms of performance and compatible with the pre-set standards and rules that implement better coding practices aiming to reduce time and costs in the execution of SQL. It acts as a quality filter, impeding inadequate code from being promoted to the productive environment and identifying inadequate logical access, coding that can cause the consumption of critical resources or even errors in execution time, provoking an impact on the stability of the environment. The results of the evaluations are registered in product bases, constituting an inventory of evaluations of the collection of installation programs. Eccox Application Quality Control for Oracle should be used during the development of programs in the steps that precede the promotion of the code within the application cycle or in inventory processes to identify eventual opportunities for improvement.
Eccox Application Quality Control for Oracle is simply and easily integrated to the tools that manage the application lifecycle, such as Subversion e CVS. Acting as a quality filter, Eccox Application Quality Control for Oracle should be integrated into the development cycle of applications (inserted in the procedures for compiling and promoting the code), interacting in the program development and maintenance. Its purpose is to support developers in the coding process identifying the SQL that show violations and providing orientation for the applicable alternatives according to each case.
• Definition and implementation of contingency processes;
• Monitoring the vegetative growth of the bases of Eccox Application Quality Control for Oracle according to the stored evaluation data;
• Implementation of Purge processes of the evaluation data;
• Maintenance of the processes that implement Eccox Application Quality Control for Oracle interface with the continuous integration process;
• Adjustments to the product parameters;
• Adjustments to the rules of verification parameters;
• Choice of adopted evaluation criterion, signal codes and mode of operation;
• Definition and implementation of new verification rules;
• Registration of source files in exception;
• Registration of the Legacy.