基于SQL Server的能耗监测数据库设计

Design of Energy Consumption Monitoring Database Based on SQL Server

随着当今工业生产和科学研究对数据应用要求的日益提高,数据库技术已成为控制系统重要部分。本文依据国家机关办公建筑和大型公共建筑能耗监测数据库的相关技术导则对SQLServer数据库的组成进行了总结和概述,并按照相关技术导则的要求论述了能耗数据特点与数据表格的组成,对数据库表结构设计方法作了论述。该系统可操作性强,通用性好,快捷方便。因此,该研究成果将具有广泛的发展和应用前景。

Along with the requirements of modern industry production and science research on data collection increasing, database technology in the control system is becoming more and more important. On the basis of gov- ernment office buildings and large public building energy consumption monitoring database technical guidelines, we have a summary and overview of the composition of the SQL Server database. And in accordance with the rele- vant technical guide requirements, we discuss the characteristics of energy consumption data and data forms of da- ta tables. The method of database table structure design is also discussed. The system has a feasible operability and versatility, and it＇s quick and easy. Therefore, the research results will have a wide range of development and appli- cation prospects.