Construction tunnel personnel and equipment positioning method based on multi-source data support

Abstract

The invention discloses a construction tunnel personnel and equipment positioning method based on multi-source data support, relates to the field of scheduling systems, and aims to solve the problems that personnel scheduling cannot be accurately carried out, and the working efficiency is low due to the fact that workers in part of existing construction sites do not carry positioning systems and cannot observe the positions of the workers in real time. In the prior art, the processing efficiency of emergency events is poor, the following scheme is provided, the system comprises a handheld mobile terminal, a base station, a map database, an NFC data terminal, a power management module and a mobile scheduling platform, and the handheld mobile terminal is used for storing information of workers and uploading position information. The system is novel in structure, the power position of the online mobile client can be automatically uploaded to the mobile scheduling platform, the encryption effect is improved, information leakage is avoided, the safety of the method of the system is improved, data are uniformly stored in an Oracle10g database, unified management is achieved, and practicability is improved.

Description

Technical Field

[0001] The present invention relates to the field of dispatching systems, and in particular to a method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources. Background Art

[0002] With the construction of smart construction sites, construction site management urgently needs transformation and upgrading, and "smart construction" is about to emerge. As the construction area of ​​the construction site continues to increase, the number of construction site personnel continues to increase, and the construction behavior of the construction site has gradually become more complex, diversified, and normalized, which puts forward higher requirements for the reasonable deployment of construction site construction and rapid emergency dispatch. Some existing construction site staff do not carry positioning systems and cannot observe the positions of each staff member in real time, resulting in the inability to accurately dispatch personnel and poor efficiency in dealing with emergencies. Therefore, in order to solve such problems, we propose a construction tunnel personnel and equipment positioning method based on multi-source data support. Summary of the invention

[0003] The present invention proposes a method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources, which solves the problem that some existing construction site workers do not carry a positioning system and cannot observe the position of each worker in real time, resulting in inaccurate personnel scheduling and poor efficiency in dealing with emergencies.

[0004] In order to achieve the above object, the present invention adopts the following technical solutions:

[0005] A method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources, comprising a handheld mobile terminal, a base station, a map database, an NFC data terminal, a power management module, and a mobile scheduling platform, wherein the handheld mobile terminal is used for storing information of staff members and uploading location information, the base station is used for the construction of GPS positioning facilities, and is connected to the map database and the NFC data terminal, the map database is used for collecting positioning information, the map database is connected to the mobile scheduling platform, the power management module is used for power supply of the NFC data terminal, and is connected to the NFC data terminal, the NFC data terminal is used for near-field data communication with the handheld mobile terminal for positioning, the NFC data terminal is connected to the mobile scheduling platform, the mobile scheduling platform is used for staff information integration, and displays the location of each staff member on a map, and receives and issues unified scheduling commands, the mobile scheduling platform is connected to an Oracle10g database, and the Oracle10g database is used for storing data of the entire positioning information; the specific steps are as follows:

[0006] Step S1, start the handheld mobile terminal, complete the first manual clock-in when going to work, and manually upload the initial positioning information through the manual positioning information uploading module in the handheld mobile terminal to determine the initial position;

[0007] Step S2, the handheld mobile terminal automatically uploads positioning information through the GPS positioning module every five minutes;

[0008] Step S3, when the mobile terminal reaches the location of the NFC data terminal, the handheld mobile terminal is brought close to the NFC data terminal to complete data communication and report the current location;

[0009] Step S4, integrating the location information data through the data integration module to facilitate subsequent information query, and encrypting the data through the data encryption module;

[0010] Step S5, uploading the personnel location information to the map database, displaying it on the map, and generating the personnel movement trajectory;

[0011] Step S6: When leaving get off work, manually clock in for the second time and upload today's data information to the mobile scheduling platform;

[0012] Step S7: today's data is integrated and transferred to the Oracle10g database for storage.

[0013] Preferably, the handheld mobile terminal includes: a terminal GPS automatic positioning module, an information query module, and a manual positioning information upload module. The terminal GPS automatic positioning module is used for uploading the location information of the staff's handheld mobile terminal, and automatically sends positioning information at regular intervals. The information query module is used for information and location query of the staff, and the manual positioning information upload module is used for manually uploading location information.

[0014] Preferably, the base station includes an NFC data transmission module, a base station GPS automatic positioning module, an encryption module, and a data integration module;

[0015] The NFC data transmission module is used to perform data interaction with the NFC data terminal;

[0016] The base station GPS automatic positioning module is used for uploading the location information of the staff's handheld mobile terminal, and automatically sends the positioning information at regular intervals;

[0017] The encryption module is used to encrypt data files;

[0018] The data integration module is used for integrating data files.

[0019] Preferably, the power management module includes a Bluetooth transmission module, a CPU processor, and a USB interface module;

[0020] The Bluetooth transmission module is used to remotely transmit the data in the NFC data terminal to the mobile scheduling platform, the CPU processor is used to process the data in the NFC terminal, and the USB interface module is used to charge the power management module.

[0021] Preferably, before manually clocking in at step S1, various data of the user should be entered into the handheld mobile terminal, including but not limited to name, job type, and job position.

[0022] Preferably, the data intercommunication work in step S3 requires the handheld mobile terminal to be brought close to the NFC data terminal for face-to-face contact, so as to perform the location upload work.

[0023] Preferably, the data integration in step S4 adopts any one of the software such as Kettle, Informatica, Datastage, and ODI, and the data encryption method in step S4 adopts plain text encryption method.

[0024] Preferably, the map information processing in step S5 is performed by knowledge extraction to extract information data that meets the requirements.

[0025] Preferably, the Oracle10g supports multi-server cluster / Cluster parallel processing mode and supports dual-machine or multi-machine system operation. In the parallel processing mode, Oracle implements a shared database on each node of the Cluster structure, and automatically implements parallel processing and load balancing. It can achieve fault tolerance and breakpoint-free recovery when a server fails, ensuring that the front-end application is not affected.

[0026] The beneficial effects of the present invention are: the online mobile client can automatically report the mobile terminal's geographical location to the mobile scheduling platform at intervals, and the automatic interval time depends on the customer-specified operator agreement and related hardware and network pressure. At the same time, the location information of the staff can be queried to facilitate the scheduling work, and the encryption effect is increased to avoid information leakage, increase the security of the system method, and store the data in an Oracle10g database for unified management to increase practicality.

[0027] In summary, the present invention is easy to use, and can automatically upload the power position of the online mobile client to the mobile scheduling platform, and increases the encryption effect to avoid information leakage, increase the security of the system method, and store the data in the Oracle10g database for unified management, thereby increasing practicality. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] Figure 1 This is a structural diagram of a method for positioning personnel and equipment in a construction tunnel based on multi-source data support as described in the present invention.

[0029] Figure 2 For the present invention Figure 1 Schematic diagram of the structure of a handheld mobile terminal.

[0030] Figure 3 For the present invention Figure 1 Schematic diagram of the structure of the base station.

[0031] Figure 4 For the present invention Figure 1 Schematic diagram of the power management module.

[0032] Figure 5 This is a workflow diagram of a method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources as described in the present invention.

[0033] Figure 6 The present invention provides a flowchart for extracting knowledge from a method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources. DETAILED DESCRIPTION

[0034] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments.

[0035] Example 1

[0036] Reference Figure 1 - Figure 3, a construction tunnel personnel and equipment positioning method based on multiple source data support, including a handheld mobile terminal, a base station, a map database, an NFC data terminal, a power management module, and a mobile scheduling platform, the handheld mobile terminal is used for storing staff information and uploading location information, the base station is used for the construction of GPS positioning facilities, and is connected to the map database and the NFC data terminal, the map database is used to collect positioning information, the map database is connected to the mobile scheduling platform, the power management module is used for power supply of the NFC data terminal, and is connected to the NFC data terminal, the NFC data terminal is used to communicate near-field data with the handheld mobile terminal for positioning, the NFC data terminal is connected to the mobile scheduling platform, the mobile scheduling platform is used for staff information integration, and displays the location of each staff member on the map, and receives and issues unified scheduling commands, the mobile scheduling platform is connected to the Oracle10g database, the Oracle10g database is used for the storage of the entire positioning information data, the handheld mobile terminal includes: a terminal GPS automatic positioning module, an information query module, an information query module, and a power management module. The base station comprises an NFC data transmission module, a base station GPS automatic positioning module, an encryption module, and a data integration module. The NFC data transmission module is used to interact with the NFC data terminal. The base station GPS automatic positioning module is used to upload the location information of the handheld mobile terminal of the staff, and automatically sends the location information at regular intervals. The encryption module is used to encrypt the data files, and the data integration module is used to integrate the data files. The power management module comprises a Bluetooth transmission module, a CPU processor, and a USB interface module. The Bluetooth transmission module is used to remotely transmit the data in the NFC data terminal to the mobile scheduling platform. The CPU processor is used to process the data in the terminal, and the USB interface module is used to charge the power management module.

