Database Migration SQL Response Comparison System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database migration technologies face challenges in ensuring that SQL statements operate correctly and efficiently in the environment of a migration destination database system, particularly due to differences in response behavior and speed between source and destination databases.
Innovation Solution
An information processing system that includes a first database in the same environment as the current database and a second database in the same environment as the migration destination database, along with an information processing device that issues test SQLs to both databases, measures execution times, and compares responses to determine if they are identical and if execution times are comparable.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If SQL statement automatic conversion is used for database migration, then migration speed and ease of operation are improved, but response accuracy and reliability deteriorate due to differences in SQL behavior between database systems
Solution Approach 1:
The patent applies preliminary action by executing test SQLs on both the source database and migration destination database before actual migration. This preliminary testing phase identifies SQL statements that produce different responses between databases, allowing corrections to be made in advance and ensuring response accuracy is maintained during migration.
2Reliability
If comprehensive SQL testing is performed in migration destination environment, then response accuracy is improved, but migration time and productivity deteriorate
Solution Approach 1:
The system performs SQL testing as a preliminary action before migration by executing test SQLs on both source and destination databases in advance. This allows identification and correction of problematic SQLs beforehand, so that during actual migration, only corrected SQLs need to be processed, maintaining high migration speed while ensuring response accuracy.
3Reliability
If manual SQL correction is performed for each SQL statement, then response accuracy is improved, but labor time and complexity increase
Solution Approach 1:
The patent implements self-service by automatically executing test SQLs on both databases and comparing their responses to identify discrepancies. The system automatically generates correction instructions for SQL statements that produce different responses, eliminating the need for manual inspection and correction of each SQL statement, thus reducing labor time and process complexity while maintaining response accuracy.
Data Source
AI summary
The present invention checks whether or not SQL works properly in a migration destination environment in a database migration test. The present invention is provided with: an SQL-statement acquisition processing unit that acquires an SQL statement; a first SQL-statement issuance processing unit that issues the acquired SQL statement to a current-environment test database; a second SQL-statement issuance processing unit that similarly issues the acquired SQL statement to a migration destination-environment test database; an SQL-statement forwarding control unit that controls the issuance of the SQL statement; a first response acquisition processing unit that acquires a first response from the current-environment test database; a second response acquisition processing unit that acquires a second response from the migration-destination-environment test database; and a response comparison processing unit that checks whether or not a normal first response and a normal second response have been acquired and that compares the first response and the second response to check whether or not the first response and the second response are the same and whether or not the execution speed of the second response is slower than that of the first response.