Collecting method and device for multi-organization energy measurement data preprocessing

By building a multi-organization data summary measurement model and pre-establishing database in a multi-organization energy management system, the problem of low data summary efficiency in a multi-organization energy management system is solved, the system is intelligent and efficiently improved, and cross-organization energy management decisions are supported.

CN119862173APending Publication Date: 2025-04-22JIANGSU LIANHONG SMART ENERGY CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202411921586.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-24
Publication Date
2025-04-22

AI Technical Summary

Technical Problem

In multi-organization energy management systems, due to the huge data scale, it is difficult for existing technology to achieve efficient summary and display of data from superior organizations, resulting in the intelligence and efficiency of the system need to be improved.

Method used

By obtaining organization-related information in the system, building a multi-organization data summary measurement model, calculating the total energy measurement of single and multi-organizations, and updating these data to a pre-established database to realize pre-summarization and storage of data.

Benefits of technology

The system is improved in the intelligence and efficiency of the system in a multi-organization mode, allowing staff to display the energy measurement data of superior organizations without the need to summarize data from subordinate organizations in real time, and support cross-organization decision-making and energy conservation and emission reduction needs.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119862173A_ABST
    Figure CN119862173A_ABST
Patent Text Reader

Abstract

The invention belongs to the technical field of energy data processing, and discloses a summarizing method and device for multi-organization energy measurement data preprocessing. The method comprises the following steps: acquiring organization related information in a system, wherein the organization related information comprises organization basic information, energy consumption information and organization equipment information; the organization basic information comprises an organization ID, an organization name, a belonging area, an organization type and a superior organization ID; the energy consumption information comprises an energy type, energy metering and a metering period; the organization equipment information comprises an equipment ID, an equipment type, an installation position, a measurement unit and an operation state; based on the organization related information, a multi-organization data summarization measurement model is built, and the total energy measurement of a single organization and the total energy measurement of multiple organizations are obtained; and the efficiency of the system is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of energy data processing, and more specifically, to a method and device for summarizing preprocessing of multi-organization energy metering data. Background Art

[0002] The existing publication number CN118113990A discloses a data preprocessing method and a preprocessing system, wherein the preprocessing system includes a data acquisition management module and a data calibration management module; by using a data recognition algorithm to perform abnormal value analysis and comparison on the calibrated image, sound and numerical data with the stored image abnormality data, sound abnormality data and numerical abnormality data, intelligent recognition and screening of abnormal images, sounds and numerical data in the data acquisition stage are realized, thereby improving the scientificity and reliability of data preprocessing; secondary data acquisition is performed on the identified image abnormality data, sound abnormality data and numerical abnormality data according to the data number using an acquisition device, and secondary abnormal data analysis and feedback are performed on the acquired image, sound and numerical data, thereby realizing abnormal data self-checking and abnormal data feedback of data acquisition, thereby improving the intelligence and accuracy of data preprocessing.

[0003] The existing technology still has the following problems:

[0004] With the development of social economy, the scale of energy management systems has tended to be large. They are no longer satisfied with the collection and measurement of a single organization, and there will be more and more energy management systems for multiple organizations in the group. In the energy management system of multiple organizations, due to the large scale of data, a design method is adopted in which each organization corresponds to a complete single-organization database. Then the data of the superior organization is aggregated from the metering data of the subordinate organizations. If the data is obtained and aggregated from each subordinate organization in real time every time the data of the superior organization is displayed, the intelligence and efficiency of the system need to be further improved.

[0005] In view of this, the present invention proposes a method and device for summarizing preprocessing of multi-organization energy metering data to solve the above problems. Summary of the invention

[0006] In order to overcome the above-mentioned defects of the prior art and to achieve the above-mentioned purpose, the present invention provides the following technical solution: a method for summarizing preprocessing of multi-organization energy metering data, comprising:

[0007] Get information about the organization in the system;

[0008] Based on the relevant information of the organization, a multi-organization data aggregation and measurement model is built to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations;

[0009] Update the pre-established database with organization-related information, single-organization total energy measurement, and multi-organization total energy measurement.

