Graphical Transaction Regions for Data Integrity

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current data processing methods lack efficient mechanisms for managing transactional operations, particularly in ensuring data integrity and error handling within complex business processes, leading to potential data loss and system instability.

Innovation Solution

The Microgen Aptitude V3.00 system allows users to define transaction regions within a graphical interface, enabling the selection and arrangement of operation icons to create a process flow, specifying transaction boundary nodes that act as rollback points for error handling, ensuring data integrity and reliability.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If traditional programming languages are used to create complex applications, then data processing functionality can be achieved, but the ease of operation deteriorates due to requiring programming knowledge

Engineering Contradiction:

Improveease of creating complex applicationsVSAvoidcomplexity of programming knowledge required

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The patent replaces traditional programming language syntax (mechanical system) with a graphical user interface consisting of drag-and-drop icons and visual workflow diagrams. This substitution allows users to create complex data processing applications through visual manipulation rather than coding, directly resolving the contradiction by improving ease of operation while eliminating the need for programming knowledge

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The patent uses visual icons that represent programming operations and data flow concepts. These icons serve as graphical copies or representations of traditional programming constructs, allowing users to work with familiar concepts in a simplified visual format rather than text-based code, thereby improving accessibility without sacrificing functional complexity

Inventive Principle:

Principle #26Copying

2Reliability

If transaction processing without rollback points is implemented, then the device complexity is reduced, but the reliability deteriorates due to potential data loss on errors

Engineering Contradiction:

Improvedata integrity in transaction processingVSAvoidcomplexity of transaction management mechanism

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent automatically establishes rollback points at the beginning of transaction regions before any operations are executed. This preliminary action ensures that if an error occurs during transaction processing, the system can revert to the state before the transaction began, guaranteeing data integrity without requiring users to manually configure complex transaction management mechanisms

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system automatically manages transaction boundaries and rollback points without requiring explicit user configuration. The graphical workflow automatically identifies transaction regions and sets up error handling mechanisms, allowing the system to serve itself in managing transaction reliability while keeping the user interface simple and the apparent complexity low

Inventive Principle:

Principle #25Self-service

Data Source

PatentUS8140894B2Transaction regions in graphical computer-implemented methods of processing data

Publication Date: 2012.03.20 APTITUDE SOFTWARE

AI summary

A method including: displaying operation icons representing operations to be performed, a user selecting and arranging the operation icons to define a flow of data between operations and to form a graphical representation of a process, the user specifying an operation icon as a transaction boundary node at the end of a transaction region, and compiling instructions to execute the arranged operations wherein the beginning of a transaction region acts as a roll back point in the event of an error occurring in the transaction region.