Report Preview Caching in Multi-Tenant Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users interacting with multi-tenant databases face ambiguity when computational resources become unavailable, leading to a perception of either temporary or permanent unresponsiveness, as existing techniques fail to provide a clear real-time experience during computationally intensive tasks.
Innovation Solution
The system pre-fetches a subset of data and emulates a result set based on a report definition, generating perceivable stimuli on the user's computer system to provide a real-time processing experience, while allowing the multi-tenant architecture flexibility in processing data and minimizing user awareness of non-real-time processing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If the system processes computationally intensive tasks in real-time, then the user experiences immediate results, but the computational resources become unavailable and the system appears unresponsive
Solution Approach 1:
The system performs preliminary actions by pre-fetching data subsets and generating emulated results before the user actually needs them. When a user requests a report, the system has already prepared approximate results in the background, allowing immediate display while full processing continues asynchronously. This resolves the contradiction by preparing responses in advance without blocking resource availability.
Solution Approach 2:
The patent introduces an intermediary mechanism - the emulated result set - that mediates between the user's need for immediate response and the system's need to process computationally intensive tasks. The emulated results serve as a placeholder that satisfies user expectations while the actual full processing occurs in the background, maintaining system availability.
2Measurement precision
If the system provides accurate real-time processing results, then the user receives precise information, but the processing time increases and user perception of latency worsens
Solution Approach 1:
The system applies partial action by processing only a subset of data initially to generate emulated results quickly, rather than processing the complete dataset. This partial processing provides sufficiently accurate results for immediate user review, while the remaining processing occurs in the background. The principle resolves the contradiction by delivering acceptable accuracy without the full time cost of complete processing.
Solution Approach 2:
The patent segments the data processing into multiple parts: an initial fast subset processing that generates emulated results, and subsequent background processing of the complete dataset. This segmentation allows the system to provide quick initial responses while continuing accurate full processing, resolving the tension between speed and accuracy.
3Productivity
If the system allows flexible data processing by the multi-tenant architecture, then resource management efficiency improves, but the user experience of real-time processing deteriorates
Solution Approach 1:
The system creates copies of data subsets and emulated results that can be immediately displayed to users without interfering with the original data processing operations. Multiple users can simultaneously access copied results while the system continues flexible resource management and background processing, resolving the contradiction between resource efficiency and user experience.
Data Source
AI summary
The present invention is directed to methods and systems for rendering perceivable stimuli representative of information processing by a multi-tenant architecture that pre-fetches a portion of a subset of data on a multi-tenant architecture and emulates a result set of data in accordance with a report definition. To that end the method comprises identifying a subset of data on the multi-tenant architecture that is subject to a report definition. A portion of the subset is pre-fetched and analyzed to emulate a result. The emulated result is transmitted to a computer system of a user of the multi-tenant architecture. Perceivable stimuli is generated on the user computer system, in response to receiving the emulated result. In this manner, a user may have the perception of real-time processing of information in accordance with the report definition white affording the owner of the multi-tenant architecture flexibility to processes the data as desired while minimizing the user's awareness that real-time processing is not occurring.