Asynchronous Testing Platform for Online Services Database

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improvetesting capabilityVSAvoidsecurity risks
Core Design Contradiction:
Adaptability or versatilityVSObject-affected harmful factors

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If asynchronous operation calls are made to the database, then application functionality is improved, but testing complexity increases

Engineering Contradiction:
Improveapplication functionalityVSAvoidtesting complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

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.

Inventive Principle:
Principle #10Preliminary action

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.

Inventive Principle:
Principle #23Feedback

3Measurement precision

If execution latency is simulated to test performance, then performance testing accuracy is improved, but testing time increases

Engineering Contradiction:
Improveperformance testing accuracyVSAvoidtesting time
Core Design Contradiction:
Measurement precisionVSLoss of time

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.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS8689052B2Performing asynchronous testing of an application occasionally connected to an online services system
Publication Date: 2014.04.01 SALESFORCE INC
  • US8689052B2 patent drawing
  • US8689052B2 patent drawing
  • US8689052B2 patent drawing

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.