CN102855310B - Well-organized electricity utilization data conversion method and device based on extensible customer segmentation model - Google Patents

Abstract

The invention relates to a method and device for converting ordered power consumption data based on an extensible user subdivision model, which are used to solve the problem of automatic conversion from file data of a user power consumption information collection system to ordered power consumption file data. It includes the following steps: A. Import the UML-based subdivision model of the initial user, and express the main objects in the orderly power consumption management system as classes, attributes and the relationship between them; B. Extend the user subdivision model; C Convert the user segmentation model based on UML format into an RDF Schema document; D According to the definition of the RDF Schema document, convert the archive data of the electricity consumption information collection system into an XML format orderly power consumption management system archive model exchange document; Eorderly The power consumption management system refers to the RDF Schema document to analyze the orderly power consumption management file data in XML format and extract the information.

Description

Orderly power consumption data conversion method and device based on scalable user segmentation model

technical field

The invention relates to the field of power system data conversion, and more specifically, the invention relates to a method and device for orderly power consumption data conversion based on an extensible user segmentation model.

Background technique

With the development of the power system towards high voltage, large power grid, and high automation, and the marketization of the power industry, the demand for enterprise-level and industry-level information sharing and application integration is becoming more and more urgent. Various automation system applications are constantly emerging, and their data conversion requirements cover different levels, all of which require convenient and flexible information sharing.

In the orderly power consumption management platform, the object of load control does not directly correspond to the metering point of the power user's electricity consumption information collection system, and the customer files and metering files are not exactly the same. In order to realize multi-dimensional load data analysis on the orderly power consumption management platform, to fully grasp the development status of orderly power consumption business in real time, and to provide support for the decision-making of orderly power consumption schemes, it is necessary to build a user classification model to achieve specific user segmentation and reasonable Determine the user object and load control object of the orderly power consumption plan to adapt to the deepening application of orderly power consumption management.

But the user segmentation model is just an abstract model, which neither defines the specification of the model database nor the format of data exchange. In the project, it is necessary to make clear and feasible regulations on the realization of the user segmentation model.

At the same time, during the operation of the orderly power consumption management platform in the later period, the user segmentation model may change. For this reason, a method that supports the expansion of the user segmentation model and can realize the automatic conversion of orderly power consumption data is needed.

Contents of the invention

The purpose of the present invention is to solve the above problems, and propose a method for converting ordered electricity consumption data based on an extensible user subdivision model, and finally achieve effective conversion from user electricity information collection system files to ordered electricity consumption files.

To achieve the above object, the present invention adopts the following technical solutions:

A sequential electricity consumption data conversion method based on an extensible user segmentation model, the implementation steps are as follows:

A imports the UML-based subdivision model of the initial user, and expresses the main objects in the ordered power consumption management system as classes, attributes and the relationship between them;

B expands the user segmentation model;

C converts the UML-based user segmentation model into an RDF Schema document;

D According to the definition of the RDF Schema document, the file data of the power consumption information collection system is converted into an orderly power consumption management system file model exchange document in XML format;

E The orderly power consumption management system refers to the RDF Schema document to analyze the orderly power consumption management file data in XML format and extract the information.

In the step B, the expansion of the user segmentation model is mainly completed by defining different namespaces to expand new classes and attributes, using independent namespaces, and clearly distinguishing the XML documents of the user segmentation model into user segmentation model standards and user defined.

The user segmentation model conversion process in the step C is:

C1. Initialization, select a class related to other classes in the user segmentation model as the root element, and map it to the root of RDF Schema ∑={root}, the type of the root is recorded as type _root , Γ={type _root }, the attribute of the root is mapped to the sub-element sequence ∑={{root}, ∑ _root } under type _root , then the root node element is expressed as {∑, Γ, type _root , ∑ _root };

C2. Map a class in the user segmentation model to the top element i in the RDF Schema, denoted as ε _i , then ∑={ε _i }, its type is mapped to complexType, denoted as τ, then Γ={τ }, the attribute type of the class is mapped to the same data type existing in RDF Schema, which is recorded as type _τ , and the i element node is expressed as {∑, Γ, τ, type _τ };

