Power distribution network operation management data fusion method based on XML method

Abstract

The invention discloses a power distribution network operation management data fusion method based on an XML (Extensible Markup Language) method, which comprises the following steps that: firstly, a lower-level power grid exports parameters and an operation region position in the operation management of a power distribution network in a local area as a standard XML exchange file, and an upper-level power distribution network management system imports an XML power distribution network operation point exchange file into a target geographic area; and according to the regional position of each operation point, determining fusion coordinates, and combining to obtain data corresponding to all operation points in the power distribution network operation management system, thereby solving the technical problems that the geographic positions of the operation points of the existing power distribution network are dispersed and the management system lacks unified communication and data format standards. A power distribution network employee can master more comprehensive operation conditions of the power distribution network, more rigorously perform networked and scientific management of the power distribution network operation, more comprehensively consider a data fusion method between power distribution network operation management systems, improve the management efficiency of the power distribution network, and improve the timeliness and scientificity of the power distribution network operation management.

Description

Technical Field

[0001] The invention belongs to the technical field of automatic control, and in particular relates to a distribution network operation management data fusion method based on XML method, which is applied to the fusion of distribution network data. Background Art

[0002] At present, the management mode of distribution network is usually a distribution network service network composed of dispersed operation points within the city. When conducting network management, it is necessary to summarize the operation data of different regions and different management units. Since the management system development units of units at all levels are different, there is a lack of unified network communication data standards between different systems, which also leads to technical difficulties in building a unified distribution network operation management system based on network transmission data.

[0003] The objects of distribution network operation management are geographically dispersed operation points and operation management processes. A unified data interface and data format are also required between various distribution network operation management systems. Since distribution network operations are mainly managed in counties within the city, this leads to the variability of distribution network operation management data. Due to the lack of effective data communication between substation data based on operation points and high-voltage system data, it is impossible to effectively integrate the dispersed operation points in the distribution network and the distribution network operation order data, resulting in the inability to effectively match the data. Manual classification and summary are required, which reduces the timeliness of distribution network operation management and increases cost expenditure. Summary of the invention

[0004] In view of the problems existing in the above-mentioned prior art, the present invention provides a distribution network operation management data fusion method based on the XML method. First, the lower-level power grid exports the parameters and operation regional locations in the distribution network operation management of the region into a standard XML exchange file, and the upper-level distribution network management system then imports the XML distribution network operation point exchange file into the target geographical area, determines the fusion coordinates according to the geographical location of each operation point, and obtains the data corresponding to all the operation points in the distribution network operation management system after combination; the distribution network operation management data fusion technology needs to comprehensively manage all the distribution network operation-related basic parameters of the operation points in each geographical area of ​​the distribution network, and after realizing the integration of the distribution network geographical multi-region operation management data, on the one hand, the distribution network operation management data can be distributedly maintained and centrally shared according to the dispatch of each operation point, reducing the workload of data interaction of each operation point; on the other hand, the distribution network practitioners can grasp a more comprehensive distribution network operation situation, more rigorously carry out the network and scientific management of the distribution network operation, more comprehensively consider the data fusion method between the distribution network operation management systems and improve the distribution network management efficiency, improve the timeliness and scientificity of the distribution network operation management, and solve the technical problems of the existing distribution network due to the dispersed geographical location of the operation points and the lack of unified communication and data format standards in the management system.

[0005] In order to achieve the above-mentioned purpose, the technical solution adopted by the present invention is: a distribution network operation management data fusion method based on the XML method, firstly, the lower-level power grid exports the parameters and operation area locations in the distribution network operation management of the region as a standard XML exchange file, and the upper-level distribution network management system then imports the XML distribution network operation point exchange file into the target geographical area, determines the fusion coordinates according to the geographical location of each operation point, and obtains the data corresponding to all the operation points in the distribution network operation management system after combination.

[0006] Further, the method specifically includes the following steps:

[0007] Obtaining the regional data and management data of distribution network operation points;

[0008] Extract metadata in XML format of work order attributes of a single distribution network operation point in the distribution network operation point regional data;

[0009] Converting the distribution network system operation work order in the distribution network operation point management data into text data, and extracting the geographical location of the distribution network operation work order in the text data;

[0010] The fusion position of each operation point is determined according to the geographical location of the distribution network operation work order, and the operation point work unit data and the distribution network operation work order geographical location are combined to obtain the data corresponding to all the operation points in the distribution network operation management system.

[0011] Furthermore, the regional data of the distribution network operation point:

