Openmade Consulting (CEO Choi Young-cheol) announced the launch of OTO 2.0, an open source DB conversion support solution that can dramatically improve the automatic conversion rate of SQL by incorporating AI into OTO.

This time, the area where AI was applied was the function that converts Oracle SQL into open source DB SQL, and while the SQL conversion/execution rate in the existing 1.0 version was 8-90%, the 2.0 version equipped with AI this time showed a conversion/execution success rate of 98%, which is close to 100%.

Openmade Consulting explains that this will be very welcome news to customers who are considering switching to an open source DB due to the cost burden of the currently operating Oracle DB, as it will now be possible to completely resolve the conversion and verification to ANSI SQL.

In addition, the O2 2.0 version provides a function that converts SQL written by developers familiar with the Oracle environment using Oracle functions into ANSI standard SQL suitable for open source DB in real time, thereby increasing development productivity.

O2 is a solution that automatically performs everything from SQL conversion to SQL execution values and performance verification without human intervention when converting an Oracle DB to an open source DB.

When converting Oracle DB to open source DB, it drastically shortens the DB conversion period, reduces costs, and automatically supports verification of SQL quality and performance stabilization. Its main functions are ▲Automatically converting Oracle SQL to open source DB SQL ▲Checking the quality and execution errors of converted SQL ▲Comparing/verifying the number and result values with AS-IS (Oracle) for the execution results of converted SQL ▲Comparing/analyzing the performance change differences with AS-IS (Oracle) for the execution performance of converted SQL ▲Optimal index guide through SQL analysis, etc.

Openmade Consulting announced that it will continue research and development for 100% perfect SQL conversion through the application of AI.

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

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

#Database #DB #Oracle #SQL #OpenPOPOTO #OTO #SQLAutomaticConversion #AI #opensource #opensource #opensourceconversion #postgresql #openpop #openmadeconsulting #openmade