Asynchronous Testing Platform for Online Services Database
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems face challenges in testing applications that are occasionally connected to an online services system, particularly due to security risks associated with installing third-party software at multi-tenant database servers and insufficient testing platforms for asynchronous operation calls.
Innovation Solution
The development of methods and systems for asynchronous testing of applications, which involve retrieving metadata from an online services database, authorizing replication, making asynchronous operation calls, and recording execution latency to simulate and test the performance of applications connected to an online services system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If third-party data management software is installed at the database server for testing, then testing capability is improved, but security risks increase
Solution Approach 1:
The patent introduces a testing platform that acts as an intermediary between the third-party software and the multi-tenant database server. This platform provides the necessary testing capabilities while isolating the database server from direct exposure to third-party software, thereby maintaining security. The platform includes components such as a testing application server, database, and interface that enable comprehensive testing without requiring software installation at the server level.
2Adaptability or versatility
If asynchronous operation calls are made to the database, then application functionality is improved, but testing complexity increases
Solution Approach 1:
The testing platform performs preliminary actions by pre-configuring test scenarios, data, and expectations before executing asynchronous operation calls. The system prepares test cases that specifically address asynchronous operations, including setting up appropriate data states, defining expected outcomes, and configuring timing parameters. This preliminary preparation simplifies the actual testing process by having all necessary components ready before the complex asynchronous operations are initiated.
Solution Approach 2:
The patent implements comprehensive feedback mechanisms that automatically capture, analyze, and report results from asynchronous operation calls. The testing platform monitors the execution of asynchronous operations, tracks their status, and compares actual outcomes against expected results. This automated feedback loop reduces testing complexity by eliminating manual verification steps and providing clear pass/fail indicators for each test case.
3Measurement precision
If execution latency is simulated to test performance, then performance testing accuracy is improved, but testing time increases
Solution Approach 1:
The testing platform employs parameter changes by allowing dynamic adjustment of latency simulation values without requiring actual time delays. Instead of waiting for extended periods to simulate various performance scenarios, the system modifies timing parameters programmatically to represent different latency conditions. This enables comprehensive performance testing across multiple scenarios in a fraction of the time it would take to actually wait for each scenario to unfold in real-time.
Data Source
AI summary
In a method, system, and computer-readable medium having instructions for performing asynchronous testing of an application that is occasionally connected to an online services system, metadata describing at least a portion of an online services database is retrieved and the at least a portion of the online services database is authorized for replication at a software application, information is determined for an entity for an application database from the metadata, a request is sent for a database using the software application interface and the request has an asynchronous operation call to the database for the entity, an execution of the asynchronous operation call is recorded within a callback function, a response is received for the asynchronous operation call, and a result is determined for the software application performance.


