Dynamic Report Generation Using Agnostic JSON Conversion
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for data report generation in businesses are inefficient, requiring manual collection and processing of vast amounts of data, which is time-consuming and labor-intensive.
Innovation Solution
A method and system for dynamic report generation using a unique query language to retrieve data from external data stores, converting queries to an agnostic JSON language, and generating reports with runtime parameters, thereby automating data collection and processing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual data collection and processing methods are used, then data can be retrieved from external sources, but the process is extremely time-consuming and labor-intensive
Solution Approach 1:
The patent replaces manual mechanical data collection processes with an automated computer system that uses query language to retrieve data from external data stores. The system automatically executes queries, retrieves data, converts it to JSON format, and generates reports without manual intervention, thereby eliminating the time-consuming manual copying and processing steps described in the background.
Solution Approach 2:
The system enables self-service report generation where the automated system performs data collection, conversion, and report generation tasks that would otherwise require manual consultant intervention. The query language and automated processing allow the system to serve itself by automatically retrieving and processing data from external sources without requiring manual data collection and processing by consultants or employees.
2Productivity
If automated query-based data retrieval is implemented, then data collection becomes efficient, but system complexity increases due to query language conversion and data processing requirements
Solution Approach 1:
The patent introduces an intermediary JSON (JavaScript Object Notation) language as a universal intermediary format between the query language and external data stores, and between the retrieved data and the final report. This intermediary layer simplifies the system architecture by providing a standardized interface for data exchange, making the complex query conversion and data processing more manageable through a common communication protocol.
Solution Approach 2:
The system employs a universal query language that can interface with multiple different external data stores through standardized protocols. The automated system handles multiple functions including query execution, data retrieval from various sources, data conversion to JSON format, and report generation, thereby managing system complexity through a multi-functional unified approach rather than separate specialized components.
Data Source
AI summary
A method, system, and computer program product for dynamic report generation may include a computing device generating a report template including one or more queries that define calls to an external data store. The computing device stores the report template in a report template repository and generates a new report that includes one or more runtime parameters for each of the one or more queries of the report template. The computing device generates the new report by converting the one or more queries of the new report to an agnostic JSON language and retrieves data from an external data store identified in each of the one or more queries and converting the retrieved data to the agnostic JSON language.


