Automatic Follow-on Data Set Creation in Networked Databases

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In complex database-related processes, access delays occur when transitioning between processing stages due to the need for dialogue-type communications, which become disruptive as the number of collaborative users and parallel processes increase, hindering smooth transitions and data integrity.

Innovation Solution

A method for automatically creating follow-on data sets by skipping dialogue routines, using user-defined criteria to generate and display lists of data sets that allow for automatic creation, and utilizing control elements to initiate the creation of follow-on data sets based on derived data, ensuring efficient handling and association of data sets across a computer network.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If dialogue-type communications are used to initiate transitions between processing stages, then data integrity is ensured through user input and confirmation, but access delays occur and productivity decreases

Engineering Contradiction:
Improvedata integrityVSAvoidprocessing speed
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The system allows skipping the dialogue routine for automatic creation of follow-on data sets. When the evaluation unit determines that sufficient data is available, the system can automatically create follow-on data sets without requiring interactive user input, thereby reducing access delays while maintaining data integrity through predefined evaluation criteria.

Inventive Principle:
Principle #21Skipping (Rushing through)

Solution Approach 2:

The system enables self-service by automatically evaluating data set requirements and creating follow-on data sets without user intervention. The evaluation unit autonomously determines whether data is sufficient, and the automatic creation mechanism generates follow-on data sets independently, eliminating the need for manual dialogue while ensuring data quality through systematic evaluation.

Inventive Principle:
Principle #25Self-service

2Reliability

If data sets are locked for other users during access, then data integrity is maintained, but access delays occur for collaborative users

Engineering Contradiction:
Improvedata integrityVSAvoidaccess delay
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary evaluation of data sets to determine sufficiency before locking occurs. By pre-assessing whether data meets requirements for follow-on data set creation, the system can prepare and execute automatic creation during brief access windows, reducing the duration of locks and minimizing impact on collaborative users.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system dynamically adjusts the locking mechanism based on data sufficiency evaluation. When data is sufficient, the system can proceed with automatic creation more rapidly; when insufficient, it allows extended access periods for data completion. This dynamic approach optimizes the balance between data integrity and user access efficiency.

Inventive Principle:
Principle #15Dynamics

3Ease of operation

If conventional conflict resolution mechanisms are used, then smooth transitions are achieved in scenarios with few users, but the mechanisms become inadequate as the number of users and parallel processes increases

Engineering Contradiction:
Improvesmooth transitionVSAvoidsystem capacity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The system replaces manual conflict resolution mechanisms with an automated evaluation and creation system. Instead of relying on user dialogue and manual coordination, the evaluation unit automatically assesses data sufficiency and triggers follow-on data set creation, eliminating the need for complex human-mediated conflict resolution even as user numbers increase.

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

Solution Approach 2:

The system changes the operational parameters from interactive dialogue-based transitions to automated evaluation-based transitions. By shifting from a parameter regime requiring user communication to one using systematic data evaluation, the system maintains smooth transitions regardless of the number of concurrent users or processes.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS7693893B2Distributed handling of associated data sets in a computer network
Publication Date: 2010.04.06 SAP SE
  • US7693893B2 patent drawing
  • US7693893B2 patent drawing
  • US7693893B2 patent drawing

AI summary

A networked database includes the automatic creation of follow-on data sets from initial data sets. A dialogue routine is implemented for initiating a dialogue-type communication that includes inputting and confirming data required for creating the follow-on data sets. The database is provided with a plurality of data sets and is capable of generating and displaying a list of data sets according to user-defined criteria. For a data set in the generated list that allows for the automatic creation of a follow-on data set, a related, configurable, user-activated control element is displayed. Upon user-activation, the control element, generates a control signal for initiating the automatic creation of the follow-on data set based on data derived from the selected data set and/or any data set associated with the selected data set. The newly created follow-on data set is then associated with the selected data set.