Online Services Report Generation Using Pre-computed Aggregates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Generating reports in conventional database systems is time-consuming and costly due to the need for continual updating of data from various sources, which can lead to outdated information.
Innovation Solution
A method for generating reports in an online services system that involves receiving a list of target data, generating fields, populating them with composite information, and fetching the target data in real-time from internal and external sources using composition information, allowing for up-to-date reports without periodic updates.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If data is continually updated from various sources to maintain freshness, then report accuracy is improved, but time consumption and cost increase
Solution Approach 1:
The patent pre-computes and stores aggregate data and metadata about data sources in a centralized database. When a report is requested, the system retrieves pre-computed aggregates and combines them with current data from sources, rather than re-querying all sources from scratch. This preliminary preparation significantly reduces report generation time while maintaining accuracy.
Solution Approach 2:
The patent creates a centralized database that copies and stores aggregate information from multiple data sources. Instead of continuously connecting to and querying all original sources, the system works with copies of aggregated data that are updated periodically or on-demand, reducing the time and resources required for report generation.
2Measurement precision
If data is continually updated from various sources to maintain freshness, then report accuracy is improved, but cost increases
Solution Approach 1:
The system pre-computes aggregates and stores them in a centralized database, so when reports are generated, the system retrieves and combines pre-computed data rather than performing expensive real-time queries to all original sources. This preliminary action significantly reduces computational resources and costs.
Solution Approach 2:
The patent creates a centralized database that copies aggregate information from multiple data sources. By working with these copies rather than continuously querying original sources, the system reduces the computational and financial resources required to maintain data freshness and generate accurate reports.
3Measurement precision
If data is fetched in real-time from multiple sources, then report currency is improved, but system complexity increases
Solution Approach 1:
The patent segments the data retrieval process into two parts: (1) pre-computation and storage of aggregates in a centralized database, and (2) on-demand retrieval and combination of these aggregates with current source data. This segmentation simplifies the system by separating the complex task of aggregating data from multiple sources into a manageable process.
Solution Approach 2:
The centralized database acts as an intermediary between the report generation system and the multiple data sources. It stores pre-computed aggregates and metadata, allowing the system to retrieve and combine data without needing to directly manage complex connections to all original sources, thus reducing system complexity.
Data Source
AI summary
A system and method for performing security assessments in an online services system. In one embodiment, the method includes receiving a list of target data for a report; and generating fields in the report. The method also includes populating the fields with composite information; receiving a command to execute the report; fetching the target data using the composite information; and populating the report with the target data.