Development of a multi-historian SCADA data collection middleware : a thesis presented in partial fulfilment of the requirements for the degree of Master of Engineering in Computer and Electronic Engineering at Massey University, Albany, New Zealand.

Simple item page
dc.contributor.authorBridges, Jeffrey Paul
dc.date.accessioned2014-02-24T00:41:57Z
dc.date.available2014-02-24T00:41:57Z
dc.date.issued2013
dc.description.abstractThis thesis details the implementation of a SCADA middleware package designed to provide a common interface to the most commonly used SCADA historians in use within local government in New Zealand. The middleware integrates with a New Zealand developed cloud based solution that is used throughout the country for compliance monitoring and reporting of water and wastewater treatment facilities. The middleware connects via the internet to the historians hosted on-site within council networks and retrieves data which is replicated in a local database. This approach provides backup for the data and allows it to be accessed quickly when required for reporting. The middleware database is hosted within a Microsoft SQL Server instance to ensure compatibility and ease of rollout when paired with the commercial cloud solution. To ensure reliable data collection and resilience to connection interruption all transactions made against the client historians are controlled by a queue stored in the middleware database. The middleware includes an inbuilt mechanism for integrity checking to ensure all data available in the client historian is collected and has been designed to run with minimal intervention of company staff. To reduce storage requirements the middleware includes a data deduplication system that removes repeated samples from the SQL Server database after integrity checking has been performed. This provides a lossless compression mechanism that does not alter the precision of the data collected. The middleware implementation has now been in use in a production environment collecting data from councils for compliance purposes for approximately six months. During this time data collection has been very reliable with the middleware handling numerous connection outages without intervention.en
dc.identifier.urihttp://hdl.handle.net/10179/5132
dc.language.isoenen
dc.publisherMassey Universityen_US
dc.rightsThe Authoren_US
dc.subjectAutomatic data collection systemsen
dc.subjectSupervisory control systemsen
dc.subjectWater treatment plantsen
dc.subjectSewage disposal unitsen
dc.subjectAutomationen
dc.titleDevelopment of a multi-historian SCADA data collection middleware : a thesis presented in partial fulfilment of the requirements for the degree of Master of Engineering in Computer and Electronic Engineering at Massey University, Albany, New Zealand.en
dc.typeThesisen
massey.contributor.authorBridges, Jeffrey Paulen
thesis.degree.disciplineComputer and Electronic Engineeringen
thesis.degree.grantorMassey Universityen
thesis.degree.levelMastersen
thesis.degree.nameMaster of Engineering (M.E.)en
Files
Original bundle
Now showing 1 - 2 of 2
Thumbnail Image
Name:
01_front.pdf
Size:
261.98 KB
Format:
Adobe Portable Document Format
Description:
Download
Thumbnail Image
Name:
02_whole.pdf
Size:
811.9 KB
Format:
Adobe Portable Document Format
Description:
Download
License bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
license.txt
Size:
804 B
Format:
Item-specific license agreed upon to submission
Description:
Download
Collections
Theses and Dissertations