CN104317879A - Method for displaying telemetering data in real time on basis of real-time database - Google Patents
Method for displaying telemetering data in real time on basis of real-time database Download PDFInfo
- Publication number
- CN104317879A CN104317879A CN201410564037.7A CN201410564037A CN104317879A CN 104317879 A CN104317879 A CN 104317879A CN 201410564037 A CN201410564037 A CN 201410564037A CN 104317879 A CN104317879 A CN 104317879A
- Authority
- CN
- China
- Prior art keywords
- real
- category
- data
- time
- excel
- 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.)
- Granted
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 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
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 external member is Microsoft's matured product, is also one of present most popular statistical tool; Excel carries VBA instrument, can screen the data in Excel.
Real-time data base (also known as time series databases) be used for specially processing with time the target magnanimity that measures in real time/database of historical data, there is very high storage speed, query and search efficiency and data compression ratio.
In the prior art of electric power information and technical field of automation, also do not utilize Excel to show remote measurement real time data, to carry out the example of simple subsequent treatment.
Summary of the invention
In order to solve the problem, realize real-time telemetry data and presenting at Excel form conditional, the invention provides a kind of telemetry real-time exhibition method based on real-time data base, its technical scheme is specific as follows:
Category-A data source table, category-B data source table, the control table of C class and real-time data base telemeter are set in Excel, wherein,
Feeder line and main transformer are set to the major key of the category-A data source table of the whole multi-field of Excel and the category-B data source table of each few field, wherein category-B data source table is the base table of category-A data source table, generate category-A data source table represent be kept at Sheet table, the table finally generated by application module is category-B data source table.
The control table safeguarded the field order of category-A data source table is the control table of C class, and the control table of C class controls the order that each field occurs in Excel table, ensures the correctness of category-B table synthesis category-A table.
The corresponding relation of measuring point name and measuring point description is contained in real-time data base telemeter, this telemeter is also Excel form, the remote measurement wherein containing each application module gathers, No. ID and text description of each measuring point is remained in this Excel form, contain line name in text description, No. ID that gives tacit consent to each measuring point correct with text description.Real-time data base telemeter selects condition to select monitoring wire according to certain deleting, and automatic refresh data in real time.
Further, above-mentioned category-B data source table is divided into two class forms, first kind form does not comprise real time data (being called for short B1 class form), it contains the incidence relation of each circuit and some specific fields, electric substation as corresponding in line name and main transformer, the affiliated area that line name is corresponding and power supply station etc.; Equations of The Second Kind form is the acquisition function containing circuit certain electric parameters corresponding in (being called for short B2 class form), and this function contains real-time data base real time data calling interface.
Further, in Excel, each interactive interface is all generated by the built-in VBA of Excel.
The present invention is based on Real-Time Databases System Technique, with application module data each in dispatch automated system for key foundation, utilize the ripe software Excel of Microsoft as the development environment of whole method for designing, the real time data source that real time data shows as whole report data is collected by real-time data base, publicly-owned and the privately owned attribute of each main transformer and feeder line is combined, realize dispatcher and can go out wish by the conditional filtering of setting the picture that emphasis monitors, and according to qualifications, sequence is provided at Excel form, cell color changes, jump out the modes such as alert box and occur unusual condition to remind dispatcher.The present invention is that dispatching automation personnel skip each application module of dispatch automated system, directly monitor that critical circuits provides means more efficiently.
Accompanying drawing explanation
Fig. 1 is the data flow schematic diagram of the inventive method.
Embodiment
Below in conjunction with drawings and Examples, the present invention is described in further detail.
As shown in Figure 1, the implementing procedure of the inventive method is as follows:
1, live database server passes through the mode of calling interface from each application module receiving real-time data.
2, the server of Excel and database server be installed in the same network segment, connected by Excel interactive interface and real-time data base.
3, realize the renewal of category-A form by concatenation module and record the difference before changing.
4, selected by the restriction of interactive interface condition needed for circuit table and this circuit under measure presented change.
In the present invention, category-A table field selected, comprise line name, electric substation, main transformer, permissible load, affiliated area, power supply station, user, meritorious, idle, electric current, winter limit, summer limit, line voltage, temperature, gear etc.; Category-A form is exactly a two-dimentional large table, this form is that last each monitors the immediate data source of applying picture, and be equivalent to the data dictionary of Oracle, difference is exactly that this form is placed in the Sheet of Excel, quantity is comparatively large, and all forms are exactly using line name as major key.
Category-A form is all synthesized by category-B form, and category-B form comprises less field, as just contained two field line names and electric substation in certain category-B form, can be referred to as electric substation's category-B form; Electric substation's category-B form generates (every other category-B form is all such generation, and strict regulations line name is as the major key of other category-B forms) by according to certain application module automatic or manual.
Two class forms are divided in category-B form, first kind form does not comprise real time data (being called for short B1 class form), it contains the incidence relation of each circuit and some specific fields, electric substation as corresponding in line name and main transformer, the affiliated area that line name is corresponding and power supply station etc.; Equations of The Second Kind form (being called for short B2 class form) contains the acquisition function of circuit certain electric parameters corresponding, this function contains real-time data base real time data calling interface, thus circuit and corresponding electric parameters just define mapping relations one by one, as line name and the meritorious form just forming a B2 class, in this form, contain the function interface obtaining real-time data base.
The generation of B2 class form parses according to the measuring point description list in real-time data base, the field that two crucial is had in measuring point description list, be respectively measuring point title and measuring point description, wherein measuring point title is exactly unique English mark and the Chinese description of this measuring point, description for certain electric parameters of certain circuit is also unique, describe and be similar to the meritorious of so-and-so circuit, so-and-so circuit idle.The basic ideas generating the process of B2 class form are exactly describe the location of first carrying out electric parameters to Chinese, as meritorious, electric current, idle etc., here have recorded unique English mark of this description simultaneously, delete all circuits selecting certain electric parameters again, sort according to the order of the major key circuit of category-A form again, finally when the synthesis of this B2 class form or when upgrading category-A form, the parameter of unique English mark as respective function of certain circuit electric parameters will be utilized.
The C class charting appearance position (as A, AB etc.) of category-A form each field from left to right, have recorded up-to-date the putting in order of category-A form major key simultaneously, category-B form can do corresponding renewal according to the order of C class charting, be implemented as the initial row of field location category-A table update used by C class form and category-B form self, and make real-time update.
The generation method of category-A form major key is that automatic or manual generates category-B table circuit main transformer correspondence table from application-specific module, and this circuit is subordinated to this main transformer exactly.In the sequence of category-A form major key, be all that corresponding for main transformer circuit entirety (main transformer is head, and circuit is arranged backward) is arranged successively from top to bottom.In category-A form major key, the circuit between two main transformers closed on all is subordinated to main transformer above.
The interface developed in Excel comprises, DataBase combining interface, category-A module upgrade interface, and (this interface completes category-B table update in category-A form, and to record in category-A form and category-B form newly-increased or there is no the position that upgrades), (scheme Custom Interface limits specific circuit and specific guard condition to scheme Custom Interface exactly, comprise meritorious, power factor (PF), warning look threshold), interface after customization can be illustrated in a new Sheet table, because the inside replicates the function in category-A form, so the real-time refreshing of circuit electric values can be realized.
User mainly uses interactive interface, but the quality that above-mentioned link realizes depends on the support, the particularly accuracy of category-A form of a few class form, and the accuracy of category-A form relies on the measuring point description list in the accuracy of other forms and real-time data base.
The invention is not restricted to above-described embodiment, all technical schemes adopting equivalent replacement or equivalence replacement to be formed all belong to the scope of protection of present invention.
Claims (3)
1. based on a telemetry real-time exhibition method for real-time data base, it is characterized in that, category-A data source table, category-B data source table, the control table of C class and real-time data base telemeter are set in Excel, wherein,
Described category-A data source table data are multi-field, and with feeder line and main transformer for major key;
Described category-B data source table data are few field, and category-B data source table is the base table of category-A data source table;
The control table of described C class controls the order that each field occurs in Excel table, ensures the correctness of category-B table synthesis category-A table;
Displaying table selects condition to select monitoring wire according to deleting of presetting, and automatic refresh data in real time.
2. method according to claim 1, is characterized in that, described category-B data source form is divided into two class forms, and first kind form does not comprise real time data, and it comprises the incidence relation of each circuit and specific fields; Equations of The Second Kind form contains the acquisition function of circuit certain electric parameters corresponding, and this function comprises real-time data base real time data calling interface.
3. method according to claim 1 and 2, is characterized in that, in Excel, each interactive interface is all generated by the built-in VBA of Excel.
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 true CN104317879A (en) | 2015-01-28 |
| CN104317879B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110297826A (en) * | 2019-05-31 | 2019-10-01 | 南京理工大学 | Method based on json dynamic analysis satellite telemetering data |
| CN112380284A (en) * | 2020-10-09 | 2021-02-19 | 华能国际电力股份有限公司上安电厂 | Power plant operation monitoring and alarming system based on SIS system and Excel platform |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050258806A1 (en) * | 2004-02-28 | 2005-11-24 | Universal Electronics Inc. | System and method for automatically synchronizing and acquiring content for battery powered devices |
| 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 |
-
2014
- 2014-10-21 CN CN201410564037.7A patent/CN104317879B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050258806A1 (en) * | 2004-02-28 | 2005-11-24 | Universal Electronics Inc. | System and method for automatically synchronizing and acquiring content for battery powered devices |
| 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 |
|---|
| 宋超: ""监控组态软件实时数据库的研究与应用"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 费东虎 等: ""基于海迅实时数据库的配电线路运行监视软件"", 《浙江电力》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110297826A (en) * | 2019-05-31 | 2019-10-01 | 南京理工大学 | Method based on json dynamic analysis satellite telemetering data |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104317879B (en) | 2018-01-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3913555A1 (en) | Power distribution network operation aided decision-making analysis system and method | |
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| CN105069690B (en) | A kind of grid operation data processing method | |
| CN105278373A (en) | Substation integrated information processing system realizing method | |
| CN104767280B (en) | One kind realizes Quadratic Imaginary loop visualization method in intelligent substation | |
| CN107835107B (en) | Measurement display system based on power grid measurement topology and WebGis | |
| CN102750406B (en) | Multi-version management method for model set and difference model-based power grid model | |
| CN107832533A (en) | A kind of real-time monitoring and displaying method and system of transformer station based on three-dimensional information model | |
| CN103970887B (en) | A kind of information flow display system and method based on GIS power distribution network figures | |
| CN102957205B (en) | A kind of method and system setting up electricity distribution network model | |
| CN103715767A (en) | Smart power grid information integration and display platform | |
| CN107256442B (en) | Line loss calculation method based on mobile client | |
| CN102123045A (en) | Modeling method for high-voltage equipment on-line monitoring systems based on international electro-technical commission (IEC) 61850 | |
| CN105046344B (en) | Master station data quality optimization method for support system of intelligent power grid scheduling technology | |
| CN106250449A (en) | A kind of electric network information superposition dynamic display method and device | |
| CN107862392B (en) | Equipment account management and control method based on power distribution network intelligent operation and maintenance management and control platform | |
| CN105447127A (en) | Failure outage range visualization system and method based on power distribution automation and marketing GIS | |
| CN101930481A (en) | Method used for generating CIM model describing power grid change in designated time slot and system thereof | |
| CN108520163A (en) | Three-dimensional net rack method for automatic modeling based on CIM model and SVG figures | |
| CN108153965A (en) | A kind of method that interval component based on SCD file automatically generates | |
| CN105528671A (en) | Power grid multidimensional sensing and safety assessment system and method on the basis of big data | |
| CN101916269B (en) | The generation method of power grid SVG graphic file, described graphic file and generation system | |
| CN102592175B (en) | A kind of power system line loss management analysis method and system | |
| CN104317879A (en) | Method for displaying telemetering data in real time on basis of real-time database | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard |
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 | ||
| 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 |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |