A method and device for data structuring processing of a CIM model

By converting the EAP file of the CIM model into an xsd file and configuring dependencies in the development environment, creating data conversion classes and Excel workbooks, the problems of large workload and high error rate of manual modeling of CIM models are solved, and more efficient data structured processing is achieved.

CN113742409BActive Publication Date: 2025-07-08GUANGZHOU POWER SUPPLY BUREAU GUANGDONG POWER GRID CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202111033742.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-03
Publication Date
2025-07-08
Estimated Expiration
2041-09-03

AI Technical Summary

Technical Problem

When establishing structured data structures in existing CIM models, manual modeling is huge and conversion errors are prone to occur.

Method used

By obtaining the EAP file of the CIM model's supporting modeling tool file, converting it into a document structure description xsd file, building development environment configuration dependencies, establishing a CIM structured data model, creating a data conversion class and naming it, and obtaining and adding the target xsd file to the Excel workbook.

Benefits of technology

Simplifies the conversion process from CIM model to structured data, reduces the workload of manual operations and reduces the error rate.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113742409B_ABST
    Figure CN113742409B_ABST
Patent Text Reader

Abstract

The present invention discloses a method and apparatus for data structuring processing of a CIM model, which are used to solve the technical problems that the existing CIM model for establishing a structured data structure has a huge workload based on manual modeling and is prone to conversion errors. The present invention includes: obtaining a supporting modeling tool file EAP file of a preset CIM model; converting the EAP file into a document structure description xsd file; building a development environment configuration dependency based on the xsd file; establishing a CIM structured data model based on the development environment configuration dependency; creating a data conversion class, and naming and numbering the fields in the CIM structured data model based on the data conversion class; creating an xld file object, and creating a global workbook object wb and a worksheet object sheet of the wb; obtaining a target xsd file from the CIM structured data model; adding the target xsd file into the sheet; and inputting the data of the wb into the xld file corresponding to the xld object.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data structured processing, and particularly to a method and device for data structured processing of a CIM model. Background Art

[0002] As an application program interface of an energy management system, the Common Information Model (CIM) provides a standard specification for power system data interaction and has important application value. Establishing a structured data structure based on the CIM model is the basis of engineering applications; however, most of the basic materials of the CIM model are in PDF format, such as the IEC 61968 and IEC 61970 standards, and the CIM model contains numerous classes and attributes, and the association relationships between classes and between classes and attributes are complex. The direct manual modeling workload is extremely large and conversion errors are likely to occur. Summary of the Invention

[0003] The present invention provides a method and device for data structured processing of a CIM model, which are used to solve the technical problems that the existing manual modeling for establishing a structured data structure based on the CIM model has a huge workload and is prone to conversion errors.

[0004] The present invention provides a method for data structured processing of a CIM model, including:

[0005] Obtaining a supporting modeling tool file EAP file of a preset CIM model;

[0006] Converting the EAP file into a document structure description xsd file;

[0007] Building a development environment configuration dependency based on the xsd file;

[0008] Establishing a CIM structured data model based on the development environment configuration dependency;

[0009] Creating a data conversion class, and naming and numbering the fields in the CIM structured data model based on the data conversion class;

[0010] Creating an xld file object, and creating a global workbook object wb and a worksheet object sheet of the wb;

[0011] Obtaining a target xsd file from the CIM structured data model;

[0012] Adding the target xsd file into the sheet;

[0013] Inputting the data of the wb into the xld file corresponding to the xld object.

[0014] Optionally, the step of adding the target xsd file into the sheet includes:

[0015] Load the target xsd file and obtain the root node;

[0016] Extract the package name from the target xsd file and obtain the package comment based on the root node;

[0017] Write the package name and the package comment into the sheet;

[0018] Obtain class data based on the root node and write the class data into the sheet;

[0019] Obtain enumeration data based on the root node and write the enumeration data into the sheet.

[0020] Optionally, the step of obtaining class data based on the root node and writing the class data into the sheet includes:

[0021] Obtain the complexType element of the root node;

[0022] Obtain the class name and class comment of the complexType element;

[0023] Write the class name and the class comment into the sheet.

