[IT Daily] Openmade Consulting (CEO Choi Young-cheol), a DB construction specialist, began supplying a new version of its SQL quality management solution, 'OpenPOP', in July of last year. Its core function, 'SPS (SQL Performance Impact Analysis),' is emerging as an essential tool for U2L (Unix to Linux) migration, and is gaining attention from customers.

According to the industry, Openmade Consulting supplied the 'OpenPOP SPS' solution to the Suhyup Bank U2L project and Shinhan Bank's next-generation project in April and May, respectively. As a result, it is evaluated that it will greatly contribute to U2L migration and SQL performance verification and early stabilization in the new DB environment, and play a big role in the U2L conversion without performance problems of the application and successful DB upgrade.

OpenPOP Key Features for E2E SQL Quality Management

The reason why the SPS function is so well-received by customers is said to be the ease of use and market-friendly performance enhancement of the 'OpenPOP' solution. In other words, the existing solution, which was a function-centered SQL quality management system, was simplified by applying a quality management system closely linked to the customer's work process, as well as integrating functions. Based on this, the performance was greatly enhanced with automated functions for checking/verifying/tracking/diagnosing/testing SQL quality in all stages from SQL development to testing, distribution, operation, and response to changes in the DB operating environment. Accordingly, not only SQL quality was greatly improved, but also development productivity was greatly improved, and factors causing SQL performance failures were eliminated, enabling proactive prevention of DB performance failures. In this process, Openmade Consulting explained that in particular, the SPS (SQL Performance Impact Analysis) function, which had been distributed across each area of the product, was integrated and reorganized, and at the same time, market requirements were actively reflected to create a new function.

Let's take a closer look at what kind of solution 'OpenPOP SPS' is. The 'OpenPOP SPS' solution: △ When the operating DB environment changes due to U2L or DB version upgrade and cloud deployment, etc., △ It quickly compares and analyzes the impact of performance changes on the performance of the currently operating DB SQL and the SQL to be executed in the new operating environment, thereby supporting early stabilization of performance in the new DB environment. It also provides a function to quickly and conveniently analyze the impact of performance changes on related SQL even when making relatively simple changes such as changing and patching tables/indexes/parameters of the currently operating DB.

Verification of DB performance comparison of OpenPOP SPS

In addition, the biggest advantage of OpenPOP SPS is that it performs in advance 'selection of SQL change targets according to DB version and comprehensive inspection of SQL execution errors' in the △ project execution preparation stage, △ in the execution stage, 'automatic comparison and verification of SQL performance of current operation DB and new operation DB', △ finds SQL whose performance is degraded in the new DB environment and 'supports efficient and automated performance optimization work' for the corresponding SQL, and △ ultimately, 'early verification of APP/SQL performance in the new operation system', which can minimize concerns about performance problems in the new DB operation environment at an early stage.

Also, Openmade Consulting explains that the popularity of the 'OpenPOP SPS' solution is due to the differentiated solution that supports DB performance stabilization through 'SQL performance verification' and 'execution plan optimization support' at an early stage through 'analysis of performance changes in related SQL' even when the currently operating DB environment is changed. This is because it is currently planning to upgrade DB to U2L and Oracle 19c version, or companies that need to frequently analyze the impact of performance changes on operating SQL due to frequent changes in operating DB.

http://www.itdaily.kr/news/articleView.html?idxno=203974