[0010] Furthermore, the method for constructing the multi-organization data aggregation measurement model includes:

[0011] Step S1, regularly start the timing device, and obtain the organization-related information in the system at each unit time interval; the organization-related information includes basic organization information, energy consumption information and organization equipment information; the basic organization information includes organization ID, organization name, region, organization type and parent organization ID; the energy consumption information includes energy type, energy measurement and measurement cycle; the organization equipment information includes equipment ID, equipment type, installation location, measurement unit and operation status;

[0012] Step S2, define the data summary measurement model expression structure; the organization with organization ID n is recorded as An; the organization with parent organization ID p is recorded as Bp; the energy measurement corresponding to the equipment ID e is recorded as Me; n, p and e are all positive real numbers greater than or equal to 1, and the values ​​of n, p and e may not be equal;

[0013] Step S3: For each organization, obtain organization-related information, and replace missing data in the corresponding organization-related information with 0;

[0014] Step S4: unify the measurement units of energy measurement corresponding to different energy types; the energy types include electrical energy, thermal energy and gas;

[0015] Step S5: Calculate and obtain the total energy measurement C corresponding to each organization through the single-organization data summary measurement model expression; the single-organization data summary measurement model expression supports automatic expansion of addition, subtraction, multiplication and division calculations and calculations of conventional mathematical functions;

[0016] Step S6: By accumulating the total energy measurements corresponding to different organizations belonging to the same superior organization, the total energy measurement D corresponding to the multiple organizations corresponding to the superior organization is calculated.

[0017] Furthermore, the single-organization data summary measurement model expression is:

[0018] Cn=Q n1 +Q n2 +Q n3 ;

[0019] Where Cn represents the total energy measurement corresponding to the organization An; Q n1 Indicates the total amount of electrical energy corresponding to the organization An; Q n2 Indicates the total amount of heat energy corresponding to tissue An; Q n3 Indicates the total amount of gas corresponding to tissue An; Q n1 The method of obtaining is to add up the energy measurement of the equipment corresponding to the electric energy; Qn2 The method of obtaining is to add up the energy measurement of the equipment corresponding to the thermal energy; Q n3 The method for obtaining the energy is to accumulate the energy of the equipment corresponding to the gas.

[0020] Furthermore, the database pre-establishment method includes:

[0021] Step W1: store the data in segments by field according to the pre-built storage format, and convert the byte order to the little-endian mode to ensure the uniformity of the data format;

[0022] Step W2: Generate CRC check code (cyclic redundancy check) to ensure data integrity;

[0023] Step W3: Update the database regularly to ensure that the stored data is always consistent with the latest energy metering results.

[0024] Furthermore, the storage format pre-construction method includes:

[0025] The storage format consists of a message header, a message length, a message body, a cyclic redundancy check (CRC), and a message tail; the fixed length of the message header is 2 bytes, and the value is 60; the field length of the message length is 2 bytes, the corresponding data type is int16, and the little-endian storage mode is adopted; the field length of the cyclic redundancy check is 4 bytes, the data type is int32; the fixed length of the message tail is 2 bytes, and the value is 60; the message body includes an organization information part, a device information part, and an energy metering information part; the organization information part includes an organization ID, an organization name length, an organization name, and an upper-level organization ID; the device information part includes The data includes the number of devices and a list of device information; the device information list includes the device ID, device type length, device type, installation location length, installation location and operating status; the energy metering information part includes the total energy metering C of a single organization, the total energy metering D of multiple organizations, the number of energy types, the list of energy types, the metering cycle and the effective time; the field lengths of the total energy metering C of a single organization and the energy metering D of multiple organizations are both 8 bytes, the data type is float64, and the storage method is little endian; the energy type list includes the energy type ID, the length of the energy type name, the energy type name, the energy metering value, the length of the metering unit and the metering unit.

