In the era of “the Internet of Things”, more and more applications face the challenge of how to manage the massive volume of data generated by various sensors and devices in the current data management systems. Real time databases handle the data with operational technology (OT) characteristics (high volume, long lifecycle, simple format). However, while achieving excellent “write” performance, these systems provide limited “read” capabilities. In this paper, we present a new real time operational database (RODB) system. Our system addresses the “read” problem by extending the anatomy of the Informix system architecture. The core ideas allow complicated queries in SQL manner to deal with various advanced “read” tasks while keeping the “write” advantages of the existing real time databases. We demonstrate the high efficiency of our system on both “write” and “read” applications with a variety of real case studies in the domains of C&P, E&U and facility data management.
By: Sheng Huang, Xiao Yan Chen, Kai Liu, Yao Liang Chen, Chen Wang, Simon David
Published in: RC25327 in 2012
LIMITED DISTRIBUTION NOTICE:
This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.
Questions about this service can be mailed to reports@us.ibm.com .