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.
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.
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.