FLOW STATE TOTALS AND AUTO FLOW WAREHOUSING

摘要

A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

主权项

1. A method of interactively displaying statuses in a workflow, the method comprising:
identifying, from a database, the set of statuses in the workflow;
determining, from the database, for each particular status of the statuses, a first quantity of objects possessing the particular status at a first point in time;rendering a graphical element for each particular status of the statuses, each graphical element containing an indication of the first quantity of objects for that particular status;receiving user input;in response to receiving the user input, determining, from the database, for each particular status of the statuses, a second quantity of items possessing the particular status at a second point in time; andadjusting the graphical element for each particular status of the statuses to cause each graphical element to indicate the second quantity of objects possessing the particular status.