TWI677845B - Water consumption monitoring device and water consumption monitoring method - Google Patents

Abstract

A method for monitoring water consumption is provided, including: receiving accumulated water consumption data, and sampling the accumulated water consumption data to generate a first data set and a second data set corresponding to a first time interval; and filtering the first data set and the first data set according to a threshold value. Two data sets to generate a first set of reduced data sets and a second set of reduced data sets respectively; and in response to a difference in sampling time between the first set of reduced data sets and the second set of reduced data sets exceeding a first time interval, according to the first set The reduced data set and the second reduced data set generate imputed data sets; and the total water consumption is calculated based on the first reduced data set, the second reduced data set, and the imputed data set.

Description

Water consumption monitoring device and water consumption monitoring method

The present invention relates to a monitoring technology, and more particularly, to a water consumption monitoring device and a water consumption monitoring method.

The current water consumption monitoring equipment collects water data and continuously accumulates it until the water volume progressive value exceeds the upper limit of the water consumption counter, the counter is reset and the water volume progressive value returns to zero. However, the use of progressive data collection methods will encounter various problems, such as failure to report water usage due to communication anomalies, sudden increase in the value of water usage due to temporary or permanent equipment abnormality, or reset of the water usage counter due to reaching the maximum value, which will result in water usage data. The value of the value rapidly decreases. The above conditions often cause abnormal numerical values of water consumption, making it difficult for personnel to accurately evaluate water consumption data through water consumption monitoring equipment.

Therefore, there is a need to propose a method that can exclude abnormal values and repair missing values, so that the monitoring equipment can correctly reflect the water situation.

The invention provides a water consumption monitoring device, which includes a transceiver, a storage unit, and a processing unit. The transceiver receives cumulative water usage data. The storage unit stores a plurality of modules. The processing unit is coupled to the receiver and the storage unit, and accesses and executes multiple modules. The multiple modules include a data acquisition module, a data filtering module, a data value-added module, and a data correction module. The data acquisition module samples the accumulated water consumption data to generate a first data set and a second data set corresponding to the first time interval. The data filtering module filters the first data set and the second data set according to a threshold value to generate a first set of reduced data sets and a second set of reduced data sets, respectively. The data complementation module generates an imputed data set based on the first and second datasets in response to a difference in sampling time between the first and second datasets exceeding a first time interval. . The data correction module calculates the total water consumption according to the first data set, the second data set, and the imputed data set.

The invention provides a water consumption monitoring method, which includes: receiving accumulated water consumption data, and sampling the accumulated water consumption data to generate a first data set and a second data set corresponding to a first time interval; and filtering the first data set according to a threshold value. And the second dataset to generate the first and second datasets, respectively; in response to the difference between the sampling time of the first and second datasets exceeding the first time interval, according to the first One set of reduced data sets and the second set of reduced data sets generate imputed data sets; and calculate the total water consumption based on the first set of reduced data sets, the second set of reduced data sets, and the imputed data sets.

Based on the above, the water consumption monitoring device of the present invention can filter the original water consumption data, present more accurate sampling data to the monitoring device, and can also greatly compress the water consumption data. The water consumption monitoring device can interpolate the sampling data to repair the missing water consumption data. Through the water consumption monitoring method of the present invention, the water consumption monitoring device can correct various abnormal water consumption data.

In order to make the above features and advantages of the present invention more comprehensible, embodiments are hereinafter described in detail with reference to the accompanying drawings.

In order to eliminate abnormal water consumption values and repair missing water consumption data, the present invention proposes a water consumption monitoring device and a water consumption monitoring method.

FIG. 1 is a schematic diagram of a water consumption monitoring device 10 according to an embodiment of the present invention. The water consumption monitoring device 10 may include a processing unit 100, a storage unit 200, and a transceiver 300.

