One industrial use case that demonstrates the integration of OT and IT data is for an oil and gas client with remote assets. This client maintains several rotating machines which operate in the field to manage their gas flow through miles of pipelines. These compressors operate at 15,000 rpm’s and have integrated sensors that measure pressure, temperature and vibration. The sensors are connected to a mobile network which can be unpredictable. The onboard systems can cache or store data collected for a finite period of time to account for network outage scenarios and this functions for some of the more static data such as temperature and pressure. Vibrations are unique in that the deviations in these values can occur in milliseconds and often are used to predict potential failures in the equipment. Collecting this high resolution data exceeds most caching capabilities and would overload these remote networks.
Most middleware layers force users to duplicate their data onto a completely different platform. Leverage both OT and IT systems and be selective on what data you access based on the workflows that your team already needs.
In this instance, HarperDB was installed on a small computer connected in line with the sensors where the vibration data could be streamed directly into the local datastore. Using thresholds, each value was then compared and if the value exceeded the threshold, an “out of spec” event was generated in a separate table. Instead of forwarding all of this data, only the events were transmitted across the network. A second node was installed at the operations center which collected the events from the distributed assets and presented a dashboard and alerts to operators. The dashboard also included data from their ERP system which included specific vendor and maintenance records for these specific assets. The orchestration of high frequency operational data and more static asset maintenance data was automated using built in HarperDB features.
Ready to Try HarperDB?
Our newest product, HarperDB Cloud is a great way to jump start your OT/IT integration.
We are looking for developers to beta HarperDB Cloud and we are offering $250 in credits to make your project a reality. Be up in running in five minutes and let us worry about managing and hosting your database so you can focus more on code and worry less about DevOps.