Tool to chart resource utilization

Hi fellow Informixers, I'm looking for a tool that can produce a graphical chart of resource utilization and also provide help in analysing utilization data. The resources (which could be anything from rental cars, hotel rooms or, in our case, e.g. operating rooms) are described in one table, e.g. CREATE TABLE resource (res_nr SERIAL, res_description CHAR(80)); while utilization is stored in another table, e.g. CREATE TABLE utilization (res_nr INTEGER, from_date DATETIME YEAR TO MINUTE, to_date DATETIME YEAR TO MINUTE); Of course this is a very crude simplification, but you should get the picture. Now I need a tool (or tools) that, based on these Informix tables, can help me with the following tasks: - Produce a graphical chart or plot of utilization over time; - Retrieve information like "which is the next resource that will become available for a duration of two hours" - produce statistical analysis of resource utilization Since this is IMHO a pretty common task, I'm sure there must be software out there for it, so I don't have to re-invent the wheel. I don't need a complete resource administration package, the data are input from other sources. I've been given the assignment to analyze them and extract information for presentation to higher powers. Thanks for any input, Richard -- +--------------------------+------------------------------------------+ | Dr. med Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+