Automatic Process Flow Rearrangement in Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Complex database systems with numerous process flows face challenges in error detection and efficiency due to complexity, making it difficult for users to visualize and debug process flows, especially with repetitive structures and cyclic dependencies.
Innovation Solution
An automatic rearrangement technique using a modified Depth First Search algorithm that realigns process flows into a logical top-down structure, allowing users to input flows in a freeform style without grid constraints, while addressing cyclic dependencies by tracking traversed nodes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If process flows are illustrated in a complex system with numerous processes, then the database system can represent the complete system, but it becomes extremely difficult for users to detect potential problems due to the complexity of the illustration
Solution Approach 1:
The patent segments the complex process flow illustration into multiple hierarchical levels. The system divides the overall process flow into parent processes and child processes, allowing users to view the system at different levels of detail. This segmentation enables users to focus on specific portions of the process flow without being overwhelmed by the complete system, thereby making problem detection feasible even in systems with numerous processes.
2Ease of operation
If process flows are entered in a freeform or unstructured style, then users can easily input flows without grid constraints, but errors and inconsistencies may be introduced into the process flow
Solution Approach 1:
The system performs preliminary actions by automatically analyzing the freeform process flow input and identifying potential errors, inconsistencies, and inefficiencies before the user finalizes the process flow. The system pre-processes the input data, applies validation rules, and provides feedback to the user about detected issues, allowing corrections to be made before the process flow is committed to the database.
3Adaptability or versatility
If repetitive process flows are present in the system, then the system can represent real-world scenarios, but inefficiencies arise that could be served more efficiently with a single combined process flow structure
Solution Approach 1:
The system automatically detects repetitive process flow patterns and merges them into single parameter definitions. When the same process flow structure is detected multiple times, the system consolidates these into a single parameter that can be reused across multiple instances. This merging reduces redundancy, improves maintenance efficiency, and allows for easier modification of repetitive patterns while preserving the ability to represent real-world scenarios.
Data Source
AI summary
Embodiments regard transfer of data streaming services to provide continuous data flow. An embodiment of an apparatus includes one or more processors to process data for database operation and a database storage, wherein the system is to: receive one or more process flows, each process flow including a plurality of nodes and including one or more flows between each of the plurality of nodes and another node of the plurality of nodes; and upon receipt of a request, automatically rearrange the one or more process flows, including the apparatus to evaluate a first process flow including traversing of each node of the first process flow, and generate a rearranged process flow based on the first process flow, including establishing a level and coordinate position for each node of first process flow, and establishing a logical direction for each flow between the plurality of nodes of the first process flow.