智能视频监控系统数据库设计  

The Design of Database of Intelligent Monitoring System

作　　者：薛瑞华[1] 谢刚[1] 赵哲峰[1] 

机构地区：[1]太原理工大学信息工程学院,山西太原030024

出　　处：《软件》2011年第12期50-52,74,共4页Software

基　　金：太原高新区创新基金项目(08CXJJ-77)

摘　　要：本文针对智能监控系统的功能和特点,并根据软件开发中数据库设计的理论,给出了智能监控系统的数据库的概念设计、逻辑结构设计,最后实现了数据库的建立。本文数据库使用SQL Server 2005为数据库开发环境,采用Client/Server开发模式。本系统可以为管理员设置不同级别的权限,实现分级管理。实现实时存储录像文件和报警图片,管理员可以根据图片和录像文件的类型、时间、设备名称和设备位置等信息,来查询所需的图片和录像,方便监控人员查询和确认报警事件。经实际中使用证明,本文所设计的数据库简洁、结构合理、稳定性好、性能高。On the basis of the characteristic of intelligent video monitoring system and the theory of database design, the conceptual design and logical structure design of the database was given in this paper. Then, the database was established. The database uses SQL Server 2005 as the development environment and adopts Client/Server mode. Different level authority can be set for different administrators, so the system realizes the graded administration. It can real-time save video file and alarm picture. The administrator can query alarm pictures and video file by the type of picture and video file, time, equipment name and position. It brings convenience for people to query and affirm the alarm event. It is proved that the database design in this paper is concise and reasonably structured. It also has good stability and high performance.

关 键 词：智能视频监控 系统 数据库 E—R 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]