A railway engineering geological survey database online collaboration tool and device

Abstract

The present application relates to the technical field of online cooperation of geological survey, in particular to a railway engineering geological survey database online cooperation tool and equipment, comprising: an initialization permission module, which is used for building a five-level cooperation architecture and initializing permissions; a cooperation operation module, which is used for uploading and updating data of different users; a conflict processing module, which is used for determining a conflict type and recording a conflict number; giving a conflict solution according to the conflict type; a data management module, which is used for obtaining a conflict factor, a fluctuation factor, a capacity factor and an access factor, adjusting a preset initial life cycle of each data, and obtaining a final life cycle of each data; and managing data through the final life cycle of each data. The present application improves the efficiency of online cooperation.

Description

Technical Field

[0001] This invention relates to the field of online collaborative geological exploration technology, and in particular to an online collaborative tool and equipment for railway engineering geological exploration databases. Background Technology

[0002] Currently, railway engineering geological surveys mainly utilize professional tools such as Lizheng Survey Software, storing structured data such as borehole data, strata data, and water levels in Access or SQL Server databases, and integrating with CAD platforms for data cataloging. However, existing technologies suffer from key problems such as low collaboration efficiency (reliance on hard drive copying leads to version inconsistencies), difficulty in data management (local storage is prone to loss and difficult to trace), insufficient standardization (inconsistent input specifications), and weak quality control (lack of transparency in incremental changes). There is an urgent need for a technical solution that supports online collaboration, intelligent conflict resolution, and full lifecycle management to improve the efficiency and data reliability of railway survey projects. Summary of the Invention

[0003] This invention provides an online collaborative tool and equipment for railway engineering geological survey databases, which addresses the problems of low collaboration efficiency, difficult data management, insufficient standardization, and weak quality control in existing railway engineering geological surveys.

[0004] The objective of this invention can be achieved through the following technical solutions:

[0005] The first aspect of this invention is to provide an online collaborative tool for railway engineering geological survey databases, comprising:

[0006] Initialize permissions module: Used to build a five-level collaborative architecture and initialize permissions;

[0007] Collaborative task module: used for data upload and update operations by different users;

[0008] Conflict handling module: This module is used to bind a conflict detection rule base to each paragraph, perform conflict detection on each paragraph using the conflict detection rule base, and obtain the conflict type of each paragraph; when a user uploads or updates data, it calls the initialization permission module to verify the paragraph operation permission, and determines whether there is a conflict based on the permission verification result; when a conflict occurs, it determines the conflict type and records the number of conflicts; and provides a solution to the conflict based on the conflict type.

[0009] Data Management Module: This module quantifies the conflict factor based on the number of times each data item is conflicted; determines the fluctuation factor based on the number of times each user modifies each data item; obtains the capacity factor for each data item; determines the access factor for each data item based on the number of times each data item is accessed; adjusts the preset initial lifecycle of each data item using the conflict factor, fluctuation factor, capacity factor, and access factor to obtain the final lifecycle of each data item; and manages the data based on the final lifecycle of each data item.

[0010] Furthermore, the construction of the five-level collaborative architecture and the initialization of permissions include:

[0011] In the project architecture setup, a five-level project management system is established, including project level, phase level, section level, solution level, and work point level;

[0012] The system is configured with three user roles: super administrator, project manager, and team member. The super administrator is responsible for the overall system configuration, the project manager is responsible for managing specific survey projects, and the team member is responsible for data collection and editing.

[0013] Furthermore, the data upload and update operations for different users include:

[0014] The person in charge uploads route information, assigns permissions to group members for each section, group members download general configurations, group members download routes, group members upload or update design drilling and CAD data, group members update all scheme data at the section level or create new schemes, group members upload or update scheme data, and group members upload or update work site data.

[0015] Furthermore, the provision of conflict resolution based on the type of conflict includes:

[0016] The conflict types include conflicts in scheme name, exploration point number, CAD file, report document, and geological logic. The solution strategy for scheme name conflicts is to force overwrite or rename. The solution strategy for exploration point number conflicts is to retain data that conforms to stratigraphic continuity or mark abnormal data for manual review. The solution strategy for CAD file conflicts is to highlight the elements modified by different users or support selective merging by layer. The solution strategy for report document conflicts is to mark deleted content in red or added content in green or manually select to retain paragraphs. The solution strategy for geological logic conflicts is to adjust the stratigraphic thickness to the allowable range of the specification or forcibly insert fault markers and notify the person in charge.

[0017] Furthermore, the conflict factor is quantified based on the number of times each data conflict occurs; the fluctuation factor is determined based on the number of times the user modifies each data point, including:

[0018] The conflict factor is specifically expressed by the formula:

[0019]

[0020] In the formula, This indicates the total number of uploads for each piece of data. This indicates the number of conflict triggers for each data item. This represents the conflict factor for each data point;

[0021] The volatility factor is specifically expressed by the formula:

[0022]

[0023] In the formula, This indicates the total number of days each data point exists. This indicates the number of times each data point has been modified in the past month. This represents the volatility factor for each data point.

[0024] Further, obtaining the capacity factor for each data point includes:

[0025] When each piece of data is a single file, and the size of a single file is greater than 1GB, the capacity factor of each piece of data is recorded as 0.7;

[0026] When each data point is a paragraph-level population, and the total size of all files within the same paragraph is greater than 10GB, then the capacity factor for each data point is set to 0.5.

[0027] In other cases, the capacity factor for each data point is set to 1.

[0028] Furthermore, determining the access factor for each piece of data based on the number of times each piece of data is accessed includes:

[0029]

[0030] In the formula, This represents the average number of times all data is accessed. This indicates the number of times each piece of data was accessed. This represents the access factor for each piece of data.

[0031] Furthermore, the step of adjusting the preset initial lifecycle of each data point using the conflict factor, the volatility factor, the capacity factor, and the access factor to obtain the final lifecycle of each data point includes:

[0032]

[0033] In the formula, This represents the conflict factor for each data point. This represents the volatility factor for each data point. This represents the capacity factor for each data point. This represents the access factor for each piece of data. This indicates the preset initial lifespan of each data item. This indicates the final lifecycle of each piece of data.

[0034] A second aspect of the present invention is to provide an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the computer program, implements the aforementioned online collaborative tool for railway engineering geological survey database.

[0035] A third aspect of the present invention is to provide a computer-readable storage medium storing a computer program that, when executed by a processor, implements the aforementioned online collaborative tool for railway engineering geological survey database.

[0036] Compared with existing technologies, the beneficial effects of this invention are: constructing a five-level collaborative architecture and initializing permissions; solving the problems of low efficiency and insufficient annotation; enabling data upload and update operations for different users; solving the problems of data version confusion and opaque progress; binding a conflict detection rule library to each paragraph, performing conflict detection on each paragraph through the conflict detection rule library, and obtaining the conflict type of each paragraph; when a user uploads or updates data, calling the initialization permission module to verify the paragraph operation permission, judging whether there is a conflict based on the permission verification result, and determining the conflict type and recording the number of conflicts when a conflict occurs; providing a conflict solution based on the conflict type; solving the problem of data conflict and reducing the impact of data conflict; quantifying the conflict factor based on the number of conflicts of each data; determining the fluctuation factor based on the number of times the user modifies each data; obtaining the capacity factor of each data; determining the access factor of each data based on the number of times each data is accessed; adjusting the preset initial lifecycle of each data based on the conflict factor, the fluctuation factor, the capacity factor, and the access factor to obtain the final lifecycle of each data; managing data through the final lifecycle of each data, while improving data quality control, thus solving the problem of weak quality control. Attached Figure Description

[0037] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0038] Figure 1 This invention provides a schematic diagram of the module flow of an online collaborative tool for railway engineering geological survey database. Detailed Implementation

[0039] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0040] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0041] To address the problems existing in the background technology, an online collaborative tool and equipment for railway engineering geological exploration database has been developed, which has significant practical implications.

[0042] like Figure 1 As shown, the first aspect of the present invention is to provide an online collaborative tool for railway engineering geological survey databases, comprising:

[0043] Initialize permission module 101.

