Reporting Engine Framework for Dynamic Query Generation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current reporting systems for generating database queries are hindered by high upfront infrastructure and software licensing costs, steep learning curves, vendor dependence, and the need for technical expertise, making it difficult for general end users to analyze and interpret data effectively.

Innovation Solution

A reporting engine framework that dynamically generates database queries through a user-friendly interface, utilizing multiple APIs to retrieve filters, operators, and unique values, allowing end users to create queries without prior SQL knowledge or understanding of database architecture, and can be deployed as a vendor-agnostic web service, reducing dependencies on specific products and infrastructure.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If vendor products (e.g., IBM Cognos BI, SAP Crystal Reports) are used for data analysis, then reporting functionality is provided, but upfront infrastructure costs and software licensing costs increase

Engineering Contradiction:

Improvereporting functionalityVSAvoidinfrastructure costs and software licensing costs

Core Design Contradiction:

ReliabilityVSQuantity of substance

Solution Approach 1:

The patent replaces expensive vendor reporting products with a free, open-source reporting engine (e.g., JasperReports), eliminating software licensing costs. The solution uses readily available infrastructure components rather than proprietary systems, achieving the same reporting functionality without the associated costs.

Inventive Principle:

Principle #27Cheap short-living objects (Disposable)

2Reliability

If vendor products are used for data analysis, then reporting capability is provided, but complex initial setup and vendor-dependence increase

Engineering Contradiction:

Improvereporting capabilityVSAvoidinitial setup complexity and vendor-dependence

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent implements a self-service reporting system where end users can independently create, modify, and execute reports without requiring vendor support or complex administrative setup. The system provides built-in tools for query generation, report design, and execution, eliminating vendor-dependence for enhancements and bug fixes.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The reporting system is segmented into independent, modular components including query generation, report design, data rendering, and user interface layers. This modular architecture simplifies setup and maintenance, allowing each component to be configured and managed independently without affecting the entire system.

Inventive Principle:

Principle #1Segmentation

3Adaptability or versatility

If in-house reporting product is developed, then customization capability is provided, but user experience and backend developers along with continuous maintenance effort increase

Engineering Contradiction:

Improvecustomization capabilityVSAvoiddevelopment and maintenance effort

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent employs a universal reporting engine that handles multiple reporting scenarios and data sources through a single platform. The system provides built-in customization capabilities for query generation, report formatting, and data visualization without requiring separate development efforts for different reporting needs, eliminating the requirement for dedicated user experience and backend developers.

Inventive Principle:

Principle #6Universality (Multi-functionality)

4Reliability

If traditional reporting systems are used, then data analysis is provided, but steep learning curve for end users increases

Engineering Contradiction:

Improvedata analysis capabilityVSAvoidlearning curve

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The patent introduces an intelligent query generation intermediary that translates simple user selections into complex database queries automatically. End users interact with a simplified interface that presents pre-defined query templates and parameters, eliminating the need to learn SQL or database architecture while still enabling sophisticated data analysis capabilities.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system replaces the mechanical process of manual query writing and report configuration with automated query generation and intelligent report assembly. The reporting engine automatically generates queries based on user selections and assembles reports without requiring users to manually code or configure complex parameters, dramatically reducing the learning curve.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS11709842B2System and method for implementing a reporting engine framework

Publication Date: 2023.07.25 JPMORGAN CHASE BANK NA

AI summary

Embodiments disclosed herein provide for systems and methods of a reporting engine framework that dynamically generates a database query. The systems and methods provide for generating the database query via an intuitive user interface, wherein the user interface interacts with a plurality of application program interfaces to retrieve and generate data associated with the database to be queried.