Construction waste weighbridge data distributed storage verification method, computer device and medium

Abstract

The application discloses a kind of construction waste weighbridge data distributed storage verification method, computer equipment and medium, the method includes the following steps: S1, the weighbridge management server of pound room records the weighbridge data of construction waste warehouse in and out in real time, and is stored in local database;S2, local database and cloud database are communicated, and the weighbridge data is transmitted to cloud database;S3, the data in local database and cloud database are periodically verified, if the data in two data is found to be inconsistent, the position of inconsistent data is determined, and the inconsistent data is corrected.The total weight in calculation period is used to verify whether the data in two databases is consistent, which is not only simple to operate, but also can reduce the amount of operation, improve the flexibility and efficiency of verification, and reduce the consumption of system resources.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, specifically to a distributed storage and verification method for construction waste weighbridge data, computer equipment, and media. Background Technology

[0002] Construction waste refers to the waste generated by construction units or individuals during the construction, laying, demolition, and repair of various buildings, structures, pipelines, etc. This waste includes slag, waste materials, mud, and other waste; it is a general term for slag, waste concrete, waste bricks, and other waste generated by construction companies engaged in demolition, construction, decoration, and maintenance activities.

[0003] There are several common methods for treating construction waste: (1) Landfill: This is a traditional method of treating construction waste, which involves transporting the waste to a designated landfill for burial. However, this method has environmental problems, such as soil pollution and exacerbation of the greenhouse effect. (2) Incineration: Construction waste is converted into heat energy or solid residue through high-temperature oxidation or reduction reactions. This method is fast and requires little land, but the harmful gases and dust produced during combustion will pollute the air. (3) Recycling: Recyclable resources in construction waste are extracted and processed to give them renewed value. This method can reduce the generation of construction waste and save resources. However, due to the large amount of impurities in construction waste, the recycling rate is low. To improve the recycling rate, construction waste needs to be pre-treated, such as screened and crushed. (4) Biodegradation: Microorganisms are used to decompose the organic matter in construction waste and convert it into harmless substances. This method has low processing costs and little environmental impact, but the processing cycle is long.

[0004] Before construction waste can be recycled, it must first be collected at a waste treatment plant for resource recovery before the usable waste is distributed to appropriate locations. Each time a garbage truck enters or leaves the plant, the construction waste is weighed and its weight recorded. In the construction waste treatment process, weighbridge data is crucial for assessing waste weight and calculating treatment costs. With the development of big data and cloud computing technologies, distributed storage systems are widely used for storing and managing construction waste weighbridge data. However, data consistency verification in distributed storage systems remains a technical challenge. Summary of the Invention

[0005] To address the shortcomings of existing technologies, this invention provides a distributed storage and verification method, computer equipment, and medium for construction waste weighbridge data, thereby improving the problems of difficulty in verifying the consistency and low accuracy of weighbridge data in existing technologies.

[0006] The technical solution adopted by this invention to solve its technical problem is:

[0007] In a first aspect, the present invention provides a distributed storage and verification method for construction waste weighbridge data, comprising the following steps:

[0008] S1. The weighbridge management server in the weighbridge room records the weighbridge data of construction waste entering and leaving the warehouse in real time and stores it in the local database.

[0009] S2. The local database communicates with the cloud database to transmit the weighbridge data to the cloud database;

[0010] S3. Periodically verify the data in the local database and the cloud database. If inconsistencies are found between the two databases, determine the location of the inconsistent data and correct the inconsistent data.

[0011] In one embodiment, before storing the weighbridge data into a local database, the weighbridge data is preprocessed to ensure that the weighbridge data stored in the local database has a uniform format.

[0012] In one embodiment, the storage format of the weighbridge data is: timestamp-license plate number-weight-entry / exit type.

[0013] In one embodiment, step S3 specifically includes:

[0014] The cloud database reads the weighbridge data X within the time period T from the local database;

[0015] The cloud database filters its own weighbridge data Y within time period T;

[0016] Verify whether the weighbridge data X and the weighbridge data Y are consistent. If they are inconsistent, determine whether the data in the local database or the data in the cloud database is incorrect.

[0017] After identifying the database with incorrect data, locate and correct the erroneous data.

[0018] In one embodiment, verifying whether the weighbridge data X and the weighbridge data Y are consistent includes:

[0019] Calculate the total weight W1 of the weighbridge data X and the total weight W2 of the weighbridge data Y, respectively;

[0020] If the total weight W1 = W2, it indicates that the weighbridge data X is consistent with the weighbridge data Y;

[0021] If the total weight W1 ≠ W2, it indicates that the weighbridge data X and the weighbridge data Y are inconsistent.

[0022] In one embodiment, when it is determined that the weighbridge data X and the weighbridge data Y are inconsistent,