[0026] Furthermore, in the energy type list, the field length of the energy type ID is 4 bytes, and the data type is int32; the field length of the energy type name length is 2 bytes, and the data type is int16; the field length of the energy type name is dynamic bytes, and the data type is string (UTF-8); the field length of the energy measurement value is 8 bytes, and the data type is float64; the field length of the measurement unit length is 2 bytes, and the data type is int16; the field length of the measurement unit is dynamic bytes, and the data type is string (UTF-8); the storage method in the energy type list is all little-endian mode.

[0027] Furthermore, in the device information list, the field length of the device ID is 4 bytes, and the data type is int32; the field length of the device type is 2 bytes, and the data type is int16; the field length of the device type is dynamic bytes, and the data type is string (UTF-8); the field length of the installation location length is 2 bytes, and the data type is int16; the field length of the installation location is dynamic bytes, and the data type is string (UFT-8); the field length of the operating status is 1 byte, and the data type is Byte; the storage method in the device information list is all little-endian mode.

[0028] Furthermore, the system is an energy management system; the energy metering is the energy consumption within a period of time corresponding to the energy type; the metering period is the time length of energy metering statistics; the equipment types include electricity meters, water meters and gas meters; the operating status includes activation, standby and maintenance.

[0029] A device for summarizing preprocessing of energy metering data of multiple organizations, implementing a method for summarizing preprocessing of energy metering data of multiple organizations, comprising:

[0030] A data acquisition module is used to obtain information related to the organization in the system;

[0031] The data processing module builds a multi-organization data aggregation and measurement model based on organization-related information to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations;

[0032] The database building module updates the organization-related information, the total energy measurement of a single organization, and the total energy measurement of multiple organizations to the pre-established database.

[0033] The technical effects and advantages of the method and device for summarizing multi-organization energy metering data preprocessing of the present invention are as follows:

[0034] The present invention provides a method and device for summarizing energy metering data preprocessing of multiple organizations. In a multi-organization mode, basic information of organizations, energy consumption information, organizational equipment information, relationships between organizations, and relationships between energy metering corresponding to organizations and equipment are abstracted and defined in advance to form user-maintainable expressions, which are stored in a pre-established database. The inventive device performs data aggregation calculations for multiple organizations based on the expressions and saves them in the databases of the corresponding organizations, so that when staff members display the energy metering data of the superior organization, they do not need to aggregate the data from each subordinate organization in real time, but can directly obtain the data from the database, thereby improving the intelligence of the system and at the same time improving the efficiency of the system.

[0035] By aggregating the energy metering data, the system can provide cross-organizational decision-making support to superior organizations, such as intuitively comparing energy consumption horizontally and vertically, recording high-energy-consuming organizations, and promoting energy conservation and emission reduction.

[0036] Through dynamic fields (such as device information, energy type list) and fixed formats (such as message header and message footer), the system can easily expand new equipment and new energy types to adapt to future needs; currently it supports three major energy types: electricity, thermal energy and gas. In the future, the organization scale can be expanded according to demand, and other energy types such as hydropower and steam can be added, which effectively improves the adaptability and flexibility of the solution. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 This is a schematic diagram of a summary device for preprocessing energy metering data of multiple organizations according to Embodiment 1 of the present invention;

[0038] Figure 2 This is a flow chart of a summary method for preprocessing multi-organization energy metering data according to Embodiment 2 of the present invention;

[0039] Figure 3 This is a flow chart of a method for building a multi-organization data aggregation measurement model according to Embodiment 1 of the present invention;

[0040] Figure 4 This is a schematic diagram of an energy type list according to Example 1 of the present invention. DETAILED DESCRIPTION

[0041] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0042] Example 1

[0043] See also Figure 1 As shown, a multi-organization energy metering data preprocessing aggregation device described in this embodiment includes: a data acquisition module, a data processing module and a database building module, and each module is connected by wire and / or wireless.

[0044] The data acquisition module is used to obtain organization-related information in the system, and the organization-related information includes basic organization information, energy consumption information and organization equipment information; the basic organization information includes organization ID, organization name, region, organization type and parent organization ID; the energy consumption information includes energy type, energy metering and metering cycle; the organization equipment information includes equipment ID, equipment type, installation location, measurement unit and operating status.

