基于Oracle PL/SQL存储过程的水调自动化数据处理系统  

Automatic Data Processing System for Waterpower Scheduling Automation System Based on Oracle PL/SQL Stored Program

作　　者：杨宁[1] 张建[1] 吴志坚[2] 

机构地区：[1]国网电力科学研究院,江苏省南京市210003 [2]南京解放军理工大学,江苏省南京市210000

出　　处：《水电自动化与大坝监测》2009年第6期77-80,共4页HYDROPOWER AUTOMATION AND DAM MONITORING

摘　　要：水调自动化系统是电网运行的重要生产系统,数据处理子系统是水调系统的数据加工厂,负责为水调系统提供实时、准确、可靠的数据。如何科学地应用商用数据库提供的编程功能,最大限度地提高数据处理的实时性、高效性和计算效率成为一个新的研究课题。文中针对该问题,分析比较了常见数据处理系统实施方案的优缺点,最终选择基于Oracle过程性语言/结构化查询语言(PL/SQL)存储过程技术,为水调系统提供高效、可靠的数据源。The waterpower scheduling automation system is an important part of an electric power dispatching and management system. The sub-system of data processing is responsible for providing real time, accurate, and reliable data for the waterpower scheduling automation system. How to efficiently use the programming ability of commercial database is a new research topic. It can increase the computational efficiency of data processing and can provide the real-time data. This paper evaluates and compares several common data processing systems. The result shows that the data storage technique based on Oracle PL/SQL stored programming is able to provide efficient and reliable data sources for the waterpower scheduling automation system.

关 键 词：水调系统 数据处理 PL/SQL 存储过程 三峡水调自动化系统 

分 类 号：TV697.1[水利工程—水利水电工程]