Construction waste wagon balance data distributed storage verification method, computer equipment and medium

Abstract

The invention discloses a distributed storage verification method for construction waste wagon balance data, computer equipment and a medium, and the method comprises the following steps: S1, a wagon balance management server of a weight house records the wagon balance data of construction waste in and out of a warehouse in real time, and stores the wagon balance data into a local database; s2, the local database communicates with the cloud database, and weighbridge data is transmitted to the cloud database; and S3, periodically verifying the data in the local database and the cloud database, and if the data in the local database and the cloud database are found to be inconsistent, determining the position of the inconsistent data, and correcting the inconsistent data. Whether the data in the two databases are consistent or not is verified by adopting the total weight in the calculation time period, so that the operation is simple, the calculation amount can be reduced, the verification flexibility and efficiency are improved, and the consumption of system resources is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method for distributed storage and verification of construction waste weighing scale data, computer equipment and medium. Background Art

[0002] Construction waste refers to the waste generated during the construction, laying, demolition and repair of various buildings, structures, pipe networks, etc. by construction units or individuals. These wastes include slag, abandoned materials, mud and other wastes. They are the general term for slag, waste concrete, waste bricks and stones and other wastes generated by construction companies in production activities such as demolition, construction, decoration and maintenance.

[0003] There are usually several methods for treating construction waste: (1) Landfill: This is a traditional method for treating construction waste, which involves transporting construction waste to designated landfills for burial. However, this method has environmental problems, such as soil pollution and aggravated greenhouse effect. (2) Incineration: Construction waste is converted into heat energy or solid residue through high-temperature oxidation or reduction reactions. This method has a fast processing speed and occupies a small area, but the harmful gases and dust generated during the combustion process will pollute the air. (3) Recycling: Renewable resources in construction waste are extracted and processed to restore their value. This method can both 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. In order to improve the recycling rate, construction waste needs to be pre-treated, such as screening and crushing. (4) Biodegradation: Use microorganisms to decompose organic matter in construction waste and convert it into harmless substances. This method has low processing costs and little impact on the environment, but the processing cycle is long.

[0004] Before construction waste is processed, it needs to be recycled to the waste treatment plant, and then the usable waste is distributed to the corresponding location after resource processing. Every time the garbage truck enters and leaves the factory, the construction waste is weighed and the weight is recorded. In the process of construction waste treatment, the scale data is an important basis for evaluating the weight of the garbage and calculating the processing costs. With the development of big data and cloud computing technology, distributed storage systems are widely used in the storage and management of construction waste scale data. However, the problem of data consistency verification in distributed storage systems has always been a technical difficulty. Summary of the invention

[0005] In view of the deficiencies in the prior art, the present invention provides a method for distributed storage and verification of construction waste weighing scale data, a computer device and a medium, so as to improve the problems of difficulty in consistency verification and low accuracy of weighing scale data in the prior art.

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

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

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

[0009] S2, the local database communicates with the cloud database and transmits the weighbridge data to the cloud database;

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

[0011] In one embodiment, before storing the weighbridge data in the local database, the weighbridge data is preprocessed so that the weighbridge data stored in the local database has a unified format.

[0012] In one embodiment, the storage format of the weighbridge data is: timestamp-license plate number-weight-in and out storage type.

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

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

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

[0016] Verify whether the weighbridge data X is consistent with the weighbridge data Y. If not, determine whether the data in the local database or the cloud database is incorrect.

[0017] After determining the database with incorrect data, locate the incorrect data and correct it.

[0018] In one embodiment, checking whether the weighbridge data X is consistent with the weighbridge data Y 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 is inconsistent with the weighbridge data Y,

[0023] The weighbridge data X and the weighbridge data Y are divided into multiple segments {x1, x2, ..., x n}, {y1,y2,…,y n}, calculate the total weight of each fragment separately;

[0024] The fragment x n The total weight of the fragment y n If the total weights of the two fragments are consistent, it means that the data of the two fragments are consistent;

[0025] If the fragment x n The total weight of the fragment y n If the total weights of n ,y n Divide and repeat the above process.

[0026] In one embodiment, when the number of data entries contained in the divided segment is less than 15, the division 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 strip is located, the original data record of the weighing room is found based on the timestamp, license plate number, and entry and exit type of the data strip, and the erroneous data in the local database / cloud database is corrected based on the original data record.

