- By Steve Graves
- August 11, 2023
- Feature
Summary
The latest database technology allows the capture and utilization of previously out of reach data found in mission-critical SCADA systems.

"In the context of a mission-critical SCADA system using a real-time operating system (RTOS), the term 'real-time' means a guarantee of temporal consistency, not 'real-fast' or streaming data, that might be fast, but offers no temporal guarantees."
Steve Graves
Utilizing the data in mission-critical SCADA systems implies the use of a database management system (DBMS). Capturing the data in these systems will require a DBMS that can guarantee that the system’s state accurately reflects the state of the external environment it is controlling, within set timing constraints, at all times. In other words, one that can work cooperatively with the operating system’s scheduler so that the entire operation—the sensor access and the database access - either succeeds or is rejected as one. In either case, the system retains temporal data consistency and a system failure is avoided.
In the context of a mission-critical SCADA system using a real-time operating system (RTOS), the term “real-time” means a guarantee of temporal consistency, not “real-fast” or streaming data, that might be fast, but offers no temporal guarantees. There is nothing in a traditional DBMS that maintains external or temporal consistency, thus the need for a hard real-time database management system that has the features necessary to make that guarantee.
The latest DBMS technology offers transaction managers that work in concert with RTOS schedulers, and also support data management in Asymmetric MultiProcessing (AMP) architecture systems. These systems are typically composed of two CPUs of differing architecture, typically executing different operating systems (e.g., INTEGRITY and Linux), and a large amount of memory shared by the CPUs that can be used for an in-memory database available to both CPUs. This edge system can then manage the sensor data in a time-series database that will facilitate more reliable service, more efficient production and distribution, more compliant, etc., with less down time and less waste.
A hard real-time database management system with support for AMP architectures offers companies the key to the data that is under-utilized in mission-critical SCADA systems.
About The Author
Steve Graves is CEO and co-founder of McObject LLC, a company founded in 2001 with the launch of the eXtremeDB In-memory Database System (IMDS) product family, the first embedded DBMS created specifically for embedded systems.
Did you enjoy this great article?
Check out our free e-newsletters to read more great articles..
Subscribe