C3. If there is a data type under construction or a user-defined data type in the class, its type mapping is simpleType, which is recorded as τ′, Γ={τ, τ′}, and its attribute mapping is a restriction data type. Recorded as type _τ ′, merged into the set of node element i;

C4. If there is multiplicity in the attributes of the class, its type mapping is complexType, which is recorded as τ″, Γ={τ, τ″}, and its declaration is represented by a unique (reg exp _τ ″, type _τ ″) sequence pair , the regular expression reg exp _τ ″ expresses the range of the number of sub-elements nested in the element, denoted as L(reg exp _τ ″), each complex type corresponds to a mapping table, denoted as ∑ ″, ∑={ {ε _i }, ∑″}, and give the type of sub-element nested in the complex type, denoted as type _τ ″, merge all the information into the set of node element i;

C5. Repeat steps C2, C3, and C4 until all vertices are processed;

C6. Adopt the polymorphic mechanism, obtain the attributes of the elements to be inherited from the parent class through the polymorphic list, use blocking and renaming to resolve conflicts caused by inheritance between elements, and use element and attribute references to resolve References between elements.

In the step E, the orderly power consumption management file data analysis process includes:

E1. Read the XML file of the user segmentation model to obtain the Document object;

Read the user segmentation model file that needs to be parsed according to the path. Reading and writing XML documents mainly depends on the org.dom4j.io package, and use SAXReader to read.

SAXReader reader = new SAXReader();

Document document=reader.read(new File(cim.xml));

E2. Obtain all nodes of the required type according to the path, and put them into the List;

E3. Traverse all child nodes under a certain node, and obtain a certain attribute name and attribute value under a certain node.

A conversion device for an ordered power consumption data conversion method based on an extensible user segmentation model, the device comprising:

The visual model editor is responsible for displaying the user's multi-dimensional subdivision model and allowing the user to expand the existing model by dragging and dropping;

The model converter is mainly responsible for converting the user segmentation model in UML format into an RDF Schema document. The definition process of RDF Schema is the process of expressing the user multi-dimensional segmentation model with RDF Schema vocabulary;

The data processing engine converts the file data of the power consumption information collection system into the file data of the orderly power consumption management system in XML format;

The file data parsing module, based on the RDF Schema document of the user segmentation model, parses the useful data in the file data of the orderly power consumption management system in XML format for use by the orderly power use management system.

The beneficial effects of the present invention are:

1. Establish a factual index system for each business object of orderly power consumption through the user segmentation model, including indicators of electricity, load, loss, power quality, etc., and at the same time provide a clear and feasible user detail The implementation of sub-models in specific projects;

2. Support the expansion of the user segmentation model. This method supports the expansion of the user segmentation model according to the actual situation of load control during the use of the orderly power consumption management platform in the later stage;

3. It can automatically convert the data model of the electricity consumption information collection system into an orderly electricity consumption data model according to the expanded user segmentation model.

Description of drawings

Fig. 1 is an overall flow chart of an orderly power consumption data conversion method based on an extensible user segmentation model;

Figure 2 is a flow chart of user segmentation model conversion;

Fig. 3 is a flow chart of orderly power consumption management file data analysis;

Fig. 4 is an orderly power consumption data conversion device based on an extensible user subdivision model;

Figure 5 is a diagram of the expanded user segmentation model;

Fig. 6 is an example diagram of attributes of an extended user segmentation model.

Detailed ways

The present invention will be further described below in conjunction with accompanying drawing and embodiment:

Referring to Fig. 1, it is a flow chart of an orderly power consumption data conversion method based on an extensible user subdivision model of the present invention, including the following steps:

A. Import the initial user segmentation model;

B. Expand the user segmentation model;

C. Convert the UML-based user segmentation model into an RDF Schema document;

D. According to the definition of the RDF Schema document, the file data of the power consumption information collection system is converted into an orderly power consumption management system file model exchange document in XML format;

E. The orderly power consumption management system refers to the RDF Schema document to analyze the orderly power consumption management file data in XML format and extract the information.

