煤矿安全监管系统数据库设计与分析  

Database design and analysis in coal mine safety supervision system

作　　者：张楠[1] 黄俊[1] 全太锋 

机构地区：[1]重庆邮电大学信号与信息处理重庆市重点实验室,重庆400065 [2]重庆煤安森科技股份有限公司无线技术研发部,重庆400065

出　　处：《数字通信》2013年第5期91-94,共4页Digital Communications and Networks

摘　　要：煤炭工业为我国经济发展做出了巨大贡献,但频繁发生的矿难事故也严重威胁到矿工的生命,造成了极大的经济损失和恶劣的社会影响。煤矿监控系统对矿井进行智能化、数字化的管理,将大大减少井下事故的发生率,其中数据库的设计是整个系统的重要部分。从概念化的角度给出了数据库的总体设计,给出了部分数据库系统的ER图及关系模式,并标明了其主键和外键,同时还给出了实时数据库的性能要求。When coal industry makes a great contribution to economic development of China, the frequent occurrence of mine accidents seriously threats the lives of miners. The coal mine monitoring system thas realized the management of mine intelligence and digitization then greatly reduces the incidence of downhole accidents. Among them the database designing is the important part of the whole system. This article gives the overall design of database from the concept of perspective then di- vides the datebase system into six subsystems and describes them respectively . At the same time it gives the ER diagram and relational model of each subsystem with the primary key and foreign key and the performance requirements of real-time database.

关 键 词：煤矿安全 监控 系统边界 数据库 实时性 

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