Design and Application of Real-time Database Model for Smart
Residential Quarter
Chenlu Tian
1, a
, Shaolin Wang
1,b
,Guiqing Zhang
1,2,c
, and Jiajun Luo
1
1
College of Information&Electrical Engineering ,Shandong Jianzhu University,Jinan,China
2
Shandong Provincial Key Laboratory of Intelligent Buildings Technology,Jinan,China
a
15634135867@163.com,
b
281419316@qq.com,
c
qqzhang@sdjzu.edu.cn
Key words: smart residential quarter, distribute, real-time database,SOA,cloud
Abstract:With the development of smart city and smart residential quarter, there are new data
demand of time constraint, heterogeneous and distributed data integration, resource sharing ,global
management and coordination and regional autonomy. To meet the demands, this thesis reviews the
current situation of research on the real-time database for smart residential quarter and puts forward
a distributed database model based on SOA. The model is illustrated in database architecture and
data model. What’s more, A real-time database is constructed based on the model and has been
applied in a smart residential quarter. The real-time database provides safe, reliable and efficient
data acquisition and processing capability .
Introduction
Motivated by sustainable development requirements of global environment and modern cities, the
concept of the Smart City has been introduced as a strategic device of future urbanization on a
global scale[1]. Communities is an essential component of urban services and resident management,
and its degree of smartness is closely related to smartness of a city which will finally be reflected in
living standard of residents, such as convenience, safety and harmony of life[2]. Smart residential
quarter may include or be included in one or more communities. There are many distributed
intelligent systems or equipment such as smart homes, environmental monitoring systems,
ground-source heat pump system and so on. The intelligent systems or equipments are the data
sources in smart residential quarter and create quarter big data as vital part of city big data.
The numerous sensing devices of IOTS and other smart systems generate massive data every
second, which is used in the accurate management, real-time control , scientific decision-making of
energy-saving operation, regulation of environment comfort degree. There is high real-time
requirement in data collection for timely monitoring and control of the environment or electrical
facilities. Usually, the database systems such as SQL SERVER or My SQL would not be applicable
for the time-critical applications because of the poor real-time performance. Both timing constraints
and data consistency would be taken into consider in smart quarter real-time database systems when
scheduling the transactions so that they can be accomplished by their corresponding deadlines [3].
Apart from the time constraints that are out of the demand of continuously data tracking, timing
correctness requirements are also proposed due to the need to keep data available for the
decision-making activities of the controlling systems [4].
At the same time, there are many differences from the industry and electricity power
environment.
4th International Conference on Sensors, Mechatronics and Automation (ICSMA 2016)
Copyright © 2016, the Authors. Published by Atlantis Press.
This is an open access article under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).
Advances in Intelligent Systems Research, volume 136