[0012] Operation point data format: Operation point data is the file attributes of the power operation point of the distribution network system, including: data identification, operation point location, operation point category, operation point name, operation point model, fused latitude and fused longitude fields;

[0013] The distribution network operation point management data format is:

[0014] Distribution network operation process data format: including field explanation, field name, field type, data identifier, current process node, approver, approval opinion, operation cost and rejection opinion;

[0015] Distribution network operation sheet data format: Contains the data identification involved in the operation sheet, operation type, line name, operation date, contact person, contact phone number and operation and maintenance team.

[0016] Furthermore, the work point work unit data is composed of a plurality of fields in the corresponding work point work sheet in the work point data format.

[0017] Furthermore, the distribution network operation point management data is converted into text data, and the specific steps are as follows: construct a text conversion tool based on XML technology, input the operation point work order data in the distribution network operation system into the text conversion tool, the text conversion tool recognizes the data structure of the distribution network operation system operation work order, and the conversion component outputs the distribution network operation system operation work order as text data.

[0018] Furthermore, the distribution network operation point management data is stored in a relational database, specifically: a mapping relationship is established between the operation point keywords in the distribution network operation point management data and the table fields in the relational database, and the power diagram data is stored in the relational database.

[0019] Furthermore, after the distribution network operation management data is converted into text data in XML format, the operation point data is aggregated by modifying the geographic coordinate data of the operation point in the XML format.

[0020] The beneficial effects of the present invention are:

[0021] 1) Using the attribute information of the operation point data description file, the integration of distribution network operation management data based on the XML method is realized, which not only completes the decoupling of network transmission and storage of distribution network system operation work order data, but also retains the traditional application method of distribution network system based on structured operation database attribute retrieval;

[0022] 2) The geographic data of the operation points and the distribution network operation work order data are stored in XML format, and the data formats of the distribution network system operation work order collection, processing, information extraction, data fusion and storage are defined and standardized. The description structure of the distribution network system operation management data is unified, and a standardized general process for integrated distribution network operation management in XML format is constructed, providing a general method for distribution network operation data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a fusion block diagram of the independent operation points of the present invention;

[0024] Figure 2 It is a flow chart for generating structured data of XML distribution network operation management;

[0025] Figure 3 It is a fusion flow chart of independent operation points of the present invention;

[0026] Figure 4 This is a conversion diagram of the text conversion tool. DETAILED DESCRIPTION

[0027] In order to make the purpose, technical solution and advantages of the present invention more clear, the present invention is further described in detail below through the accompanying drawings and embodiments. However, it should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the scope of the present invention.

[0028] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by technicians in the technical field to which the present invention belongs. The terms used in the specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention.

[0029] like Figure 1-4 As shown, a distribution network operation management data fusion method based on the XML method is used. The lower-level operation point operation management system is analyzed by the database, and a standard XML database exchange file for communication is exported. The fusion coordinates are determined according to the geographical location of each operation point. After combination, the data corresponding to all the operation points in the distribution network operation management system are obtained to generate a complete distribution network operation point network diagram.

[0030] The distribution network operation point management data is stored in a relational database, specifically: a mapping relationship is established between the operation point keywords in the distribution network operation point management data and the table fields in the relational database, and the power diagram data is stored in the relational database.

[0031] The specific steps of the distribution network operation management data fusion method based on XML method are as follows:

[0032] S1. Obtain the regional data of the distribution network operation point and the management data of the distribution network operation point, and define the data format:

[0033] The regional data of distribution network operation points are unstructured data, and the management data of distribution network operation points are structured data.

[0034] S11. The data format of the operation point is defined as follows:

[0035] The operation point data described in this embodiment are file attributes of the power operation points of the distribution network system, such as data identification, operation point location, operation point category, operation point name, operation point model, fused latitude and fused longitude.

[0036] In order to ensure the flexibility and extensibility of the operation point data, this embodiment uses the XML format to store the operation point data. The key data format of the operation point is as follows:

[0037] Table 1 Structured data format based on key fields of operation points

[0038] Field Explanation Field Name Field Type Data Identification id integer Work point location POS string Work point category type string Work point name name string Operation point model model String Fusion Latitude latitude integer Fusion Longitude longitude integer

[0039]

[0040]

[0041] Among them, <record>The format file represents the data values ​​in all seven key fields as character data in the element. For each field, the TERMINATOR attribute indicates the terminator that follows the data value.

