Solution
"Switching to Open Source DB" No more worries
Openpop OTO will lighten the burden of your worries.
ORACLE to 오픈소스 DB 전환지원 솔루션
오픈소스 DB로 전환을 고민하는 당신께
oTo는 O2 같은 존재가 되어줄 것입니다.
"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
STRENGTHS
oTo operating environment
OpenPOP O2's automation features are:
For customers considering switching to open source DB
I will be like a ray of light and oxygen to you.
OTO
01
SQL Conversion
Oracle SQL to Open Source DB SQL
It automatically converts and partially converts SQL Text.
Through mapping rules when conversion is required
Supports batch conversion.
02
Automatic verification of conversion results
Error checking and conversion SQL
AS-IS/Execution results (number/value)
TO-BE comparison/verification.
03
Performance Optimization
AS-IS/Execution performance of converted SQL
TO-BE comparison/verification,
Through the index optimization guide
Supports performance improvement of DB/SQL.
04
BMT Support (Additional Service)
Tailored to customer needs
The best open source DB
Open source DBs to choose from
Supports BMT.
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 completeness
Complete conversion to open source DB SQL
Wouldn't it take a lot of manpower and time?
SQL 변환 및 오류 점검
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
The execution result of the converted SQL
How do I verify that it is identical to 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
변환 완전성
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.).
결과 무결성
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 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
oTo의 강력한 엔진과 다양한 기능들은, 오픈소스 DB로의 전환을 신속하고 안정감있게 수행될 수 있도록 지원합니다.
