Prerequisite Application Program Dependency Resolution

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Manually determining and sorting prerequisite application programs for software updates is time-consuming, inefficient, and prone to errors due to the large number of required patches and potential duplicates.

Innovation Solution

A computer-implemented method and system that automatically determines and sorts prerequisite application programs using a hierarchical tree structure, removes duplicates, and downloads them in the correct order for installation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If manually traversing prerequisite application programs to ascertain which files are needed, then the user can identify required files, but the process becomes extremely time consuming and inefficient

Engineering Contradiction:
Improveidentification of required filesVSAvoidtime required for manual traversal
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The system automatically traverses the hierarchical prerequisite tree, queries the database for required files, and generates the installation list without requiring manual user intervention. The computer system performs the complex traversal and file identification tasks autonomously, transforming a manual process into an automated one.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces manual mechanical processes (user traversing, reading, and compiling prerequisite lists) with automated computer-based processes. The system uses database queries, automated tree traversal algorithms, and programmatic file generation to substitute for manual user operations, significantly reducing time and effort.

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

2Reliability

If manually removing duplicate prerequisites at different levels of prerequisite set, then the user can eliminate duplicates, but the process is inefficient and susceptible to human error

Engineering Contradiction:
Improveaccuracy of duplicate removalVSAvoidtime required for manual duplicate removal
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system automatically detects and removes duplicate prerequisites by querying the database and comparing prerequisite entries across different levels of the hierarchical tree. The computer system autonomously identifies duplicates and generates a deduplicated installation list, eliminating manual intervention and associated errors.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces manual duplicate detection with automated database querying and programmatic comparison. The system uses SQL queries to retrieve prerequisite information and automated logic to identify and remove duplicates, substituting manual inspection with computer-based processing that is both faster and more reliable.

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

3Reliability

If manually sorting the large number of prerequisite application programs into the correct application order, then the user can ensure proper installation sequence, but the process is uneconomical and prone to mistakes

Engineering Contradiction:
Improvecorrectness of installation orderVSAvoidtime required for manual sorting
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system automatically determines the correct installation order by traversing the hierarchical prerequisite tree and querying the database for dependency relationships. The computer system generates the installation list in the proper sequence without manual intervention, ensuring correctness while eliminating the time-consuming manual sorting process.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces manual sorting with automated database-based ordering. The system uses SQL queries to retrieve prerequisite information and automated algorithms to sort files according to their dependency relationships, substituting manual sequencing with computer-based processing that guarantees correct installation order.

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

4Ease of operation

If downloading all prerequisite application programs manually, then the user can install the requested software, but the process becomes complex and error-prone due to the large number of files

Engineering Contradiction:
Improvesimplicity of installation processVSAvoidcomplexity of prerequisite management
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The system automatically manages the entire prerequisite download process by querying the database, traversing the hierarchical tree, and generating a comprehensive installation list. The computer system handles all complexity autonomously, presenting the user with a simple single-action process while managing the underlying complexity of numerous prerequisite files.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces manual prerequisite management with automated computer-based processing. The system uses database queries, automated tree traversal, and programmatic file generation to substitute for manual handling of numerous prerequisite files, significantly simplifying the user experience while managing system complexity.

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

Data Source

PatentUS8209679B2Computer implemented method and system for processing a client request for an application program
Publication Date: 2012.06.26 ORACLE INT CORP
  • US8209679B2 patent drawing
  • US8209679B2 patent drawing
  • US8209679B2 patent drawing

AI summary

A computer implemented method and system for processing a client request for an application program. The application program may require one or more software applications as prerequisites. In response to a client request for the application program, the system automatically determines prerequisite application programs associated with the requested application program. The prerequisite applications include a first set of direct prerequisite application programs and a second set of indirect prerequisite application programs. The method includes checking whether the second set contains a duplicate prerequisite application program that corresponds to an original prerequisite application program existing in the first set, and removing the original prerequisite application program from the first set automatically if the second set contains the duplicate prerequisite application program. Further, the method includes saving non-duplicated prerequisite programs of the first set. The pruned set of prerequisite programs and the requested program may be downloaded to the client.