CN118096120A - Data real-time monitoring method and system based on multiple data collection - Google Patents

Data real-time monitoring method and system based on multiple data collection Download PDF

Info

Publication number
CN118096120A
CN118096120A CN202410241477.2A CN202410241477A CN118096120A CN 118096120 A CN118096120 A CN 118096120A CN 202410241477 A CN202410241477 A CN 202410241477A CN 118096120 A CN118096120 A CN 118096120A
Authority
CN
China
Prior art keywords
lighting equipment
data
average illuminance
lighting
average
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.)
Granted
Application number
CN202410241477.2A
Other languages
Chinese (zh)
Other versions
CN118096120B (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.)
Jiangsu Fengdeng Optoelectronics Technology Co ltd
Original Assignee
Jiangsu Fengdeng Optoelectronics Technology Co ltd
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 Jiangsu Fengdeng Optoelectronics Technology Co ltd filed Critical Jiangsu Fengdeng Optoelectronics Technology Co ltd
Priority to CN202410241477.2A priority Critical patent/CN118096120B/en
Publication of CN118096120A publication Critical patent/CN118096120A/en
Application granted granted Critical
Publication of CN118096120B publication Critical patent/CN118096120B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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/20Administration of product repair or maintenance
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00Pattern recognition
    • G06F18/20Analysing
    • G06F18/23Clustering techniques
    • G06F18/232Non-hierarchical techniques
    • G06F18/2321Non-hierarchical techniques using statistics or function optimisation, e.g. modelling of probability density functions
    • G06F18/23213Non-hierarchical techniques using statistics or function optimisation, e.g. modelling of probability density functions with fixed number of clusters, e.g. K-means clustering
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00Pattern recognition
    • G06F18/20Analysing
    • G06F18/24Classification techniques
    • G06F18/243Classification techniques relating to the number of classes
    • G06F18/2433Single-class perspective, e.g. one-against-all classification; Novelty detection; Outlier detection
    • 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
    • Y02BCLIMATE CHANGE MITIGATION TECHNOLOGIES RELATED TO BUILDINGS, e.g. HOUSING, HOUSE APPLIANCES OR RELATED END-USER APPLICATIONS
    • Y02B20/00Energy efficient lighting technologies, e.g. halogen lamps or gas discharge lamps
    • Y02B20/40Control techniques providing energy savings, e.g. smart controller or presence detection

