Benchmarking Database Systems for the Requirements of Sensor Readings

被引:18
作者
Pungila, Ciprian [1 ]
Fortis, Teodor-Florin [1 ]
Aritoni, Ovidiu [1 ]
机构
[1] Res Inst E Austria, Timisoara 300223, Romania
关键词
Benchmarking; Energy monitoring; Sensor data; Smart metering; Time-series data;
D O I
10.4103/0256-4602.55279
中图分类号
TM [电工技术]; TN [电子技术、通信技术];
学科分类号
080906 [电磁信息功能材料与结构]; 082806 [农业信息与电气工程];
摘要
Improving energy efficiency in order to reduce CO2 emissions is a permanent challenge in the European space. Smart metering could help for improving energy efficiency by offering information about the way in which the energy is used. Smart metering will be based on large volumes of sensor data, since energy monitoring will bring together sensor data from various critical areas. The main purpose of this paper was to present the selection mechanism for a scalable storage solution, based on the requirements of the DEHEMS (Digital Environment Home Energy Management System) project. With regular sensor readings coming at every 6 seconds, there is an impressive amount of data collected even for the minimal target of about 250 households, 10 sensors per user. With these huge data streams that are non-stationary time-series data, collected at discrete intervals, the DEHEMS project has to offer a solution for storing and retrieving sensor data in a responsive way. We have tested both collection speed and aggregation speed for reasonable data streams of sensor data. The tests were performed on various database models, with their associated representations, including relational databases, key-value stores, column stores, self-tuning databases, as well as time-series enabled database systems. These experiments confirmed that column stores and key-value stores perform better than relational databases, while time-series databases outperform all the others.
引用
收藏
页码:342 / 349
页数:8
相关论文
共 13 条
[1]
[Anonymous], MOBILISING INDIVIDUA
[2]
[Anonymous], 2002, Proceedings of the 1st ACM International Workshop on Wireless Sensor Networks and Applications. WSNA'02, DOI [DOI 10.1145/570738.570750, 10.1145/570738.570750]
[3]
[Anonymous], 2005, SUSTAIN DEV RES NETW
[4]
DEALMEIDA A, 2006, P INT EN EFF DOM APP
[5]
GABER MM, 2007, LEARNING DATA STREAM
[6]
GIBBONS PB, 2003, IEEE PERVASIVE COMPU, V2
[7]
KLEEMAN M, 2001, SYSTEMATISIERUNG POT
[8]
Integrated residential gateway controller for home energy management system [J].
Kushiro, N ;
Suzuki, S ;
Nakata, M ;
Takahara, H ;
Inoue, M .
IEEE TRANSACTIONS ON CONSUMER ELECTRONICS, 2003, 49 (03) :629-636
[9]
Skyline index for time series data [J].
Li, QZ ;
López, IFV ;
Moon, B .
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2004, 16 (06) :669-684
[10]
LIU C, 2005, GLOBAL TELECOMMU DEC