CN104317879B - A kind of telemetry real-time exhibition method based on real-time data base - Google Patents
A kind of telemetry real-time exhibition method based on real-time data base Download PDFInfo
- Publication number
- CN104317879B CN104317879B CN201410564037.7A CN201410564037A CN104317879B CN 104317879 B CN104317879 B CN 104317879B CN 201410564037 A CN201410564037 A CN 201410564037A CN 104317879 B CN104317879 B CN 104317879B
- Authority
- CN
- China
- Prior art keywords
- real
- classes
- time
- time data
- class
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/338—Presentation of query results
Abstract
The invention discloses a kind of telemetry real-time exhibition method based on real-time data base, to realize that real-time telemetry data are presented in Excel forms conditional, the present invention is based on Real-Time Databases System Technique, using each application module data in dispatch automated system as key foundation, the development environment of whole design method is used as by the use of Microsoft maturation software Excel, the real time data source that real time data is used as whole report data and shows is collected by real-time data base, the publicly-owned and privately owned attribute of each main transformer and feeder line is combined, realize that dispatcher can go out to wish the picture of emphasis monitoring by the conditional filtering of setting, and according to qualifications, sequence is provided in Excel forms, cell color changes, the modes such as alert box are jumped out to remind dispatcher unusual condition occur.The present invention, which for dispatching automation personnel skips each application module of dispatch automated system, is directly monitored by critical circuits provides more efficiently means.
Description
Technical field
The present invention relates to a kind of telemetry methods of exhibiting, belong to electric power information and technical field of automation.
Background technology
Excel in Microsoft Office suites is Microsoft's matured product, and now most popular
One of statistical tool；Excel carries VBA instruments, and the data in Excel can be screened.
Real-time data base (also known as time series databases) be specifically used to target measures when processing carries magnanimity in real time/
The database of historical data, there is very high storage speed, query and search efficiency and data compression ratio.
In electric power information and technical field of automation in the prior art, do not utilize also Excel distant to show
Survey real time data, carry out the example of simple subsequent treatment.
The content of the invention
In order to solve the above problems, realize that real-time telemetry data are presented in Excel forms conditional, the invention provides
A kind of telemetry real-time exhibition method based on real-time data base, its technical scheme are specific as follows：
A classes Data source table, B classes Data source table, the control table of C classes and real-time data base telemeter are set in Excel, its
In,
Feeder line and main transformer are arranged to the A classes Data source table of Excel whole multi-field and the B class data of each few field
The major key of source table, wherein B classes Data source table are the base tables of A class Data source tables, and the A class Data source tables of generation, which show, to be stored in
Sheet tables, the table finally generated by application module is B class Data source tables.
The control table safeguarded to the field order of A class Data source tables is C class control tables, and C classes control table control is each
The order that field occurs in Excel tables, ensure the correctness of B classes table synthesis A class tables.
The corresponding relation of measuring point name and measuring point description is contained in real-time data base telemeter, the telemeter is also Excel
Form, wherein the remote measurement for containing each application module collects, the ID number and word of each measuring point are remained in the Excel forms
Describe, contain line name in word description, ID number and the word description for giving tacit consent to each measuring point are correct.Real-time data base
Telemeter selects condition to select monitoring wire, and automatic real-time refresh data according to certain deleting.
Further, above-mentioned B classes Data source table is divided into two class forms, and first kind form does not include real time data (abbreviation B1 classes
Form), it contains the incidence relation of each circuit and some specific fields, electric substation and main transformer, line as corresponding to line name
Affiliated area and power supply station etc. corresponding to the title of road；It is to contain circuit to correspond to some in second class form (abbreviation B2 classes form)
The acquisition function of electrical quantity, this function contain real-time data base real time data calling interface.
Further, each interactive interface is generated by VBA built in Excel in Excel.
The present invention is based on Real-Time Databases System Technique, using each application module data in dispatch automated system as core
Basis, by the use of Microsoft maturation software Excel as the development environment of whole design method, real-time number is collected by real-time data base
According to the real time data source shown as whole report data, the publicly-owned and privately owned attribute of each main transformer and feeder line is incorporated into one
Rise, realize that dispatcher can go out to wish the picture of emphasis monitoring by the conditional filtering of setting, and according to qualifications,
Excel forms provide sequence, cell color change, jump out the modes such as alert box to remind dispatcher unusual condition occur.
The present invention, which for dispatching automation personnel skips each application module of dispatch automated system, is directly monitored by critical circuits provides more
Efficiently means.
Brief description of the drawings
Fig. 1 is the data flow schematic diagram of the inventive method.
Embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.
As shown in figure 1, the implementing procedure of the inventive method is as follows：
1st, live database server by way of calling interface from each application module receiving real-time data.
2nd, installation Excel server and database server are in the same network segment, by Excel interactive interfaces and in real time
Database connects.
3rd, the difference after realizing the renewal of A class forms by concatenation module and record before changing.
4th, by measuring presented change under the circuit table and the circuit needed for the restriction selection of interactive interface condition.
In the present invention, selecting for A class table fields, line name, electric substation, main transformer, permissible load, affiliated area are included
Domain, power supply station, user, active and reactive, electric current, winter limit, summer limit, line voltage, temperature, gear etc.；A classes form is just
It is a two-dimentional big table, the form is the immediate data source of last each supervision application picture, the data equivalent to Oracle
Dictionary, difference is exactly that the form is placed in Excel Sheet, and quantity is larger, and all forms are exactly to be used as master using line name
Key.
A classes form is synthesized by B class forms, and B classes form includes less field, if in some B class form comprising
Two field line names and electric substation, can be referred to as electric substation B class forms；Electric substation B class forms are by being applied according to some
(every other B classes form is all so to generate to the generation of module automatic or manual, and strict regulations line name is as other B classes
The major key of form).
It is divided into two class forms in B class forms, first kind form does not include real time data (abbreviation B1 classes form), and it is contained
The incidence relation of each circuit and some specific fields, electric substation and main transformer as corresponding to line name, institute corresponding to line name
Belong to region and power supply station etc.；Second class form (abbreviation B2 classes form) contains the acquisition function that circuit corresponds to some electrical quantity,
This function contains real-time data base real time data calling interface, thus circuit and corresponding electrical quantity are formed mapping pass one by one
System, as line name and it is active just form the form of a B2 class, the function that acquisition real-time data base is contained in the form connects
Mouthful.
The generation of B2 class forms is to describe table according to the measuring point in real-time data base to parse, and measuring point describes have two in table
Individual crucial field, respectively measuring point title and measuring point describe, and wherein measuring point title is exactly unique English mark of the measuring point
Being described with Chinese, the description for some electrical quantity of certain circuit is also unique, is described similar to the active of so-and-so circuit,
So-and-so circuit it is idle.The basic ideas for generating the process of B2 class forms are exactly that the positioning of electrical quantity is first carried out to Chinese description,
It is such as active, electric current, idle, unique English mark of the description is have recorded simultaneously here, then delete and select some electrical quantity
All circuits, it is ranked up further according to the order of the major key circuit of A class forms, finally when this B2 classes form synthesizes or updates A classes
During form, will by the use of certain circuit electrical quantity unique English mark as respective function parameter.
The C class chartings appearance position (such as A, AB) of each field of A classes form from left to right, have recorded simultaneously
A class form major keys are newest to put in order, and B classes form can update according to corresponding to being made the order of C class chartings, specific implementation
Field to be used by C classes form and B classes form itself positions A classes table update starting row, and makees real-time update.
The generation method of A class form major keys is that automatic or manual generates B class table circuit main transformers pair from application-specific module
Table is answered, the circuit is just slaves to the main transformer.All it is whole by one corresponding to main transformer circuit in the sequence of A class form major keys
Body (main transformer is head, circuit toward heel row) is arranged from top to bottom successively.In A class form major keys, the circuit between two main transformers closed on
All it is subordinated to main transformer above.
The interface developed in Excel includes, and B classes (are completed in the interface in database linkage interface, A generic modules renewal interface
Table update into A class forms, and record in A classes form and B class forms increase newly or without renewal position), scheme customization circle
(scheme Custom Interface is exactly to limit specific circuit and specifically monitor condition, including active, power factor (PF), warning color in face
Threshold), the interface after customization can be illustrated in a new Sheet table, because the inside replicates the function in A class forms, so
The real-time refreshing of circuit electric values can be realized.
User mainly uses interactive interface, but the quality of above-mentioned link realization depends on the support of a few class forms,
The particularly accuracy of A classes form, and the accuracy of A class forms relies on the survey in the accuracy and real-time data base of other forms
Point description table.
The invention is not restricted to above-described embodiment, all technical schemes formed using equivalent substitution or equivalence replacement are belonged to
The scope of protection of present invention.
Claims (2)
- A kind of 1. telemetry real-time exhibition method based on real-time data base, it is characterised in that A class numbers are set in Excel According to source table, B classes Data source table, the control table of C classes and real-time data base telemeter, wherein,The A classes Data source table data are multi-field, and using feeder line and main transformer as major key；The A classes Data source table is all by B classes Data source table synthesizes；The B classes Data source table data are few field, and B classes Data source table is the base table of A class Data source tables；The B classes data Source form is divided into two class forms, and first kind form does not include real time data, and it includes each circuit and the incidence relation of specific fields； Second class form contains the acquisition function that circuit corresponds to some electrical quantity, and this function calls comprising real-time data base real time data Interface, the second class form are to describe table according to the measuring point in real-time data base to parse；The C classes control table controls the order that each field occurs in Excel tables, ensures the correct of B classes table synthesis A class tables Property；B classes Data source table can the renewal according to corresponding to being made the order that the control table of C classes records；Real-time data base remote measurement selects condition to select monitoring wire, and automatic real-time refresh data according to default delete.
- 2. according to the method for claim 1, it is characterized in that, each interactive interface is all by built in Excel in Excel VBA is generated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410564037.7A CN104317879B (en) | 2014-10-21 | 2014-10-21 | A kind of telemetry real-time exhibition method based on real-time data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410564037.7A CN104317879B (en) | 2014-10-21 | 2014-10-21 | A kind of telemetry real-time exhibition method based on real-time data base |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104317879A CN104317879A (en) | 2015-01-28 |
| CN104317879B true CN104317879B (en) | 2018-01-12 |
Family
ID=52373111
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410564037.7A Active CN104317879B (en) | 2014-10-21 | 2014-10-21 | A kind of telemetry real-time exhibition method based on real-time data base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104317879B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110297826B (en) * | 2019-05-31 | 2020-12-11 | 南京理工大学 | Method for dynamically analyzing satellite telemetry data based on json |
| CN112380284A (en) * | 2020-10-09 | 2021-02-19 | 华能国际电力股份有限公司上安电厂 | Power plant operation monitoring and alarming system based on SIS system and Excel platform |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN102567565A (en) * | 2011-11-10 | 2012-07-11 | 重庆电力设计院 | Cable parameter processing method and system utilizing same |
| CN103116814A (en) * | 2013-03-14 | 2013-05-22 | 上海市电力公司 | Medium-term load forecasting system for regional power grid master devices |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7768234B2 (en) * | 2004-02-28 | 2010-08-03 | Janik Craig M | System and method for automatically synchronizing and acquiring content for battery powered devices |
-
2014
- 2014-10-21 CN CN201410564037.7A patent/CN104317879B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN102567565A (en) * | 2011-11-10 | 2012-07-11 | 重庆电力设计院 | Cable parameter processing method and system utilizing same |
| CN103116814A (en) * | 2013-03-14 | 2013-05-22 | 上海市电力公司 | Medium-term load forecasting system for regional power grid master devices |
Non-Patent Citations (2)
| Title |
|---|
| "基于海迅实时数据库的配电线路运行监视软件";费东虎 等;《浙江电力》;20130930;第47页第2段-第49页第1段，附图1-6 * |
| "监控组态软件实时数据库的研究与应用";宋超;《中国优秀硕士学位论文全文数据库 信息科技辑》;20111015;论文正文第14页第2段-第16页第2段 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104317879A (en) | 2015-01-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106650161B (en) | Electrical single line diagram mapping method and system based on power grid GIS | |
| CN105069690B (en) | A kind of grid operation data processing method | |
| CN107292003B (en) | Automatic generation method of power grid station wiring diagram | |
| CN102508989B (en) | Dynamic power grid panorama display system on basis of virtual reality | |
| CN103970887B (en) | A kind of information flow display system and method based on GIS power distribution network figures | |
| CN105278373A (en) | Substation integrated information processing system realizing method | |
| CN107835107B (en) | Measurement display system based on power grid measurement topology and WebGis | |
| CN102957205B (en) | A kind of method and system setting up electricity distribution network model | |
| CN102033953A (en) | Equipment accounting management method for electric distribution network | |
| CN101930481B (en) | Method used for generating CIM model describing power grid change in designated time slot and system thereof | |
| CN107256442B (en) | Line loss calculation method based on mobile client | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN102779156A (en) | Configuration method for database of communication device in digital substation | |
| CN111585349B (en) | Power grid model management and monitoring system | |
| CN106408207A (en) | Modeling method and system for secondary virtual loop of intelligent substation | |
| CN112132327A (en) | Multi-source data fusion-oriented intelligent planning system for power distribution network | |
| CN202110580U (en) | Intelligent distribution network equipment account management system based on GIS (Geographic Information System) | |
| CN106970999A (en) | A kind of BPA Database Modelings and maintaining method | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base | |
| CN105490270A (en) | Monitoring interface generation method and device of intelligent power distribution system | |
| CN101916269B (en) | The generation method of power grid SVG graphic file, described graphic file and generation system | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN107944659A (en) | A kind of substation supervisory control system auto report completing method and apparatus | |
| CN105740296B (en) | Intelligent substation data subscription method based on access model | |
| CN106301893A (en) | The information interacting method safeguarded for BTS management and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Li Guohua Inventor after: Xiong Lijuan Inventor after: Wang Jinping Inventor after: Wang Fengping Inventor after: Wang Chunlong Inventor after: Zhang Kai Inventor after: Yao Wei Inventor after: Liu Wei Inventor after: Liu Hailong Inventor after: Zhang Yu Inventor after: Guo Diankui Inventor before: Wang Fengping Inventor before: Guo Diankui Inventor before: Xiong Lijuan Inventor before: Wang Chunlong Inventor before: Li Guohua Inventor before: Liu Wei Inventor before: Liu Hailong Inventor before: Wang Jinping Inventor before: Zhang Yu |
|
| CB03 | Change of inventor or designer information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |