Data management method and system for engineering project synchronization prevention

Abstract

The invention discloses a data management method and system for engineering project synchronization prevention, and belongs to the technical field of engineering project management. The method comprises the steps that an engineering project database is established for an engineering project, an engineering project stage sub-database is established in the engineering project database according to engineering project stages, and an engineering project data table is established in the engineering project database; in the starting and ending period of the engineering project, after the engineering project generates new data, preprocessing the new data, adding data information to the new data, and generating target data; and importing the target data into the corresponding engineering project stage sub-database according to the data information, adding the data information into an engineering project data table, and recording time information of importing new data in the engineering project data table. According to the method, the data generated by the engineering project can be effectively managed in a unified manner, and the data can be effectively utilized.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering project management, and more specifically, to a data management method and system for synchronous prevention of engineering projects. Background Art

[0002] At present, a large amount of engineering project data will be generated during the implementation of engineering projects, including invalid data or duplicate data, as well as a large amount of non-standard data. As a result, it is difficult to summarize the engineering project data, and the data is difficult to use, making it impossible to reasonably monitor the engineering projects based on the data. Summary of the invention

[0003] In view of the above problems, the present invention proposes a data management method for synchronous prevention of engineering projects, comprising:

[0004] For the engineering project, a project database is built, and a project phase sub-database is built in the project database according to the project phases, and a project data table is established in the project database;

[0005] During the start and end period of the project, when the project generates new data, the new data is preprocessed and data information is added to the new data to generate target data;

[0006] The target data is imported into the corresponding engineering project phase sub-database according to the data information, and the data information is added to the engineering project data table, and the time information of importing the new data is recorded in the engineering project data table.

[0007] Optional, engineering project stages, including: project approval stage, construction preparation stage, construction stage, project handover stage and project completion stage.

[0008] Optionally, the method further includes:

[0009] Set up data management permissions for database administrators;

[0010] The data management permissions include: permissions to add, delete and modify the project stage sub-database, permissions to add, delete, modify, update and call imported data in the project stage sub-database, permissions to add, delete, modify, update and call the project data table, and opening or closing permissions to add, delete, modify and update imported data for project staff.

[0011] Optional, data information, including: engineering project phase information corresponding to the new data and data feature information;

[0012] The data characteristic information includes: project progress information and staff information.

[0013] Optionally, when the engineering project generates new data, the new data is preprocessed, including:

[0014] Extract features from the new data, and determine whether the new data is output data of the engineering project based on the extracted features. If so, normalize the new data; if not, give a data error prompt;

[0015] The normalization processing of the new data includes: adjusting the data format of the new data to a preset format, adding a standardized data name to the new data, and if the space occupied by the new data exceeds the preset requirement, splitting or compressing the new data to meet the space requirement;

[0016] The data name is a unique name.

[0017] Optionally, importing the target data into a corresponding engineering project phase sub-database according to the data information includes:

[0018] After receiving the target data, according to the data information, the corresponding engineering project stage sub-database is traversed to check whether there is similar data in the corresponding engineering project stage sub-database. If not, the target data is imported. If so, the target data is compared with the similar data. If the comparison result is consistent, the import is rejected. If the target data is updated compared with the similar data, the similar data is updated with the target data, and the updated information is added to the engineering project data table for record.

[0019] Optionally, the method further includes:

[0020] Obtain the identity information of the project staff, and add a staff information sub-database in the database. The staff identity information is stored in the staff information sub-database. When the staff imports new data into the database, obtain the staff identity authentication information, and verify the staff identity authentication information with the staff identity information stored in the staff information sub-database. If the verification passes, send a random verification code to the staff, verify the staff identity again, and if the verification passes, allow the staff to import new data.

[0021] Optionally, the method further includes:

[0022] Statistics are collected on the engineering project data stored in the database at a preset period to determine the phase progress of the engineering project and record the phase progress.

[0023] In another aspect, the present invention further proposes a data management system for synchronous prevention of engineering projects, comprising:

[0024] A database building unit, used to build a project database for a project, build a project phase sub-database in the project database according to the project phases, and establish a project data table in the project database;

[0025] A data processing unit is used to pre-process new data generated by the engineering project during the start and end period of the engineering project, and to add data information to the new data to generate target data;

[0026] The data management unit is used to import the target data into the corresponding engineering project phase sub-database according to the data information, add the data information to the engineering project data table, and record the time information of importing the new data in the engineering project data table.

[0027] Optional, engineering project stages, including: project approval stage, construction preparation stage, construction stage, project handover stage and project completion stage.

[0028] Optionally, the database building unit is also used to:

[0029] Set up data management permissions for database administrators;

[0030] The data management permissions include: permissions to add, delete and modify the project stage sub-database, permissions to add, delete, modify, update and call imported data in the project stage sub-database, permissions to add, delete, modify, update and call the project data table, and opening or closing permissions to add, delete, modify and update imported data for project staff.

[0031] Optional, data information, including: engineering project phase information corresponding to the new data and data feature information;

[0032] The data characteristic information includes: project progress information and staff information.

[0033] Optionally, when the engineering project generates new data, the new data is preprocessed, including:

[0034] Extract features from the new data, and determine whether the new data is output data of the engineering project based on the extracted features. If so, normalize the new data; if not, give a data error prompt;

[0035] The normalization processing of the new data includes: adjusting the data format of the new data to a preset format, adding a standardized data name to the new data, and if the space occupied by the new data exceeds the preset requirement, splitting or compressing the new data to meet the space requirement;

[0036] The data name is a unique name.

[0037] Optionally, importing the target data into a corresponding engineering project phase sub-database according to the data information includes:

[0038] After receiving the target data, according to the data information, the corresponding engineering project stage sub-database is traversed to check whether there is similar data in the corresponding engineering project stage sub-database. If not, the target data is imported. If so, the target data is compared with the similar data. If the comparison result is consistent, the import is rejected. If the target data is updated compared with the similar data, the similar data is updated with the target data, and the updated information is added to the engineering project data table for record.

[0039] Optionally, the data processing unit is further configured to:

[0040] Obtain the identity information of the project staff, and add a staff information sub-database in the database. The staff identity information is stored in the staff information sub-database. When the staff imports new data into the database, obtain the staff identity authentication information, and verify the staff identity authentication information with the staff identity information stored in the staff information sub-database. If the verification passes, send a random verification code to the staff, verify the staff identity again, and if the verification passes, allow the staff to import new data.

[0041] Optionally, the database building unit is also used to:

[0042] Statistics are collected on the engineering project data stored in the database at a preset period to determine the phase progress of the engineering project and record the phase progress.

[0043] In yet another aspect, the present invention further provides a computing device, comprising: one or more processors;

[0044] a processor for executing one or more programs;

[0045] When the one or more programs are executed by the one or more processors, the above-described method is implemented.

[0046] In yet another aspect, the present invention further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed, the method described above is implemented.

[0047] Compared with the prior art, the present invention has the following beneficial effects:

[0048] The present invention provides a data management method for synchronous prevention of engineering projects, including: for engineering projects, building an engineering project database, and building an engineering project stage sub-database in the engineering project database according to the engineering project stage, and establishing an engineering project data table in the engineering project database; during the start and end period of the engineering project, when the engineering project generates new data, pre-processing the new data, adding data information to the new data, and generating target data; importing the target data into the corresponding engineering project stage sub-database according to the data information, and adding the data information to the engineering project data table, and recording the time information of importing the new data in the engineering project data table. The present invention can effectively manage the data generated by the engineering project in a unified manner, and can effectively utilize the data, while also ensuring the security of the data. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] Figure 1 is a flow chart of the method of the present invention;

[0050] Figure 2 It is a structural diagram of the system of the present invention. DETAILED DESCRIPTION

[0051] Now, exemplary embodiments of the present invention are described with reference to the accompanying drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. These embodiments are provided to disclose the present invention in detail and completely and to fully convey the scope of the present invention to those skilled in the art. The terms used in the exemplary embodiments shown in the accompanying drawings are not intended to limit the present invention. In the accompanying drawings, the same units / elements are marked with the same reference numerals.

[0052] Unless otherwise specified, the terms (including technical terms) used herein have the commonly understood meanings to those skilled in the art. In addition, it is understood that the terms defined in commonly used dictionaries should be understood to have the same meanings as those in the context of the relevant fields, and should not be understood as idealized or overly formal meanings.

[0053] Embodiment 1:

[0054] The present invention proposes a data management method for engineering projects, or can be called a data management method for synchronous prevention of engineering projects, such as Figure 1 As shown, including:

[0055] Step 1: For the engineering project, a project database is built, and a project phase sub-database is built in the engineering project database according to the engineering project phase, and an engineering project data table is established in the engineering project database;

[0056] Step 2: During the start and end period of the project, when the project generates new data, pre-process the new data, add data information to the new data, and generate target data;

[0057] Step 3: Import the target data into the corresponding engineering project phase sub-database according to the data information, add the data information into the engineering project data table, and record the time information of importing the new data in the engineering project data table.

[0058] By adding the data information to the engineering project data table and recording the time information of importing new data in the engineering project data table, a data management method for synchronously preventing data errors in engineering projects is implemented.

[0059] Among them, the engineering project stages include: project approval stage, construction preparation stage, construction stage, project handover stage and project completion stage.

[0060] The method further includes:

[0061] Set up data management permissions for database administrators;

[0062] The data management permissions include: permissions to add, delete and modify the project stage sub-database, permissions to add, delete, modify, update and call imported data in the project stage sub-database, permissions to add, delete, modify, update and call the project data table, and opening or closing permissions to add, delete, modify and update imported data for project staff.