[0028] In a second aspect, 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, computer instructions are stored in the memory, and the processor executes the distributed storage and verification method of construction waste scale data by executing the computer instructions.

[0029] In a third aspect, the present invention provides a computer-readable storage medium having computer instructions stored thereon, wherein the computer instructions are used to enable a computer to execute the method for distributed storage and verification of construction waste scale data.

[0030] The beneficial effect of the present invention is that the distributed storage and verification method, computer equipment and medium of the construction waste scale data of the present invention fully consider the characteristics of construction waste, and use the total weight within the calculation time period to verify whether the data in the two databases are consistent. This is not only simple to operate, but also can reduce the amount of calculation. There is no need to verify each scale data one by one, which improves the flexibility and efficiency of the 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. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] The present invention is further described below in conjunction with the accompanying drawings and embodiments.

[0032] Figure 1 It is a flow chart of the distributed storage and verification method of construction waste weighing scale data of the present invention.

[0033] Figure 2 It is a communication architecture diagram between the local database and the cloud database of the present invention. DETAILED DESCRIPTION

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

[0035] In the description of the present invention, it should be understood that the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", "clockwise", "counterclockwise", "axial", "radial", "circumferential" and the like indicate positions or positional relationships based on the positions or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention. In addition, features defined as "first" and "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, unless otherwise specified, "multiple" means two or more.

[0036] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0037] like Figure 1 to Figure 2 As shown, the distributed storage and verification method of construction waste scale data of this embodiment includes the following steps: S1. The scale management server of the scale room records the scale data of construction waste in and out in real time and stores it in the local database. S2. The local database communicates with the cloud database and transmits the scale data to the cloud database. S3. Periodically verify the data in the local database and the cloud database. If the data in the two data are inconsistent, determine the location of the inconsistent data and correct the inconsistent data.

[0038] It should be noted that weighbridge data is important data in the process of construction waste treatment. When the collection and transportation vehicles enter and leave the waste treatment plant, the weighbridge will be used to weigh the collection and transportation vehicles. During weighing, the collection and transportation vehicles stop on the weighbridge, and the camera is used to collect the license plate information of the collection and transportation vehicles. The weighbridge collects the weight data of the construction waste and sends it to the weighbridge management server. The camera sends the license plate number to the weighbridge management server. The weighbridge management server is placed in the weighing room and managed by the staff. After receiving the real-time weighbridge data, the weighbridge management server first pre-processes the weighbridge data and then sends it to the local database, so that the weighbridge data stored in the local data has a unified format.

[0039] In this embodiment, the preprocessing of the weighbridge data includes: data cleaning, format conversion, etc., to ensure the accuracy of the weighbridge data and the uniformity of the format. For example, the storage format of the weighbridge data is: timestamp-license plate number-weight-in and out storage type. The timestamp can reflect the time of weighing (including year / month / day / time), and the timestamp of each weighbridge data is unique. The license plate number is used to reflect the transport vehicle. The in and out storage type includes outbound and inbound. The storage format of this embodiment can reflect the relevant information when the construction waste is weighed, which is convenient for subsequent verification.

[0040] In this embodiment, the local database and the cloud database can interact with each other. That is, the weighbridge data exists in three places: the weighbridge management server, the local database, and the cloud database. Distributed storage has the following advantages: storage capacity and performance can be linearly expanded by adding new nodes; it is conducive to improving data reliability and security, and even if a node fails, other copies can still ensure data integrity and availability; costs are reduced through shared storage of multiple nodes, and storage capacity can be dynamically adjusted according to demand to achieve higher resource utilization. In order to ensure the reliability of the data, the data in the local database and the cloud database need to be periodically verified.

[0041] In this embodiment, step S3 specifically includes: the cloud database reads the weighbridge data X within the time period T from the local database; the cloud database filters its own weighbridge data Y within the time period T; checks whether the weighbridge data X is consistent with the weighbridge data Y, and if not, determines whether the data in the local database or the cloud database is incorrect; after determining the database with incorrect data, locates the incorrect data and corrects it. Checking whether the weighbridge data X is consistent with the weighbridge data Y includes: calculating 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 is consistent with the weighbridge data Y; if the total weight W1≠W2, it indicates that the weighbridge data X is inconsistent with the weighbridge data Y.