The processing unit 100 is coupled to the storage unit 200 and the transceiver 300, and accesses and executes a plurality of modules stored in the storage unit 200. The processing unit 100 may be, for example, a central processing unit (CPU), or other programmable general-purpose or special-purpose microprocessor (microprocessor), digital signal processor (DSP), or A stylized controller, an application specific integrated circuit (ASIC) or other similar components or a combination of the foregoing components, the present invention is not limited thereto.

The storage unit 200 stores a plurality of modules, and the modules may include a data storage module 201, a data acquisition module 202, a data filtering module 203, a data supplement module 204, a threshold value setting and calculation module 205, and Data correction module 206. The functions of these modules will be explained later in this article. The storage unit 200 may be, for example, any type of fixed or removable random access memory (RAM), read-only memory (ROM), and flash memory. ), A hard disk drive (HDD), a solid state drive (SSD), or a similar element or a combination of the foregoing elements, the present invention is not limited thereto.

The transceiver 300 transmits and receives signals. The transceiver 300 may also perform operations such as low noise amplifying (LNA), impedance matching, mixing, up-down conversion, filtering, amplification, and the like. In this embodiment, the transceiver 300 is configured to receive the accumulated water consumption data. For example, the transceiver 300 may collect accumulated water consumption data reported from water meters and smart water management equipment, and transmit the accumulated water consumption data to the data storage module 201 of the storage unit 200 to store the data. Cumulative water usage data can include information such as time, equipment unique identification code, and cumulative water usage.

FIG. 2 illustrates a flowchart of a water consumption monitoring method according to an embodiment of the present invention. The water consumption monitoring method may be implemented by the water consumption monitoring device 10 shown in FIG. 1.

In step S210, the transceiver 300 may receive the accumulated water consumption data, and the data acquisition module 202 may sample the accumulated water consumption data to generate a first data set E ₀ ′ and a second data set corresponding to the first time interval. E _N ′, where the first data set E ₀ ′ corresponds to the first period, and the second data set E _N ′ corresponds to the second period, and the first period is earlier than the second period. The first data set E ₀ ′ and the second data set E _N ′ may include M sampling data R _j (j = 1 ~ M, where M is an arbitrary positive integer).

Specifically, the data storage module 201 can store the accumulated water consumption data from the transceiver 300. The data acquisition module 202 may sample the accumulated water consumption data stored in the data storage module 201 to generate one or more data sets E _i ′ (i = 0 ~ N, where N Is any positive integer). For example, the data storage module 201 may sample one piece of sampling data from the cumulative water consumption data at each sampling interval (for example, every minute), and then sample M pieces of data (for example, fifteen pieces) R _j ( j = 1 ~ M) is combined into a data set E _i ′ (i = 0 ~ N) corresponding to the first time interval (for example, every fifteen minutes). In detail, if the first time interval is T ₁ and the data acquisition module 202 intends to sample at time T, the data acquisition module 202 may be based on a sampling interval between T _S = T-2 * T ₁ to Sampling during T _E = T – T ₁ to generate a data set E _i 'composed of at least one sample of water consumption data R _j (j = 1 ~ M), where R ₁ corresponds to time T _S , R _M Corresponds to time T _E and time T _S is separated from time T _E by a first time interval T ₁ . Subsequently, data capture module 202 may be before T _S, but the sum of the nearest sampled data R ₀ T _S is sampled out at the sampling time, and the data R _0, together with the sampling data set E _i 'to the data transfer filter module 203.

In some embodiments, the data storage module 201 may store statistical data corresponding to the data set E _i ′. In some embodiments, the data filtering module 203 and the data supplementing module 204 can process the data set, and then generate a plurality of statistical data corresponding to the data set E _i ′. Each piece of statistical data can represent the statistical results of all the original water consumption sampling data in the first time interval, which can include the time interval start time, the time interval end time, the first water consumption sample data, and the last water consumption sample. Data, the number of original sampling data in the first time interval, and equipment unique identifier.

Next, in step S220, the data filtering module 203 may filter the data set E _i ′ according to a threshold value to generate an aggregate data set E _i . FIG. 3 further illustrates a flowchart of step S220 of the water consumption monitoring method according to an embodiment of the present invention.

