Virtual Database System Redirecting Test Commands
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database performance testing is costly and resource-intensive due to the need for replicating production-level databases, which can be impractical, time-consuming, and risky, especially when changes occur frequently, potentially causing errors or rendering the production database unusable.
Innovation Solution
A virtual database system is used to redirect test commands from a database management system to a backup database, allowing for equivalent production-level testing without interfering with the production database, enabling on-demand performance testing and reducing resource overhead by maintaining synchronization with the production database.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If a production-level database is replicated for testing, then testing accuracy is improved, but resource consumption and time required increase significantly
Solution Approach 1:
The patent creates a virtual database that is a simplified copy of the production database, containing only the necessary structure and data for testing purposes. This virtual copy allows accurate performance testing while consuming significantly fewer resources than a full production replica, directly resolving the contradiction between testing accuracy and resource consumption.
Solution Approach 2:
The patent segments the production database into a virtual database by extracting and isolating only the essential components needed for testing. This segmentation allows the testing system to use a reduced subset of the production database structure, maintaining testing validity while reducing resource requirements.
2Adaptability or versatility
If the production database is modified for testing, then testing capability is improved, but system stability and reliability deteriorate
Solution Approach 1:
The patent separates the production database from the testing environment by creating an independent virtual database. This segmentation allows testing modifications to be applied to the virtual database without affecting the production database, thereby maintaining system stability and reliability while enabling full testing capability.
Solution Approach 2:
The virtual database acts as an intermediary between the production database and the testing system. It receives test commands and provides test results without exposing the production database to testing operations, thus protecting system stability while enabling comprehensive testing.
3Productivity
If comprehensive performance testing is conducted on production database, then testing thoroughness is improved, but operational time and productivity are reduced
Solution Approach 1:
The patent creates a virtual database copy that can be used for comprehensive performance testing without interrupting production operations. This virtual copy enables thorough testing while the production database continues to operate normally, eliminating the time loss that would occur with in-place testing.
Solution Approach 2:
The virtual database is prepared in advance as a standalone testing environment, allowing comprehensive performance testing to be conducted before production changes are implemented. This preliminary testing action ensures thoroughness while avoiding operational interruptions.
4Measurement precision
If a full production database replica is maintained for testing, then test result accuracy is improved, but device complexity and setup requirements increase
Solution Approach 1:
The patent uses a virtual database that replicates the essential structure and functionality of the production database without requiring a complete physical replica. This virtual copy maintains test result accuracy while significantly reducing the complexity of setup and maintenance requirements.
Solution Approach 2:
The patent modifies the database replication parameters to create a virtual database with optimized characteristics for testing. By adjusting parameters such as data volume, structure complexity, and resource allocation, the system achieves accurate test results with reduced setup complexity.
Data Source
AI summary
A database performance testing system and non-transitory, computer readable medium utilizes a virtual database system to test a production-level database without interfering with operations of the production-level database by redirecting test commands to a backup database. By incorporating the virtual database system into a production-level database test, the database performance testing system and non-transitory, computer readable medium is able to overcome technical and resource obstacles of testing against a production-level database. The database performance testing system also includes a database management system that issues a test command to a production-level database. However, the virtual database system intercepts the test command and redirects the test command to a backup database, which is an equivalent of the production-level database. The test results returned by the backup database are the same results that would result from the production-level database without interfering with operations of the production-level database.