The initial user segmentation model imported in step A is shown in Figure 5 below. The negative control households and negative control points in the orderly electricity consumption user segmentation model are the file information defined and managed in the orderly electricity consumption system. There are two situations for the negative control account: for the same business account is divided into multiple contract accounts due to marketing business needs, and the object to be managed in the negative control business is the business account, then the business account can be linked to a negative control account Corresponding; the metering equipment of multiple users is installed at the same physical location, and only one terminal device is installed on site. The load control management object performs load control, and these electricity customers correspond to a load control household. The negative control households can be subdivided according to the orderly power consumption industry classification, light/heavy industry classification, key/non-key enterprises, high energy consumption, continuous/non-continuous enterprises, military/non-military enterprises, control methods, etc., so as to construct Create a user segmentation model for electricity customers.

In the step B, the expansion of the user segmentation model is mainly completed by defining different namespaces and expanding new classes and attributes. Due to the use of independent namespaces, the XML document of the user segmentation model can clearly distinguish which content is user segmentation Which models are standard and which are user-defined. In the user segmentation model, we can add an extended user segmentation model attribute "factory holiday" to the negative control household class. If other systems are not interested in this extension, this custom flag can simply be ignored. As shown in Figure 6 below, the factory holiday attribute marked in the dotted line box is a new attribute that was expanded later.

With reference to Fig. 2, in the described step C, user subdivision model conversion includes:

C1. Initialization, select a class related to other classes in the user segmentation model as the root element, and map it to the root of RDF Schema ∑={root}, the type of the root is recorded as type _root , Γ={type _root }, the attribute of the root is mapped to the sub-element sequence ∑={{root}, ∑ _root } under type _root , then the root node element is expressed as {∑, Γ, type _root , ∑ _root };

C2. Map a class in the user segmentation model to the top element i in the RDF Schema, denoted as ε _i , then ∑={ε _i }, its type is mapped to complexType, denoted as τ, then Γ={τ }, the attribute type of the class is mapped to the same data type existing in RDF Schema, which is recorded as type _τ , and the i element node is expressed as {∑, Γ, τ, type _τ };

C3. If there is a data type under construction or a user-defined data type in the class, its type mapping is simpleType, which is recorded as τ′, Γ={τ,τ′}, and its attribute mapping is a restriction data type. Recorded as type _τ ′, merged into the set of node element i;

C4. If there is multiplicity in the attributes of the class, its type mapping is complexType, which is recorded as τ″, Γ={τ, τ″}, and its declaration is represented by a unique (reg exp _τ ″, type _τ ″) sequence pair , the regular expression reg exp _τ ″ expresses the range of the number of sub-elements nested in the element, denoted as L(reg exp _τ ″), each complex type corresponds to a mapping table, denoted as ∑ ″, ∑={ {ε _i }, ∑″}, and give the type of sub-element nested in the complex type, denoted as type _τ ″, merge all the information into the set of node element i;

C5. Repeat steps C2, C3, and C4 until all vertices are processed;

C6. Adopt the polymorphic mechanism, obtain the attributes of the elements to be inherited from the parent class through the polymorphic list, use blocking and renaming to resolve conflicts caused by inheritance between elements, and use element and attribute references to resolve References between elements.

The converted RDF Schema document is as follows:

<rdfs:Classrdf:ID="negative control account">

<rdfs:labelxml:lang="zh-CN">Responsible control account</rdfs:label>

<rdfs:subClassOfrdf:resource="rdfs:Resource"/>

<rdfs:comment>The negative control account is the file information defined and managed in the orderly power consumption management system, and the negative control account can correspond to one or more business accounts in the marketing system</rdfs:comment>

<dw:stereotype>″″<dw:stereotype>

</rdfs:Class>

<rdfs:Propertyrdf:ID="Negative Control Account. Negative Control Account ID">

<rdfs:labelxml:lang=”zh-CN”>Register ID</rdfs:label>

<rdfs:domainrdf:resource="# negative control account"/>

<rdfs:rangerdf:resource="# negative control user ID"/>

<rdfs:comment>"The unique identification of the negative control household in the orderly power consumption management system"

</rdfs:comment></rdf:Property>

<rdfs:Propertyrdf:ID="Responsible control household. Factory holiday">

<rdfs:labelxml:lang=″zh-CN″>Factory Holidays</rdfs:label>

<rdfs:domainrdf:resource="# negative control account"/>

<rdfs:rangerdf:resource="#factory holiday"/>