[0063] The data information includes: the engineering project phase information and data feature information corresponding to the new data;

[0064] The data characteristic information includes: project progress information and staff information.

[0065] When a project generates new data, the new data is preprocessed, including:

[0066] Extract features from the new data, and determine whether the new data is output data of the engineering project based on the extracted features. If so, normalize the new data; if not, give a data error prompt;

[0067] The normalization processing of the new data includes: adjusting the data format of the new data to a preset format, adding a standardized data name to the new data, and if the space occupied by the new data exceeds the preset requirement, splitting or compressing the new data to meet the space requirement;

[0068] The data name is a unique name.

[0069] The target data is imported into the corresponding engineering project phase sub-database according to the data information, including:

[0070] After receiving the target data, according to the data information, the corresponding engineering project stage sub-database is traversed to check whether there is similar data in the corresponding engineering project stage sub-database. If not, the target data is imported. If so, the target data is compared with the similar data. If the comparison result is consistent, the import is rejected. If the target data is updated compared with the similar data, the similar data is updated with the target data, and the updated information is added to the engineering project data table for record.

[0071] The method further includes:

[0072] Obtain the identity information of the project staff, and add a staff information sub-database in the database. The staff identity information is stored in the staff information sub-database. When the staff imports new data into the database, obtain the staff identity authentication information, and verify the staff identity authentication information with the staff identity information stored in the staff information sub-database. If the verification passes, send a random verification code to the staff, verify the staff identity again, and if the verification passes, allow the staff to import new data.

[0073] The method further includes:

[0074] Statistics are collected on the engineering project data stored in the database at a preset period to determine the phase progress of the engineering project and record the phase progress.

[0075] The present invention can effectively and uniformly manage the data generated by the engineering project and can effectively utilize the data.

[0076] Embodiment 2:

[0077] On the other hand, the present invention also provides a data management system 200 for engineering projects, or can be called a data management system for synchronous prevention of engineering projects, such as Figure 2 As shown, including:

[0078] The database construction unit 201 is used to construct a project database for a project, and to construct a project phase sub-database in the project database according to the project phases, and to establish a project data table in the project database;

[0079] The data processing unit 202 is used to pre-process new data generated by the engineering project during the start and end period of the engineering project, and add data information to the new data to generate target data;

[0080] The data management unit 203 is used to import the target data into the corresponding engineering project phase sub-database according to the data information, add the data information to the engineering project data table, and record the time information of importing the new data in the engineering project data table.

[0081] Among them, the engineering project stages include: project approval stage, construction preparation stage, construction stage, project handover stage and project completion stage.

[0082] The database building unit 201 is also used for:

[0083] Set up data management permissions for database administrators;

[0084] The data management permissions include: permissions to add, delete and modify the project stage sub-database, permissions to add, delete, modify, update and call imported data in the project stage sub-database, permissions to add, delete, modify, update and call the project data table, and opening or closing permissions to add, delete, modify and update imported data for project staff.

[0085] The data information includes: the engineering project phase information and data feature information corresponding to the new data;

[0086] The data characteristic information includes: project progress information and staff information.

[0087] When a project generates new data, the new data is preprocessed, including:

[0088] Extract features from the new data, and determine whether the new data is output data of the engineering project based on the extracted features. If so, normalize the new data; if not, give a data error prompt;

[0089] The normalization processing of the new data includes: adjusting the data format of the new data to a preset format, adding a standardized data name to the new data, and if the space occupied by the new data exceeds the preset requirement, splitting or compressing the new data to meet the space requirement;

[0090] The data name is a unique name.

[0091] The target data is imported into the corresponding engineering project phase sub-database according to the data information, including:

[0092] After receiving the target data, according to the data information, the corresponding engineering project stage sub-database is traversed to check whether there is similar data in the corresponding engineering project stage sub-database. If not, the target data is imported. If so, the target data is compared with the similar data. If the comparison result is consistent, the import is rejected. If the target data is updated compared with the similar data, the similar data is updated with the target data, and the updated information is added to the engineering project data table for record.

[0093] The data processing unit 202 is further used for:

[0094] Obtain the identity information of the project staff, and add a staff information sub-database in the database. The staff identity information is stored in the staff information sub-database. When the staff imports new data into the database, obtain the staff identity authentication information, and verify the staff identity authentication information with the staff identity information stored in the staff information sub-database. If the verification passes, send a random verification code to the staff, verify the staff identity again, and if the verification passes, allow the staff to import new data.

[0095] The database building unit 201 is also used for:

[0096] Statistics are collected on the engineering project data stored in the database at a preset period to determine the phase progress of the engineering project and record the phase progress.