[0024] Optionally, the step of obtaining enumeration data based on the root node and writing the enumeration data into the sheet includes:

[0025] Obtain the simpleType element of the root node;

[0026] Obtain the attribute type of the simpleType element and write the attribute type into the sheet.

[0027] The present invention further provides a data structuring processing device for a CIM model, including:

[0028] An EAP file acquisition module, configured to acquire an EAP file, which is a supporting modeling tool file of a preset CIM model;

[0029] An xsd file conversion module, configured to convert the EAP file into a document structure description xsd file;

[0030] A development environment configuration dependency construction module, configured to build development environment configuration dependencies based on the xsd file;

[0031] The CIM structured data model building module is used to build a CIM structured data model based on the development environment configuration dependencies;

[0032] The data conversion class creation module is used to create a data conversion class and number the fields in the CIM structured data model based on the data conversion class;

[0033] The xld file object creation module is used to create an xld file object, and create a global workbook object wb and a worksheet object sheet of the wb;

[0034] The target xsd file acquisition module is used to acquire a target xsd file from the CIM structured data model;

[0035] The addition module is used to add the target xsd file into the sheet;

[0036] The input module is used to input the data of the wb into the xld file corresponding to the xld object.

[0037] Optionally, the addition module includes:

[0038] The root node acquisition sub-module is used to load the target xsd file and acquire the root node;

[0039] The package name and package comment acquisition sub-module is used to extract the package name from the target xsd file and acquire the package comment based on the root node;

[0040] The package name and package comment writing sub-module is used to write the package name and the package comment into the sheet;

[0041] The class data writing sub-module is used to acquire class data based on the root node and write the class data into the sheet;

[0042] The enumeration data writing sub-module is used to acquire enumeration data based on the root node and write the enumeration data into the sheet.

[0043] Optionally, the class data writing sub-module includes:

[0044] The complexType element acquisition unit is used to acquire the complex complexType element of the root node;

[0045] The class name and class comment acquisition unit is used to acquire the class name and class comment of the complexType element;

[0046] The class name and class comment writing unit is used to write the class name and the class comment into the sheet.

[0047] Optionally, the enumerated data writing sub-module includes:

[0048] A simpleType element obtaining unit, configured to obtain the simpleType element of the root node;

[0049] An attribute type writing unit, configured to obtain the attribute type of the simpleType element and write the attribute type into the sheet.

[0050] The present invention also provides an electronic device, which includes a processor and a memory:

[0051] The memory is used to store program code and transmit the program code to the processor;

[0052] The processor is configured to execute the data structuring processing method of the CIM model described in any one of the above according to the instructions in the program code.

[0053] The present invention also provides a computer-readable storage medium, which is used to store program code, and the program code is used to execute the data structuring processing method of the CIM model described in any one of the above.

[0054] It can be seen from the above technical solutions that the present invention has the following advantages: The present invention obtains the supporting modeling tool file EAP file of the preset CIM model; converts the EAP file into a document structure description xsd file; builds the development environment configuration dependencies based on the xsd file; establishes a CIM structured data model based on the development environment configuration dependencies; creates a data conversion class, and names and numbers the fields in the CIM structured data model based on the data conversion class; creates a sheet; obtains the target xsd file from the CIM structured data model; and adds the target xsd file into the sheet. This simplifies the process of converting the CIM model into structured data. Description of the Drawings

[0055] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for use in the description of the embodiments or the prior art. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0056] Figure 1 It is a step flow chart of a data structuring processing method of a CIM model provided by an embodiment of the present invention;

[0057] Figure 2 Block diagram of a data structuring processing device for a CIM model provided by an embodiment of the present invention. Specific embodiments

[0058] Embodiments of the present invention provide a data structuring processing method and device for a CIM model, which are used to solve the technical problems that the existing establishment of a structured data structure for a CIM model is based on manual modeling with a huge workload and is prone to conversion errors.

[0059] In order to make the objectives, features, and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the embodiments described below are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0060] Please refer to Figure 1 , Figure 1 Flowchart of the steps of a data structuring processing method for a CIM model provided by an embodiment of the present invention.

[0061] A data structuring processing method for a CIM model provided by an embodiment of the present invention includes:

[0062] Step 101: Obtain the supporting modeling tool file EAP file of the preset CIM model;

[0063] Step 102: Convert the EAP file into a document structure description xsd file;

[0064] In the embodiments of the present invention, Enterprise Architect software can be used to convert the CIM supporting EAP data file into an xsd file. For example, use Enterprise Architect software to open the supporting EAP data file iec61970cim17v23_iec61968cim13v11_iec62325cim03v14.eap of CIM; expand and select each package in sequence in the left Project area. For each package: click the Develop menu, click "Export XSD" in the Schema Modeling menu area, select the Encoding method in the pop-up dialog box, specify the location of the generated file, and click the Generate button to generate the xsd file.

[0065] Step 103: Build the development environment configuration dependencies based on the xsd file;

[0066] In practical applications, the development environment configuration dependencies can be set up according to the actual development environment. For example, based on the Java platform, the Eclipse development environment is used; the Maven dependency management environment is set up, and a Maven Project is created; in the pom.xml file, the dom4j dependency is configured to support reading xsd files in xml format, the poi dependency is configured to support reading and writing xls files of Excel, and jna is configured to support related plugins.

[0067] Step 104: Establish a CIM structured data model based on the development environment configuration dependencies;

[0068] In the embodiment of the present invention, after setting up the development environment configuration dependencies, a CIM structured data model can be established, and its fields include package name, class name, base class, attribute name, attribute type, minimum number of attributes, maximum number of attributes, value, and comment.

[0069] Step 105: Create a data conversion class, and number and name the fields in the CIM structured data model based on the data conversion class;

[0070] In the embodiment of the present invention, after establishing the CIM structured data model, a data conversion class Eaxsd2Xls can be created. For example, declare a static integer variable row number rownum and initialize it to 0, and number and name the CIM structured data fields, such as package name (PAC_NAME_IDX = 0), class name (CLA_NAME_IDX = 1), base class (BASE_IDX = 2), attribute name (PRO_NAME_IDX = 3), attribute type (PRO_TYPE_IDX = 4), minimum number of attributes (PRO_MIN_IDX = 5), maximum number of attributes (PRO_MAX_IDX = 6), value (VALUE_IDX = 7), and comment (ANN_IDX = 8).

[0071] Step 106: Create an xld file object, and create a global workbook object wb and a worksheet object sheet of wb;

[0072] In the embodiment of the present invention, after creating the data conversion class, an xls file object can be created. Depending on poi, create a global HSSFWorkbook object wb, create a global HSSFSheet object sheet based on wb and set the form name such as "CIM"; set the table header, such as adding the CIM structured data fields to the first row of sheet in sequence, and the static integer variable row number rownum is incremented by 1.

[0073] Step 107: Obtain the target xsd file from the CIM structured data model;

[0074] Next, obtain all xsd files in the specified directory. For example, based on the input xsd file directory, traverse each subdirectory in turn, and use the recursive method for the subdirectories to finally find all target xsd files.

[0075] Step 108, add the target xsd file to the sheet;

[0076] After determining the target xsd file, the target xsd file can be written into the sheet.

[0077] Among them, step 108 may include the following sub-steps:

[0078] S11, load the target xsd file and obtain the root node;

[0079] S12, extract the package name from the target xsd file and obtain the package comment based on the root node;

[0080] S13, write the package name and the package comment into the sheet;

[0081] S14, obtain the class data based on the root node and write the class data into the sheet;

[0082] S15, obtain the enumeration data based on the root node and write the enumeration data into the sheet.

[0083] Furthermore, step S14 may include the following sub-steps:

[0084] S141, obtain the complexType complex type element of the root node;

[0085] S142, obtain the class name and class comment of the complexType element;

[0086] S143, write the class name and class comment into the sheet.

[0087] Step S15 may include the following sub-steps:

[0088] S151, obtain the simpleType simple type element of the root node;

[0089] S152, obtain the attribute type of the simpleType element and write the attribute type into the sheet.

[0090] In practical applications, writing the data of each xsd file into the sheet specifically includes the following steps:

[0091] 1) Construct an Eaxsd2Xls instance using the file path and sheet. Rely on dom4j to create a SAXReader object reader, and use the read() method of reader to load the xsd file into a Document instance. Obtain the root node rootElement through the Document instance.