[0045] The organization ID is a unique identifier for each organization; the organization name is the name of the organization corresponding to the organization ID; the region is the geographical region or department classification where the organization is located; the organization types include subsidiaries, branches, departments, functional units, project teams and partners, etc.; the parent organization ID is the ID of the parent organization to which the organization belongs; the energy types include electricity, heat and gas; energy measurement is the energy consumption over a period of time corresponding to the energy type; the metering period is the length of time for energy metering statistics; the device ID is a unique identifier for each device; the device types include electricity meters, water meters and gas meters, etc.; the installation location is the specific installation location of the device in the organization; the measurement units include kilowatt-hours and tons, etc.; the operating status includes activation, standby and maintenance, etc.

[0046] It should be noted that the organization is an independent unit or entity within a larger group or enterprise with independent operation and energy management responsibilities; each organization has an independent database for recording the corresponding organization-related information.

[0047] By obtaining relevant information about the organization, it is helpful to aggregate data across organizations in the subsequent multi-organization system. Multi-organization systems usually involve multiple sub-organizations or departments, and each organization may have independent energy metering equipment, parameter settings, and energy consumption records; obtaining basic organizational information, energy consumption information, and organizational equipment information of each organization will help to effectively aggregate and analyze data between different organizations.

[0048] The basic information of the organization is obtained through database query; the energy consumption data is obtained through the energy management system; and the equipment information of the organization is obtained through the equipment management system.

[0049] The data processing module builds a multi-organization data aggregation and measurement model based on organization-related information to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations.

[0050] See also Figure 3As shown, the method for building the multi-organization data aggregation measurement model includes:

[0051] Step S1, regularly start the timing device to obtain the relevant information of the collected tissue at each unit time interval.

[0052] Step S2, define the data summary metering model expression structure; the organization with organization ID n is recorded as An; the organization with parent organization ID p is recorded as Bp; the energy metering corresponding to the equipment ID e is recorded as Me; n, p and e are all positive real numbers greater than or equal to 1, and the values ​​of n and e may not be equal.

[0053] By defining the data aggregation measurement model expression structure, it is helpful to calculate and aggregate the energy consumption of multiple organizations in the future.

[0054] Step S3: For each organization, obtain organization-related information and replace missing data in the corresponding organization-related information with 0 to ensure that the subsequent calculation process is not affected.

[0055] Step S4: unify the measurement units of energy measurement corresponding to different energy types.

[0056] Step S5: Calculate and obtain the total energy measurement C corresponding to each organization through the single-organization data summary measurement model expression; the single-organization data summary measurement model expression supports automatic expansion of addition, subtraction, multiplication and division calculations and calculations of conventional mathematical functions.

[0057] The single-organization data summary measurement model expression is:

[0058] Cn=Q n1 +Q n2 +Q n3

[0059] Where Cn represents the total energy measurement corresponding to the organization An; Q n1 Indicates the total amount of electrical energy corresponding to the organization An; Q n2 Indicates the total amount of heat energy corresponding to tissue An; Q n3 Indicates the total amount of gas corresponding to tissue An; Q n1 The method of obtaining is to add up the energy measurement of the equipment corresponding to the electric energy; Q n2 The method of obtaining is to add up the energy measurement of the equipment corresponding to the thermal energy; Q n3 The method for obtaining the energy is to accumulate the energy of the equipment corresponding to the gas.

[0060] For example, the data aggregation econometric model of organization 1 is:

[0061] C1=Q 11 +Q 12 +Q 13=(M1+M2)+(M3+M4)+(M5+M6)

[0062] Among them, C1 means that the energy measurement of organization 1 is the total accumulation of the energy measurements of devices with IDs 1, 2, 3, 4, 5 and 6; the energy types corresponding to devices with IDs 1 and 2 are both electric energy; the energy types corresponding to devices with IDs 3 and 4 are both thermal energy; and the energy types corresponding to devices with IDs 5 and 6 are both gas.