[0042] Among them, <row>element, the format file maps the id column to the first field, the pos column to the second field, the type column to the third field, the name column to the fourth field, the model column to the fifth field, the latitude column to the sixth field, and the longitude column to the seventh field.

[0043] Optimized, "id" is the unique identifier of the unstructured file and cannot be empty.

[0044] Optimized, in <record>In the element, the data fields correspond one-to-one to the columns in the table.

[0045] Optimized, the SQL statement view collation is SQL_Latin1_General_CP1_CI_AS.

[0046] S12. The data format of the distribution network operation process is defined as follows:

[0047] The operation process data required to be extracted from the operation process data of each operation point of the distribution network system is relatively consistent, including the data identifier involved in the operation process, the current process node, the approver, the approval opinion, the operation cost and the rejection opinion. The storage of the key structure data information of the operation process in the present invention is based on the XML format, which is as follows:

[0048] Table 2 Key structured data format of the operation process

[0049] Field Explanation Field Name Field Type Data Identification id integer Current process node node string Approver approver float Approval comments comment float Operating costs cost float Rejection of opinion rejection float

[0050]

[0051]

[0052] Among them, <record>The format file represents the data values ​​in all six key setting-related fields as character data in the element. For each field, the TERMINATOR attribute indicates the terminator that follows the data value.

[0053] Among them, <row>element, the format file maps the id column to the first field, the node column to the second field, the approve column to the third field, the comment column to the fourth field, the cost column to the fifth field, and the rejection column to the sixth field.

[0054] Optimized, "id" is the unique identifier of the unstructured file and cannot be empty.

[0055] Optimized, in <record>In the element, the data fields correspond one-to-one to the columns in the table.

[0056] Optimized, SQL statement view collation is SQL_Latin1_General_CP1_CI_AS.

[0057] S13. The format of the distribution network operation sheet is defined as follows:

[0058] The data types of the work order formats of each work point in the distribution network system are relatively consistent, including the data identifiers involved in the work order, the work type, the line name, the work date, the contact person, the contact person's phone number, and the operation and maintenance team. The present invention stores key information based on the XML format, as follows:

[0059] Table 3 Structured data format of distribution network operation order

[0060] Field Explanation Field Name Field Type Data Identification id integer Type of assignment jobtype integer Line Name route integer Operation Date jobdate integer Contact contactname integer Contact phone number contactphone integer Operation and maintenance team team integer

[0061]

[0062]

[0063] Among them, <record>The format file represents the parameter values ​​in all seven key setting principle related fields as character data in the element. For each field, the TERMINATOR attribute indicates the terminator that follows the data value.

[0064] Among them, the job type field is an integer, 1 means live connection, 2 means live disassembly, 3 means live repair, 4 means live fault elimination, 5 means live coordination, 6 means live fault elimination, 7 means account cancellation, and 8 means live load transfer.

[0065] Among them, <row>In the element, the format file maps the id column to the first field, the job type column to the second field, the route name column to the third field, the job date column to the fourth field, the contact name column to the fifth field, the contact phone column to the sixth field, and the team column to the seventh field.

[0066] Optimized, "id" is the unique identifier of the unstructured file and cannot be empty.

[0067] Optimized, in <record>In the element, the data fields correspond one-to-one to the columns in the table.

[0068] Optimized, SQL statement view collation is SQL_Latin1_General_CP1_CI_AS.

[0069] S2. Data processing:

[0070] S21. Operation point metadata extraction:

[0071] like Figure 3 As shown, the present embodiment extracts the metadata of the operation point by means of automatic extraction by program + manual verification and supplementation. The user can also customize the relevant metadata extraction method. The extracted data is stored in the metadata format defined in the "data definition link".

[0072] The automatic extraction process is as follows:

[0073] 1) Use the built-in functions of the programming language to obtain the database file name, file path, field name, number of fields, field type and other file attributes of unstructured data;

[0074] 2) Customize data import business rules; based on the business rules, generate data import sequence business type information through the classification model, such as line short-circuit current report and setting report, which belong to the business type of files. (This step is optional)

[0075] S3, Data Fusion:

[0076] like Figure 3 As shown, the data fusion method includes the following steps:

[0077] Select the operation point fusion file to be exported, determine the location to be imported in the distribution network operation general diagram, determine whether the operation point data needs to be imported, do not replace the operation points that need to be retained in the target area, replace the operation points that need to be deleted in the target area, and then compare the import file with the import data to retain the operation point data in the target area, and finally import the target operation point area and generate the integrated distribution network operation point fusion drawing.

