CN109359134B - Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining - Google Patents

Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining Download PDF

Info

Publication number
CN109359134B
CN109359134B CN201810998765.7A CN201810998765A CN109359134B CN 109359134 B CN109359134 B CN 109359134B CN 201810998765 A CN201810998765 A CN 201810998765A CN 109359134 B CN109359134 B CN 109359134B
Authority
CN
China
Prior art keywords
data
energy consumption
characteristic line
electricity
abnormal
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201810998765.7A
Other languages
Chinese (zh)
Other versions
CN109359134A (en
Inventor
马良栋
张吉礼
许艺颖
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Dalian Qunzhi Technology Co ltd
Original Assignee
Dalian University of Technology
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Dalian University of Technology filed Critical Dalian University of Technology
Priority to CN201810998765.7A priority Critical patent/CN109359134B/en
Publication of CN109359134A publication Critical patent/CN109359134A/en
Application granted granted Critical
Publication of CN109359134B publication Critical patent/CN109359134B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/08Construction
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/80Management or planning
    • Y02P90/82Energy audits or management systems therefor

Landscapes

  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Educational Administration (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Game Theory and Decision Science (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Testing And Monitoring For Control Systems (AREA)

Abstract

The invention belongs to the technical field of building energy consumption monitoring platform data processing, and provides a method for identifying illumination socket energy consumption recessive abnormal data based on data mining, which comprises the following steps: s1, establishing an energy utilization mode according to the historical data; s2, aiming at any energy utilization mode, establishing an electricity utilization characteristic database; s3, identifying the dominant abnormal data based on a clustering big data analysis method; and S4, identifying the recessive abnormal data based on the historical electricity utilization characteristic line. The method has the beneficial effects that the hidden abnormal energy consumption data of the lighting socket, which cannot be identified by the conventional big data analysis method, is identified based on the electricity utilization characteristic line, so that the building energy consumption data quality is greatly improved.

Description

Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining
Technical Field
The invention relates to a data processing method, in particular to a method for identifying illumination and socket energy consumption recessive abnormal data based on data mining, and belongs to the technical field of building energy consumption monitoring platform data processing.
Background
In recent years, a public building energy consumption monitoring platform is established, and the realization of building energy consumption item measurement is an important content for the construction of a public building energy supervision system. At present, building energy consumption monitoring platforms of different scales are established in many provinces and cities of China, and rich data is accumulated. However, due to some technical obstacles, the overall quality of building monitoring data is low, and data abnormal problems such as data loss, data mutation and the like occur, through investigation and analysis, the abnormal data proportion of the existing building energy consumption monitoring platform is generally up to 20%, so that the energy consumption monitoring data is far from the real energy consumption of the building, and a large amount of energy consumption data cannot be fully utilized. With the continuous development of green buildings in China, people not only acquire more and more types and larger data quantity of building energy consumption data, but also have higher and higher requirements on data quality. In order to improve the data quality of the building energy consumption monitoring platform, in recent years, many scientific researchers at home and abroad focus on the problems existing in the energy consumption monitoring platform data, and the missing or abnormal data of the platform is solved and corrected by adopting methods such as a data mining technology, cluster analysis and the like. The invention discloses a public building energy consumption supervision platform data processing method based on data mining (patent application number is 201410482593.X), which is technically characterized by comprising four aspects of problem data primary identification, energy consumption mode characteristic parameter set establishment according to historical data, problem data fine identification and problem data intelligent supplement, and the energy consumption mode characteristic parameter set for a building is established by classifying the historical energy consumption data according to different energy consumption modes, so that the integrated processing of classification identification, cleaning and intelligent supplement of the problem data of an energy consumption supervision platform is realized. The method can realize the identification of missing data and mutation data, but can not identify monitoring data which have abnormal energy consumption and meet the requirement of threshold selection. The energy consumption of building electricity is generally divided into four items of energy consumption of lighting sockets, energy consumption of heating ventilation air conditioners, energy consumption of power equipment and energy consumption of special electricity. The patent provides a method for identifying hidden abnormal data of energy consumption of the lighting socket based on data mining by adopting a big data analysis method aiming at the electricity consumption characteristics of the energy consumption of the lighting socket so as to improve the data quality of a building energy consumption monitoring platform.
Disclosure of Invention
The invention aims to solve the technical problem of providing a method for identifying the hidden abnormal energy consumption data of the lighting socket based on data mining, which can effectively improve the data quality of a public building energy consumption supervision platform.
The technical scheme of the invention is as follows:
a method for identifying energy consumption implicit abnormal data of an illumination socket based on data mining comprises the following steps:
s1, establishing an energy utilization mode according to the historical data: finely dividing the lighting and socket energy consumption data into energy utilization modes such as working days, holidays and the like according to whether the day of the energy consumption data is a holiday or not;
s2, establishing a power utilization characteristic database: aiming at any one energy utilization mode, converting the accumulated energy consumption into energy consumption per unit time, and sequentially storing the energy consumption per unit time according to unit time step length by taking days as a unit, wherein the energy consumption data per day is an electricity utilization characteristic line;
the energy consumption calculation formula per unit time is as follows:
Ej=Sj-Sj-1formula (1)
Wherein E isjIs the energy consumption per unit time, SjThe cumulative reading of the meter at the j-th moment, Sj-1The accumulated reading number of the meter at the j-1 moment is obtained;
s3, explicit abnormal data identification: identifying dominant abnormal data such as data loss, data mutation and the like in the energy consumption data of any energy consumption mode due to the metering or transmission process based on a clustering big data analysis method;
s4, implicit abnormal data identification: judging whether the new power utilization characteristic line is consistent with the power utilization characteristic line of the historical data under the similar working conditions or not based on the historical power utilization characteristic line, if so, judging that the energy consumption data is normal, and if not, judging that the energy consumption data is implicitly abnormal;
the specific identification steps are as follows:
s41, calculating the slope of the historical data electricity utilization characteristic line
Assuming that m historical data electricity utilization characteristic lines are provided, for any historical data electricity utilization characteristic line i, the electricity consumption at the j th moment and the j +1 th moment are respectively Ei,jAnd Ei,j+1The slope of the electricity utilization characteristic line in the time from the j th to the j +1 th is ki,jThe calculation formula of (2) is as follows:
Figure BDA0001782464740000031
where Δ tiIs the unit time length;
s42, and the general change trend of the historical data electricity utilization characteristic line
Suppose that n (0) is total in the j-th to j + 1-th time points<n<m) slope k of electricity utilization characteristic line of historical datai,jIf the power utilization characteristic line occupation ratio is p-n/m (%), the corresponding power utilization characteristic line occupation ratio for reducing the power consumption is q-1-p, if p is greater than q, the overall power consumption in the time from j to j +1 is in an increasing trend, otherwise, the overall power consumption is reducedA few trends;
s43, calculating the slope K of the new data electricity utilization characteristic line at the moment by adopting the method of the step S41j
S44, identifying the recessive abnormal error data by using whether the new data electricity characteristic line is consistent with the historical data electricity characteristic line
If K isj>0 and p in this time period>q or Kj<0 and p in this time period<q, the new electricity utilization characteristic line in the time period is consistent with the trend of the historical data; counting the number a of time periods with consistent curve change trend within 24 hours, if a/24>And 90%, the new electricity utilization characteristics are normal, otherwise, hidden abnormal error data exist.
Compared with the prior art, the method has the advantages that the method for identifying the energy consumption recessive abnormal data of the lighting socket based on data mining is provided, and the quality of the building energy consumption data is greatly improved.
Drawings
FIG. 1 is a flow chart of explicit anomaly data identification according to the present invention.
Fig. 2 is a diagram illustrating conversion of accumulated energy consumption into energy consumption per unit time.
FIG. 3 is a flowchart of the identification of implicit abnormal data.
FIG. 4 is a schematic diagram of the calculation of the slope of the electrical characteristic line.
Detailed Description
The following detailed description of the invention refers to the accompanying drawings that illustrate specific embodiments of the invention.
Referring to the attached figure 1, the invention relates to a method for identifying energy consumption implicit abnormal data of a lighting socket based on data mining, which comprises the following steps:
s1, establishing an energy utilization mode according to historical data, and finely dividing the energy consumption data of the lighting and socket into energy utilization modes such as working days, holidays and the like according to whether the day of the energy consumption data is a holiday or not;
s2, referring to the attached figure 2, establishing an electricity utilization characteristic database, converting accumulated energy consumption data into energy consumption per unit time aiming at any energy utilization mode, sequentially storing the energy consumption per unit time according to unit time step length by taking days as a unit, wherein the energy consumption data per day is an electricity utilization characteristic line;
the energy consumption calculation formula per unit time is as follows:
Ej=Sj-Sj-1formula (1)
Wherein E isjIs the energy consumption per unit time, SjThe cumulative reading of the meter at the j-th moment, Sj-1The accumulated reading number of the meter at the j-1 time is shown.
S3, identifying dominant abnormal data, namely identifying the dominant abnormal data such as data loss, data mutation and the like in the energy consumption data due to metering or transmission processes based on big data analysis methods such as K-keys, density clustering and the like;
and S4, recognizing the recessive abnormal data, judging whether the new power utilization characteristic line is consistent with the power utilization characteristic line of the history data under the similar working conditions or not based on the history power utilization characteristic line, if so, judging that the energy consumption data are normal, and if not, judging that the energy consumption data are recessive abnormal.
Referring to fig. 3, the implicit abnormal data identification specifically includes the following steps:
s41, calculating the slope of the historical data electricity utilization characteristic line;
referring to fig. 4, assuming that there are m historical data electricity utilization characteristic lines, for any one historical data electricity utilization characteristic line i, the electricity consumption amounts at the j th and j +1 th time points are respectively Ei,j、Ei,j+1The slope of the power utilization broken line from the j-th to the j + 1-th time is ki,jThe calculation formula of (2) is as follows:
Figure BDA0001782464740000051
where Δ tiIs a unit time length.
S42, describing the general change trend of the historical data electricity characteristic line;
suppose that n (0) is total in the j-th to j + 1-th time points<n<m) slope k of electricity utilization characteristic line of historical datai,j(i is more than or equal to 0 and less than or equal to n) is more than 0, the power utilization characteristic line occupation ratio of the power consumption increase at the moment is p-n/m (%), the corresponding power utilization characteristic line occupation ratio of the power consumption decrease is q-1-p,if p > q, the total electricity consumption in the time from j to j +1 is in an increasing trend, otherwise, the total electricity consumption is in a decreasing trend.
S43, calculating the slope K of the new data electricity utilization characteristic line at the moment by adopting the method S41j
And S44, identifying the recessive abnormal error data by using whether the new data electricity utilization characteristic line is consistent with the historical data electricity utilization characteristic line or not.
If K isj>0, and p is within the time period>q or, Kj<0, and p is within the time period<And q, the new electricity utilization characteristic line in the time period is consistent with the historical data trend. Counting the number a of time periods with consistent curve change trend within 24 hours, if a/24>And 90%, the new electricity utilization characteristics are normal, otherwise, hidden abnormal error data exist.

Claims (1)

1. A method for identifying energy consumption implicit abnormal data of an illumination socket based on data mining is characterized by comprising the following steps:
s1, establishing an energy utilization mode according to the historical data: finely dividing the lighting and socket energy consumption data into working day and holiday energy utilization modes according to whether the day of the energy consumption data is a holiday or not;
s2, establishing a power utilization characteristic database: aiming at any one energy utilization mode, converting the accumulated energy consumption into energy consumption per unit time, and sequentially storing the energy consumption per unit time according to unit time step length by taking days as a unit, wherein the energy consumption data per day is an electricity utilization characteristic line;
the energy consumption calculation formula per unit time is as follows:
Ej=Sj-Sj-1formula (1)
Wherein E isjIs the energy consumption per unit time, SjThe cumulative reading of the meter at the j-th moment, Sj-1The accumulated reading number of the meter at the j-1 moment is obtained;
s3, explicit abnormal data identification: identifying data loss and data mutation dominant abnormal data generated in the metering or transmission process in the energy consumption data of any energy consumption mode based on a clustering big data analysis method;
s4, implicit abnormal data identification: judging whether the new power utilization characteristic line is consistent with the power utilization characteristic line of the historical data under the similar working conditions or not based on the historical power utilization characteristic line, if so, judging that the energy consumption data is normal, and if not, judging that the energy consumption data is implicitly abnormal;
the specific identification steps are as follows:
s41, calculating the slope of the historical data electricity utilization characteristic line
Assuming that m historical data electricity utilization characteristic lines are provided, for any historical data electricity utilization characteristic line i, the electricity consumption at the j th moment and the j +1 th moment are respectively Ei,jAnd Ei,j+1The slope of the electricity utilization characteristic line in the time from the j th to the j +1 th is ki,jThe calculation formula of (2) is as follows:
Figure FDA0003026159060000011
where Δ tiIs the unit time length;
s42, and the general change trend of the historical data electricity utilization characteristic line
Suppose that the slope k of n historical data power utilization characteristic lines in the j to j +1 timei,jGreater than 0, wherein 0<n<If p is greater than q, the total electricity consumption in the time from the j to the j +1 is in an increasing trend, otherwise, the total electricity consumption is in a decreasing trend;
s43, calculating the slope K of the new data electricity utilization characteristic line at the moment by adopting the method of the step S41j
S44, identifying the recessive abnormal error data by using whether the new data electricity characteristic line is consistent with the historical data electricity characteristic line
If K isj>0 and p within the j-th to j + 1-th time>q or Kj<0 and p within the j-th to j + 1-th time<q, the new electricity utilization characteristic line is consistent with the historical data trend from the j to the j + 1; counting the number a of time periods with consistent curve change trend within 24 hours, if a/24>90%, the new electricity utilizationThe characteristic is normal, otherwise, hidden abnormal error data exists.
CN201810998765.7A 2018-08-30 2018-08-30 Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining Active CN109359134B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810998765.7A CN109359134B (en) 2018-08-30 2018-08-30 Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810998765.7A CN109359134B (en) 2018-08-30 2018-08-30 Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining

Publications (2)

Publication Number Publication Date
CN109359134A CN109359134A (en) 2019-02-19
CN109359134B true CN109359134B (en) 2021-07-06

Family

ID=65350170

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810998765.7A Active CN109359134B (en) 2018-08-30 2018-08-30 Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining

Country Status (1)

Country Link
CN (1) CN109359134B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110988556B (en) * 2019-12-20 2022-03-29 上海市建筑科学研究院有限公司 Diagnosis method for architectural lighting socket support in non-operation period
CN112686286B (en) * 2020-12-18 2024-05-28 博锐尚格科技股份有限公司 Building operation energy consumption abnormality identification method, system and computer readable storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104199961A (en) * 2014-09-19 2014-12-10 北京建筑技术发展有限责任公司 Data mining based public building energy consumption monitoring platform data processing method
CN104636999A (en) * 2015-01-04 2015-05-20 江苏联宏自动化***工程有限公司 Detection method for building abnormal energy consumption data
CN105588995A (en) * 2015-12-11 2016-05-18 深圳供电局有限公司 Line loss abnormity detection method for electric power metering automation system
CN106909664A (en) * 2017-02-28 2017-06-30 国网福建省电力有限公司 A kind of power equipment data stream failure recognition methods

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB201509507D0 (en) * 2015-06-02 2015-07-15 Passivsystems Ltd Fault detection in energy generation arrangements

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104199961A (en) * 2014-09-19 2014-12-10 北京建筑技术发展有限责任公司 Data mining based public building energy consumption monitoring platform data processing method
CN104636999A (en) * 2015-01-04 2015-05-20 江苏联宏自动化***工程有限公司 Detection method for building abnormal energy consumption data
CN105588995A (en) * 2015-12-11 2016-05-18 深圳供电局有限公司 Line loss abnormity detection method for electric power metering automation system
CN106909664A (en) * 2017-02-28 2017-06-30 国网福建省电力有限公司 A kind of power equipment data stream failure recognition methods

Also Published As

Publication number Publication date
CN109359134A (en) 2019-02-19

Similar Documents

Publication Publication Date Title
CN106681964B (en) Energy Consumption of Public Buildings statistical audit method for splitting
CN108846530B (en) Short-term load prediction method based on clustering-regression model
CN109508743B (en) KNN improved algorithm-based method for repairing abnormal energy consumption data of lighting socket
CN109359134B (en) Method for identifying energy consumption implicit abnormal data of lighting socket based on data mining
CN110796307B (en) Distributed load prediction method and system for comprehensive energy system
CN109447107B (en) On-line detection method for daily energy consumption mode abnormality of air conditioner of office building based on information entropy
CN109283898A (en) A kind of plant area&#39;s energy consumption monitoring management system
WO2021120829A1 (en) Method for diagnosing energy consumption of lighting socket branches of buildings during non-operational periods
CN112987617A (en) Near-zero energy consumption building digital management system and energy efficiency monitoring method
CN114336615A (en) Power resource scheduling intelligent management system based on big data analysis of power transmission environment
CN115186888A (en) Energy saving and consumption reduction method based on double carbon targets
CN116796403A (en) Building energy saving method based on comprehensive energy consumption prediction of commercial building
CN117043794A (en) Building energy consumption prediction method and system based on multiple linear regression and cluster analysis
CN105719194B (en) Automatic optimization-searching type power load classification method
CN116468302A (en) Building park energy structure evaluation method, system, electronic equipment and storage medium
CN116224161A (en) Judgment method based on polarity reverse connection error wiring abnormality of voltage transformer
CN106056477A (en) Industry capacity utilization rate calculating method based on electricity consumption big data
CN112712213B (en) Method and system for predicting deep migration learning energy consumption of concentrated air conditioning house
CN114638284A (en) Power utilization behavior characterization method considering external influence factors
TWI536282B (en) Campus energy conservation neural network decision spport system and method thereof
CN114997470A (en) Short-term power load prediction method based on LSTM neural network
CN113487062A (en) Power load prediction method based on periodic automatic encoder
CN113822473B (en) Traction energy consumption reasonable interval prediction method based on multidimensional data
CN117875502A (en) Industrial enterprise power consumption structure optimization system and method based on carbon emission
CN115809807A (en) Deep energy-saving method for enterprise users

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20231225

Address after: Room 2205, 2 / F, 56a22, Torch Road, Dalian hi tech Industrial Park, 116000, Liaoning Province

Patentee after: Dalian Qunzhi Technology Co.,Ltd.

Address before: 116024 No. 2 Ling Road, Ganjingzi District, Liaoning, Dalian

Patentee before: DALIAN University OF TECHNOLOGY

TR01 Transfer of patent right