System and method of workflow database creation and interaction
View Patent ↗A system and method of generating a workflow database creation and interaction schema from a graphical user interface used to create a form. The embodiments discloses the system that utilizes a drag and drop application that allows for configuration of a plurality of forms. These forms can then be placed in a graphical flow that will dictate the order of the forms. Through its graphical user interface, the system is able to gather information on field structure, flow among form elements, element identification, among other embodiments. This information allows the system to automate the creation of the database schema without user intervention.
1. A method for information storage in a database through analysis of a transactional workflow on a graphical user interface, said method comprising:
using at least two sensors;
using at least one processor, each said sensor connected to at least one said processor;
accessing at least one database;
providing
an application interface to said sensors that provides a graphical
representation of said transactional workflow, wherein said application interface contains a canvas graphical representation where one or more specific functionality icons are placed on said canvas, with each said specific functionality icon representing a
configuration interface that generates a configuration for said icon, where one of said functionality icons contains the configuration for a specific sensor, wherein said specific sensors are configured to track a specific event that is interlinked by one or more program execution links;
wherein said canvas is divided into columns and rows representing a respective grid location execution slot identified by the grid location where said slot is placed in said canvas, and where said specific functionality icons representing a configuration interface of a data operation and information acquisition from one said sensor are interlinked by one or more of said program execution links across said grid locations on said canvas;
wherein a track event option uses the sensors to track an event linked to a synchronization option and starts or ends a process given a particular sensor's trigger, creating a dependency between different operators;
analyzing said transactional workflow so as to insert data on the database tables based on the properties of each of the operators in the workflow as a function of said program execution dependency between sensor triggers in said configuration interface;
analyzing said transactional workflow to determine when each said specific functionality icon placed within a grid location execution slot on said canvas has a predecessor operator; and
adding a foreign key attribute to the workflow table column based on said dependency of the triggers in said sensor functionality icon configuration interface of the grid location where any said dependency is found.
2. The method of claim 1 wherein:
said sensors are comprised of one or more of the following types of sensors:
visual or thermal cameras, sound, temperature, moisture, motion, interrupters or similar; and
said transactional workflow is analyzed to determine when each said specific functionality icon placed within a grid location execution slot on said canvas has a dependency across grid locations; and
the data is inserted on the database tables when there are no said dependencies.
3. The method of claim 2 wherein:
said transactional workflow is analyzed to determine when each said specific functionality icon placed within a grid location execution slot on said canvas has a row codependency from a previously created operator along said column; and
said analysis inserts the data on the database tables with the operator attributes and a corresponding foreign key column from a previously created table when the operator is found to be dependent on the database table created for the previous row operator.
4. The method of claim 2 wherein:
said transactional workflow is analyzed to determine when each said specific functionality icon placed within a grid location execution slot on said canvas has a dependency across grid locations; and
the data is inserted into the data tables within said databases with the appropriate dependency as well as any applicable foreign key columns.
5. The method of claim 4 wherein:
said transactional workflow is analyzed to determine when each said specific functionality icon placed within an execution slot on said canvas has a columnar codependency from a previously created operator along said column; and
said analysis inserts the data on the database tables with the operator attributes and corresponding foreign key column from a previously created workflow table operation when the operator is found to be dependent on the database table created for the previous operator.
6. A non-transitory computer-readable medium embodying a program executable by at least one computing device, the program when executed causing said at least one computing device to do the following:
using at least two sensors;
using at least one processor, each said sensor connected to at least one said processor;
accessing at least one database;
providing an application interface to said sensors that provides a graphical representation of said transactional workflow, wherein said application interface contains a canvas graphical representation where one or more specific functionality icons are placed on said canvas, with each said specific functionality icon representing a configuration interface that generates a configuration for said icon, where one of said functionality icons contains the configuration for a specific sensor, wherein said specific sensors are configured to track a specific event that is interlinked by one or more program execution links;
wherein said canvas is divided into columns and rows representing a respective grid location execution slot identified by the grid location where said slot is placed in said canvas, and where said specific functionality icons representing a configuration interface of a data operation and information acquisition from one said sensor are interlinked by one or more of said program execution links across said grid locations on said canvas;
wherein a track event option uses the sensors to track an event linked to a synchronization option and starts or ends a process given a particular sensor's trigger, creating a dependency between different operators;
analyzing said transactional workflow so as to insert data on the database tables based on the properties of each of the operators in the workflow as a function of said program execution dependency between sensor triggers in said configuration interface;
analyzing said transactional workflow to determine when each said specific functionality icon placed within a grid location execution slot on said canvas has a predecessor operator; and
adding a foreign key attribute to the workflow table column based on said dependency of the triggers in said sensor functionality icon configuration interface of the grid location where any said dependency is found.