Automated Application Interface for Data Analysis

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data analysis software users face time-consuming processes when generating reports from databases, requiring manual operations across multiple software applications, and programming expertise is often necessary for automation, especially for periodic reports.

Innovation Solution

An automated application interface system using wizards to capture user input and generate template data stores, which can be executed in a specific sequence to perform software interface and data analysis operations, reducing the need for manual intervention and programming knowledge.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual operations are performed to generate reports from database software using data analysis software, then the user can complete the report generation process, but the process is time-consuming and requires significant user effort

Engineering Contradiction:
Improvereport generation speedVSAvoidtime required for manual operations
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by capturing user input through wizards and pre-configuring template data stores that encode the sequence of operations needed for report generation. This allows the system to automatically execute predefined sequences without requiring users to manually perform each step during report generation, thereby reducing time loss while maintaining productivity.

Inventive Principle:
Principle #10Preliminary action

2Extent of automation

If programming is used to automate the report generation process between software applications, then automation is achieved, but significant programming knowledge is required

Engineering Contradiction:
Improveautomation of report generationVSAvoidprogramming knowledge required
Core Design Contradiction:
Extent of automationVSEase of operation

Solution Approach 1:

The patent introduces an intermediary layer consisting of wizards and template data stores that mediate between the user and the complex automation processes. The wizards guide users through configuration without requiring programming knowledge, while the template data stores encapsulate the automation logic. This intermediary approach achieves high automation while maintaining ease of operation by hiding complexity from the user.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent uses copying by creating template data stores that replicate the structure and logic of manual operation sequences. These templates can be copied and reused for multiple report generation tasks, allowing automation to be achieved through simple template instantiation rather than programming each operation from scratch.

Inventive Principle:
Principle #26Copying

3Ease of operation

If wizards are provided to assist with manual operations, then the ease of operation improves, but the process remains time-consuming and requires user intervention

Engineering Contradiction:
Improveuser interface guidanceVSAvoidtime for periodic task execution
Core Design Contradiction:
Ease of operationVSLoss of time

Solution Approach 1:

The patent merges the wizard interface functionality with automated execution capabilities by combining user input capture, template generation, and sequence execution into a unified system. This allows the ease of operation provided by wizards to be combined with automated execution, eliminating the need for repeated user intervention in periodic tasks while maintaining user-friendly configuration.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS8661343B2Computer-implemented systems and methods for an automated application interface
Publication Date: 2014.02.25 SAS INSTITUTE INC
  • US8661343B2 patent drawing
  • US8661343B2 patent drawing
  • US8661343B2 patent drawing

AI summary

In accordance with the teachings described herein, systems and methods are provided for an automated application interface. One or more wizards may be used to receive user input in order to perform one or more software interface operations to manipulate a first set of data between data analysis software and database software. Information associated with the user input may be captured and used to generate one or more template data stores. A user interface may be used to modify at least one template data store to identify a subsequent set of data. The template data stores may be automatically executed in an identified sequence to perform software interface and data analysis operations for the subsequent set of data.