[0023] The weighbridge data X and the weighbridge data Y are divided into multiple segments {x1, x2, ..., x...} according to the same time length. n}、{y1,y2,…,y n} Calculate the total weight of each segment separately;

[0024] fragment x n Total weight and fragment y n The total weights of the two segments are compared. If the total weights of the two segments are the same, it means that the data of the two segments are consistent.

[0025] If fragment x n Total weight and fragment y n If the total weights are inconsistent, continue with fragment x. n y n Divide the data and repeat the above process.

[0026] In one embodiment, if the number of data entries in the divided segment is less than 15, the segmentation is not continued. At this time, the data in the local database and the cloud database in the segment are compared one by one to see if they are consistent, and the inconsistent data entries are located.

[0027] In one embodiment, when an erroneous data bar is located, the original data record of the weighbridge is found based on the data bar's timestamp, license plate number, and entry / exit type. The erroneous data in the local database / cloud database is then corrected based on the original data record.

[0028] Secondly, the present invention provides a computer device, comprising: a memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions to perform the distributed storage and verification method for construction waste weighbridge data.

[0029] Thirdly, the present invention provides a computer-readable storage medium storing computer instructions, the computer instructions being used to cause a computer to execute the distributed storage verification method for construction waste weighbridge data.

[0030] The beneficial effects of this invention are that the distributed storage verification method, computer equipment and medium for construction waste weighbridge data fully consider the characteristics of construction waste and use the total weight within a calculation period to verify whether the data in the two databases are consistent. This not only simplifies the operation but also reduces the amount of computation. There is no need to verify each weighbridge data one by one, which improves the flexibility and efficiency of verification. The verification cycle can be adjusted according to actual needs, reducing the overhead and cost of data consistency verification and reducing the consumption of system resources. Attached Figure Description

[0031] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0032] Figure 1 This is a flowchart of the distributed storage and verification method for construction waste weighbridge data of the present invention.

[0033] Figure 2 This is a communication architecture diagram between the local database and the cloud database of this invention. Detailed Implementation

[0034] The present invention will now be described in further detail with reference to the accompanying drawings. These drawings are simplified schematic diagrams, illustrating only the basic structure of the invention, and therefore only show the components relevant to the invention.

[0035] In the description of this invention, it should be understood that the terms "center," "longitudinal," "lateral," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," "axial," "radial," and "circumferential," etc., indicating orientation or positional relationships, are based on the orientation or positional relationships shown in the accompanying drawings and are only for the convenience of describing the invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of the invention. Furthermore, features defined with "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this invention, unless otherwise stated, "a plurality of" means two or more.

[0036] In the description of this invention, it should be noted that, unless otherwise explicitly specified and limited, the terms "installation," "connection," and "linking" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal connection of two components. Those skilled in the art can understand the specific meaning of the above terms in this invention based on the specific circumstances.

[0037] like Figures 1 to 2 As shown, the distributed storage and verification method for construction waste weighbridge data in this embodiment includes the following steps: S1, the weighbridge management server in the weighbridge room records the weighbridge data of construction waste entering and leaving the warehouse in real time and stores it in a local database. S2, the local database communicates with the cloud database to transmit the weighbridge data to the cloud database. S3, the data in the local database and the cloud database are periodically verified. If inconsistencies are found between the two databases, the location of the inconsistent data is determined and the inconsistent data is corrected.

[0038] It's important to note that weighbridge data is crucial in the construction waste disposal process. When collection vehicles enter or leave the waste treatment plant, they are weighed using a weighbridge. During weighing, the vehicles stop on the weighbridge, and cameras capture their license plate information. The weighbridge sends the collected construction waste weight data to the weighbridge management server, while the cameras send the license plate numbers to the same server. The weighbridge management server is located in the weighbridge room and managed by staff. Upon receiving real-time weighbridge data, the server preprocesses it before sending it to its local database, ensuring the stored data has a standardized format.

[0039] In this embodiment, the preprocessing of weighbridge data includes data cleaning, format conversion, etc., to ensure the accuracy and format consistency of the weighbridge data. For example, the storage format of the weighbridge data is: timestamp-license plate number-weight-entry / exit type. The timestamp reflects the weighing time (including year / month / day / time), and each weighbridge data point has a unique timestamp. The license plate number identifies the transport vehicle. The entry / exit type includes exit and entry. The storage format of this embodiment reflects relevant information when weighing construction waste, facilitating subsequent verification.

[0040] In this embodiment, the local database and the cloud database can interact. That is, the weighbridge data exists in three places: the weighbridge management server, the local database, and the cloud database. Distributed storage is used, which has the following advantages: storage capacity and performance can be linearly scaled by adding new nodes; it improves data reliability and security, ensuring data integrity and availability even if a node fails; it reduces costs through shared storage across multiple nodes and allows for dynamic adjustment of storage capacity based on demand, achieving higher resource utilization. To ensure data reliability, the data in both the local and cloud databases needs to be periodically verified.

