The requirement was to be able to show the process flow between units in a particular oil refinery with relationships representing the refined output from one processing unit and the input into another. The idea is to build out quite detailed maps of the process flows within refineries and then use this with other 3rd party outage data to predict the affect on production and thus ultimately the change in price of crude and refined oil products.
The POC was quite simple, as you can see from the screenshot below, and was really just put together to show off what could be done with a graphing tool. The refinery units and relationships are pulled from the DB and, at the point a graph is saved, all the positional and sizing data is saved as well. It would need a lot of work to get it up to scratch but it was just starting point to illicit further ideas from the client.
|Oracle Apex with MXGraph|