面向敏感区域的智能监控与预警数据库研究与设计

doi:10.3969/j.issn.1671-1122.2019.12.001

摘要/Abstract

摘要：

文章采用多线程、数据库、目标检测与跟踪、区块链等技术设计了适合敏感区域使用的智能监控与预警数据库系统,实现了对可疑动态物体和静态物体的定位、检测、跟踪、拍摄、入库、预警、查询、管理等功能,解决了监控编程中经常出现的“死机”等问题。同时,为了保证监控预警数据的高度安全性,文章利用区块链技术存储相关数据,由共识算法决定数据的删除等操作,并对关键技术和实现过程进行分析,对视频流畅度等进行实验验证。文章以“双一流”高校实验室安全建设为例对设计的智能监控与预警数据库系统进行了验证。

关键词: 智能监控, 预警, 区块链, 数据库, 敏感区域

Abstract:

This paper analyzes and practices the intelligent monitoring and early warning in the sensitive area, designs the intelligent monitoring and early warning system suitable for the sensitive area by using multithreading, database, target detection and tracking, blockchain and other technologies, and realizes the positioning, detection, tracking, shooting, warehousing, early warning, query, management of suspicious dynamic and static objects, solves the “crash” and other problems in monitoring programming. In order to ensure the high security of monitoring and early warning data, this paper discusses the storage of relevant data by blockchain technology, determines the deletion of data by the consensus algorithm, describes the key technology and implementation process, and carries out experimental verification and analysis of video fluency. This paper takes the safety construction of “double first class” university laboratory as an example to verify the system.

Key words: intelligent monitoring, early warning, block chain, database, sensitive areas

中图分类号:

TP309

王文明, 王全玉, 王英豪, 任好盼. 面向敏感区域的智能监控与预警数据库研究与设计[J]. 信息网络安全, 2019, 19(12): 1-9.

Wenming WANG, Quanyu WANG, Yinghao WANG, Haopan REN. Research and Design of Intelligent Monitoring and Early Warning Database System for Sensitive Areas[J]. Netinfo Security, 2019, 19(12): 1-9.

图/表 14

图1

图2

图3

图4

表1

表2

图5

图6

图7

表3

图8

图9

图10

图11

参考文献 16

[1]	HUANG Kaiqi, CHEN Xiaotang, KANG Yunfeng, et al.Intelligent Visual Surveillance: A Review[J]. Chinese Journal of Computers, 2015, 38(6): 1093-1118.
	黄凯奇,陈晓棠,康运锋,等.智能视频监控技术综述[J].计算机学报,2015,38(6):1093-1118.
[2]	LV Yangang, ZHANG Hongrui, ZHANG Jun, et al.Intelligent Surveillance System Used for Protecting the Security of Laboratory[J]. Research and Exploration in Laboratory, 2011, 30(6): 204-207.
	吕延岗,张红瑞,张军,等.保障实验室安防的智能监控系统[J].实验室研究与探索,2011,30(6):204-207.
[3]	ZHOU Chunyue, YAN Ziqi.Research on the Structure of Smart Laboratory Based on the Internet of Things Technology[J]. Research and Exploration in Laboratory, 2014, 33(5): 239-243.
	周春月,闫子淇.基于物联网技术的智慧实验室架构研究[J].实验室研究与探索,2014,33(5):239-243.
[4]	BU Chunyuan, XU Dahua.Development of Intelligent Laboratory Monitoring System[J]. Experimental Technology and Management, 2007, 24(7): 145-147.
	步春媛,徐大华.智能实验室监控系统的设计[J].实验技术与管理,2007,24(7):145-147.
[5]	LIU Wenyi, LIU Liqun, SHAN Mengchen, et al.Design of an Intelligent Laboratory Monitoring Control System Based on Wireless Sensor Network[J]. Research and Exploration in Laboratory, 2017, 36(6): 259-266.
	刘文艺,刘立群,单梦晨,等.基于无线传感器网络的实验室智能监控系统设计[J].实验室研究与探索,2017,36(6):259-266.
[6]	XUN Shenglan.Design and Application of Laboratory Video Monitoring System Based on Mobile Terminal[J]. Experimental Technology and Management, 2015, 32(9): 230-232.
	薛胜兰. 基于移动终端的实验室视频监控系统设计与应用[J].实验技术与管理,2015,32(9):230-232.
