Stripping Unused Data References from Business Intelligence Reports
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Business Intelligence reports often become large and computationally intensive due to unnecessary data object references, increasing the complexity and time required for data retrieval and management.
Innovation Solution
A method to identify and remove unused data object references from reports by tracing data lineage, generating a subset of references to only the data objects needed for report generation, thereby reducing the report size and complexity.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If all data object references are retained in Business Intelligence reports, then the reports maintain complete data coverage and versatility, but the report size and computational complexity increase significantly
Solution Approach 1:
The patent extracts and removes unused data object references from Business Intelligence reports while retaining only the references necessary for report generation. This extraction process reduces report complexity and size without compromising the reports' ability to generate required results, directly resolving the contradiction between complete data coverage and report complexity.
2Adaptability or versatility
If all data object references are retained in Business Intelligence reports, then the reports maintain complete data coverage, but the time required for data retrieval and report refresh increases
Solution Approach 1:
The patent removes unnecessary data object references from reports, extracting only the essential references needed for report generation. This reduction in the number of references directly decreases the time required for data retrieval and report refresh operations while preserving complete data coverage for the required report outputs.
3Device complexity
If unused data object references are removed from reports, then the report size and complexity are reduced, but the risk of removing potentially needed references increases
Solution Approach 1:
The patent performs preliminary analysis of data lineage and usage patterns before removing references. By tracing which data objects are actually used in report generation and which are unused, the system makes informed decisions about removal, ensuring that only truly unnecessary references are eliminated. This preliminary action preserves data integrity while achieving complexity reduction.
Data Source
AI summary
A computer readable storage medium comprises executable instructions to provide a first report defining a plurality of references to a plurality of data objects. The plurality of references to the plurality of data objects is analyzed to identify references to unused data objects. The references to the unused data objects are removed from the plurality of references to generate a subset of references to a subset of data objects. A second report defining the subset of references to the subset of data objects is generated.