[0063] Step S6: By accumulating the total energy measurements corresponding to different organizations belonging to the same superior organization, the total energy measurement D corresponding to multiple organizations corresponding to the superior organization is calculated to facilitate energy management and decision support at the group level.

[0064] For example, the total energy measurement D1 of the parent organization 1 is:

[0065] D1=C1+C3+C5.

[0066] Among them, D1 means that the energy measurement of the parent organization B1 is the sum of the total energy measurement of organizations C1, C2 and C3.

[0067] The database building module updates the organization-related information, the total energy measurement of a single organization, and the total energy measurement of multiple organizations to the pre-established database, so that the system can summarize and process the cross-organizational data in advance, so that the current organization can directly obtain it from the database when displaying data.

[0068] The database pre-establishment method comprises:

[0069] Step W1: store the data in segments by field according to the pre-built storage format, and convert the byte order to little-endian mode to ensure the uniformity of the data format.

[0070] Step W2: Generate a CRC check code (cyclic redundancy check) to ensure data integrity.

[0071] Step W3: Update the database regularly to ensure that the stored data is always consistent with the latest energy metering results.

[0072] The pre-construction method of the storage format includes:

[0073] The storage format consists of a message header, a message length, a message body, a cyclic redundancy check (CRC) and a message tail; the fixed length of the message header is 2 bytes, and the value is 60; the field length of the message length is 2 bytes, the corresponding data type is int16, and the little-endian storage mode is adopted; the field length of the cyclic redundancy check is 4 bytes, and the data type is int32; the fixed length of the message tail is 2 bytes, and the value is 60; the message body includes an organization information part, a device information part and an energy metering information part; the organization information part includes an organization ID, an organization name length, an organization name and an upper-level organization ID; the device information part includes the number of devices and a device information list; the device information list (repeatedly stored according to the number of devices) includes the device ID, the length of the device type, the device type, the length of the installation location, the installation location and the operating status; the energy metering information part includes the total energy metering C of a single organization, the total energy metering D of multiple organizations, the number of energy types, the list of energy types, the metering cycle and the effective time.

[0074] The field lengths of the single-organization total energy measurement C and the multi-organization energy measurement D are both 8 bytes, the data type is float64, and the storage method is little-endian mode; the energy type list (repeatedly stored according to the number of energy types) includes the energy type ID, energy type name length, energy type name, energy measurement value, measurement unit length and measurement unit.

[0075] See also Figure 4 As shown, in the energy type list, the field length of the energy type ID is 4 bytes, the data type is int32, and the corresponding description is the unique identification of the energy type; the field length of the energy type name length is 2 bytes, the data type is int16, and the corresponding description is the byte length of the energy type name; the field length of the energy type name is dynamic bytes, the data type is string (UTF-8), and the corresponding description is such as electric energy, thermal energy and gas; the field length of the energy measurement value is 8 bytes, the data type is float64, and the corresponding description is the current type of energy measurement data; the field length of the measurement unit length is 2 bytes, the data type is int16, and the corresponding description is the byte length of the measurement unit; the field length of the measurement unit is dynamic bytes, the data type is string (UTF-8), and the corresponding description is such as kilowatt-hours, tons and cubic meters; the storage methods in the energy type list are all little-endian mode.

[0076] In the device information list, the field length of the device ID is 4 bytes, the data type is int32, and the corresponding description is that the current device is uniquely identified; the field length of the device type length is 2 bytes, the data type is int16, and the corresponding description is the byte length of the device type length; the field length of the device type is dynamic bytes, the data type is string (UTF-8), and the corresponding description is such as electricity meter, water meter and gas meter; the field length of the installation location length is 2 bytes, the data type is int16, and the corresponding description is the byte length of the device installation location; the field length of the installation location is dynamic bytes, the data type is string (UFT-8), and the corresponding description is the physical installation location of the device; the field length of the operating status (device status) is 1 byte, the data type is Byte, and the corresponding description is that the device operating status includes activation, standby and maintenance; the storage methods in the device information list are all little-endian mode.

[0077] Example 2

[0078] See also Figure 2 As shown, this embodiment provides a summary method for preprocessing energy metering data of multiple organizations, including:

[0079] Get information about the organization in the system;

[0080] Based on the relevant information of the organization, a multi-organization data aggregation and measurement model is built to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations;

[0081] Update the pre-established database with organization-related information, single-organization total energy measurement, and multi-organization total energy measurement.

[0082] Example 3

[0083] The electronic device of this embodiment includes: a processor, a memory, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps in the embodiment of the method for summarizing preprocessing of multi-organization energy metering data are implemented, such as Figure 2 Alternatively, when the processor executes the computer program, the functions of each module / unit in the above-mentioned device embodiments are implemented, for example Figure 1 Functionality of the modules shown.

[0084] Exemplarily, the computer program may be divided into one or more modules / units, which are stored in the memory and executed by the processor to complete the present application. The one or more modules / units may be a series of computer program instruction segments capable of completing specific functions, which are used to describe the execution process of the computer program in the terminal device.

[0085] Those skilled in the art will appreciate that these are merely examples of electronic devices and do not constitute a limitation of the electronic device. The electronic device may include more or fewer components than those shown in the figure, or a combination of certain components, or different components. For example, the electronic device may also include input and output devices, network access devices, buses, etc.

[0086] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0087] The memory may be an internal storage unit of the terminal device, such as a hard disk or memory of the terminal device. The memory may also be an external storage device of the terminal device, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the terminal device. Furthermore, the memory may include both an internal storage unit and an external storage device of the terminal device. The memory is used to store the computer program and other programs and data required by the terminal device. The memory may also be used to temporarily store data that has been output or is to be output.

[0088] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0089] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0090] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0091] If the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present application implements all or part of the process in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer program can implement the steps of the above-mentioned method embodiment when executed by the processor. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electrical carrier signal, telecommunication signal and software distribution medium, etc.

[0092] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application.

Claims

1. A method for summarizing multi-organization energy metering data preprocessing, characterized in that: include: Get information about the organization in the system; Based on the relevant information of the organization, a multi-organization data aggregation and measurement model is built to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations; Update the pre-established database with organization-related information, single-organization total energy measurement, and multi-organization total energy measurement.

2. According to claim 1, a method for summarizing multi-organization energy metering data preprocessing, characterized in that: The method for constructing the multi-organization data aggregation measurement model includes: Step S1, regularly start the timing device, and obtain the organization-related information in the system at each unit time interval; the organization-related information includes basic organization information, energy consumption information and organization equipment information; the basic organization information includes organization ID, organization name, region, organization type and parent organization ID; the energy consumption information includes energy type, energy measurement and measurement cycle; the organization equipment information includes equipment ID, equipment type, installation location, measurement unit and operation status; Step S2, define the data summary measurement model expression structure; the organization with organization ID n is recorded as An; the organization with parent organization ID p is recorded as Bp; the energy measurement corresponding to the equipment ID e is recorded as Me; n, p and e are all positive real numbers greater than or equal to 1, and the values ​​of n, p and e may not be equal; Step S3: For each organization, obtain organization-related information, and replace missing data in the corresponding organization-related information with 0; Step S4: unify the measurement units of energy measurement corresponding to different energy types; the energy types include electrical energy, thermal energy and gas; Step S5: Calculate and obtain the total energy measurement C corresponding to each organization through the single-organization data summary measurement model expression; the single-organization data summary measurement model expression supports automatic expansion of addition, subtraction, multiplication and division calculations and calculations of conventional mathematical functions; Step S6: By accumulating the total energy measurements corresponding to different organizations belonging to the same superior organization, the total energy measurement D corresponding to the multiple organizations corresponding to the superior organization is calculated.

3. The method for summarizing multi-organization energy metering data preprocessing according to claim 2 is characterized in that: The single-organization data summary measurement model expression is: Cn=Q n1 +Q n2 +Q n3 ; Where Cn represents the total energy measurement corresponding to the organization An; Q n1 Indicates the total amount of electrical energy corresponding to the organization An; Q n2 Indicates the total amount of heat energy corresponding to tissue An; Q n3 Indicates the total amount of gas corresponding to tissue An; Q n1 The method of obtaining is to add up the energy measurement of the equipment corresponding to the electric energy; Q n2 The method of obtaining is to add up the energy measurement of the equipment corresponding to the thermal energy; Q n3 The method for obtaining the energy is to accumulate the energy of the equipment corresponding to the gas.