[7]	QIU Daoyin, ZHANG Wenjing, LIU Jin, et al.Application of Frame Difference Methods in Real-time Moving Target Tracking[J]. Journal of North China University of Water Resources and Electric Power, 2009(3): 45-46.
	邱道尹,张文静,顾波,等.帧差法在运动目标实时跟踪中的应用[J].华北水利水电学院学报,2009(3):45-46.
[8]	GAN Minggang, CHEN Jie, LIU Jin, et al.Moving Object Detection Algorithm Based on Three-Frame-Differencing and Edge Information[J]. Journal of Electronics & Information Technology, 2010, 32(4): 894-897.
	甘明刚,陈杰,刘劲,等.一种基于三帧差分和边缘信息的运动目标检测方法[J].电子与信息学报,2010,32(4):894-897.
[9]	XIN Chenxi.Design and Implementation of Intelligent Monitoring and Early Warning Database[D]. Beijing: Beijing Institute of Technology, 2014.
	辛晨曦. 智能监控与预警数据库设计与实现[D].北京:北京理工大学,2014.
[10]	DONG Daiying, WANG Xueming.Research on Electronic Medical Record Sharing Model Based on Blockchain[J]. Computer Technology and Development, 2019, 29(5): 121-125.
	董黛莹,汪学明.基于区块链的电子医疗记录共享研究[J].计算机技术与发展,2019,29(5):121-125.
[11]	ZHU Xi.Design and Implementation of Remote Monitoring System for Construction Safety[D]. Changsha: Hunan University, 2016.
	朱玺. 面向建筑施工安全的远程监控系统的设计与实现[D].长沙:湖南大学,2016.
[12]	SONG Wei, ZHANG Li. DENG Yahang.Research of Model Improved Method Based on Background Subtraction[J]. Transducer and Microsystem Technologies, 2017, 36(10): 67-69.
	宋伟,张力,邓亚航.基于背景差分法的模型改进方法研究[J].传感器与微系统,2017,36(10):67-69.
[13]	DUAN Liming.Design and Implementation of Intelligent Monitoring System for Large Distributed System[D]. Beijing: University of Chinese Academy of Sciences, 2018.
	段立明. 面向大型分布式系统的智能监控系统设计与实现[D].北京:中国科学院大学,2018.
[14]	CAI Weide, YU Lian, WANG Rong, et al.Blockchain Application Development Techniques[J]. Journal of Software, 2017, 28(6): 1474-1487.
	蔡维德,郁莲,王荣,等.基于区块链的应用系统开发方法研究[J].软件学报,2017,28(6):1474-1487.
[15]	CHEN Jinyu, LI Ruiguang.Design of an Academic Information Management System Based on Blockchain[J]. Software Guide, 2018, 17(8): 1-4.
	陈金育,李瑞光.一种基于区块链的学业信息管理系统[J].软件导刊,2018,17(8):1-4.
[16]	WANG Wenming, SHI Chongyang, ZHANIBIEKE Dasitan.Smart Contract Experimental Platform Based on Blockchain Technology[J]. Experimental Technology and Management, 2019, 36(3): 86-91.
	王文明,施重阳,达斯坦•扎尼别克.基于区块链技术的智能合约实验平台[J].实验技术与管理,2019,36(3):86-91.

字段名	类型	为空	键	注释
ID	int	Not null	主键	自动增长的ID号
ImageName	Nchar(23)	Not null		异常图片名称
Address	Nchar(100)	Not null		异常图片存储地址
Property	Nchar(8)	Not null		异常动静属性

字段名	类型	键
编号	Nchar(4)	主键
姓名	Nchar(4)
电子邮箱	超链接
手机号码	Nchar(11)
职务	Nchar(8)

测试项目	测试结果
界面功能	正常
历史记录查询功能	正常
历史记录列表显示	正常
历史记录显示	正常
异常邮件收发邮箱设置	正常
异常邮件收发功能	正常
异常邮件阅读功能	正常
异常短信收发功能	正常
智能监控功能（可疑运动物体）	正常
智能监控功能（检测可疑运动物体）	正常
智能监控功能（检测静态遗留物并框出）	正常
智能监控功能（显示提示信息）	正常
智能监控功能（提示音）	正常
数据库信息更新情况	正常
相关文件夹更新情况	正常
数据库内容显示和删除	正常
Rinkby区块测试（以太坊）	正常