Openmade Consulting (CEO Choi Young-cheol) announced the new feature of ‘SQL Quality Automatic Improvement’ technology in ‘OpenPOP’, a solution that prevents database (DB) performance failures through preemptive SQL quality/performance management.

The newly added OpenPop SQL quality automatic improvement technology is a very powerful automation technology that automatically corrects about 25 SQL syntax quality errors that may exist in development SQL.

The SQL quality check function of OpenPop currently being provided is:

We provide functions that allow developers to directly check/modify SQL quality and control shape registration. These are functions that support developers to check SQL quality themselves in the Eclipse development environment, or automatically check the quality of SQL when the developed SQL is stored in the shape management system, and block inappropriate SQL from being stored in the shape management repository. In addition, we provide a function that allows you to improve the quality of developed SQL by batch checking SQL existing in the source code and SQL executed in the DB.

There are a total of 38 SQL quality inspection items checked by OpenPop, and the main quality inspection target is to prevent problems such as malfunctions, performance degradation, errors, and management efficiency degradation that may occur due to quality-violating SQL.

The newly announced ‘SQL quality automatic improvement’ technology is,

In a reality where it is not easy to operate a quality management system for SQL,

Openmade Consulting expects that this will be a very useful function for customers as it can automatically analyze code quality issues in development SQL and automatically correct codes of SQL with poor quality, thereby preventing possible DB performance degradation and failures caused by poor SQL from the development stage. This will also be an opportunity to increase Openpop's sales.

Openmade Consulting stated that the 'SQL Quality Automatic Improvement' technology will provide practical help to all organizations that require database performance management and quality improvement, and that they plan to further expand the quality inspection area and develop more quality automation technologies through continuous research and development in the future.

<Reporter Kim Dong-gi>kdk@bikorea.net

http://www.bikorea.net/news/articleView.html?idxno=42024

#Database #DB #Oracle #SQL #SQLQualityOptimization #SQLQualityInspection #SQLPerformanceOptimization #SQLPerformanceInspection #OpenPop #openpop #openmadeconsulting #openmade #openmade #SQLQualityInspectionAutomation #SQLQualityInspectionPlugin #SQLQualityInspectionEclipse #SQLIndexOptimization #SQLQualityAutomaticImprovement