[0042] During verification, for example, the selected time period T is from 9:00 to 17:00 on March 1, 2024. There are 100 pieces of weighbridge data in this time period. These 100 pieces of weighbridge data (i.e., weighbridge data X and weighbridge data Y) are screened out in the local database and the cloud database respectively. Since the weighbridge data of construction waste is mainly weight data, in order to improve the efficiency of verification, during verification, the present embodiment first calculates the total weight of the 100 pieces of weighbridge data X and weighbridge data Y respectively. If the two total weights are the same, it is considered that the weighbridge data X and the weighbridge data Y are consistent. If the weight in a certain database is tampered with, the total weight will not match. When the total weight is found to be inconsistent, the next step of verification is performed, which can save a lot of time and improve the verification efficiency.

[0043] In this embodiment, when it is determined that the weighbridge data X and the weighbridge data Y are inconsistent, the weighbridge data X and the weighbridge data Y are divided into multiple segments {x1, x2, ..., x n}, {y1,y2,…,y n}, calculate the total weight of each fragment respectively; put the fragment x n The total weight of the fragment y n If the total weight of the two fragments is the same, it means that the data of the two fragments are consistent; if the fragment x n The total weight of the fragment y n If the total weights of n ,y n Divide and repeat the above process.

[0044] For example, when it is found that the total weight of 100 pieces of weighbridge data in the time period T of the two databases from 9:00 on March 1, 2024 to 16:00 on March 1, 2024 is inconsistent, the weighbridge data X and Y are further divided. For example, with a length of 2 hours, the weighbridge data X is divided into {x1, x2, x3, x4}, and the weighbridge data Y is divided into {y1, y2, y3, y4}, and the total weight of the segments x1, x2, x3, x4 is calculated respectively.

[0045] ””'

[0046] Compare w1, w2, w3, w4, and the total weight w1, w2, w3, w4 of segments y1, y2, y3, y4, and compare w1 with w1, w2 with w'2, w3 with w'3, and w4 with w'4. Assuming that w2 is found to be inconsistent with w'2 and the other three segments are consistent, the erroneous data can be located in segments x2 and y2. If the data entries contained in segments x2 and y2 are less than 15 at this time, there is no need to continue to divide segments x2 and y2. Directly compare the data entries in segments x2 and y2 one by one to find the entries with inconsistent weight data. If the data entries contained in segments x2 and y2 exceed 15 at this time, continue to divide segments x2 and y2 according to the time length of 30 minutes. For example, the segment after division is x2. 21 ,x 22 ,x 23 ,x 24 and 21 ,y 22 ,y 23 ,y 24 , calculate x respectively 21 ,x 22 ,x 23 ,x 24 The total weight w 21 ,w 22 ,w 23 ,w 24 , calculate y 21 ,y 22 ,y 23 ,y 24 The total weight w' 21 ,w' 22 ,w' 23 ,w' 24 , compare w 21 and

[0047] ”'

[0048] w 21 Are they consistent? Compare w 22 With w 22 Are they consistent? Compare w23 With w 23 Are they consistent? Compare w 24 With w' 24 Are they consistent? Suppose that w is found at this time 21 With w' 21 If the other three fragments are consistent, then the erroneous data can be located in fragment x. 21 ,y 21 If at this time segment x 21 ,y 21 If the data entry contained in is less than 15, then there is no need to perform segment x 21 ,y 21 Continue to divide and compare the fragments one by one 21 ,y 21 Through the above verification method, the incorrect data can be quickly and accurately located.

[0049] When the wrong data strip is located, the original data record of the weighing room is found according to the timestamp, license plate number, and entry and exit type of the data strip, and the wrong data in the local database / cloud database is corrected according to the original data record. Because the original data record is first-hand data, it can be used as a basis for correction.

[0050] The present invention also provides a computer device, including: a memory and a processor, the memory and the processor are connected to each other in communication, the memory stores computer instructions, and the processor executes the distributed storage verification method of building waste scale data by executing the computer instructions. In some optional embodiments, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Similarly, multiple computer devices can be connected, and each device provides some necessary operations (for example, as a server array, a group of blade servers, or a multi-processor system). The processor can be a central processing unit, a network processor or a combination thereof. Among them, the processor can further include a hardware chip. The above-mentioned hardware chip can be a dedicated integrated circuit, a programmable logic device or a combination thereof. The above-mentioned programmable logic device can be a complex programmable logic device, a field programmable logic gate array, a general array logic or any combination thereof. The memory can include a high-speed random access memory, and can also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device.