In step S221, the threshold value setting and calculation module 205 confirms whether there is a manually input threshold value (for example, each sampling) that is manually set in response to an unexpected situation (for example, a sudden increase in reasonable water consumption caused by an increase in temporary water demand). Maximum allowable increase in water use during the interval). If there is no manual input threshold value, in step S222, the threshold value setting and calculation module 205 may calculate the threshold value by using the past water consumption data. For example, the threshold value setting and calculation module 205 may obtain the increase in water consumption for each sampling interval in the same time period in the past three years, and use the largest one of the increase in water consumption as the threshold.

In step S223, the threshold setting and calculation module 205 can determine whether a difference between a second sampling data (for example: R _j ) and a first sampling data (for example: R _j-1 ) in the data set E _i ′ is Exceeds the threshold, wherein the sampling time of the first sampling data R _j-1 is earlier than the sampling time of the second sampling data R _j . If the determination result of step S223 is YES, the process proceeds to step S224, and if the determination result of step S223 is no, the process proceeds to step S225.

In step S224, the data filtering module 203 may remove the second sampling data R _j from the data set E _i ′. The purpose of this step is to remove the unreasonable increase in water consumption (that is, the difference between the water consumption between the sampling data R _j-1 and R _j is greater than the threshold) from the data set E _i ′.

In step S225, the data filtering module 203 determines whether the second sampling data R _j is the last sampling data R _M in the data set E _i ′. If the judgment result is no, the data filtering module 203 sets j = j + 1 in step S226 and executes step S223 again. If R _{j is} the last sampling data R _M , go to step S227. The data filtering module 203 may use the sampled data that has not been removed to form the condensed data set E _i (i = 0 ~ N). After executing step S227, the process may proceed to step S230.

In short, in the process of step S220, the data filtering module 203 can filter each data set E _i ′ and generate a corresponding plurality of reduced data set E _i .

Returning to FIG. 2, in step S230, the data complementing module 204 may respond to the first set of reduced data sets E ₀ and the second set of reduced data sets E _N with a sampling time difference exceeding the first time interval according to the first set. The reduced data set E ₀ and the second reduced data set E _N generate an imputed data set E _k (k = 1 ~ N-1). Specifically, after obtaining multiple sets of reduced data sets E _i , the data complementing module 204 first determines from the multiple sets of reduced data sets E _i (i = 0 ~ N) that they can be used as a linear interpolation operation. The first set of reduced data sets E ₀ and the second set of reduced data sets E _N.

First, the data supplementation module 204 sequentially judges whether sampling data exists in each of the reduced data sets E _i . If a constriction of all sampled data sampled data does not exist within the data set E _i, corresponding to the representative data sets within the constriction data set E _i E _i 'have been filtered data filtering module 203, and thus the current collector The reduced data set E _i does not have any sampling data, and the reduced data set E _{i is} not suitable as the second reduced data set E _N. In contrast, if the data set E _i constriction sampled data in memory, and representative of the current data set E _i corresponding to the reduced data set E _i ', there is not at least a sum of sampled data filter module 203 Profile Filtered. In this way, the data supplement module 204 may use the intensive data set E _i as the second intensive data set E _N.

After obtaining the reduced second current data set E _N, 204 data module's complement data storage module 201 may be removed from the sampling time which is earlier than the second current sampling time of reduced data set E _N, having at least a sum of sampled data and its A set of reduced data sets E _i whose sampling time is closest to the sampling time of the second set of reduced data sets E _N is taken as the first set of reduced data sets E ₀ . Then, the data complementing module 204 can determine whether there are other invalid set of reduced data sets E _i between the first set of reduced data sets E ₀ and the second set of reduced data sets E _N (ie: Reduced data set E _i ). The data storage module 201 can store the first set of reduced data sets E ₀ and the second set of reduced data sets E _N for future query.

