Title
The next generation operational data historian for IoT based on informix
Abstract
In the era of the Internet of Things (IoT), increasing numbers of applications face the challenge of using current data management systems to manage the massive volume of operational data gener-ated by sensors and devices. Databases based on time series data model, like PI Server, are developed to handle such data with operational technology (OT) characteristics (high volume, long lifecycle, and simple format). However, while achieving excellent write performance, these database systems provide limited query capabilities. In this paper, we present the next-generation Opera-tional Data Historian (ODH) system that is based on the IBM© Informix© system architecture. The system combines the write advantages of the existing time series databases and the ability to run complex queries in SQL. We demonstrate the high efficiency of our system for both writing and querying data with a variety of case studies in the industries of Energy and Utilities and con-nected vehicles. In addition, we present the first benchmark, IoT-X, to evaluate technologies on operational data management for IoT.
Year
DOI
Venue
2014
10.1145/2588555.2595638
SIGMOD Conference
Keywords
Field
DocType
relational db,systems,time series db
SQL,Time series,Data mining,Relational database,Computer science,Internet of Things,Systems architecture,Data management,Database
Conference
Citations 
PageRank 
References 
7
0.58
3
Authors
8
Name
Order
Citations
PageRank
Sheng Huang1769.79
Yaoliang Chen2386.09
Xiaoyan Chen371.26
Kai Liu4133.16
Xiaomin Xu5203.81
Chen Wang628520.06
Kevin Brown7121.21
Inge Halilovic8121.21