CN103631578B - Method for exhibiting data in a kind of distribution automation system - Google Patents

Abstract

The invention discloses a data display method in a distribution network automation system. The steps are: converting the SVG standard vector diagram into a C# object; analyzing the CIM file, that is, the public information model file, and mapping to each element of the lpf vector diagram; the lpf vector diagram Obtain the topological relationship of the measuring points from the relational database; embed the dynamic lpf into the JSP through the ActiveX control, and display the configuration diagram on the WEB page. The invention solves the problem of real-time display of data in the real-time database and relational database under the environment of the distribution network automation system, and completes the public information model analysis and SVG vector diagram conversion under the premise of ensuring that the existing distribution network system remains unchanged For the lpf graph in its own format, display the information in the lpf graph, and then embed javascript script and ActiveX control in the lpf graph to realize the real-time display of data in real-time database and relational database on JSP.

Description

A data display method in distribution network automation system

technical field

The invention belongs to the technical field of distribution network automation systems, in particular to a data display method in the distribution network automation system.

Background technique

Scalable Vector Graphics (Scalable Vector Graphics, SVG) is a graphic format based on Extensible Markup Language (XML) for describing two-dimensional vector graphics. SVG is developed by W3C and is an open standard.

The Document Object Model (DOM for short) is a standard programming interface recommended by the W3C organization for processing Extensible Markup Language.

ActiveX is Microsoft's name for a series of strategic object-oriented programming technologies and tools, the main technology of which is Component Object Model (COM). In networks with directory and other support, COM becomes Distributed COM (DCOM). When creating a program that includes ActiveX, the main job is the component, a program that can be self-sufficient to run anywhere in the ActiveX network (today's network mainly includes Windows and Mac). This component is the ActiveX control.

Common Information Model (CIM, Common Information Model) is a conceptual model for describing management information that has nothing to do with specific implementation. CIM is divided into two parts: CIM specification (CIM Specification) and CIM mode (CIM Schema). The CIM specification provides the formal definition of the model, which describes the language, naming, meta-mode and mapping technology to other management models (such as SNMP MIB); the CIM schema gives the description of the actual model. The CIM model consists of three layers: the core model, the public model and the extended model. The core model is a collection of a series of classes, connections, and attributes. This object group provides a common basic information model for all management domains; the public model provides a general information model for specific management domains. These specific management domains, such as systems, applications, Networks and devices, etc.; extended models represent technology-specific extensions of the general model.

The traditional distribution network system data display method is shown in Figure 1.

Java Applet is a small application program written in the Java language, usually directly embedded in a web page, which can produce special effects. A web page containing an Applet is called a Java-Powered page, and it can be called a Java-supported web page. JavaApplet can be used to display functions such as graphics drawing, font and color control, animation graphics browsing, historical curves, real-time alarms, etc. The curves show telemetry and telematics information or graphic element information from the database.

JSP (Java Server Pages) consists of HTML code and Java code embedded in it. Java Servlet is the technical basis of JSP, and the development of large-scale Web applications requires the cooperation of Java Servlet and JSP to complete. JSP has all the characteristics of Java technology, which is easy to use, completely object-oriented, platform-independent, safe and reliable, and mainly oriented to the Internet. In this way, the Java Applet application can be embedded into the JSP, and the historical curve or alarm information can be viewed on the page, and finally can be released uniformly with the container.

The Web module of the dispatching system often uses high-efficiency language processes such as C++ and Java Applets for database transmission by calling the Socket interface. High-level languages are often used to deal with transactions that require high efficiency and time effects, such as calling database data and modifying database data.

The above is the traditional data display method, and the data display method of this method cannot meet the real-time requirements of the current distribution network data.

Contents of the invention

In order to improve the real-time performance of data display of the distribution network system, combined with the characteristics of the distribution network system itself, the present invention provides a data display method that meets the real-time requirements and well combines the characteristics of the real-time database and the relational database itself.

Technical scheme of the present invention is:

A method for displaying data in a distribution network automation system, comprising the following steps:

(1) Convert SVG standard vector graphics to C# objects;

(2) Analyze the CIM file, that is, the public information model file, and map it to each element of the lpf vector diagram;

(3) The lpf vector diagram obtains the topological relationship of the measuring points from the relational database;

(4) Embed the dynamic lpf into the JSP through the ActiveX control, and display the configuration diagram in the WEB page.

Further, the step (1) specifically includes the following steps:

A. SVG standard vector graphics are analyzed in XML format to create XML DOM files;

B. Analyze the nodes in the XML DOM file, extract element attributes, and read them into memory;

