Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for displaying telemetering data in real time on basis of real-time database

A technology of telemetry data and database, which is applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as instances where real-time data processing of telemetry is not shown.

Active Publication Date: 2015-01-28
TAIYUAN POWER SUPPLY COMPANY OF STATE GRID SHANXI ELECTRIC POWER
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the existing technology in the field of power system informatization and automation technology, there is no example of using Excel to display real-time telemetry data and perform simple follow-up processing

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for displaying telemetering data in real time on basis of real-time database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] The present invention will be described in further detail below in conjunction with the accompanying drawings and embodiments.

[0015] Such as figure 1 Shown, the implementation process of the inventive method is as follows:

[0016] 1. The real-time database server receives real-time data from each application module by calling the interface.

[0017] 2. The server where Excel is installed and the database server are in the same network segment, and a connection is established with the real-time database through the Excel interactive interface.

[0018] 3. Through the splicing module, the update of the A-type form and the difference before and after the record change are realized.

[0019] 4. Select the required line table and the changes presented by the measurement under the line through the limitation of the interactive interface conditions.

[0020] In the present invention, the selection of type A form fields includes line name, substation, main transformer, a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for displaying telemetering data in real time on basis of a real-time database and aims to achieve conditional displaying of real-time telemetering data in Excel forms. According to the method, on the basis of real-time database technology and on the core basis of application modules in a dispatching automation system, the Microsoft mature software Excel is used as a development environment for the whole design method, the real-time database collects real-time data as a real-time data source for displaying whole report form data, public and private attributes of main transformers and feeders are integrated, a dispatcher is allowed to screen pictures excepted to be emphatically monitored according to set conditions, and according to constraints, the dispatcher is reminded of abnormalities by means of ranking, cell color changing, alarm box pop-out and the like in the Excel forms. A more convenient means is provided for the dispatching automation staff to directly monitor key lines while skipping the application modules of the dispatching automation system.

Description

technical field [0001] The invention relates to a method for displaying telemetry data, which belongs to the technical field of power system informatization and automation. Background technique [0002] Excel in the Microsoft Office suite is a mature product of Microsoft Corporation and one of the most widely used statistical tools; Excel comes with a VBA tool that can filter data in Excel. [0003] A real-time database (also known as a time-series database) is a database specially designed to process massive real-time / historical data with time-scale measurements. It has very high storage speed, query retrieval efficiency, and data compression ratio. [0004] In the existing technology in the field of power system information and automation technology, there is no example of using Excel to display real-time telemetry data and perform simple follow-up processing. Contents of the invention [0005] In order to solve the above problems and realize conditional presentation of...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30G06F17/22
CPCG06F16/338
Inventor 王凤萍郭殿奎熊莉娟王春龙李国华刘伟刘海龙王进平张宇
Owner TAIYUAN POWER SUPPLY COMPANY OF STATE GRID SHANXI ELECTRIC POWER