[0092] 2) Write the package name and package comment. Based on the file path, extract the name of the end folder as the package name; based on the rootElement nested structure, obtain the documentation element of the annotation as the package comment. Create a row based on the sheet, and create cell objects for the package name and package comment respectively, and add the package name and package comment to the cells respectively; increment the static integer variable row number rownum by 1.

[0093] 3) Write class data. Use the element list to obtain all complexType elements in the root node rootElement, traverse the element list, and process the elements using step 5).

[0094] 4) Write enumeration data. Use the element list to obtain all simpleType elements in the root node rootElement, traverse the element list, and process the elements using step 5).

[0095] 5) Write the class name and class comment. Obtain the value of the element attribute name as the class name; based on the element nested structure, obtain the documentation element of the annotation as the class comment. Create a row based on the sheet, and create cell objects for the class name and class comment respectively, and add the class name and class comment to the cells respectively; increment the static integer variable row number rownum by 1.

[0096] Write the inherited class attribute. Based on the element nested structure, obtain the extension sub - element of complexContent and store it in the ext variable. Obtain the value of the ext attribute base as the inherited class. Create a row based on the sheet, create a cell object for the inherited class, and add the inherited class to the cell; increment the static integer variable row number rownum by 1. Based on the element list of the element of sequence nested in ext, traverse the element list and process its elements using step 6).

[0097] Write non - inherited classes. Based on the element list of the element of sequence nested in the element, traverse the element list and process its elements using step 6).

[0098] Write an enumeration class. Obtain the child element restriction of the element and store it in the variable res. The value of the base attribute of res is the attribute type. Create a row based on the sheet, create a cell object for the attribute type, and add the attribute type to the cell; the static integer variable row number rownum is incremented by 1. Obtain the element list of enumeration based on res, traverse the element list, and process its elements using step 6).

[0099] Return the call.

[0100] 6) Process basic elements. Create a row based on the sheet.

[0101] If the element contains the name attribute, create a cell object for the attribute name and use the attribute value as the cell content; if the element contains the type attribute, create a cell object for the attribute type and use the attribute value as the cell content; if the element contains the minOccurs attribute, create a cell object for the minimum number of attributes and use the attribute value as the cell content; if the element contains the maxOccurs attribute, create a cell object for the maximum number of attributes and use the attribute value as the cell content; if the element contains the value attribute, create a cell object for the value and use the attribute value as the cell content.

[0102] Based on the element nesting, obtain the documentation element of annotation, which is the attribute annotation, create a comment cell and set its value; the static integer variable row number rownum is incremented by 1.

[0103] Return the call.

[0104] Step 109, input the data of wb into the xld file corresponding to the xld object.

[0105] In practical applications, the storage path and name of the xls file can be specified, and a file output stream is created accordingly. Call the write() method of the HSSFWorkbook object wb in poi to output the data to the file output stream, and then close the file output stream and wb in sequence to complete the structured xls file storage of CIM data.

[0106] The present invention simplifies the process of converting a CIM model into structured data by obtaining a supporting modeling tool file (EAP file) of a preset CIM model, converting the EAP file into a document structure description (xsd file), building development environment configuration dependencies based on the xsd file, establishing a CIM structured data model based on the development environment configuration dependencies, creating a data conversion class, naming and numbering the fields in the CIM structured data model based on the data conversion class, creating a sheet, obtaining a target xsd file from the CIM structured data model, and adding the target xsd file to the sheet.

[0107] Please refer to Figure 2 , Figure 2 which is a structural block diagram of a device for processing the data structuring of a CIM model provided by an embodiment of the present invention.

[0108] An embodiment of the present invention provides a device for processing the data structuring of a CIM model, including:

[0109] An EAP file acquisition module 201, configured to acquire a supporting modeling tool file (EAP file) of a preset CIM model;

[0110] An xsd file conversion module 202, configured to convert the EAP file into a document structure description (xsd file);

[0111] A development environment configuration dependency construction module 203, configured to build development environment configuration dependencies based on the xsd file;

[0112] A CIM structured data model establishment module 204, configured to establish a CIM structured data model based on the development environment configuration dependencies;