Suppose the sampling time of the first sampling data of the first set of reduced data set E ₀ is T _S0 , the sampling time of the last sampling data is T _E0 , and the sampling time of the first sampling data of the second set of reduced data set E _N is T The sampling time of _SN and last sampling data is T _EN . If T _SN minus T _{S0 is} greater than the first time interval T1, it means that there are other invalid set data sets E _i between the first set data set E ₀ and the second set data set E _N (that is, set data There is no sampling data in the set E _i ). Profile module 204 may make the value of the reduced data set for the first current and the second current E ₀ reduced data set E _N linear interpolation operation data for the sample patch to be some constriction invalid data set. For example, the data interpolation module 204 may calculate the interpolation data set E _k (k = 1 ~ N-1) based on the first data set E ₀ and the second data set E _N through linear interpolation. The first and last samples of data, where the first set of reduced data set E ₀ corresponds to the first period, the second set of reduced data set E _N corresponds to the second period, and the imputed data set E _k corresponds to the third period , The first period is earlier than the second period and the third period is between the first period and the second period. The data storage module 201 can store the calculated interpolation data set E _k for future query.

In some embodiments, the complement value data module 204 through a linear interpolation can be used to repair operations to be filtered sampled data sampled according to first document data interpolated data set E _k and the last stroke of the sampled data, so that interpolation data set E _k Include M sampling data R _j (j = 1 ~ M, where M is any positive integer). The data storage module 201 can store the repaired interpolation data set E _k for future query.

On the other hand, the data complementation module 204 can also calculate the interpolation data set E _k (k = 1 ~ N-1) based on the statistics of the first set of reduced data sets E ₀ and the second set of reduced data sets E _N. Statistics, as shown in formula (1). Formula (1) Where v (a) represents a statistic of a, and N represents the total number of intensive data sets, and the statistic may be, for example, a variation amount, a standard deviation, or an average value, and the present invention is not limited thereto.

In step S240, the data correction module 206 can calculate the total water consumption according to the first set of reduced data sets E ₀ , the second set of reduced data sets E _N, and the interpolation data sets E _k . The data storage module 201 can store the calculated total water consumption for future inquiry. In detail, according to the data correction module 206 may correspond to the first current reduced data set E _0, the second header compression and a plurality of data sets T E _N T first data interpolation sampled data set and the plurality of E _k T sampling end of the pen The data calculate the total water consumption, as shown in formula (2). Formula (2) where U represents the total water consumption between the first period and the second period, f (a) represents the first sampling data of the intensive data set a, and l (a) represents the last sampling data of the intensive data set a , M (a, b) represents the conditional equation shown in formula (3). Formula (3)

To sum up, the water consumption monitoring device of the present invention can filter the original water consumption data, remove meaningless or abnormal sampling data (for example, sampling data of a surge in water consumption), and then more accurate sampling data Presented to the monitoring device, and can also greatly compress water data. The water consumption monitoring device can interpolate the sampling data to repair missing water consumption data, and can also calculate the total water consumption based on a small amount of sampling data. Through the water consumption monitoring method of the present invention, the water consumption monitoring device can correct various abnormal water consumption data.

Although the present invention has been disclosed as above with the examples, it is not intended to limit the present invention. Any person with ordinary knowledge in the technical field can make some modifications and retouching without departing from the spirit and scope of the present invention. The protection scope of the present invention shall be determined by the scope of the attached patent application.

10‧‧‧ Water consumption monitoring device

100‧‧‧ processing unit

200‧‧‧Storage unit

201‧‧‧Data Storage Module

202‧‧‧Data Acquisition Module

203‧‧‧Data Filtering Module

204‧‧‧Data Supplement Module

205‧‧‧Threshold setting and calculation module

206‧‧‧Data Correction Module

300‧‧‧ Transceiver

S210, S220, S221, S222, S223, S224, S225, S226, S227, S230, S240‧‧‧ steps

FIG. 1 is a schematic diagram of a water consumption monitoring device according to an embodiment of the present invention. FIG. 2 is a flowchart illustrating a method for monitoring water consumption according to an embodiment of the present invention. FIG. 3 is a flowchart illustrating steps of a water consumption monitoring method according to an embodiment of the present invention.