Landscapes

  • Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Human Resources & Organizations (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Evolutionary Biology (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Artificial Intelligence (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Probability & Statistics with Applications (AREA)
  • Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Circuit Arrangement For Electric Light Sources In General (AREA)

Abstract

The invention discloses a data real-time monitoring method and a system based on multiple data collection, which relate to the technical field of lighting equipment data monitoring and comprise the following steps: acquiring historical power data and average illumination data of the lighting equipment; determining the attenuation condition of luminous flux emitted by the lighting equipment; calculating to obtain average illuminance data of different indoor areas based on real-time power and specification data of the lighting equipment; judging whether the average illuminance data of different indoor areas are matched with the specification of the lighting equipment or not, and overhauling and adjusting the lighting equipment; the average illumination of the indoor area is analyzed, secondary inspection and supplementation are carried out on the clustering analysis result, the detection efficiency of the abnormal energy consumption lighting equipment is improved, and meanwhile, the lighting function of the lighting equipment can be inspected; an intelligent energy management system is implemented by adopting an advanced energy saving technology, so that the energy utilization rate is improved, a high-efficiency energy consumption monitoring system is established, and energy conservation and emission reduction can be realized.

Description

Data real-time monitoring method and system based on multiple data collection
Technical Field
The invention relates to the technical field of data monitoring of lighting equipment, in particular to a data real-time monitoring method and system based on multiple data collection.
Background
The energy consumption of the lighting equipment is large, particularly in large public places such as shops, exhibition halls, subway stations and the like, the energy consumption of the lighting equipment occupies a considerable proportion and cannot meet the requirements; the abnormal energy consumption of the indoor lighting equipment is found in time, so that the method is an important measure for reducing the energy consumption; the abnormal illumination energy consumption refers to the phenomenon that in an illumination system, due to equipment failure, system configuration errors, improper manual operation and the like, illumination equipment runs for a long time or runs excessively, so that energy waste and energy consumption increase are caused; at present, most places adopt a periodic manual detection mode to detect the energy consumption of indoor abnormal lighting equipment, and the abnormal energy consumption detection has limitation, long consumption time and practically does not have the energy saving effect; therefore, how to increase the detection efficiency of the abnormal energy consumption lighting device and further reduce the energy consumption of the lighting device is a urgent problem to be solved.
Disclosure of Invention
The invention aims to provide a data real-time monitoring method and system based on multi-data collection so as to solve the problems in the background technology.
In one aspect of the present invention, there is provided a data real-time monitoring method based on data collection, comprising:
S1-1, acquiring historical power data of lighting equipment and historical average illumination data of different indoor areas;
S1-2, determining the attenuation condition of luminous flux emitted by the lighting equipment along with the increase of the service time of the lighting equipment based on the historical power data and the illumination data of the lighting equipment;
S1-3, calculating average illuminance data of different indoor areas based on real-time power and specification data of the lighting equipment;
S1-4, judging whether the average illuminance data of different indoor areas are matched with the specifications of the lighting equipment, if not, abnormal conditions exist in the lighting equipment in the areas, and taking the lighting equipment related to the areas into a key monitoring range for overhauling and adjusting the lighting equipment; if so, the key monitoring range is not required to be included.
In step S1-2, the method further comprises the following steps:
The method comprises the steps of obtaining initial illuminance data of one working surface when the lighting equipment is installed, comparing two results of illuminance data of the same working surface by the lighting equipment when a worker overhauls the lighting equipment after the installation, and obtaining the attenuation condition of luminous flux emitted by the lighting equipment by taking the ratio of the illuminance data obtained during overhauling to the initial illuminance data; testing the same lighting equipment in different working modes to obtain attenuation conditions of luminous fluxes emitted by all the lighting equipment, and recording the attenuation conditions as f (pn, t), wherein pn is a positive integer and represents the working modes of the lighting equipment with different specifications; t is the duration of use of the lighting device.
Optionally, f (pn, t) may be approximately replaced by a maintenance factor MF, which takes into account the influence of factors such as light source attenuation, luminaire dust accumulation, etc. on the lighting effect, and recommended values for the maintenance factor MF may be found from the luminaire's lighting design manual and related criteria.
The average illuminance data for different areas in the room is calculated by the following formula:
E av=∑iWi×Ui×f(pn,t)i, wherein E av represents average illuminance, i represents a lighting installation position in the room; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, f (pn, t) i denotes the attenuation of the luminous flux emitted by the luminaire;
calculating the average illuminance for a particular region generally applies to the following equation:
In/> For the luminous flux of the lighting device, CU is the space utilization factor, a is the area of the area; the space utilization coefficient is related to the position of the lighting equipment, the specification of the lighting equipment, the property and the area of the area and the like, and other factors except the specification of the lighting equipment are not changed with time; MF is the ratio of the average illuminance on the work surface after long-term use of the lighting system to the average illuminance at the time of new installation, and is related to the lighting equipment specification and the use time; the luminous flux of the lighting device is related to the specification of the lighting device; thus, the influence of the lighting device at one installation position on the average illuminance of the area can be represented by W i and U i, and the influence of the lighting device at all installation positions on the average illuminance of the area can be obtained after W i is added;
The indoor area can be automatically divided through buildings such as rooms, and also can be manually divided; such as a room, can form an area;
in the normal operation mode: finding out the center of the area and the intersection points ints of the vertical lines where the center of the area is positioned and the plane of the installation position of the lighting equipment, and finding out the lighting equipment with different specifications and symmetrical with the intersection points ints; finding out average illumination E pn1 and E pn2 brought by lighting equipment with different specifications from historical data, respectively eliminating attenuation conditions of luminous flux emitted by the lighting equipment by E pn1 and F pn2, taking the ratio to obtain U pn1/Upn2, marking the U pn1/Upn2 as C, and expressing U pn1 as C multiplied by U pn2; pn1 and pn2 are different values of the pn value range; when the historical data does not exist, manually testing to obtain the data; unifying all the lighting equipment in the same mode, and representing the lighting equipment by using U i in the same lighting equipment specification; based on the average illuminance data of the area, an equation set { E av=∑iWi×Ui×f(pn,t)i is established and solved, wherein the equation set { E av=∑iWi×Ui×f(pn,t)i comprises an influence variable U i of one lighting equipment specification on the average illuminance, influence variables W i of a plurality of lighting equipment positions on the average illuminance, an influence variable W i of all the lighting equipment positions on the average illuminance and an influence variable U i of one lighting equipment specification on the average illuminance are obtained, and then the influence variable U i of one lighting equipment specification on the average illuminance is restored according to a unified mode of the lighting equipment specification to obtain the influence of all the lighting equipment specifications on the average illuminance;
At the symmetrical position, the influence of the position of the lighting equipment on the average illumination of the area is the same, so that the influence of different specifications of the lighting equipment at the symmetrical position can be unified through the ratio; the lighting equipment specifications of all the indoor areas are communicated, and when the lighting equipment with symmetrical positions does not exist in one area, the data of other areas can be used; the influence of the indoor whole-area lighting equipment specification on the average illuminance is kept consistent;
When the lighting device is in an operation mode other than the normal operation mode: based on the average illuminance data of the area when the lighting device in other operation modes exists, a known influence variable W i of the lighting device position on the average illuminance and a decay condition f (pn, t) i of the luminous flux emitted by the lighting device are substituted into an equation set, and the influence variable of the lighting device specification on the average illuminance is calculated.
The lighting device has different working modes, including normal working, energy-saving working, color temperature adjustment and the like, and the different working modes of the lighting device are distinguished through the specification of the lighting device.
The influence variable W i of the plurality of luminaire positions on the average illuminance is reduced by:
for mutually symmetrical lighting device positions, the influence variables of the lighting device positions on the average illuminance are the same, and one variable can be used for representing the other variable;
In the normal operation mode: finding out lighting equipment which is not in the same specification of symmetrical positions, finding out average illumination E pn3 and E pn4 caused by different lighting equipment positions from existing historical data, respectively eliminating attenuation conditions of luminous fluxes emitted by the lighting equipment by E pn3 and E pn4, taking a ratio to obtain U pn3/Upn4, marking the ratio as D, and representing U pn3 as D multiplied by U pn4; pn3 and pn4 are different values of a pn value range; the number of lighting device position variables is reduced.
After the influence of the using time is eliminated, the influence caused by the position variable is only remained, and the number of the position variables can be reduced through the ratio.
In step S1-4, the method further comprises the following steps:
Acquiring actual measurement values of historical lighting equipment attribute data and average illuminance data of an indoor area; calculating average illuminance data of the indoor area based on the specification and the using time length of the lighting equipment, and obtaining a difference value between an actual measurement value and a calculated value of the average illuminance data; the minimum value in all the difference values is the starting point of the error interval, and the maximum value in all the difference values is the ending point of the error interval; multiplying the starting point and the end point of the error interval by a correction coefficient k based on the specification and the using time of the lighting equipment at the current moment, judging whether the calculated value of the regional average illuminance data is in the corrected error interval, and if so, matching the power consumption of the lighting equipment with the average illuminance; if not, the lighting device power consumption does not match the average illuminance. The average illuminance calculation formula has an error with the actual situation, because an error range needs to be set, and when the calculated value and the measured value are within the error range, the specification of the lighting equipment is consistent with the average illuminance.
The correction coefficient k is determined by:
Acquiring the attribute of the current lighting equipment, wherein the attribute of the lighting equipment comprises the specification, the power, the using duration and the service life of the lighting equipment; converting the category type lighting equipment specification data into numerical value type lighting equipment specification data; performing kmeans clustering on the attribute data of the lighting equipment; obtaining a clustering center based on a clustering result, and if no isolated point exists, setting a correction coefficient to be 1, wherein no abnormal condition exists in the lighting equipment; if the isolated point exists, the abnormal condition exists in the power consumption of the lighting equipment, the cluster center closest to the isolated point is found, the distance ed 1 between the isolated point and the closest cluster center is calculated, the distance ed 2 between the closest cluster center and the farthest lighting equipment attribute data point in the cluster to which the isolated point belongs is calculated, and the offset value brought by the isolated point is Wherein the value range of j is the same as i, and represents the installation position of the lighting equipment; by changing the power data of the isolated point, the distance ed 1 is corrected to be ed 2, and the difference between the power before correction and the power after correction is Δp j; and adding 1 after taking the sum of offset values brought by all the isolated points to obtain a correction coefficient k.
The specification of the lighting equipment comprises the running state of the lighting equipment and specific parameters of the lighting equipment, such as luminous flux, luminous efficiency, light source type, color temperature and the like; when the abnormal power exists in the lighting equipment, the error range is influenced; when the power of the lighting equipment is larger than the rated power corresponding to the specification of the lighting equipment, the actual measurement value of the lighting equipment is increased, so that the error interval is required to be moved along with the actual measurement value; vice versa; a plurality of lighting devices exist in the same area, the position variable is a main influencing factor, and one lighting device influences the whole area according to the duty ratio of the position variable; possible reasons include abnormal power consumption of the lighting device, problems in the control loop, etc.; when the control signal output by the control loop is in an energy-saving mode and the lighting equipment works in a normal mode, abnormal power appears in the lighting equipment at the moment, if the error of the calculated value and the measured value is in the error range, the problem of the luminous performance of the lighting equipment is not solved, and the problem of abnormal power consumption of the lighting equipment can be judged; if the errors of the calculated value and the measured value are not in the error range, the specification of the lighting equipment and the actual lighting effect of the lighting equipment can be indicated to be not matched; when the power of the lighting equipment does not detect abnormal conditions, the lighting equipment can be further detected by utilizing the average illuminance data, whether the specification of the lighting equipment is matched with the actual lighting effect of the lighting equipment is judged, and the detection result of the lighting equipment is improved; meanwhile, the average illuminance can be detected for the illumination function of the illumination device regardless of the clustering result.
In another aspect of the present invention, there is provided a data real-time monitoring system based on data collection, comprising: the device comprises a data collection module, a data storage module, an illumination analysis module, a power consumption analysis module and a detection module; the output end of the data collection module is connected with the input ends of the data storage module and the power consumption analysis module, and is used for acquiring power data of indoor lighting equipment and illuminance information of different areas; the output end of the data storage module is connected with the input ends of the illumination analysis module and the power consumption analysis module, and is used for storing attribute data of the lighting equipment and illumination information of each area; the output end of the power consumption analysis module is connected with the input end of the illumination analysis module, and is used for analyzing the power consumption data of the lighting equipment and finding the lighting equipment with abnormal power consumption; the output end of the illumination analysis module is connected with the input end of the monitoring module, whether the illumination data of the indoor area are matched with the power consumption data of the lighting equipment or not is judged based on the analysis result of the power consumption data of the lighting equipment, and if the illumination data of the indoor area are not matched with the power consumption data of the lighting equipment, the lighting equipment related to the area is brought into a key monitoring range; if so, overhauling and adjusting the lighting equipment in a conventional manner; the detection module is used for carrying out careful overhaul and adjustment on the lighting equipment in the heavy point monitoring range and carrying out overhaul and adjustment on the lighting equipment outside the heavy point monitoring range in a conventional mode.
The power consumption analysis module further comprises a data type conversion unit, a kmeans clustering unit and a preprocessing unit; the data type conversion unit is used for converting category type lighting equipment attribute data into numerical data; the preprocessing unit is used for normalizing the attribute data of the numerical lighting equipment; and the kmeans clustering unit performs kmeans clustering on the attribute data of the lighting equipment to find out the lighting equipment with abnormal power, namely abnormal energy consumption.
The illumination analysis module further comprises a correction coefficient calculation unit, an average illumination data calculation unit and an error interval calculation unit, wherein the correction coefficient calculation unit generates a correction coefficient to correct an error interval of the average illumination data based on the abnormal power consumption lighting equipment determined by the power consumption analysis module; the average illuminance data calculation unit obtains average illuminance data of the area based on the specification and the use duration of the lighting equipment; the error interval calculation unit is used for determining an allowable error between the measured value and the calculated value of the average illuminance data.
The average illuminance data calculation unit uses the following formula: e av=∑iWi×Ui×f(pn,t)i calculates the average illuminance data of the region, and solves parameters in the formula by constructing an equation set; wherein E av is the average illuminance, i represents the lighting installation position in the room; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, and f (pn, t) i denotes the attenuation of the luminous flux emitted by the luminaire.
Compared with the prior art, the invention has the following beneficial effects: by carrying out cluster analysis on the attribute of the lighting equipment, the lighting equipment with abnormal energy consumption in the running process can be detected; the average illumination of the indoor area is analyzed, secondary inspection and supplementation are carried out on the clustering analysis result, the detection efficiency of the abnormal energy consumption lighting equipment is improved, and meanwhile, the lighting function of the lighting equipment can be inspected; the lighting equipment is subjected to targeted overhaul and adjustment, so that the lighting equipment can be operated for a long time and efficiently, the replacement frequency of the lighting equipment is reduced, and the overall energy consumption is reduced; an intelligent energy management system is implemented by adopting an advanced energy saving technology, so that the energy utilization rate is improved, a high-efficiency energy consumption monitoring system is established, and energy conservation and emission reduction can be realized.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
fig. 1 is a schematic structural diagram of a data real-time monitoring system based on multiple data collection according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In an embodiment of the present invention, referring to fig. 1, a schematic structural diagram of a data real-time monitoring system based on multiple data collection is provided, including: the device comprises a data collection module, a data storage module, an illumination analysis module, a power consumption analysis module and a detection module; the output end of the data collection module is connected with the input ends of the data storage module and the power consumption analysis module, and is used for acquiring power data of indoor lighting equipment and illuminance information of different areas; the output end of the data storage module is connected with the input ends of the illumination analysis module and the power consumption analysis module, and is used for storing attribute data of the lighting equipment and illumination information of each area; the output end of the power consumption analysis module is connected with the input end of the illumination analysis module, and is used for analyzing the power consumption data of the lighting equipment and finding the lighting equipment with abnormal power consumption; the output end of the illumination analysis module is connected with the input end of the monitoring module, whether the illumination data of the indoor area are matched with the power consumption data of the lighting equipment or not is judged based on the analysis result of the power consumption data of the lighting equipment, and if the illumination data of the indoor area are not matched with the power consumption data of the lighting equipment, the lighting equipment related to the area is brought into a key monitoring range; if so, overhauling and adjusting the lighting equipment in a conventional manner; the detection module is used for carrying out careful overhaul and adjustment on the lighting equipment in the heavy point monitoring range and carrying out overhaul and adjustment on the lighting equipment outside the heavy point monitoring range in a conventional mode.
The power consumption analysis module further comprises a data type conversion unit, a kmeans clustering unit and a preprocessing unit; the data type conversion unit is used for converting category type lighting equipment attribute data into numerical data; the preprocessing unit is used for normalizing the attribute data of the numerical lighting equipment; and the kmeans clustering unit performs kmeans clustering on the attribute data of the lighting equipment to find out the lighting equipment with abnormal power consumption.
The illumination analysis module further comprises a correction coefficient calculation unit, an average illumination data calculation unit and an error interval calculation unit, wherein the correction coefficient calculation unit generates a correction coefficient to correct an error interval of the average illumination data based on the abnormal power consumption lighting equipment determined by the power consumption analysis module; the average illuminance data calculation unit obtains average illuminance data of the area based on the specification and the use duration of the lighting equipment; the error interval calculation unit is used for determining an allowable error between the measured value and the calculated value of the average illuminance data.
The average illuminance data calculation unit uses the following formula: e av=∑iWi×Ui×f(pn,t)i calculates the average illuminance data of the region, and solves parameters in the formula by constructing an equation set; where E av denotes an average illuminance, i denotes a lighting installation position in the room; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, and f (pn, t) i denotes the attenuation of the luminous flux emitted by the luminaire.
In an embodiment of the present invention, there is provided a data real-time monitoring method based on data collection, including:
S1-1, acquiring historical power data of the lighting equipment and historical average illumination data of different indoor areas.
S1-2, determining the attenuation condition of luminous flux emitted by the lighting device along with the increase of the service time based on historical power data and illumination data of the lighting device:
The method comprises the steps of obtaining initial illuminance data of one working surface when the lighting equipment is installed, comparing two results of illuminance data of the same working surface by the lighting equipment when a worker overhauls the lighting equipment after the installation, and obtaining the attenuation condition of luminous flux emitted by the lighting equipment by taking the ratio of the illuminance data obtained during overhauling to the initial illuminance data; testing the same lighting equipment in different working modes to obtain attenuation conditions of luminous fluxes emitted by all the lighting equipment, and recording the attenuation conditions as f (pn, t), wherein pn is a positive integer and represents the working modes of the lighting equipment with different specifications; t is the duration of use of the lighting device.
S1-3, calculating average illuminance data of different indoor areas based on real-time power and specification data of the lighting equipment;
the average illuminance data is calculated by the following formula:
E av=∑iWi×Ui×f(pn,t)i, wherein E av represents average illuminance, i represents a lighting installation position in the room; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, f (pn, t) i denotes the attenuation of the luminous flux emitted by the luminaire;
in the normal operation mode: finding out the center of the area and the intersection points ints of the vertical lines where the center of the area is positioned and the plane of the installation position of the lighting equipment, and finding out the lighting equipment with different specifications and symmetrical with the intersection points ints; finding out average illumination F pn1 and E pn2 brought by lighting equipment with different specifications from historical data, respectively eliminating attenuation conditions of luminous fluxes emitted by the lighting equipment by E pn1 and E pn2, taking a ratio to obtain U pn1/Upn2, marking the U pn1/Upn2 as C, and representing U pn1 as C multiplied by U pn2; pn1 and pn2 are different values of the pn value range; when the historical data does not exist, manually testing to obtain the data; unifying all the lighting equipment in the same mode, and representing the lighting equipment by using U i in the same lighting equipment specification; based on the average illuminance data of the area, an equation set { E av=∑iWi×Ui×f(pn,t)i is established and solved, wherein the equation set { E av=∑iWi×Ui×f(pn,t)i comprises an influence variable U i of one lighting equipment specification on the average illuminance, influence variables W i of a plurality of lighting equipment positions on the average illuminance, an influence variable W i of all the lighting equipment positions on the average illuminance and an influence variable U i of one lighting equipment specification on the average illuminance are obtained, and then the influence variable U i of one lighting equipment specification on the average illuminance is restored according to a unified mode of the lighting equipment specification to obtain the influence of all the lighting equipment specifications on the average illuminance;
When the lighting device is in an operation mode other than the normal operation mode: substituting a known influence variable W i of the position of the lighting device on the average illuminance and a decay condition f (pn, t) i of luminous flux emitted by the lighting device into an equation set based on the average illuminance data of the area when the lighting device in other working modes exists, and calculating the influence variable of the specification of the lighting device on the average illuminance;
The influence of multiple luminaire locations on the average illuminance variable W i is reduced in number by:
for mutually symmetrical lighting device positions, the influence variables of the lighting device positions on the average illuminance are the same, and one variable can be used for representing the other variable;
In the normal operation mode: finding out lighting equipment which is not in the same specification of symmetrical positions, finding out average illumination E pn3 and E pn4 caused by different lighting equipment positions from existing historical data, respectively eliminating attenuation conditions of luminous fluxes emitted by the lighting equipment by E pn3 and E pn4, taking a ratio to obtain U pn3/Upn4, marking the ratio as D, and representing U pn3 as D multiplied by U pn4; pn3 and pn4 are different values of the pn value range; the number of lighting device position variables is reduced.
S1-4, judging whether the average illuminance data of different indoor areas are matched with the specification of the lighting equipment or not: acquiring actual measurement values of historical lighting equipment attribute data and average illuminance data of an indoor area; calculating average illuminance data of the indoor area based on the specification and the using time length of the lighting equipment, and obtaining a difference value between an actual measurement value and a calculated value of the average illuminance data; the minimum value in all the difference values is the starting point of the error interval, and the maximum value in all the difference values is the ending point of the error interval; multiplying the starting point and the end point of the error interval by a correction coefficient k based on the specification and the using time of the lighting equipment at the current moment, judging whether the calculated value of the regional average illuminance data is in the corrected error interval, and if so, matching the power consumption of the lighting equipment with the average illuminance; if not, the power consumption of the lighting equipment is not matched with the average illuminance; if the illumination equipment in the area is not matched with the key monitoring range, abnormal conditions exist in the illumination equipment in the area, the illumination equipment related to the area is brought into the key monitoring range, and the illumination equipment is overhauled and regulated; if the key monitoring range is matched, the key monitoring range is not required to be included;
The correction coefficient k is determined by: acquiring the attribute of the current lighting equipment, wherein the attribute of the lighting equipment comprises the specification, the power, the using duration and the service life of the lighting equipment; converting the category type lighting equipment specification data into numerical value type lighting equipment specification data; performing kmeans clustering on the attribute data of the lighting equipment; obtaining a clustering center based on a clustering result, and if no isolated point exists, setting a correction coefficient to be 1, wherein no abnormal condition exists in the lighting equipment; if the isolated point exists, the abnormal condition exists in the power consumption of the lighting equipment, the cluster center closest to the isolated point is found, the distance ed 1 between the isolated point and the closest cluster center is calculated, the distance ed 2 between the closest cluster center and the farthest lighting equipment attribute data point in the cluster to which the isolated point belongs is calculated, and the offset value brought by the isolated point is Wherein the value range of j is the same as i, and represents the installation position of the lighting equipment; by changing the power data of the isolated point, the distance ed 1 is corrected to be ed 2, and the difference between the power before correction and the power after correction is Δp j; and adding 1 after taking the sum of offset values brought by all the isolated points to obtain a correction coefficient k.
The lighting device specification can be converted into a numerical value by using 0, 1 and 2 for two types of lighting devices with different specifications to indicate that the first type of lighting device is in a closed, energy-saving and normal working state, and 10, 11 and 12 for the second type of lighting device to indicate that the second type of lighting device is in a closed, energy-saving and normal working state; alternatively, the service life of the lighting device can be also regarded as category type data and converted into numerical type, the service life of the lighting device with the same specification is the same, the service life value is fixed, and different service lives can be distinguished through assignment.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
Finally, it should be noted that: the foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. The data real-time monitoring method based on the data collection is characterized by comprising the following steps of:
S1-1, acquiring historical power data of lighting equipment and historical average illumination data of different indoor areas;
S1-2, determining the attenuation condition of luminous flux emitted by the lighting equipment along with the increase of the service time of the lighting equipment based on the historical power data and the illumination data of the lighting equipment;
S1-3, calculating average illuminance data of different indoor areas based on real-time power and specification data of the lighting equipment;
S1-4, judging whether the average illuminance data of different indoor areas are matched with the specifications of the lighting equipment, if not, abnormal conditions exist in the lighting equipment in the areas, and taking the lighting equipment related to the areas into a key monitoring range for overhauling and adjusting the lighting equipment; if so, the key monitoring range is not required to be included.
2. The method for real-time monitoring of data based on multiple data collection according to claim 1, further comprising the steps of, in step S1-2:
The method comprises the steps of obtaining initial illuminance data of one working surface when the lighting equipment is installed, comparing two results of illuminance data of the same working surface by the lighting equipment when a worker overhauls the lighting equipment after the installation, and obtaining the attenuation condition of luminous flux emitted by the lighting equipment by taking the ratio of the illuminance data obtained during overhauling to the initial illuminance data; testing the same lighting equipment in different working modes to obtain attenuation conditions of luminous fluxes emitted by all the lighting equipment, and recording the attenuation conditions as f (pn, t), wherein pn is a positive integer and represents the working modes of the lighting equipment with different specifications; t is the duration of use of the lighting device.
3. The method for real-time monitoring data based on multiple data collection according to claim 2, wherein the average illuminance data of different areas in the room is calculated by the following formula:
E av=∑iWi×Ui×f(pn,t)i,Eav is the average illuminance, where i represents the lighting installation location in the room, each location where the lighting installed is unique; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, f (pn, t) i denotes the attenuation of the luminous flux emitted by the luminaire;
In the normal operation mode: finding out the center of the area and the intersection points ints of the vertical lines where the center of the area is positioned and the plane of the installation position of the lighting equipment, and finding out the lighting equipment with different specifications and symmetrical with the intersection points ints; finding out average illumination E pn1 and E pn2 brought by lighting equipment with different specifications from historical data, respectively eliminating attenuation conditions of luminous fluxes emitted by the lighting equipment by E pn1 and E pn2, taking a ratio to obtain U pn1/Upn2, marking the U pn1/Upn2 as C, and representing U pn1 as C multiplied by U pn2; pn1 and pn2 are different values of the pn value range; when the historical data does not exist, manually testing to obtain the data; unifying all the lighting equipment in the same mode, and representing the lighting equipment by using U i in the same lighting equipment specification; based on the average illuminance data of the area, an equation set { E av=∑iWi×Ui×f(pn,t)i is established and solved, wherein the equation set { E av=∑iWi×Ui×f(pn,t)i comprises an influence variable U i of one lighting equipment specification on the average illuminance, influence variables W i of a plurality of lighting equipment positions on the average illuminance, an influence variable W i of all the lighting equipment positions on the average illuminance and an influence variable U i of one lighting equipment specification on the average illuminance are obtained, and then the influence variable U i of one lighting equipment specification on the average illuminance is restored according to a unified mode of the lighting equipment specification to obtain the influence of all the lighting equipment specifications on the average illuminance;
When the lighting device is in an operation mode other than the normal operation mode: based on the average illuminance data of the area when the lighting device in other operation modes exists, a known influence variable W i of the lighting device position on the average illuminance and a decay condition f (pn, t) i of the luminous flux emitted by the lighting device are substituted into an equation set, and the influence variable of the lighting device specification on the average illuminance is calculated.
4. A method of real-time monitoring of data based on multiple data collection according to claim 3, wherein the influence variable W i of the multiple luminaire locations on the average illuminance is reduced in number by:
For mutually symmetrical lighting device positions, the influence variables of the lighting device positions on the average illuminance are the same, and one variable is represented by the other variable;
In the normal operation mode: finding out lighting equipment which is not in the same specification of symmetrical positions, finding out average illumination E pn3 and E pn4 caused by different lighting equipment positions from existing historical data, respectively eliminating attenuation conditions of luminous fluxes emitted by the lighting equipment by E pn3 and E pn4, taking a ratio to obtain U pn3/Upn4, marking the ratio as D, and representing U pn3 as D multiplied by U pn4; pn3 and pn4 are different values of a pn value range; the number of lighting device position variables is reduced.
5. The method for real-time monitoring of data based on multiple data collection according to claim 4, further comprising the steps of, in step S1-4:
acquiring actual measurement values of historical lighting equipment attribute data and average illuminance data of an indoor area; calculating average illuminance data of the indoor area based on the specification and the using time length of the lighting equipment, and obtaining a difference value between an actual measurement value and a calculated value of the average illuminance data; the minimum value in all the difference values is the starting point of the error interval, and the maximum value in all the difference values is the ending point of the error interval; multiplying the starting point and the end point of the error interval by a correction coefficient k based on the specification and the using time of the lighting equipment at the current moment, judging whether the calculated value of the regional average illuminance data is in the corrected error interval, and if so, matching the power consumption of the lighting equipment with the average illuminance; if not, the lighting device power consumption does not match the average illuminance.
6. The method for real-time monitoring of data based on multiple data collection according to claim 5, wherein the correction factor k is determined by:
Acquiring the attribute of the current lighting equipment, wherein the attribute of the lighting equipment comprises the specification, the power, the using duration and the service life of the lighting equipment; converting the category type lighting equipment specification data into numerical value type lighting equipment specification data; performing kmeans clustering on the attribute data of the lighting equipment; obtaining a clustering center based on a clustering result, and if no isolated point exists, setting a correction coefficient to be 1, wherein no abnormal condition exists in the lighting equipment; if the isolated point exists, the abnormal condition exists in the power consumption of the lighting equipment, the cluster center closest to the isolated point is found, the distance ed 1 between the isolated point and the closest cluster center is calculated, the distance ed 2 between the closest cluster center and the farthest lighting equipment attribute data point in the cluster to which the isolated point belongs is calculated, and the offset value brought by the isolated point is Wherein the value range of j is the same as i, and represents the installation position of the lighting equipment; by changing the power data of the isolated point, the distance ed 1 is corrected to be ed 2, and the difference between the power before correction and the power after correction is Δp j; and adding 1 after taking the sum of offset values brought by all the isolated points to obtain a correction coefficient k.
7. A data real-time monitoring system based on multiple data collection, using the data real-time monitoring method based on multiple data collection according to any one of claims 1 to 6, comprising: the device comprises a data collection module, a data storage module, an illumination analysis module, a power consumption analysis module and a detection module; the output end of the data collection module is connected with the input ends of the data storage module and the power consumption analysis module, and is used for acquiring power data of indoor lighting equipment and illuminance information of different areas; the output end of the data storage module is connected with the input ends of the illumination analysis module and the power consumption analysis module, and is used for storing attribute data of the lighting equipment and illumination information of each area; the output end of the power consumption analysis module is connected with the input end of the illumination analysis module, and is used for analyzing the power consumption data of the lighting equipment and finding the lighting equipment with abnormal power consumption; the output end of the illumination analysis module is connected with the input end of the monitoring module, whether the illumination data of the indoor area are matched with the power consumption data of the lighting equipment or not is judged based on the analysis result of the power consumption data of the lighting equipment, and if the illumination data of the indoor area are not matched with the power consumption data of the lighting equipment, the lighting equipment related to the area is brought into a key monitoring range; if so, overhauling and adjusting the lighting equipment in a conventional manner; the detection module is used for carrying out careful overhaul and adjustment on the lighting equipment in the heavy point monitoring range and carrying out overhaul and adjustment on the lighting equipment outside the heavy point monitoring range in a conventional mode.
8. The data real-time monitoring system based on multiple data collection according to claim 7, wherein the power consumption analysis module further comprises a data type conversion unit, a kmeans clustering unit and a preprocessing unit; the data type conversion unit is used for converting category type lighting equipment attribute data into numerical data; the preprocessing unit is used for normalizing the attribute data of the numerical lighting equipment; and the kmeans clustering unit performs kmeans clustering on the attribute data of the lighting equipment to find out the lighting equipment with abnormal power consumption.
9. The system for monitoring data in real time based on multiple data collection according to claim 7, wherein the illuminance analysis module further comprises a correction coefficient calculation unit, an average illuminance data calculation unit and an error interval calculation unit, the correction coefficient calculation unit generates a correction coefficient to correct an error interval of the average illuminance data based on the abnormal power consumption lighting apparatus determined by the power consumption analysis module; the average illuminance data calculation unit obtains average illuminance data of the area based on the specification and the use duration of the lighting equipment; the error interval calculation unit is used for determining an allowable error between the measured value and the calculated value of the average illuminance data.
10. The multi-data collection-based data real-time monitoring system according to claim 9, wherein the average illuminance data calculation unit is configured by: e av=ΣiWi×Ui×f(pn,t)i calculates the average illuminance data of the region, and solves parameters in the formula by constructing an equation set; where E av denotes an average illuminance, i denotes a lighting installation position in the room; w i denotes the effect of the luminaire position on the average illuminance, U i denotes the effect of the luminaire specification on the average illuminance, and f (pm, t) i denotes the attenuation of the luminous flux emitted by the luminaire.
CN202410241477.2A 2024-03-04 2024-03-04 Data real-time monitoring method and system based on multiple data collection Active CN118096120B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202410241477.2A CN118096120B (en) 2024-03-04 2024-03-04 Data real-time monitoring method and system based on multiple data collection

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202410241477.2A CN118096120B (en) 2024-03-04 2024-03-04 Data real-time monitoring method and system based on multiple data collection

Publications (2)

Publication Number Publication Date
CN118096120A true CN118096120A (en) 2024-05-28
CN118096120B CN118096120B (en) 2024-09-13

Family

ID=91161278

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202410241477.2A Active CN118096120B (en) 2024-03-04 2024-03-04 Data real-time monitoring method and system based on multiple data collection

Country Status (1)

Country Link
CN (1) CN118096120B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101861017A (en) * 2010-05-04 2010-10-13 王默文 Region illumination maintenance system and method
WO2011154756A2 (en) * 2010-06-09 2011-12-15 Wemont Kft. Method for constructing a lighting device with discrete light sources and thus obtained lighting device
CN104697631A (en) * 2015-04-03 2015-06-10 国家电网公司 Illumination fault detection method and central processing unit
CN111695792A (en) * 2020-05-29 2020-09-22 北方国际合作股份有限公司 Subway illumination system abnormal energy consumption analysis method based on multi-attribute clustering
KR102368139B1 (en) * 2021-07-26 2022-02-28 국방기술품질원 Illumination uniformity evaluation system for a compartment and method
CN116204566A (en) * 2023-04-28 2023-06-02 深圳市欣冠精密技术有限公司 Digital factory monitoring big data processing system

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101861017A (en) * 2010-05-04 2010-10-13 王默文 Region illumination maintenance system and method
WO2011154756A2 (en) * 2010-06-09 2011-12-15 Wemont Kft. Method for constructing a lighting device with discrete light sources and thus obtained lighting device
CN104697631A (en) * 2015-04-03 2015-06-10 国家电网公司 Illumination fault detection method and central processing unit
CN111695792A (en) * 2020-05-29 2020-09-22 北方国际合作股份有限公司 Subway illumination system abnormal energy consumption analysis method based on multi-attribute clustering
KR102368139B1 (en) * 2021-07-26 2022-02-28 국방기술품질원 Illumination uniformity evaluation system for a compartment and method
CN116204566A (en) * 2023-04-28 2023-06-02 深圳市欣冠精密技术有限公司 Digital factory monitoring big data processing system

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
游燕;: "浅谈平均照度计算", 江西建材, no. 16, 30 August 2017 (2017-08-30), pages 19 - 20 *
赵亚萍: "民用建筑电气照明系统节能技术分析", 中国优秀硕士学位论文全文数据库, 15 February 2017 (2017-02-15), pages 038 - 2023 *
郭廷锦;连晖;孙同会;: "设备能耗分析中标准规范对照法在节能改造中的应用", 福建建材, no. 03, 20 March 2018 (2018-03-20), pages 93 - 94 *

Also Published As

Publication number Publication date
CN118096120B (en) 2024-09-13

Similar Documents

Publication Publication Date Title
CN106802616B (en) Building energy consumption comprehensive management system and method
CN101883455A (en) Lighting power-saving measurement and control system based on wireless sensor network
CN115802562A (en) Illumination intensity self-adaptive adjustment system of LED ceiling lamp
CN117172625B (en) Comprehensive analysis method for energy-saving reconstruction of existing building
CN112333891B (en) Lighting lamp fault prediction and health management device and method and railway vehicle
CN117314039A (en) Intelligent energy utilization method and system for comprehensive energy system facing park carbon reduction demand
CN117033927B (en) Subway station carbon emission real-time monitoring, predicting and analyzing method
CN115877115B (en) Safety detection system for installation of weak current equipment based on big data
CN111682925B (en) Data acquisition and processing method for intelligent street lamp
CN118096120B (en) Data real-time monitoring method and system based on multiple data collection
CN110988556A (en) Diagnosis method for architectural lighting socket support in non-operation period
CN112215526B (en) Metering system evaluation method and device and readable storage medium
CN113962100A (en) Automatic optimization intelligent energy control system and method based on big data analysis
CN112165755B (en) Building brightening intelligent control management system based on big data
CN117082701A (en) LED lighting control system based on wireless technology
CN108828469B (en) Street lamp fault diagnosis circuit and diagnosis method thereof
CN104931824A (en) Electricity utilization equipment monitoring system
CN115915559A (en) Intelligent control method and system for building illumination
CN116388685A (en) Solar cell panel operation control system
CN115129770A (en) Data analysis system and method of building energy data acquisition and analysis platform
CN104348108B (en) A kind of transformer station user run based on area power grid assesses system
CN102510646A (en) Remote intelligent monitoring system for street lamp
CN202634827U (en) Wireless detection, calibration, repair and regulation system for ambient illumination
CN109635345A (en) A kind of lighting apparatus method for early warning based on cloud computing
CN117494484B (en) Building fault diagnosis prediction and health management method based on large model training

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