Solution
"Switching to Open Source DB" No more worries
OpenPOP oTo will lighten the burden of your worries.
ORACLE to open source DB conversion support solution
Considering a move to an open-source database? OpenPOP oTo will be as vital as O2 to your success
"Transition to open source DB"
You don't have to worry anymore
The weight of the worries is taken care of by Open Pop OTO.
I'll make it easy for you
Reduce the number of people
Automation of the entire conversion process from SQL conversion to DB performance optimization
Automated verification of conversion results
OpenPOP oTo automatically verifies the execution results (number of cases, values) of the converted SQL and the execution performance (AS-IS/TO-BE) without human intervention.
Increase productivity
Through repeated tasks from SQL conversion to verification,
Shortening the period & reducing costs
Short-term conversion and reduction of deployment costs through automation of the entire SQL conversion ~ verification process
STRENGTHS
Oracle DB ▶ Opensource DB
OpenPOP oTo operating environment
OpenPOP oTo's automation features are:
For customers considering switching to open source DB
I will be like a ray of light and oxygen to you.
01
SQL Conversion
t automatically converts Oracle SQL to open-source DB SQL and supports batch conversion through mapping rules when partial changes to the SQL text are required.
02
Automatic verification of conversion results
It checks the converted SQL for errors and then compares/verifies the execution results (row count/values) between the AS-IS and TO-BE environments
03
Performance Optimization
It compares and verifies the execution performance of the converted SQL between the AS-IS and TO-BE environments, and supports DB/SQL performance improvement through an index optimization guide
04
BMT Support (Additional Service)
We support Benchmark Tests (BMT) for open-source databases to help customers select the optimal solution for their needs
PROCESS
OpenPOP oTo provides functions to support each stage of the transition to open source DB through systematic engineering approach and repository-based process automation, and additionally supports differentiated functions to ensure the safety of SQL quality and performance after the transition.
FUNCTION
Oracle DB ▶ Opensource DB
Conversion Integrity
Worried about the time and effort for a complete open-source DB conversion?
SQL conversion and error checking
-
Collect SQL to be converted
-
SQL automatic conversion
-
Bulk modification of SQL Text portion
-
Check for conversion SQL execution errors
-
Provides a list of SQL execution errors
Results Integrity
How can I verify that the execution result of the converted SQL is the same as AS-IS?
Verify conversion SQL results (number/values)
-
Automatically execute converted SQL
-
Verification of the number of execution results
-
Verify execution result values
Performance Stability
What if performance degrades after SQL conversion?
Is it possible to compare AS-IS/TO-BE SQL performance?
Transform SQL performance verification and optimization
-
Transform SQL Performance Verification
-
AS-IS/TO-BE SQL Execution Time Comparison
-
AS-IS/TO-BE SQL Processing Block Comparison
-
Index Optimization Guide
-
SQL Tuning Process/Performance Management
Conversion completeness
SQL conversion and error checking
After collecting and preparing the target SQL for conversion (XML File, execution SQL) and performing automatic conversion, the results and status are provided.
Automatically checks for execution errors in converted SQL and provides a list of SQL that has errors.
It also supports partial conversion (text conversion) of SQL that needs to be modified due to TO-BE requirements (standardization, architecture changes, etc.).
Results Integrity
Verify the converted SQL results (number/values)
With the same test DB environment set up, the number of processed transactions and the difference in result values between the two DBs are analyzed and compared through automatic execution of all (batch) conversion SQLs.
When performing automatic execution, you can select various execution options, and the results can be verified in a very short time through OpenPOP oTo's powerful engine.
The validation result of the converted SQL provides a function to repeatedly re-validate the SQL that has errors through correction.
Performance Stability
Transform SQL Performance Verification and Optimization
By setting up the same test DB environment, the difference in execution performance for the same SQL between the two DBs is analyzed and compared through automatic execution of all (batch) converted SQLs.
When verifying the execution performance of converted SQL, you can select various options for the execution environment and check the performance comparison results in a short time.
If performance improvement is required due to poor performance of transformed SQL, we provide a function to enable repeated performance re-verification through SQL tuning.
In addition, it guides you to the optimal index through a full analysis of SQL, and when reflecting the guide index, you can check the performance changes for each SQL before and after reflection.
PRODUCTIVITY
OpenPOP oTo's powerful engine and various functions support the transition to open source DB quickly and reliably.