[0037] Example 2

[0038] Reference Figure 3 , Figure 4 , a method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources, comprising the following steps:

[0039] Step S1: Start the handheld mobile terminal. Complete the first manual clock-in during work hours, and upload the initial location information manually through the manual location information upload module in the handheld mobile terminal to determine the initial position. Before performing the manual clock-in in step S1, the data of the current user, including but not limited to name, job type, and work position, should be entered into the handheld mobile terminal first.

[0040] Step S2: The handheld mobile terminal automatically uploads the location information through the GPS positioning module every five minutes.

[0041] Step S3: When approaching the position of the NFC data terminal, bring the handheld mobile terminal close to the NFC data terminal to complete data intercommunication and report the current position. In step S3, for data intercommunication, the handheld mobile terminal needs to be brought close to the NFC data terminal for face-to-face contact to perform the position upload work.

[0042] Step S4: Integrate the location information data through the data integration module for convenient subsequent information query, and encrypt the data through the data encryption module. For the data integration in step S4, any one of the software such as Kettle, Informatica, Datastage, and ODI is used. The data encryption method in step S4 uses the plaintext encryption method, and the encryption algorithm of the plaintext encryption method is as follows: S = {P, C, K, E, D}, where P - plaintext space, representing the set of all possible plaintexts; C - ciphertext space, representing the set of all possible ciphertexts; K - key space, and the key is a variable parameter in the encryption algorithm; E - encryption algorithm, consisting of some formulas, rules, or programs; D - decryption algorithm, which is the inverse of E. When a given key is given, the following relationships exist among the symbols: C = Ek(P), encrypting the plaintext P to obtain the ciphertext C, P = Dk(C) = Dk(Ek(P)). Decrypting the ciphertext C to obtain the plaintext P. If E-1 represents the inverse of E and D-1 represents the inverse of D, then there are:

[0043] Ek = Dk-1 and Dk = Ek-1

[0044] The encryption mode uses the counter mode encryption to encrypt a series of input data blocks to generate a series of output blocks. The output blocks are XORed with the plaintext to obtain the ciphertext. For the last data block, it may be a partial data block of length u bits, and these u bits will be used for the XOR operation, while the remaining b - u bits will be discarded (b represents the block length). CTR decryption is similar. This series of counts must be different from each other. Assuming the counts are represented as T1, T2,..., Tn, the counter mode can be defined as follows:

[0045] The counter mode encryption formula is as follows:

[0046] Cj=PjXOREk(Tj)

[0047] C*n=P*nXORMSBu(Ek(Tn))j=1,2...n-1;

[0048] The CTR decryption formula is as follows:

[0049] Pj=CjXOREk(Tj)

[0050] P*n=C*nXORMSBu(Ek(Tn))j=1,2...n-1;

[0051] Encryption method: The cryptographic algorithm generates a 16-byte pseudo-random code block stream. The pseudo-random code block is XORed with the input plaintext to generate ciphertext output. The ciphertext is XORed with the same pseudo-random code to generate plaintext.

[0052] Step S5, uploading the personnel location information to the map database, displaying it on the map, and generating the personnel movement trajectory. The map information processing in step S5 is performed by knowledge extraction to extract the information data that meets the requirements. The knowledge extraction method refers to Figure 4 , specifically: InputLayer: the input sentence, each word is represented by a one-hot vector;

[0053] EmbeddingLayer: pre-trained word embedding layer, providing query vocabulary for one-hot vectors;

[0054] LSTMLayer: Use BiLSTM to encode the input sentence and obtain the output at each moment, that is, the encoding result corresponding to each word;

[0055] AttentionLayer: The typical Soft-Attention layer directly randomly initializes a parameter vector as the Query, which is used to perform one-dimensional matching with the encoding result of the sentence to calculate the attention score, and then performs a weighted summation of the encoding results of each word in the sentence. The specific expression is as follows:

[0056] M=tanh(H)

[0057] a=softmax(w"M)

[0058] r=Ha'

[0059] Among them, H is the output of BiLSTM at all times, w is a randomly initialized parameter vector, which also participates in model training, a is the calculation result of the attention score, r is the weighted result of the H attention score, and finally the weighted attention result is activated by a tanh function, that is, h*=tanh(r) to obtain the output of the attention layer;

[0060] OutputLayer: a fully connected layer classifier, the loss function is cross entropy, and the L2 regularization term is added;

[0061] Step S6: When leaving get off work, manually clock in for the second time and upload today's data information to the mobile scheduling platform;

[0062] Step S7, today's data is unified and integrated, and transmitted to the Oracle10g database for storage. The Oracle10g supports multi-server cluster / Cluster parallel processing and supports dual-machine or multi-machine system operation. In the parallel processing mode, Oracle implements a shared database on each node of the Cluster structure, and automatically implements parallel processing and load balancing. It can achieve fault tolerance and breakpoint-free recovery when a server fails, ensuring that the front-end application is not affected.

[0063] To sum up: start the handheld mobile terminal, complete the first manual clock-in when going to work, and manually upload the initial positioning information through the manual positioning information upload module in the handheld mobile terminal to determine the initial position. Then the handheld mobile terminal automatically uploads the positioning information through the GPS positioning module every five minutes. When it reaches the position of the NFC data terminal, bring the handheld mobile terminal close to the NFC data terminal to complete data exchange and report the current position. Through the data integration module, integrate the location information data to facilitate subsequent information query, and encrypt the data through the data encryption module, and upload the personnel positioning information to the map database through the Bluetooth transmission module, display it on the map, and generate the personnel movement trajectory. When leaving get off work, perform the second manual clock-in, and upload today's data information to the mobile scheduling platform, unify and integrate today's data, and transfer it to the Oracle10g database for storage.

[0064] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources, characterized in that: It includes a handheld mobile terminal, a base station, a map database, an NFC data terminal, a power management module, and a mobile scheduling platform. The handheld mobile terminal is used for storing staff information and uploading location information. The base station is used for the construction of GPS positioning facilities and is connected to the map database and the NFC data terminal. The map database is used to collect positioning information. The map database is connected to the mobile scheduling platform. The power management module is used for power supply of the NFC data terminal and is connected to the NFC data terminal. The NFC data terminal is used to communicate near-field data with the handheld mobile terminal for positioning. The NFC data terminal is connected to the mobile scheduling platform. The mobile scheduling platform is used for staff information integration and displays the location of each staff member on the map to receive and issue unified scheduling commands. The mobile scheduling platform is connected to the Oracle10g database, and the Oracle10g database is used for storing the data of the entire positioning information. The specific steps are as follows: Step S1, start the handheld mobile terminal, complete the first manual clock-in when going to work, and manually upload the initial positioning information through the manual positioning information uploading module in the handheld mobile terminal to determine the initial position; Step S2, the handheld mobile terminal automatically uploads positioning information through the GPS positioning module every five minutes; Step S3, when the mobile terminal reaches the location of the NFC data terminal, the handheld mobile terminal is brought close to the NFC data terminal to complete data communication and report the current location; Step S4, integrating the location information data through the data integration module to facilitate subsequent information query, and encrypting the data through the data encryption module; Step S5, uploading the personnel location information to the map database, displaying it on the map, and generating the personnel movement trajectory; Step S6: When leaving get off work, manually clock in for the second time and upload today's data information to the mobile scheduling platform; Step S7: today's data is integrated and transferred to the Oracle10g database for storage.

2. A method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: The handheld mobile terminal includes: a terminal GPS automatic positioning module, an information query module, and a manual positioning information uploading module. The terminal GPS automatic positioning module is used to upload the location information of the staff's handheld mobile terminal, and automatically sends the positioning information at regular intervals; the information query module is used to query the information and location of the staff; the manual positioning information uploading module is used to manually upload the location information.

3. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1 is characterized in that: The base station includes an NFC data transmission module, a base station GPS automatic positioning module, an encryption module, and a data integration module; The NFC data transmission module is used to perform data interaction with the NFC data terminal; The base station GPS automatic positioning module is used for uploading the location information of the staff's handheld mobile terminal, and automatically sends the positioning information at regular intervals; The encryption module is used to encrypt data files; The data integration module is used for integrating data files.

4. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: The power management module includes a Bluetooth transmission module, a CPU processor, and a USB interface module; The Bluetooth transmission module is used to remotely transmit the data in the NFC data terminal to the mobile dispatching platform. The CPU processor is used to process the data in the terminal statement. The USB interface module is used to charge the power management module.

5. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: Before manual clock-in in step S1, various data of the current user should be entered into the handheld mobile terminal, including but not limited to name, job type, and work position.

6. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: In step S3, for data intercommunication, the handheld mobile terminal needs to be brought close to the NFC data terminal for face-to-face contact to perform the location upload operation.

7. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: The data integration in step S4 adopts any one of the software such as Kettle, Informatica, Datastage, and ODI. The data encryption method in step S4 adopts plaintext encryption method. The encryption algorithm of the plaintext encryption method is as follows: S = {P, C, K, E, D}, where P is plaintext space, representing the set of all possible plaintexts, C is ciphertext space, representing the set of all possible ciphertexts, K is key space, and the key is a variable parameter in the encryption algorithm, E is encryption algorithm, which is composed of some formulas, rules or procedures, and D is decryption algorithm, which is the inverse of E. When the key is given When , the symbols have the following relationship: C = Ek(P), after encrypting the plaintext P, the ciphertext C is obtained, P = Dk(C) = Dk(Ek(P)), if E-1 represents the inverse of E and D-1 represents the inverse of D, then: Ek = Dk-1 and Dk = Ek-1 The encryption mode uses the counter mode to encrypt a series of input data blocks, generating a series of output blocks. The output blocks are XORed with the plaintext to obtain the ciphertext. For the last data block, it may be a partial data block of length u bits, and these u bits will be used for the XOR operation, while the remaining b - u bits will be discarded. b represents the block length. CTR decryption is similar. This series of counters must be different from each other. Assuming the counters are represented as T1, T2,..., Tn, the counter mode can be defined as follows: The encryption formula for the counter mode is as follows: Cj = Pj XOR Ek(Tj) C*n = P*n XOR MSBu(Ek(Tn)) j = 1, 2... n-1; The CTR decryption formula is as follows: Pj = Cj XOR Ek(Tj) P*n = C*n XOR MSBu(Ek(Tn)) j = 1, 2... n-1; Encryption method: The cryptographic algorithm generates a 16-byte pseudo-random code block stream. The pseudo-random code block is XORed with the input plaintext to generate the ciphertext output. The ciphertext is XORed with the same pseudo-random code to generate the plaintext.

8. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: The map information processing in step S5 adopts the knowledge extraction method to extract the information data that meets the requirements. The knowledge extraction method is as follows: InputLayer: That is, the input sentence, and each word is represented by a one-hot vector; EmbeddingLayer: The pre-trained word vector layer provides a query word table for the one-hot vector; LSTMLayer: Use BiLSTM to encode the input sentence to obtain the output at each moment, that is, the encoding result corresponding to each word; AttentionLayer: The typical Soft-Attention layer directly randomly initializes a parameter vector as Query, which is used to perform a one-dimensional matching calculation of the attention score with the encoding result of the sentence, and then weights and sums the encoding results of each word in the sentence. The specific expression is as follows: M = tanh(H) a = softmax(w"M) r = Ha' Among them, H is the output of BiLSTM at all times, w is a randomly initialized parameter vector, which also participates in model training, a is the calculation result of the attention score, r is the weighted result of the H attention score, and finally the weighted attention result is activated by a tanh function, that is, h*=tanh(r) to obtain the output of the attention layer; OutputLayer: a fully connected layer classifier, the loss function is cross entropy, and the L2 regularization term is added.

9. The method for positioning personnel and equipment in a construction tunnel based on data support from multiple sources according to claim 1, characterized in that: The Oracle10g supports multi-server cluster / Cluster parallel processing mode and supports dual-machine or multi-machine system operation. In the parallel processing mode, Oracle implements a shared database on each node of the Cluster structure, and automatically implements parallel processing and load balancing. It can achieve fault tolerance and breakpoint-free recovery when a server fails, ensuring that the front-end application is not affected.

Images