4. The method for summarizing multi-organization energy metering data preprocessing according to claim 1 is characterized in that: The database pre-establishment method comprises: Step W1: store the data in segments by field according to the pre-built storage format, and convert the byte order to little-endian mode; Step W2, generate CRC check code; Step W3: Update the database regularly to ensure that the stored data is always consistent with the latest energy metering results.

5. A method for summarizing multi-organization energy metering data preprocessing according to claim 4, characterized in that: The pre-construction method of the storage format includes: The storage format consists of a message header, a message length, a message body, a cyclic redundancy check, and a message tail; the fixed length of the message header is 2 bytes, and the value is 60; the field length of the message length is 2 bytes, and the corresponding data type is int16, and the little-endian storage mode is adopted; the field length of the cyclic redundancy check is 4 bytes, and the data type is int32; the fixed length of the message tail is 2 bytes, and the value is 60; the message body includes an organization information part, a device information part, and an energy metering information part; the organization information part includes an organization ID, an organization name length, an organization name, and an upper-level organization ID; the device information part includes a device quantity and device information list; the device information list includes device ID, device type length, device type, installation location length, installation location and operating status; the energy metering information part includes the total energy metering C of a single organization, the total energy metering D of multiple organizations, the number of energy types, the energy type list, the metering cycle and the effective time; the field lengths of the total energy metering C of a single organization and the energy metering D of multiple organizations are both 8 bytes, the data type is float64, and the storage method is little endian; the energy type list includes the energy type ID, the length of the energy type name, the energy type name, the energy metering value, the length of the metering unit and the metering unit.

6. A method for summarizing multi-organization energy metering data preprocessing according to claim 5, characterized in that: In the energy type list, the field length of the energy type ID is 4 bytes, and the data type is int32; the field length of the energy type name length is 2 bytes, and the data type is int16; the field length of the energy type name is dynamic bytes, and the data type is string (UTF-8); the field length of the energy measurement value is 8 bytes, and the data type is float64; the field length of the measurement unit length is 2 bytes, and the data type is int16; the field length of the measurement unit is dynamic bytes, and the data type is string (UTF-8); the storage methods in the energy type list are all in little-endian mode.

7. The method for summarizing multi-organization energy metering data preprocessing according to claim 5, characterized in that: In the device information list, the field length of the device ID is 4 bytes, and the data type is int32; the field length of the device type is 2 bytes, and the data type is int16; the field length of the device type is dynamic bytes, and the data type is string (UTF-8); the field length of the installation location length is 2 bytes, and the data type is int16; the field length of the installation location is dynamic bytes, and the data type is string (UFT-8); the field length of the operating status is 1 byte, and the data type is Byte; the storage methods in the device information list are all little-endian mode.

8. The method for summarizing multi-organization energy metering data preprocessing according to claim 2 is characterized in that: The system is an energy management system; the energy metering is the energy consumption within a period of time corresponding to the energy type; the metering period is the length of time for energy metering statistics; the equipment types include electricity meters, water meters and gas meters; the operating status includes activation, standby and maintenance.

9. A device for aggregating preprocessing of energy metering data of multiple organizations, implementing a method for aggregating preprocessing of energy metering data of multiple organizations as claimed in any one of claims 1 to 8, characterized in that: include: A data acquisition module is used to obtain information related to the organization in the system; The data processing module builds a multi-organization data aggregation and measurement model based on organization-related information to obtain the total energy measurement of a single organization and the total energy measurement of multiple organizations; The database building module updates the organization-related information, the total energy measurement of a single organization, and the total energy measurement of multiple organizations to the pre-established database.

Citation Information

Patent Citations

  • Data preprocessing method and preprocessing system

    CN118113990A