[May 28, 2024] Openmade Consulting (CEO: Youngcheol Choi), a company specializing in data-based services and solutions, presented a session titled 'Oracle DB to Open Source DB based on Automation Solutions' at the 23rd Public Solution Market.

The introduction of open source in the public sector is expanding day by day. Countries around the world are promoting open source activation policies for reasons such as public service innovation, strengthening digital sovereignty, and fostering software ecosystems. One of these policies is the expansion of open source introduction in the public sector. In the case of Korea, open source activation is being implemented quickly through revisions to the Software Promotion Act in 2020 and the announcement of the Software Promotion Strategy in 2023. In addition, the National IT Industry Promotion Agency is providing various guidelines for the introduction of open source to help public sector organizations and groups introduce open source. Open Made Consulting presents the OpenPOP OTO solution as a way to smoothly convert Oracle DB, which is considered the most difficult task in open source conversion projects in the public sector, to open source DBs such as MySQL and PostgreSQL using automation technology. For reference, OpenPOP OTO also supports conversion to the Tibero environment, which is widely used in the public sector, in addition to MySQL and PostgreSQL.

CEO Choi Young-cheol cited the 'gap between conversion rate and execution rate' as the reason for the difficulty in converting Oracle DB to open source DB based on his experience participating in major domestic companies and institutions related to DB. There are many migration tools on the market today. These tools advertise high conversion rates. So why do people complain about the complexity of migration in the field? CEO Choi Young-cheol said, "Conversion rate and execution rate are clearly different, but most places that provide migration-related services or solutions tend to emphasize only the conversion rate." He continued, "The conversion rate is simply the rate at which SQL statements are converted, and it does not guarantee that the converted SQL will operate properly. On the other hand, the execution rate is the rate at which the converted SQL returns accurate results. It means the proportion of sentences that are not abnormal when the converted SQL is individually executed and the results are compared with the existing Oracle results."

The gap between conversion rate and execution rate is the reason why many organizations feel burdened by the conversion to open source DB. OpenPopO2o solves the difficulties faced in the project field. OpenPopO2o is a solution that solves the problems of complex testing process, difficulty in comparing performance, and lack of appropriate tools. “OpenPopO2o is not a complex solution,” says CEO Choi Young-cheol. “It automatically converts Oracle SQL to open source SQL to reduce manual work, automatically verifies SQL quality and execution results to reduce human errors and shorten verification time, compares converted SQL with Oracle to identify and improve execution errors or performance degradation in advance, and analyzes SQL statements and DB indexes to provide index optimization guides to maintain optimal performance. CEO Choi Young-cheol introduced the results of tests conducted in actual project fields and showed how OpenPopO2o can simplify the conversion to open source DB. “When testing with 10,000 SQLs, SQL conversion took 40 minutes, SQL execution error check took 30 minutes, SQL execution result verification took 2 hours, SQL performance comparison/verification took 2 hours, and index optimization took 4 hours,” he explains. “Despite this short time, the level of automation is high, with an execution rate of over 90%.”

Meanwhile, CEO Choi Young-cheol also presented a plan for how to utilize OpenPopO2 in the public sector. Migration at a level where the business logic does not change can be processed quickly with OpenPopO2. In the case of projects that develop next-generation systems or significantly improve applications, automation-based advancement can also be performed.