[0078] Preferably, the work point data can be fully or partially exported according to the geographical scope.

[0079] Furthermore, there are two ways to import job management data: overwrite import and comparison import;

[0080] Preferably, the overwriting import does not take into account the operation point data in the target area, and the import file is imported as a whole into the target area;

[0081] Preferably, the overlay import operation does not require operator intervention, and each manual intervention window for the comparison import is not displayed, and the operation point data in the import file will be completely imported into the selected geographic target area.

[0082] Preferably, the import process automatically performs comparison and matching between the imported file and the work points within the geographic target area, and provides a window for the operator to perform manual intervention.

[0083] S4, Data Storage

[0084] The structured data obtained in this embodiment is based on the XML format, and the name therein is matched one-to-one with the table field name in the database, or a one-to-many or many-to-one mapping relationship is established, so that the structured data is stored in the relational database.

[0085] In particular, special handling is provided for the following situations:

[0086] 1. The metadata and key information of the work site obtained in this embodiment may have a multi-layer nested structure based on the XML format. For such a situation, the nested data can be stored in a field of the database table in the XML format, or the nested information can be mapped to another database table.

[0087] 2. The same type of operation points in the key information have a unique ID, and the same data may have multiple identical values ​​or different values; for multiple identical values, take one value and store it in the corresponding field of the database table; for multiple different values, all are stored in the corresponding field of the database table in a certain format.

[0088] 3. The key information is the coordinate information in the original unstructured data. Generally, there is no need to store the geographic coordinate information of the work point in the database table. The user can decide whether to store the coordinate information as needed.

[0089] The above description is only an embodiment of the present application and does not limit the patent scope of the present application. Any equivalent structure or equivalent process transformation made using the contents of the present application specification and drawings, or directly or indirectly used in other related technical fields, are also included in the patent protection scope of the present application.< / record> < / row> < / record> < / record> < / row> < / record> < / record> < / row> < / record>

Claims

1. A distribution network operation management data fusion method based on XML method, characterized in that: First, the lower-level power grid exports the parameters and operation area locations in the distribution network operation management of the region as a standard XML exchange file. The upper-level distribution network management system then imports the XML distribution network operation point exchange file into the target geographical area, determines the fusion coordinates according to the geographical location of each operation point, and obtains the data corresponding to all the operation points in the distribution network operation management system after combination.

2. The method for fusion of distribution network operation management data based on XML method according to claim 1 is characterized in that: The specific steps include: Obtaining the regional data and management data of distribution network operation points; Extract metadata in XML format of work order attributes of a single distribution network operation point in the distribution network operation point regional data; Converting the distribution network system operation work order in the distribution network operation point management data into text data, and extracting the geographical location of the distribution network operation work order in the text data; The fusion position of each operation point is determined according to the geographical location of the distribution network operation work order, and the operation point work unit data and the distribution network operation work order geographical location are combined to obtain the data corresponding to all the operation points in the distribution network operation management system.

3. The method for fusion of distribution network operation management data based on XML method according to claim 2 is characterized in that: The distribution network operation point regional data: Operation point data format: Operation point data is the file attributes of the power operation point of the distribution network system, including: data identification, operation point location, operation point category, operation point name, operation point model, fused latitude and fused longitude fields; The distribution network operation point management data format is: Distribution network operation process data format: including field explanation, field name, field type, data identifier, current process node, approver, approval opinion, operation cost and rejection opinion; Distribution network operation sheet data format: Contains the data identification involved in the operation sheet, operation type, line name, operation date, contact person, contact phone number and operation and maintenance team.

4. The method for fusion of distribution network operation management data based on XML method according to claim 3 is characterized in that: The work point work unit data is composed of a plurality of fields in the corresponding work point work sheet in the work point data format.

5. The method for fusion of distribution network operation management data based on XML method according to claim 2 is characterized in that: The distribution network operation point management data is converted into text data, and the specific steps are as follows: construct a text conversion tool based on XML technology, input the operation point work order data in the distribution network operation system into the text conversion tool, the text conversion tool recognizes the data structure of the distribution network operation system operation work order, and the conversion component outputs the distribution network operation system operation work order as text data.

6. The method for fusion of distribution network operation management data based on XML method according to claim 5 is characterized in that: After the distribution network operation management data is converted into text data in XML format, the operation point data is summarized by modifying the geographic coordinate data of the operation point in XML format.

Images