Dynamic Report Generation Using Agnostic JSON Conversion

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

VSEngineering 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

Engineering Contradiction:
Improvereport generation efficiencyVSAvoidtime required for data collection and processing
Core Design Contradiction:
ProductivityVSLoss of time

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.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

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.

Inventive Principle:
Principle #25Self-service

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

Engineering Contradiction:
Improvedata collection efficiencyVSAvoidsystem complexity for query conversion and data processing
Core Design Contradiction:
ProductivityVSDevice complexity

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

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.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS12135934B2Methods and systems for dynamic report generation
Publication Date: 2024.11.05 KOHLBERG KRAVIS ROBERTS & CO LP
  • US12135934B2 patent drawing
  • US12135934B2 patent drawing
  • US12135934B2 patent drawing

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.