C. Create a primitive object in the memory, then analyze the element attributes, and assign the attributes to the elements in the object;

D. Abstract the C# object description to obtain the drawing object in C#.

Further, the step (2) specifically includes the following steps:

A. The standard CIM file uses QT DOM to analyze the telemetry and telemetry point name and store it in the real-time database to establish a point with a unique ID;

B. C++ API interacts with the real-time database to obtain measuring point information and real-time/historical data information of the measuring point;

C and C# API execute managed code under the control of the runtime library, and obtain the interaction result between C++ API and real-time database by reading memory;

D. The lpf format configuration diagram obtains the public information model of the real-time database through C# API.

Further, the step (3) specifically includes the following steps:

A. Separate non-relational data information from relational data information in CIM, store non-relational data information in a real-time database, and store relational data information in a relational database;

B. The lpf format configuration diagram calls the relational library through ODBC to obtain the relational data information in the CIM.

Further, the step (4) specifically includes the following steps:

A. Static self-owned format lpf takes the initiative to obtain relational data information and non-relational data information from relational database and real-time database at regular intervals every second through the above method, and displays the information in lpf to realize image dynamics;

B. Embed the dynamic self-owned format lpf into the JSP through the self-written ActiveX control, and display the dynamic lpf as a part of the page.

The beneficial effects of the present invention are:

The invention solves the problem of real-time display of data in the real-time database and relational database under the environment of the distribution network automation system, and completes CIM (common information model) analysis, SVG (Scalable vector graphics) is converted into its own format lpf graphics, and then through the mapping association between its own format lpf and the real-time database relational database, the information stored in the real-time database and relational database is displayed in its own format lpf graphics, and then in its own format Embed javascript scripts and ActiveX controls in formatted lpf graphics, and finally realize real-time display of data in real-time databases and relational databases on JSP.

Description of drawings

Figure 1 is a diagram of the traditional distribution network system data display mode;

Figure 2 is the on-site implementation diagram of the data display mode of the distribution automation system.

detailed description

The present invention will be described in further detail below in conjunction with the accompanying drawings.

The invention is a data display method in the distribution network strictly following the function specification of the distribution network automation system. The technical scheme of the invention is mainly aimed at the method for displaying data of real-time database and relational database in the distribution network automation system.

Most manufacturers display standard SVG images on the page, but they also use custom-format image display, because they can customize image formats that are more in line with business characteristics according to unique business characteristics and editing tools. For example, the vector diagram in the format of lpf (proprietary format for describing two-dimensional vector graphics) is a vector diagram in its own format, which is generated by a specially customized configuration tool, which is mainly written in C#.

The data display method in a distribution network automation system of the present invention can be roughly divided into the following four steps:

SVG standard vector graphics converted to C# objects.

a. SVG standard vector graphics are analyzed in XML format to create XML DOM Document;

b. Analyze the nodes in the XML DOM Document, extract element attributes, and read them into the memory;

c. Create a primitive object in the memory, then analyze the element attributes, and assign the attributes to the elements in the object;

d. Abstract the C# object description to obtain the drawing object in C#.

Parse the CIM (Common Information Model) file and map it to each element of the lpf vector map.

a. The standard CIM file uses QT DOM to parse out the telemetry and telemetry point name and store it in the real-time database to establish a point with a unique ID;

b. C++ API interacts with the real-time database to obtain measuring point information and real-time/historical data information of the measuring point;

c. C# API executes managed code under the control of the runtime library, and obtains the interaction result between C++ API and real-time database by reading memory;

d. The lpf format configuration diagram obtains the public information model of the real-time database through C# API.

The lpf vector map obtains the topological relationship of measuring points from the relational database

a. Separate non-relational data information from relational data information in CIM, store non-relational data information in a real-time database, and store relational data information in a relational database;

b. The lpf format configuration diagram calls the relational library through ODBC to obtain the relational data information in the CIM.

Embed the dynamic lpf into the JSP through the ActiveX control, and display the configuration diagram in the WEB page.

c. Static self-owned format lpf takes the initiative to obtain relational data information and non-relational data information from relational database and real-time database at regular intervals every second, and displays the information in lpf to realize image dynamics;

d. Embed the dynamic self-owned format lpf into the JSP through the self-written ActiveX control, and display the dynamic lpf as a part of the page.

The biggest advantage of using its own format lpf compared to the svg display method based on java technology is that the SVG display graph parsed by JAVASAX needs to be updated on the entire page. The forwarding method cannot meet the requirements in terms of response speed, so for page display that requires high real-time performance, you can customize the way of graphic display and data display.