[0044] It should be noted that, in order to design an online collaborative tool for railway engineering geological survey database, the overall framework of the online collaborative tool is first designed based on the actual situation of railway engineering, and the complete online collaborative tool is designed through the overall framework.

[0045] Specifically, in user permission management, the system will set up three types of user roles, including super administrator, project manager, and team member; among them, the super administrator is responsible for the overall system configuration (enterprise IT management department), the project manager is responsible for managing specific exploration projects (overall exploration projects), and the team member is responsible for performing data collection and editing work (field geological engineer).

[0046] The project architecture is structured using a five-level project management system, including project level, phase level, section level, solution level, and work site level. The project level corresponds to the entire railway line, the phase level divides the survey and design phases, the section level is divided by geographical area, the solution level represents technical solutions, and the work site level represents specific engineering locations. Each level has its own independent access control policy.

[0047] This completes the setup of the five-level collaborative architecture and the initialization of permissions.

[0048] Collaborative work module 102.

[0049] It should be noted that during the collaborative work process, the data at each level is constantly changing. In order to ensure that the changes between the data at each level are not confusing, it is necessary to use online collaborative tools for progress monitoring and quality control. Therefore, a corresponding interface is needed to achieve visual viewing.

[0050] Specifically, a data distribution mechanism is designed, in which the system automatically filters data at each accessible level based on user permissions, adopts differential synchronization technology, transmits only changed data content, supports offline operation mode, and automatically synchronizes after the network is restored.

[0051] In real-time progress monitoring, a real-time progress visualization interface is designed to display the completion status at each level. Within this interface, progress indicators are designed for each level of the five-level project management system, allowing users to view the progress at each level. Specifically, the progress indicators for the project level include overall completion rate; for the phase level, these include phase completion rate, key deliverable completion rate, and cross-phase transition delay rate; for the segment level, geological logging progress; for the scheme level, scheme implementation coverage rate, technical parameter compliance rate, and economic deviation index; and for the work site level, data completeness and timeliness deviation.

[0052] A threshold is set for each progress indicator, and early warnings are issued based on each progress indicator to achieve high-quality control of railway engineering geological exploration.

[0053] The collaborative work phase includes the following operations: the person in charge uploads route information, the person in charge assigns permissions to team members for the section, team members download general configurations, team members download routes, team members upload or update design drilling and CAD data, team members update all scheme data at the section level or create new schemes, team members upload or update scheme data, and team members upload or update work site data.

[0054] This completes the data upload and update operations for different users.

[0055] Conflict resolution module 103.

[0056] It should be noted that in actual work, when multiple people are uploading or modifying data at different levels at the same time, conflicts are likely to occur. In order to resolve these conflicts, a conflict resolution mechanism is needed.

[0057] Specifically, a conflict detection rule base is bound to each paragraph, and conflict detection is performed on each paragraph through the conflict detection rule base to obtain the conflict type of each paragraph; when a user uploads or updates data, the initialization permission module is called to verify the paragraph operation permission, and the permission verification result is used to determine whether there is a conflict. When a conflict occurs, the conflict type is determined and the number of conflicts is recorded; and a solution to the conflict is given according to the conflict type.

[0058] The conflict types include conflicts in scheme names, exploration point numbers, CAD files, report documents, and geological logic.

[0059] In particular, during multi-person collaboration, potential conflicts may arise, necessitating the implementation of a two-way synchronization conflict resolution mechanism; the specific solution is as follows:

[0060] The strategies for resolving conflicting scheme names are to force overwrite or rename (i.e., to achieve naming consistency during "server ↔ local" two-way synchronization). The strategies for resolving conflicting exploration point numbers are to retain data that conforms to stratigraphic continuity or to mark abnormal data for manual review (i.e., to ensure the logical correctness of geological data during two-way synchronization). The strategies for resolving conflicting CAD files are to highlight elements modified by different users or support selective merging by layer (i.e., to handle version merging of unstructured files during two-way synchronization). The strategies for resolving conflicting report documents are to mark deleted content in red or added content in green or to manually select paragraphs to retain (i.e., to ensure that document synchronization is both efficient and meets the geological industry's requirements for the rigor of technical reports). The strategies for resolving conflicting geological logic are to adjust the stratigraphic thickness to the allowable range of the specifications or to force the insertion of fault markers and notify the person in charge (i.e., to ensure data compliance after two-way synchronization through the rule base).

[0061] Data Management Module 104.

[0062] It should be noted that, due to differences in the conflict, changes, access patterns, and capacity of different data, adjustments should be made when managing data to improve database storage efficiency, enhance data management value, and ensure data security.

[0063] Furthermore, it should be noted that for frequently modified data, shortening the retention time can reduce redundant storage; prioritizing the cleanup of large-volume data reduces server load. Extending the lifecycle of highly conflicting data preserves traceability; automatically downgrading the storage of cold data balances cost and availability. Mandating permanent retention of basic configurations (such as geotechnical reference tables) prevents the loss of critical standards; regularly cleaning up temporary data (such as expired CAD files) reduces the risk of leakage.

[0064] Specifically, a conflict factor is quantified based on the number of times each data conflict occurs; a fluctuation factor is determined based on the number of times each user modifies each data; a capacity factor is obtained for each data; an access factor for each data is determined based on the number of times each data is accessed; the preset initial lifecycle of each data is adjusted using the conflict factor, the fluctuation factor, the capacity factor, and the access factor to obtain the final lifecycle of each data; data management is performed based on the final lifecycle of each data, and the permission allocation in the initial permission module is optimized, while a storage strategy is fed back to the collaborative work module to improve the efficiency of online collaboration.

[0065] The conflict factor for each data point is specifically expressed by the formula:

[0066]

[0067] In the formula, This indicates the total number of uploads for each piece of data. This indicates the number of conflict triggers for each piece of data. This represents the conflict factor for each data point.

[0068] The volatility factor for each data point is expressed by the following formula:

[0069]

[0070] In the formula, This indicates the total number of days each data point exists. This indicates the number of times each data point has been modified in the past month. This represents the volatility factor for each data point.

[0071] The process of obtaining the capacity factor for each data is as follows: when each data is a single file and the capacity of a single file is greater than 1GB, the capacity factor for each data is recorded as 0.7;

[0072] When each data point is a paragraph-level population, and the total size of all files within the same paragraph is greater than 10GB, then the capacity factor for each data point is set to 0.5.

[0073] In other cases, the capacity factor for each data point is set to 1.

[0074] The access factor for each piece of data is expressed by the following formula:

[0075]

[0076] In the formula, This represents the average number of times all data is accessed. This indicates the number of times each piece of data was accessed. This represents the access factor for each piece of data.

[0077] The final lifecycle of each piece of data can be expressed by the following formula:

[0078]

[0079] In the formula, This represents the conflict factor for each data point. This represents the volatility factor for each data point. This represents the capacity factor for each data point. This represents the access factor for each piece of data. This indicates the preset initial lifespan of each data item. This indicates the final lifecycle of each piece of data.

[0080] At this point, the final lifecycle of each piece of data is determined; data management is carried out based on the final lifecycle of each piece of data, the permission allocation in the initial permission module is optimized, and the storage strategy is fed back to the collaborative operation module to improve the efficiency of online collaboration.

[0081] A second aspect of the present invention is to provide an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement an online collaborative tool for a railway engineering geological survey database.

[0082] A third aspect of the present invention is to provide a computer-readable storage medium storing a computer program that, when executed by a processor, implements an online collaborative tool for a railway engineering geological survey database.

[0083] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, etc.) containing computer-usable program code.

[0084] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, systems, and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0085] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0086] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0087] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit it. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that modifications or equivalent substitutions can still be made to the specific implementation of the present invention. Any modifications or equivalent substitutions that do not depart from the spirit and scope of the present invention should be covered within the protection scope of the present invention.

Claims