[0041] In this embodiment, step S3 specifically includes: the cloud database reading weighbridge data X within time period T from the local database; the cloud database filtering its own weighbridge data Y within time period T; verifying whether weighbridge data X and weighbridge data Y are consistent; if they are inconsistent, determining whether the data in the local database or the cloud database is incorrect; after identifying the database with incorrect data, locating the erroneous data and correcting it. Verifying whether weighbridge data X and weighbridge data Y are consistent includes: calculating the total weight W1 of weighbridge data X and the total weight W2 of weighbridge data Y respectively; if the total weight W1 = W2, it indicates that weighbridge data X and weighbridge data Y are consistent; if the total weight W1 ≠ W2, it indicates that weighbridge data X and weighbridge data Y are inconsistent.

[0042] During verification, for example, if the selected time period T is from 9:00 AM to 5:00 PM on March 1, 2024, there are 100 weighbridge data entries within this time period. These 100 weighbridge data entries (i.e., weighbridge data X and weighbridge data Y) are filtered from both the local database and the cloud database. Since the weighbridge data for construction waste mainly consists of weight data, to improve verification efficiency, this embodiment first calculates the total weight of the 100 data entries for both weighbridge data X and weighbridge data Y. If the two total weights are the same, then weighbridge data X and weighbridge data Y are considered consistent. If the weight in one of the databases is tampered with, the total weight will not match. When a discrepancy in the total weight is found, the next step of verification is performed. This saves a lot of time and improves verification efficiency.

[0043] In this embodiment, when it is determined that the weighbridge data X and weighbridge data Y are inconsistent, the weighbridge data X and weighbridge data Y are divided into multiple segments {x1, x2, ..., x...} according to the same time length. n}、{y1,y2,…,y n}, calculate the total weight of each segment separately; divide segment x n Total weight and fragment y n The total weights of the two segments are compared. If the total weights of the two segments are the same, it means that the data of the two segments are consistent; if segment x... n Total weight and fragment y n If the total weights are inconsistent, continue with fragment x. n y n Divide the data and repeat the above process.

[0044] For example, when the total weight of 100 weighbridge data entries from two databases within the time period T (March 1, 2024, 9:00 AM to 4:00 PM) is found to be inconsistent, the weighbridge data X and Y are further divided. For instance, using a 2-hour interval, weighbridge data X is divided into {x1, x2, x3, x4}, and weighbridge data Y is divided into {y1, y2, y3, y4}, and the total weight of segments x1, x2, x3, and x4 is calculated for each segment.

[0045] ""

[0046] Given the weights w1, w2, w3, w4, and the total weights w1, w2, w3, w4 of segments y1, y2, y3, y4, compare w1 with w1, w2 with w'2, w3 with w'3, and w4 with w'4. If w2 and w'2 are found to be inconsistent, while the other three segments are consistent, the erroneous data can be located in segments x2 and y2. If segments x2 and y2 contain fewer than 15 data entries, do not further divide segments x2 and y2; directly compare each data entry in segments x2 and y2 to find the inconsistent weight data. If segments x2 and y2 contain more than 15 data entries, further divide segments x2 and y2 according to a 30-minute time length. For example, the divided segments might be x... 21 ,x 22 ,x 23 ,x 24 and y 21 ,y 22 ,y 23 ,y 24 Calculate x respectively 21 ,x 22 ,x 23 ,x 24 Total weight w 21 ,w 22 ,w 23 ,w 24 Calculate y 21 ,y 22 ,y 23 ,y 24 Total weight w' 21 ,w' 22 ,w' 23 ,w' 24 Comparison w 21 and

[0047] "'

[0048] w 21 Whether they are consistent, compare w 22 with w 22 Whether they are consistent, compare w23 with w 23 Whether they are consistent, compare w 24 with w' 24 Are they consistent? Suppose we find that w at this point... 21 with w' 21 If the data is inconsistent, but the other three segments are consistent, then the erroneous data can be located in segment x. 21 y 21 In the middle. If at this time fragment x 21 y 21 If the data contains fewer than 15 entries, then fragment x does not need to be processed. 21 y 21 Continue dividing and directly comparing each segment x. 21 y 21 The data entries in the database are used to identify entries with inconsistent weight data. By using the verification methods described above, erroneous data can be located quickly and accurately.

[0049] When an erroneous data entry is located, the original data record of the weighbridge is found based on the data entry's timestamp, license plate number, and entry / exit type. The erroneous data in the local / cloud database is then corrected based on this original data record. Because the original data record is primary data, it can serve as the basis for correction.