[0113] A data conversion class creation module 205, configured to create a data conversion class and name and number the fields in the CIM structured data model based on the data conversion class;

[0114] An xld file object creation module 206, configured to create an xld file object and create a global workbook object wb and a worksheet object sheet of wb;

[0115] A target xsd file acquisition module 207, configured to acquire a target xsd file from the CIM structured data model;

[0116] An addition module 208, configured to add the target xsd file to the sheet;

[0117] An input module 209, configured to input the data of wb into the xld file corresponding to the xld object.

[0118] In the embodiment of the present invention, the addition module 208 includes:

[0119] The root node acquisition sub-module is used to load the target xsd file and acquire the root node;

[0120] The package name and package comment acquisition sub-module is used to extract the package name from the target xsd file and acquire the package comment based on the root node;

[0121] The package name and package comment writing sub-module is used to write the package name and package comment into the sheet;

[0122] The class data writing sub-module is used to acquire class data based on the root node and write the class data into the sheet;

[0123] The enumeration data writing sub-module is used to acquire enumeration data based on the root node and write the enumeration data into the sheet.

[0124] In an embodiment of the present invention, the class data writing sub-module includes:

[0125] The complexType element acquisition unit is used to acquire the complex complexType element of the root node;

[0126] The class name and class comment acquisition unit is used to acquire the class name and class comment of the complexType element;

[0127] The class name and class comment writing unit is used to write the class name and class comment into the sheet.

[0128] In an embodiment of the present invention, the enumeration data writing sub-module includes:

[0129] The simpleType element acquisition unit is used to acquire the simple type simpleType element of the root node;

[0130] The attribute type writing unit is used to acquire the attribute type of the simpleType element and write the attribute type into the sheet.

[0131] An embodiment of the present invention further provides an electronic device, which includes a processor and a memory:

[0132] The memory is used to store program codes and transmit the program codes to the processor;

[0133] The processor is used to execute the data structuring processing method of the CIM model in the embodiment of the present invention according to the instructions in the program codes.

[0134] An embodiment of the present invention further provides a computer-readable storage medium, which is used to store program codes, and the program codes are used to execute the data structuring processing method of the CIM model in the embodiment of the present invention.

[0135] Those skilled in the art can clearly understand that, for the convenience and conciseness of description, the specific working processes of the systems, devices, and units described above can refer to the corresponding processes in the foregoing method embodiments and will not be elaborated herein.

[0136] Each embodiment in this specification is described in a progressive manner. Each embodiment focuses on the differences from other embodiments. For the same or similar parts among the various embodiments, reference can be made to each other.

[0137] Those skilled in the art should understand that the embodiments of the present invention can be provided as methods, devices, or computer program products. Therefore, the embodiments of the present invention can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Moreover, the embodiments of the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0138] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of methods, terminal devices (systems), and computer program products according to the embodiments of the present invention. It should be understood that each flow and / or block in the flowchart and / or block diagram, as well as the combination of flows and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing terminal devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing terminal devices generate a device for implementing the specified functions in Figure 1 one process or multiple processes and / or blocks Figure 1 one block or multiple blocks.

[0139] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal device to work in a specific manner, such that the instructions stored in the computer-readable memory generate a manufactured article including an instruction device that implements the specified functions in Figure 1 one process or multiple processes and / or blocks Figure 1 one block or multiple blocks.

[0140] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal device, such that a series of operation steps are executed on the computer or other programmable terminal device to generate a computer-implemented process. Thus, the instructions executed on the computer or other programmable terminal device provide for implementing the specified functions in Figure 1 one process or multiple processes and / or blocksFigure 1 Steps of the functions specified in one or more boxes.

[0141] Although the preferred embodiments of the embodiments of the present invention have been described, those skilled in the art can make additional changes and modifications to these embodiments once they know the basic creative concept. Therefore, the appended claims are intended to be construed as including the preferred embodiments and all changes and modifications falling within the scope of the embodiments of the present invention.