1. An online collaborative tool for railway engineering geological survey database, characterized in that, include: Initialize permissions module: Used to build a five-level collaborative architecture and initialize permissions; Collaborative task module: used for data upload and update operations by different users; Conflict handling module: used to bind a conflict detection rule base to each paragraph, perform conflict detection on each paragraph through the conflict detection rule base, and obtain the conflict type of each paragraph; when a user uploads or updates data, it calls the initialization permission module to verify the paragraph operation permission, and determines whether there is a conflict based on the permission verification result. When a conflict occurs, it determines the conflict type and records the number of conflicts. Provide solutions to conflicts based on their types; Data management module: used to quantify the conflict factor based on the number of times each data conflict occurs; The volatility factor is determined based on the number of times each data point is modified by the user; the capacity factor for each data point is obtained. The access factor for each piece of data is determined by the number of times each piece of data is accessed. The initial lifecycle of each data point is adjusted using the conflict factor, volatility factor, capacity factor, and access factor to obtain the final lifecycle of each data point; data management is then performed based on the final lifecycle of each data point; wherein, the adjustment of the initial lifecycle of each data point using the conflict factor, volatility factor, capacity factor, and access factor to obtain the final lifecycle of each data point includes: In the formula, This represents the conflict factor for each data point. This represents the volatility factor for each data point. This represents the capacity factor for each data point. This represents the access factor for each piece of data. This indicates the preset initial lifespan of each data item. This indicates the final lifecycle of each piece of data.

2. The online collaborative tool for railway engineering geological exploration database according to claim 1, characterized in that, The construction of the five-level collaborative architecture and the initialization of permissions include: During the project architecture setup, a five-level project management system was established, including project level, phase level, section level, solution level, and work point level. The system is configured with three user roles: super administrator, project manager, and team member. The super administrator is responsible for the overall system configuration, the project manager is responsible for managing specific survey projects, and the team member is responsible for data collection and editing.

3. The online collaborative tool for railway engineering geological survey database according to claim 1, characterized in that, The data upload and update operations for different users include: The person in charge uploads route information, assigns permissions to group members for each section, group members download general configurations, group members download routes, group members upload or update design drilling and CAD data, group members update all scheme data at the section level or create new schemes, group members upload or update scheme data, and group members upload or update work site data.

4. The online collaborative tool for railway engineering geological survey database according to claim 1, characterized in that, The method of providing conflict solutions based on the type of conflict includes: The conflict types include conflicts in scheme name, exploration point number, CAD file, report document, and geological logic. The solution strategy for scheme name conflicts is to force overwrite or rename. The solution strategy for exploration point number conflicts is to retain data that conforms to stratigraphic continuity or mark abnormal data for manual review. The solution strategy for CAD file conflicts is to highlight the elements modified by different users or support selective merging by layer. The solution strategy for report document conflicts is to mark deleted content in red or added content in green or manually select to retain paragraphs. The solution strategy for geological logic conflicts is to adjust the stratigraphic thickness to the allowable range of the specification or forcibly insert fault markers and notify the person in charge.

5. The online collaborative tool for railway engineering geological survey database according to claim 1, characterized in that, The conflict factor is quantified based on the number of times each data conflict occurs; The volatility factor is determined based on the number of times the user modifies each piece of data, including: The conflict factor is specifically expressed by the formula: In the formula, This indicates the total number of uploads for each piece of data. This indicates the number of conflict triggers for each piece of data. This represents the conflict factor for each data point; The volatility factor is specifically expressed by the formula: In the formula, This indicates the total number of days each data point exists. This indicates the number of times each data point has been modified in the past month. This represents the volatility factor for each data point.

6. The online collaborative tool for railway engineering geological survey database according to claim 1, characterized in that, The process of obtaining the capacity factor for each data point includes: When each piece of data is a single file, and the size of a single file is greater than 1GB, the capacity factor of each piece of data is recorded as 0.7; When each data point is a paragraph-level population, and the total size of all files within the same paragraph is greater than 10GB, then the capacity factor for each data point is set to 0.

5. In other cases, the capacity factor for each data point is set to 1.

7. The online collaborative tool for railway engineering geological survey database according to claim 1, characterized in that, The process of determining the access factor for each piece of data based on the number of times each piece of data is accessed includes: In the formula, This represents the average number of times all data is accessed. This indicates the number of times each piece of data was accessed. This represents the access factor for each piece of data.

8. An electronic device, characterized in that, It includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the computer program, implements the online collaborative tool for railway engineering geological survey database as described in any one of claims 1-7.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the online collaborative tool for railway engineering geological survey database as described in any one of claims 1-7.

Images