Claims (10)

A water consumption monitoring device includes: a transceiver that receives accumulated water consumption data; a storage unit that stores a plurality of modules; and a processing unit that is coupled to the transceiver and the storage unit, and accesses and executes the plurality of modules. Modules, the plurality of modules including: a data acquisition module that samples the accumulated water consumption data to generate a first data set and a second data set corresponding to a first time interval; a data filtering module according to A threshold value filters the first data set and the second data set to generate a first set of reduced data sets and a second set of reduced data sets, respectively; a data supplement module, in response to the first set of reduced data sets and A difference in sampling time of the second set of reduced data sets exceeds the first time interval to generate an imputed data set based on the first set of reduced data sets and the second set of reduced data sets; and a data correction module , Calculating a total water consumption according to the first reduced data set, the second reduced data set, and the imputed data set. The water consumption monitoring device according to item 1 of the scope of patent application, wherein the first data set and the second data set are filtered according to a threshold value to generate the first and second data sets, respectively. Steps include: in response to the difference between the second sampling data and the first sampling data in the first data set exceeding the threshold, removing the second sampling data from the first data set to generate the The first reduced data set, wherein a sampling time of the first sampling data is earlier than a sampling time of the second sampling data. The water consumption monitoring device according to item 1 of the scope of patent application, wherein the step of calculating the total water consumption according to the first reduced data set, the second reduced data set, and the imputed data set includes: The total water consumption is calculated according to a plurality of first sampling data and a plurality of last sampling data respectively corresponding to the first set of reduced data sets, the second set of reduced data sets, and the interpolation data set. The water consumption monitoring device according to item 1 of the scope of patent application, wherein the first data set corresponds to a first period, the second data set corresponds to a second period, and the imputed data set corresponds to a third A time period, wherein the third time period is between the first time period and the second time period, and the first time period is earlier than the second time period. The water consumption monitoring device according to item 4 of the scope of patent application, wherein the first data set includes a plurality of sampling data in the first period and valid sampling data closest to the first period, wherein the The sampling time of the valid sampling data is earlier than the first period. A water consumption monitoring method includes: receiving accumulated water consumption data, and sampling the accumulated water consumption data to generate a first data set and a second data set corresponding to a first time interval; filtering the first data according to a threshold value And the second data set to generate a first set of reduced data sets and a second set of reduced data sets, respectively; in response to a difference in sampling time between the first set of reduced data sets and the second set of reduced data sets exceeding Generating an interpolation data set according to the first time-series reduced data set and the second time-series reduced data set at the first time interval; and according to the first time-series reduced data set and the second time-series reduced data set And the imputation data set calculates total water consumption. The water consumption monitoring method according to item 6 of the scope of patent application, wherein the first data set and the second data set are filtered according to a threshold value to generate the first data set and the second data set, respectively. Steps include: in response to the difference between the second sampling data and the first sampling data in the first data set exceeding the threshold, removing the second sampling data from the first data set to generate the The first reduced data set, wherein a sampling time of the first sampling data is earlier than a sampling time of the second sampling data. The method for monitoring water consumption according to item 6 of the scope of patent application, wherein the step of calculating the total water consumption according to the first reduced data set, the second reduced data set, and the imputed data set includes: The total water consumption is calculated according to a plurality of first sampling data and a plurality of last sampling data respectively corresponding to the first set of reduced data sets, the second set of reduced data sets, and the interpolation data set. The water consumption monitoring method according to item 6 of the scope of patent application, wherein the first data set corresponds to a first period, the second data set corresponds to a second period, and the imputed data set corresponds to a third A time period, wherein the third time period is between the first time period and the second time period, and the first time period is earlier than the second time period. The method for monitoring water consumption according to item 9 of the scope of patent application, wherein the first data set includes multiple sampling data in the first period and valid sampling data closest to the first period, wherein the The sampling time of the valid sampling data is earlier than the first period.