DATABASE

FUNCTION

 

The primary goal of a smart wastewater system database is to

collect data from the different source data streams so that it

can be converted, using advanced analytics, into actionable

information. To accomplish this task requires a robust database

to capture the data from the different streams and store it in a

normalised fashion to allow for direct comparison.

BENEFITS

 

Once data has been collected, stored, and validated in the various system databases, it can be used to:

 

  • Convert data streams to actionable information involves algorithms to process the data, and presentation of the information in a manner that is intuitive to an operator;

  • The information can be presented on an interactive dashboard that provides clear visualisation of the information with drill down access to the underlying detailed data;

  • Information can be converted into a number of Key Performance Indicators (KPIs) to evaluate the overall performance of the system against set goals and objectives.

SYSTEM REQUIREMENTS

  • The data streams will be collected in different databases for analysis as needed, either historical analysis, or as part of the dashboard presentation (i.e. graphical analysis of data points over time);

  • Each of the data streams will have their own database management tools;

  • The data sources will go through a multi-tiered data management architecture which will validate and provide QA/QC for the data;

  • Data will be sent via open standards such as web services or leveraging direct database connections as appropriate to support expansion of the system into the future.