Bristol Water (BW) approached HL to replace an obsolete water database used to help update water resource situations reports. HL was successful with its tender which included building a new water resource information system around the HydroLog4 time-series database combined with the Open Database Toolkit.
The Water Resource Planning Manager, Martin Berry wanted to replace an in-house developed database which was linked to a series of Excel spreadsheets to produce all the summaries of key indicators such as source outputs, daily demand and reservoir storage and yields.
HL's solution was based on our HydroLog4 time-series database system which provides a vast range of standard printed and graphical reports but also enabled a high degree of customised analysis, enabling BW to maintain it's investment in the array of existing spreadsheet templates.There was also a need to link incoming data from the water companies SCADA system to minimise the need for manual entry of some data already captured automatically on a daily basis. This was achieved by providing HL's TaskMaster Scheduler module to manage transfer of data automatically on a scheduled daily basis.
Subsequently a second phase of development was commissioned by BW which linked the HydroLog4 database to HL's TS Browser web-browser tools, which enabled managers to obtain summary reports and graphs of key resource data on the company intranet, without the need to be trained how to use the HydroLog4 system. The same tools have been used to produce HL's own data hosting site Timeview Telemetry.