[0050] This invention also provides a computer device, comprising: a memory and a processor, which are communicatively connected to each other. The memory stores computer instructions, and the processor executes the computer instructions to perform a distributed storage and verification method for construction waste weighbridge data. In some alternative embodiments, multiple processors and / or multiple buses can be used with multiple memories and multiple memory sets, if desired. Similarly, multiple computer devices can be connected, each providing some necessary operations (e.g., as a server array, a set of blade servers, or a multiprocessor system). The processor can be a central processing unit, a network processor, or a combination thereof. The processor may further include a hardware chip. The hardware chip can be an application-specific integrated circuit (ASIC), a programmable logic device (PLD), or a combination thereof. The programmable logic device can be a complex programmable logic device (CLP), a field-programmable gate array (FPGA), a general-purpose array logic (GPRS), or any combination thereof. The memory can include high-speed random access memory (RAM) and can also include non-transient memory, such as at least one disk storage device, flash memory, or other non-transient solid-state storage device.

[0051] This invention also provides a computer-readable storage medium storing computer instructions for causing a computer to execute a distributed storage verification method for construction waste weighbridge data. The storage medium may be a magnetic disk, optical disk, read-only memory, random access memory, flash memory, hard disk, or solid-state drive, etc.; further, the storage medium may also include combinations of the above types of memory. It is understood that computers, processors, microprocessor controllers, or programmable hardware include storage components capable of storing or receiving software or computer code, which, when accessed and executed by the computer, processor, or hardware, implement the methods shown in the above embodiments.

[0052] In summary, the distributed storage verification method, computer equipment, and medium for construction waste weighbridge data of the present invention fully consider the characteristics of construction waste and use the total weight within a calculation period to verify whether the data in the two databases are consistent. This not only simplifies the operation but also reduces the amount of computation. It eliminates the need to verify each weighbridge data one by one, improving the flexibility and efficiency of verification. The verification cycle can be adjusted according to actual needs, reducing the overhead and cost of data consistency verification and reducing the consumption of system resources.

[0053] Based on the above-described preferred embodiments of the present invention, and through the foregoing description, those skilled in the art can make various changes and modifications without departing from the inventive concept. The technical scope of this invention is not limited to the contents of the specification, but must be determined by the scope of the claims.

Claims

1. A method for checking distributed storage of construction waste weighbridge data, characterized in that, The method comprises the following steps: S1, a weighbridge management server of a weighbridge records real-time construction waste warehouse in and out of the weighbridge data, and stores it in a local database; The unified storage format of the weighbridge data is: timestamp-vehicle license plate number-weight-in and out of the warehouse type; S2, the local database communicates with the cloud database, and transmits the weighbridge data to the cloud database; S3, periodically check the data in the local database and the cloud database, if the data in the two data is inconsistent, determine the position of the inconsistent data, and correct the inconsistent data; Step S3 specifically includes: The cloud database reads the weighbridge data X in time period T from the local database; The cloud database filters its own weighbridge data Y in time period T; Check whether the weighbridge data X and the weighbridge data Y are consistent, if not, determine whether the data in the local database is wrong or the data in the cloud database is wrong; After determining the database with incorrect data, locate the incorrect data and correct it; Check whether the weighbridge data X and the weighbridge data Y are consistent, including: Calculate the total weight W1 of the weighbridge data X and the total weight W2 of the weighbridge data Y respectively; If the total weight W1=W2, it indicates that the weighbridge data X and the weighbridge data Y are consistent; If the total weight W1≠W2, it indicates that the weighbridge data X and the weighbridge data Y are inconsistent; When it is determined that the weighbridge data X and the weighbridge data Y are inconsistent, The weighing data X and the weighing data Y are divided into a plurality of segments {x1, x2, …, x n}、{y1, y2, …, y n} according to the same time length, and the total weight of each segment is calculated respectively; Compare the total weight of fragment x n with the total weight of fragment y n If the total weight of the two fragments is consistent, it indicates that the data of the two fragments is consistent. If the total weight of the segment x n is inconsistent with the total weight of the segment y n , continue to divide the segments x n , y n , and repeat the above process; When the number of data contained in the divided segment is less than 15, do not continue to divide, at this time, compare whether the data in the local database and the cloud database in the segment are consistent, and locate the inconsistent data; When the incorrect data is located, find the original data record of the weighhouse according to the timestamp, license plate number and in and out of the warehouse type of the data, and correct the error data in the local database / cloud database according to the original data record.

2. A computer device, comprising: It includes: A memory and a processor, which are connected with each other in communication, the memory stores computer instructions, and the processor executes the computer instructions to perform the construction waste weighbridge data distributed storage checking method of claim 1.

3. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer instructions, which are used to make the computer execute the construction waste weighbridge data distributed storage checking method of claim 1.

Images