Accompanying drawing 2 is the on-site implementation diagram of the data display mode of the distribution automation system, and the specific description is as follows:

(1) The CIM file in the figure is parsed and stored in the real-time database through QT DOM, and the real-time database calls the C++ API, which is managed by the C# API.

(2) SVG factory site graphics analyze its XML elements to create a Dom Document, and then form a node, thereby extracting the element attributes in the node, then parsing it into a C# object description, and then abstracting it into a C# object.

(3) By calling the relational database ODBC to call its own format primitives or store custom primitives.

(4) Finally, combine the results of (1), (2) and (3) into a static self-owned format lpf, and then form a dynamic self-owned format lpf by calling the Javascrip script embedded in the self-owned format lpf (can be written according to requirements) , and then embedded into the JSP through the ActiveX control, thus completing the display of the distribution network automation system data.

When applying the data display method in the distribution network automation system proposed by the present invention, the support of JAVA, C++, and QT operating environments is required.

The implementation steps are as follows:

Step 1: Obtain the CIM file of the distribution network automation system, analyze and store it in the real-time database, so as to form the name of the grid measuring point (such as the current of a certain station).

Step 2: After a series of parsing and transformations, the plant and station map in SVG format forms a C# object.

Step 3: The key information of measuring points in the real-time database combined with the C# object and the primitive information of the relational database (such as the information of a switch knife on the plant and station diagram) are generated into a static self-owned format lpf graph.

Step 4: The static lpf graphic in its own format forms a dynamic lpf graphic in its own format by embedding javascript script.

Step 5: The dynamic own-format lpf graphics are embedded into the JSP through the ActiveX control, so that the data information of the distribution network automation system can be viewed in real time from the web page.

The data display method in the distribution network automation system of the present invention solves the problem of displaying the data in the real-time database and the relational database in real time under the environment of the distribution network system, and ensures that the existing distribution network system remains unchanged. Next, complete CIM (Common Information Model) analysis, SVG (Scalable Vector Graphics) conversion into its own format lpf graphics, and then through the mapping association between its own format lpf and real-time database relational database, the information stored in real-time database and relational database Display in the lpf graphics in its own format, and then embed javascript scripts and ActiveX controls in the lpf graphics in its own format, and finally realize the real-time display of data in real-time databases and relational databases on JSP.

The present invention has been described according to the on-site project embodiments, so all technical solutions obtained in the form of equivalent replacement or equivalent transformation fall within the protection scope of the present invention.

Claims (4)

1. method for exhibiting data in a kind of distribution automation system, comprises the steps：

(1) SVG normal vector figures are converted to C# objects；

(2) CIM files, i.e. common information model file is parsed, is mapped to lpf vectogram each elements；

(3) lpf vectograms obtain measuring point topological relation from relational database；

(4) dynamic lpf is embedded in JSP by ActiveX control, represents configuration figure in WEB page；

Step (1) specifically includes following steps：

A, SVG normal vector figure is analyzed in xml format, creates XML DOM files；

Node in B, analysis XML DOM files, extracts element property, reads in internal memory；

C, set up graphics primitive object in internal memory, then parse element property, by attribute assignment to object in element；

D, C# object factories are carried out abstract, obtain the drawing object in C#.

2. method for exhibiting data in a kind of distribution automation system according to claim 1, it is characterised in that：The step Suddenly (2) specifically include following steps：

A, standard CIM file parse remote measure and communication measuring point name using QT DOM and are stored in real-time data base, set up and contain unique ID Measuring point；

B, C++API and real-time data base are interacted, obtain measuring point information and measuring point in real time/historical data information；

C, C#API execute Managed Code under the control of Runtime Library, the friendship for obtaining C++API and real-time data base by rdma read Mutual result；

D, lpf form configuration figure obtains the common information model of real-time data base by C#API.

3. method for exhibiting data in a kind of distribution automation system according to claim 1, it is characterised in that：The step Suddenly (3) specifically include following steps：

A, by the non-relation data information in CIM and relation data unpack, non-relation data information is stored in real-time number According to storehouse, relation data information is stored in relational database；

B, lpf form configuration figure obtains the relation data information in CIM by ODBC call relations storehouse.

4. method for exhibiting data in a kind of distribution automation system according to claim 1, it is characterised in that：The step Suddenly (4) specifically include following steps：

A, static own timing form lpf each seconds by way of above-mentioned steps (2) and (3), actively from relational database with And in real-time data base, obtain relation data information and non-relation data information respectively, and information is shown in lpf, real Existing image mobilism；

B, the ActiveX control by independently writing, own for dynamic form lpf is embedded in JSP, as a part for the page, Dynamic lpf is shown.