[0051] The present invention also provides a computer-readable storage medium, on which computer instructions are stored, and the computer instructions are used to enable a computer to execute a distributed storage and verification method for construction waste scale data. The storage medium may be a magnetic disk, an optical disk, a read-only storage memory, a random access memory, a flash memory, a hard disk or a solid-state hard disk, etc.; further, the storage medium may also include a combination of the above-mentioned types of memories. It can be understood that a computer, a processor, a microprocessor controller or programmable hardware includes a storage component that can store or receive software or computer code, and when the software or computer code is accessed and executed by a computer, a processor or hardware, the method shown in the above embodiment is implemented.

[0052] In summary, the distributed storage and verification method, computer equipment and medium of the construction waste scale data of the present invention fully consider the characteristics of construction waste, and use the total weight within the calculation time period to verify whether the data in the two databases are consistent. This is not only simple to operate, but also can reduce the amount of calculation. There is no need to verify each scale data one by one, which improves the flexibility and efficiency of the 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 ideal embodiments of the present invention, the relevant staff can make various changes and modifications without departing from the technical concept of the present invention through the above description. The technical scope of the present invention is not limited to the contents of the specification, but must be determined according to the scope of the claims.

Claims

1. A method for distributed storage and verification of construction waste weighbridge data, characterized in that: The following steps are involved: S1. The weighbridge management server in the weighing room records the weighbridge data of construction waste in and out in real time and stores it in the local database; S2, the local database communicates with the cloud database and transmits the weighbridge data to the cloud database; S3. Periodically verify the data in the local database and the cloud database. If inconsistency is found between the two data, determine the location of the inconsistent data and correct the inconsistent data.

2. The distributed storage and verification method for construction waste weighbridge data according to claim 1, characterized in that: Before storing the weighbridge data in the local database, the weighbridge data is preprocessed so that the weighbridge data stored in the local database has a unified format.

3. The distributed storage and verification method for construction waste weighbridge data according to claim 2, characterized in that: The storage format of the weighbridge data is: timestamp-license plate number-weight-in and out storage type.

4. The distributed storage and verification method for construction waste weighbridge data according to claim 3, characterized in that: Step S3 specifically includes: The cloud database reads the weighbridge data X within a time period T from the local database; The cloud database screens its own weighbridge data Y within a time period T; Verify whether the weighbridge data X is consistent with the weighbridge data Y. If not, determine whether the data in the local database or the cloud database is incorrect. After determining the database with incorrect data, locate the incorrect data and correct it.

5. The distributed storage and verification method for construction waste weighbridge data according to claim 4, characterized in that: Verifying whether the weighbridge data X is consistent with the weighbridge data Y includes: 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 is consistent with the weighbridge data Y; If the total weight W1≠W2, it indicates that the weighbridge data X and the weighbridge data Y are inconsistent.

6. The distributed storage and verification method for construction waste weighbridge data according to claim 5, characterized in that: When it is determined that the weighbridge data X is inconsistent with the weighbridge data Y, The weighbridge data X and the weighbridge data Y are divided into multiple segments {x1, x2, ..., x n }, {y1,y2,…,y n }, calculate the total weight of each fragment separately; The fragment x n The total weight of the fragment y n If the total weights of the two fragments are consistent, it means that the data of the two fragments are consistent; If the fragment x n The total weight of the fragment y n If the total weights of n ,y n Divide and repeat the above process.

7. The distributed storage and verification method for construction waste weighbridge data according to claim 6, characterized in that: When the number of data items contained in the divided segment is less than 15, the segmentation is stopped. 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 items are located.

8. The distributed storage and verification method for construction waste weighbridge data according to claim 7, characterized in that: When an erroneous data strip is located, the original data record of the weighing room is found according to the timestamp, license plate number, and entry and exit type of the data strip, and the erroneous data in the local database / cloud database is corrected according to the original data record.

9. A computer device, characterized in that: include: 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 distributed storage and verification method for construction waste scale data as described in any one of claims 1 to 8 by executing the computer instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the method for distributed storage and verification of construction waste scale data according to any one of claims 1 to 8.

Images