<rdfs:comment>"When implementing the negative control plan, select one or several days of the week as the factory holidays according to the factory holidays of the negative control households, and stipulate the start time and duration of power reduction on the factory holidays"

</rdfs:comment></rdf:Property>

The orderly power consumption management file converted in the step D is:

<dw: negative control account rdf: ID="_5">

<dw: negative control account. negative control account ID>11010000001</dw: negative control account. negative control account ID>

<dw: negative control account. negative control account number>1</dw: negative control account. negative control account number>

<dw: negative control account. negative control account name>XXXX customer</dw: negative control account. negative control account name>

<kz: Negative control households. Factory holidays> Two, four</kz: Negative control households. Factory holidays>

With reference to Fig. 3, in the described step E, the orderly power consumption management file data parsing process includes:

E1. Read the user segmentation model XML file to obtain the Document object; read the user segmentation model file that needs to be parsed according to the path, read and write XML documents mainly rely on the org.dom4j.io package, use SAXReader to read,

SAXReader reader = new SAXReader();

Document document=reader.read(new File(cim.xml));

E2. Obtain all nodes of the required type according to the path, and put them into the List;

E3. Traverse all child nodes under a certain node, and obtain a certain attribute name and attribute value under a certain node.

Referring to Fig. 4, it is an orderly power consumption file conversion device based on a customizable user multi-dimensional subdivision model, which includes:

The visual model editor 402 is responsible for displaying the user's multi-dimensional subdivision model, and allowing the user to expand the existing model through operations such as dragging and dropping;

The model converter 401 is mainly responsible for converting the user segmentation model in UML format into an RDF Schema document. The definition process of RDF Schema is the process of expressing the user multi-dimensional segmentation model with RDF Schema vocabulary;

The data processing engine 403 converts the file data of the power consumption information collection system into the file data of the orderly power consumption management system in XML format;

The file data parsing module 404, based on the RDF Schema document of the user segmentation model, parses the useful data in the file data of the orderly power consumption management system in XML format for use by the orderly power use management system.

Claims (2)

1., based on an ordered electric data transfer device for scalable user Segmentation Model, it is characterized in that, performing step is as follows:

A imports the Segmentation Model based on UML form of initial user, the main object in ordered electric management system is expressed as class, attribute and the relation between them;

B expands subscriber segmentation model; In described step B to subscriber segmentation model extension mainly through defining different NameSpaces and expand new class and attribute completing, adopt independently NameSpace, the XML document of subscriber segmentation model is clearly divided into subscriber segmentation model criteria and user-defined;

Subscriber segmentation model conversion based on UML form is RDF Schema document by C;

In described step C, subscriber segmentation model conversion process is:

C1. initialization, in subscriber segmentation model select one with all related class of other class as root element, it be mapped as RDF Schema root ∑={ root}, the type of root is designated as type _root, Γ={ type _root, the best property of attribute mapping of root is type _rootunder daughter element sequence ∑={ { root}, ∑ _root, then root node element representation is { ∑, Γ, type _root, ∑ _root;

C2. the class of in subscriber segmentation model is mapped to the top-level elements i in RDF Schema, is designated as ε _i, then ∑={ ε _i, its Type mapping is complexType, is designated as τ, then Γ={ τ }, and the attribute type of class is mapped as existing identical data type in RDF Schema, is designated as type _τ, then i node element is expressed as { ∑, Γ, τ, type _τ;

Building data type or custom data type if C3. exist in class, then its Type mapping is simpleType, is designated as τ ', and Γ={ τ, τ ' }, its best property of attribute mapping is the data type of restriction type, is designated as type _{τ '}, be incorporated in the set of node elements i;

If C4. the attribute of class exists multiplicity, then its Type mapping is complexType, is designated as τ ", Γ={ τ, τ " }, unique (reg exp of its statement _{τ "}, type _{τ "}) ordered pair represents, regular expression reg exp _{τ "}have expressed the quantitative range of the daughter element be nested in element, be designated as L (reg exp _{τ "}), the corresponding mapping relations table of each complicated type, is designated as ∑ ", ∑={ { ε _i, ∑ " }, and provide the type being nested in daughter element in complicated type, be designated as type _{τ "}, all information is incorporated in the set of node elements i;

C5. C2, C3, C4 step is repeated, until all summits all process;

C6. adopt polymorphic mechanism, by polymorphic list, obtain the attribute of an element that will inherit from parent there, utilize blocking-up and rename to solve the conflict caused because of succession between element, utilize element and quoting of attribute to solve quoting between element;

D is according to the definition of RDF Schema document, and ordered electric management system record model power information acquisition system file data being converted to XML format exchanges document;

E ordered electric management system is quoted the ordered electric administer archive data of RDF Schema document to XML format and is resolved, and extracts information wherein;

In described step e, ordered electric administer archive Data Analysis process comprises:

E1. read subscriber segmentation model XML file, obtain Document object;

Read required subscriber segmentation model file of resolving according to path, read-write XML document depends on org.dom4j.io bag, uses SAXReader mode to read,

E2. obtain all nodes of required type according to path, and be put in List;

E3. child nodes all under certain node are traveled through, and certain attribute-name under obtaining certain node and property value.

2. based on an ordered electric DTU (Data Transfer unit) for scalable user Segmentation Model, it is characterized in that, this device comprises:

Import module: the Segmentation Model based on UML form importing initial user, is expressed as class, attribute and the relation between them by the main object in ordered electric management system;

Expansion module: subscriber segmentation model is expanded; In described expansion module to subscriber segmentation model extension mainly through defining different NameSpaces and expand new class and attribute completing, adopt independently NameSpace, the XML document of subscriber segmentation model is clearly divided into subscriber segmentation model criteria and user-defined;

First modular converter: be RDF Schema document by the subscriber segmentation model conversion based on UML form;

Described first modular converter comprises:

First map unit: initialization, in subscriber segmentation model select one with all related class of other class as root element, it be mapped as RDF Schema root ∑={ root}, the type of root is designated as type _root, Γ={ type _root, the best property of attribute mapping of root is type _rootunder daughter element sequence ∑={ { root}, ∑ _root, then root node element representation is { ∑, Γ, type _root, ∑ _root;

Second map unit: the class of in subscriber segmentation model is mapped to the top-level elements i in RDF Schema, is designated as ε _i, then ∑={ ε _i, its Type mapping is complexType, is designated as τ, then Γ={ τ }, and the attribute type of class is mapped as existing identical data type in RDF Schema, is designated as type _τ, then i node element is expressed as { ∑, Γ, τ, type _τ;

3rd map unit: building data type or custom data type if exist in class, then its Type mapping is simpleType, is designated as τ ', and Γ={ τ, τ ' }, its best property of attribute mapping is the data type of restriction type, is designated as type _{τ '}, be incorporated in the set of node elements i;

4th map unit: if the attribute of class exists multiplicity, then its Type mapping is complexType, is designated as τ ", Γ={ τ, τ " }, unique (reg exp of its statement _{τ "}, type _{τ "}) ordered pair represents, regular expression reg exp _{τ "}have expressed the quantitative range of the daughter element be nested in element, be designated as L (reg exp _{τ "}), the corresponding mapping relations table of each complicated type, is designated as ∑ ", ∑={ { ε _i, ∑ " }, and provide the type being nested in daughter element in complicated type, be designated as type _{τ "}, all information is incorporated in the set of node elements i;

Repetitive: the work repeating the second map unit, the 3rd map unit, the 4th map unit, until all summits all process;

Conflict solving unit: adopt polymorphic mechanism, by polymorphic list, obtain the attribute of an element that will inherit from parent there, utilize blocking-up and rename to solve the conflict caused because of succession between element, utilize element and quoting of attribute to solve quoting between element;

Second modular converter: according to the definition of RDF Schema document, ordered electric management system record model power information acquisition system file data being converted to XML format exchanges document;

Parsing module: ordered electric management system is quoted the ordered electric administer archive data of RDF Schema document to XML format and resolved, extracts information wherein;

Described parsing module comprises:

File reading unit: read subscriber segmentation model XML file, obtain Document object;

Read required subscriber segmentation model file of resolving according to path, read-write XML document depends on org.dom4j.io bag, uses SAXReader mode to read,

Obtain node unit: all nodes obtaining required type according to path, and be put in List;

Traversal Unit: child nodes all under certain node are traveled through, and certain attribute-name under obtaining certain node and property value.