Workflow Coordinator for Automated Data Table Generation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems lack efficient methods for automatically generating attribute tables and workflows for aggregating customer profile data during business plan approval processes, leading to inefficiencies in data organization and decision-making.
Innovation Solution
The system automates the generation of attribute tables and workflows by using a computer-assisted retrieval engine to create database tables that hold newly created attributions, allowing for real-time data aggregation and reducing manual intervention, while also ensuring that workflows are managed to prevent process overlap and failures.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If manual methods are used to create attribute tables and workflows, then data organization can be customized, but the process is time-consuming and requires significant manual intervention
Solution Approach 1:
The system enables self-service by allowing business users to automatically generate attribute tables and workflows through automated processes. The workflow coordinator automatically creates data tables, defines attributes, and establishes workflows without requiring manual intervention from database administrators or developers, thus resolving the contradiction between ease of creation and time consumption.
Solution Approach 2:
The system performs preliminary actions by pre-defining templates and structures for attribute tables and workflows. When a business user requests data organization, the system has already prepared the necessary frameworks and can quickly instantiate them with minimal customization, reducing both the effort required and the time needed for data organization tasks.
2Productivity
If automated workflows are implemented, then development time is reduced, but system complexity increases
Solution Approach 1:
The workflow coordinator acts as an intermediary between business users and the complex database systems. It translates simple user requests into complex automated workflow operations, shielding users from system complexity while enabling high productivity. The coordinator manages the complexity of workflow generation, attribute table creation, and process coordination internally, presenting a simplified interface to users.
3Productivity
If multiple workflows can run simultaneously, then processing capacity increases, but the risk of process overlap and failures increases
Solution Approach 1:
The workflow coordinator implements feedback mechanisms to monitor the status of running workflows and dynamically adjust system behavior. When detecting that a workflow is already executing, the coordinator receives feedback about the current process state and responds by preventing overlapping workflows or coordinating their execution, thus maintaining both high processing capacity and process reliability through real-time status monitoring and adaptive control.
Data Source
AI summary
The present disclosure extends to methods, systems, and computer program products for approving proposed business plans and automatically generating and coordinating workflow for establishing data tables for aggregating customer profiles data. The disclosure also extends to methods, systems and computer products for scheduling processes within workflows and checking the status of the workflows.