电能量远程采集和分析系统数据库结构设计

The Database Structure Design on Remote Gathering and Analyzing System of Electric Energy Quantities

电能量远程采集和分析系统是一个集远程采集和后台分析处理于一体的系统,需要对其中大量的数据信息进行处理,因而功能强大的数据库系统是至关重要的。本文针对电能量远程采集和分析系统提出了一种基于客户/服务器(C/S)模式的数据库结构设计方法。该方法从电量采集系统的信息分类入手,对数据库进行可扩充性设计,尽量做到应用要求变更与程序无关,使数据库具有一定的可塑性,为了提高查询速度我们在对电量采集系统数据库进行设计时,做了四个方面的优化设计:1 创建适当的索引,2 创建适当的视图,3 创建适当的存储过程,4 创建适当的统计数据库表。实际运行情况表明该系统数据库结构设计合理,具有信息分类明确、层次清晰、查询方便快捷、可扩充性好等特点。

The remote gathering and analyzing system of electric energy quantities is a multi - purpose system which can collect remote data, and also analyze, deal with gathered data on backstage. As quantities of information must be dealt with, a powerful database system is very important. Aimed at the remote gathering and analyzing system of electric energy quantities, this paper has proposed a kind of structural design rethool based on C/S mode to establish the system database. Starting with the information classified, the expansibility of datebase are designed. The program is independent of application in order to make the database possess moldability. We optimize four aspects in order to increase velocity when designing. 1. Appropriate index is established2. Appropriate view is established3. Appropriate storage process is established 4. Appropriate statistical database table is established. The practices indicate that this database structural design is reasonable and has the characteristics of clear information classification, distinct arrangement, convenient to look up and easy to expand etc.