[0097] The present invention can effectively manage the data generated by the engineering project in a unified manner, and can effectively utilize the data, while also ensuring the security of the data.

[0098] Embodiment 3:

[0099] Based on the same inventive concept, the present invention also provides a computer device, which includes a processor and a memory, wherein the memory is used to store a computer program, the computer program includes program instructions, and the processor is used to execute the program instructions stored in the computer storage medium. The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. It is the computing core and control core of the terminal, which is suitable for implementing one or more instructions, and is specifically suitable for loading and executing one or more instructions in the computer storage medium to implement the corresponding method flow or corresponding functions, so as to implement the steps of the method in the above embodiment.

[0100] Embodiment 4:

[0101] Based on the same inventive concept, the present invention also provides a storage medium, specifically a computer-readable storage medium (Memory), which is a memory device in a computer device for storing programs and data. It is understandable that the computer-readable storage medium here can include both a built-in storage medium in a computer device and an extended storage medium supported by the computer device. The computer-readable storage medium provides a storage space, which stores the operating system of the terminal. In addition, one or more instructions suitable for being loaded and executed by a processor are also stored in the storage space, and these instructions can be one or more computer programs (including program codes). It should be noted that the computer-readable storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk memory. The processor can load and execute one or more instructions stored in the computer-readable storage medium to implement the steps of the method in the above embodiment.

[0102] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes. The schemes in the embodiments of the present invention may be implemented in various computer languages, for example, object-oriented programming language Java and literal scripting language JavaScript, etc.

[0103] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0104] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0105] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0106] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0107] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. A data management method for synchronous prevention of engineering projects, characterized in that: include: For the engineering project, a project database is built, and a project phase sub-database is built in the project database according to the project phases, and a project data table is established in the project database; During the start and end period of the project, when the project generates new data, the new data is preprocessed and data information is added to the new data to generate target data; The target data is imported into the corresponding engineering project phase sub-database according to the data information, and the data information is added to the engineering project data table, and the time information of importing the new data is recorded in the engineering project data table.

2. The data management method according to claim 1, characterized in that: The engineering project stages include: project approval stage, construction preparation stage, construction stage, project handover stage and project completion stage.

3. The data management method according to claim 1, characterized in that: The method further comprises: Set up data management permissions for database administrators; The data management permissions include: permissions to add, delete and modify the project stage sub-database, permissions to add, delete, modify, update and call imported data in the project stage sub-database, permissions to add, delete, modify, update and call the project data table, and opening or closing permissions to add, delete, modify and update imported data for project staff.

4. The data management method according to claim 1, characterized in that: The data information includes: engineering project phase information and data feature information corresponding to the new data; The data characteristic information includes: project progress information and staff information.

5. The data management method according to claim 1, characterized in that: When the engineering project generates new data, the new data is preprocessed, including: Extract features from the new data, and determine whether the new data is output data of the engineering project based on the extracted features. If so, normalize the new data; if not, give a data error prompt; The normalization processing of the new data includes: adjusting the data format of the new data to a preset format, adding a standardized data name to the new data, and if the space occupied by the new data exceeds the preset requirement, splitting or compressing the new data to meet the space requirement; The data name is a unique name.

6. The data management method according to claim 1, characterized in that: The importing of the target data into the corresponding engineering project phase sub-database according to the data information includes: After receiving the target data, according to the data information, the corresponding engineering project stage sub-database is traversed to check whether there is similar data in the corresponding engineering project stage sub-database. If not, the target data is imported. If so, the target data is compared with the similar data. If the comparison result is consistent, the import is rejected. If the target data is updated compared with the similar data, the similar data is updated with the target data, and the updated information is added to the engineering project data table for record.

7. The data management method according to claim 1, characterized in that: The method further comprises: Obtain the identity information of the project staff, and add a staff information sub-database in the database. The staff identity information is stored in the staff information sub-database. When the staff imports new data into the database, obtain the staff identity authentication information, and verify the staff identity authentication information with the staff identity information stored in the staff information sub-database. If the verification passes, send a random verification code to the staff, verify the staff identity again, and if the verification passes, allow the staff to import new data.

8. A data management system for synchronous prevention of engineering projects, characterized in that: include: A database building unit, used to build a project database for a project, build a project phase sub-database in the project database according to the project phases, and establish a project data table in the project database; A data processing unit is used to pre-process new data generated by the engineering project during the start and end period of the engineering project, and to add data information to the new data to generate target data; The data management unit is used to import the target data into the corresponding engineering project phase sub-database according to the data information, add the data information to the engineering project data table, and record the time information of importing the new data in the engineering project data table.

9. A computer device, characterized in that: include: one or more processors; a processor for executing one or more programs; When the one or more programs are executed by the one or more processors, the data management method according to any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: A computer program is stored thereon, and when the computer program is executed, the data management method as described in any one of claims 1-7 is implemented.

Images