[0142] Finally, it should also be noted that in this text, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the term "comprising", "including" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article or terminal device comprising a series of elements not only includes those elements, but also includes other elements not expressly listed, or also includes elements inherent to such process, method, article or terminal device. Without further limitation, an element defined by the statement "comprising an..." does not exclude the existence of additional identical elements in the process, method, article or terminal device comprising the element.

[0143] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions recorded in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for data structuring processing of a CIM model, characterized in that including: Obtain the supporting modeling tool file EAP file of the preset CIM model; Convert the EAP file into a document structure description xsd file; Build the development environment configuration dependencies based on the xsd file; Establish a CIM structured data model based on the development environment configuration dependencies; Create a data conversion class, and name and number the fields in the CIM structured data model based on the data conversion class; Create an xld file object, and create a global workbook object wb and a worksheet object sheet of the wb; Obtain the target xsd file from the CIM structured data model; Add the target xsd file to the sheet; Input the data of the wb into the xld file corresponding to the xld file object.

2. The method according to claim 1, wherein The step of adding the target xsd file to the sheet includes: Load the target xsd file and obtain the root node; Extract the package name from the target xsd file, and obtain the package comment based on the root node; Write the package name and the package comment into the sheet; Obtain the class data based on the root node, and write the class data into the sheet; Obtain the enumeration data based on the root node, and write the enumeration data into the sheet.

3. The method according to claim 2, wherein The step of obtaining the class data based on the root node and writing the class data into the sheet includes: Obtain the complexType element of the root node; Obtain the class name and class comment of the complexType element; Write the class name and the class comment into the sheet.

4. The method according to claim 2, wherein The step of obtaining the enumeration data based on the root node and writing the enumeration data into the sheet includes: Obtain the simpleType element of the root node; Obtain the attribute type of the simpleType element, and write the attribute type into the sheet.

5. A data structuring processing device for a CIM model, characterized in that, including: An EAP file acquisition module, used to obtain the supporting modeling tool file EAP file of the preset CIM model; An xsd file conversion module, used to convert the EAP file into a document structure description xsd file; A development environment configuration dependency construction module, used to build the development environment configuration dependencies based on the xsd file; A CIM structured data model establishment module, used to establish a CIM structured data model based on the development environment configuration dependencies; A data conversion class creation module, used to create a data conversion class, and name and number the fields in the CIM structured data model based on the data conversion class; An xld file object creation module, used to create an xld file object, and create a global workbook object wb and a worksheet object sheet of the wb; A target xsd file acquisition module, used to obtain the target xsd file from the CIM structured data model; An addition module, used to add the target xsd file to the sheet; An input module, used to input the data of the wb into the xld file corresponding to the xld file object.

6. The device according to claim 5, wherein The adding module includes: A root node acquisition sub-module, configured to load the target xsd file and acquire the root node; A package name and package comment acquisition sub-module, configured to extract the package name from the target xsd file and acquire the package comment based on the root node; A package name and package comment writing sub-module, configured to write the package name and the package comment into the sheet; A class data writing sub-module, configured to acquire class data based on the root node and write the class data into the sheet; An enumeration data writing sub-module, configured to acquire enumeration data based on the root node and write the enumeration data into the sheet.

7. The device according to claim 6, characterized in that, The class data writing sub-module includes: A complexType element acquisition unit, configured to acquire the complexType element of the root node; A class name and class comment acquisition unit, configured to acquire the class name and the class comment of the complexType element; A class name and class comment writing unit, configured to write the class name and the class comment into the sheet.

8. The device according to claim 6, wherein The enumeration data writing sub-module includes: A simpleType element acquisition unit, configured to acquire the simple type simpleType element of the root node; An attribute type writing unit, configured to acquire the attribute type of the simpleType element and write the attribute type into the sheet.

9. An electronic device, characterized in that, The device includes a processor and a memory: The memory is configured to store program code and transmit the program code to the processor; The processor is configured to execute the data structuring processing method of the CIM model according to the instructions in the program code as recited in any one of claims 1-4.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium is configured to store program code, and the program code is configured to execute the data structuring processing method of the CIM model according to the instructions in the program code as recited in any one of claims 1-4.

Citation Information

Patent Citations

  • A method for building power grid big data warehouse based on CIM model

    CN109492055A

  • Data analysis method and device of CIM model and storage medium

    CN112230929A