CN116827965A - Coal mine underground offline scene data storage and synchronization method based on cloud platform - Google Patents
Coal mine underground offline scene data storage and synchronization method based on cloud platform Download PDFInfo
- Publication number
- CN116827965A CN116827965A CN202311076734.3A CN202311076734A CN116827965A CN 116827965 A CN116827965 A CN 116827965A CN 202311076734 A CN202311076734 A CN 202311076734A CN 116827965 A CN116827965 A CN 116827965A
- Authority
- CN
- China
- Prior art keywords
- data
- cloud platform
- mobile terminal
- coal mine
- service
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 239000003245 coal Substances 0.000 title claims abstract description 40
- 238000013500 data storage Methods 0.000 title claims abstract description 28
- 238000003860 storage Methods 0.000 claims abstract description 16
- 230000009471 action Effects 0.000 claims description 48
- 230000008859 change Effects 0.000 claims description 43
- 230000008569 process Effects 0.000 claims description 10
- 230000006870 function Effects 0.000 claims description 6
- 238000004140 cleaning Methods 0.000 claims description 4
- 238000012508 change request Methods 0.000 description 11
- 230000005540 biological transmission Effects 0.000 description 6
- 238000004519 manufacturing process Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 239000000243 solution Substances 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000001960 triggered effect Effects 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000002347 injection Methods 0.000 description 1
- 239000007924 injection Substances 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000035515 penetration Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/12—Protocols specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Medical Informatics (AREA)
- Quality & Reliability (AREA)
- General Health & Medical Sciences (AREA)
- Computing Systems (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the disclosure relates to a coal mine underground offline scene data storage and synchronization method based on a cloud platform. On the one hand, the embodiment of the disclosure captures all operation details while the second service data generated by the sensing device is stored, and performs downloading, updating, restoring and uploading processing on the data in combination with the scene requirements of the coal mine on the well and the underground, so that excessive expenditure is avoided, and meanwhile, the reliability of data storage and synchronization is ensured. On the other hand, based on the scene of low concurrency of mine service, the full coverage data is provided, a small amount of storage is used for reducing a large amount of service processing complexity, only the data result is required to be focused, and the data synchronization efficiency is improved.
Description
Technical Field
The embodiment of the disclosure relates to the technical field of coal mine industry Internet, in particular to a coal mine underground offline scene data storage and synchronization method based on a cloud platform.
Background
Along with the penetration and application of cloud computing and big data technology in various industries, the coal production in China is also developing towards the trend of digitalization and informatization. By applying the big data technology, an intelligent coal acquisition system is established, the storage rate and the reading rate of data are improved, and the intelligent coal acquisition system is a trend of development. Along with the continuous improvement of coal mine production technology, the complexity and diversity of the underground operation environment are also higher and higher requirements are also put forward on the storage and synchronization of underground operation data. Traditional offline scene data storage methods are difficult to meet the requirement of underground coal mine data storage, and a new solution is required to be found. Therefore, the method for storing and synchronizing the offline scene data is studied, and has important significance for improving the production efficiency of the coal mine and guaranteeing the safe production of the coal mine.
The current greatest challenge of underground coal mine informatization is that the limitation of offline scenes on data transmission and storage is overcome, and although the mobile terminal has a solution, a series of operations can be performed in the offline scenes, so that the purpose of underground informatization communication is achieved. However, the following problems are also obvious, for example, the requirement and the dependence of the data transmission on the hardware equipment are higher in an offline scene, so that the problem of higher production cost is caused, and meanwhile, the problems of low efficiency, high delay and the like of the data transmission are also accompanied.
Accordingly, there is a need to improve one or more problems in the related art as described above.
It is noted that this section is intended to provide a background or context for the technical solutions of the present disclosure as set forth in the claims. The description herein is not admitted to be prior art by inclusion in this section.
Disclosure of Invention
An object of an embodiment of the present disclosure is to provide a method for storing and synchronizing coal mine underground offline scene data based on a cloud platform, so as to overcome one or more problems due to limitations and disadvantages of the related art at least to some extent.
According to a first aspect of an embodiment of the present disclosure, there is provided a method for storing and synchronizing coal mine underground offline scene data based on a cloud platform, the method comprising:
the mobile terminal acquires task information to be executed from the cloud platform;
judging a service use scene according to a sensing device, if the service use scene is an offline scene, switching the mobile terminal into a down-hole mode by a user, and pulling first service data corresponding to the task information to be executed onto the mobile terminal by the cloud platform;
the mobile terminal intercepts a data changing action corresponding to second service data of the sensing device according to the task information to be executed so as to obtain changing action data;
the mobile terminal stores the change action data into a database group;
after logging in, the user switches the mobile terminal into a logging mode;
and the mobile terminal performs restoration processing according to the change action data and the first service data to obtain the second service data, and synchronizes the second service data to the cloud platform.
In an embodiment of the disclosure, the sensing device obtains the position of the user according to a position sensor in the sensing device, so as to determine whether the service usage scenario is an offline scenario.
In an embodiment of the disclosure, the changing action data at least includes:
insert operation information, update operation information, and delete operation information.
In one embodiment of the disclosure, the database group includes a plurality of databases, one corresponding to each of the users.
In an embodiment of the disclosure, the step of storing the change action data in the database group by the mobile terminal includes:
and the mobile terminal stores the change action data into the database corresponding to the current user.
In an embodiment of the present disclosure, the mobile terminal storing the change action data in the database corresponding to the current user includes:
and processing the change action data by using a storage process or function, and storing the change action data into the database in the form of SQL information.
In an embodiment of the disclosure, after the step of switching the mobile terminal to the logging mode, the method further includes:
and inquiring according to the user identification of the user so as to extract the change action data from the corresponding database.
In an embodiment of the disclosure, the step of restoring the mobile terminal according to the change action data and the first service data to obtain the second service data includes:
and performing data cleaning on the second service data.
In an embodiment of the disclosure, the step of synchronizing the second service data to the cloud platform includes:
the mobile terminal identifies the second service data and generates a source data configuration file according to the second service data;
and the mobile terminal packages the source data configuration file into a kafka file and sends the kafka file to a cloud platform.
According to a second aspect of embodiments of the present disclosure, there is provided an electronic device, comprising:
a processor;
and a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the steps of the cloud platform based coal mine downhole offline scenario data storage and synchronization method of any of the embodiments described above via execution of the executable instructions.
The technical scheme provided by the embodiment of the disclosure can comprise the following beneficial effects:
according to the embodiment of the disclosure, through the method for storing and synchronizing the underground offline scene data of the coal mine based on the cloud platform, on one hand, all operation details are captured while the second service data generated by the sensing device is stored, and the data are downloaded, updated, restored and uploaded according to the scene requirements of the underground and the uphole of the coal mine, so that no excessive overhead is caused, and meanwhile, the reliability of data storage and synchronization is ensured. On the other hand, based on the scene of low concurrency of mine service, the full coverage data is provided, a small amount of storage is used for reducing a large amount of service processing complexity, only the data result is required to be focused, and the data synchronization efficiency is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure. It will be apparent to those of ordinary skill in the art that the drawings in the following description are merely examples of the disclosure and that other drawings may be derived from them without undue effort.
FIG. 1 illustrates a step diagram of a cloud platform based coal mine downhole offline scenario data storage and synchronization method in an exemplary embodiment of the present disclosure;
FIG. 2 illustrates a flow diagram of a cloud platform based coal mine downhole offline scenario data storage and synchronization method in an exemplary embodiment of the present disclosure;
fig. 3 shows a schematic diagram of an electronic device in an exemplary embodiment of the present disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. However, the exemplary embodiments may be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
Furthermore, the drawings are merely schematic illustrations of embodiments of the disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus a repetitive description thereof will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities.
The embodiment of the application firstly provides a coal mine underground offline scene data storage and synchronization method based on a cloud platform. Referring to fig. 1, the cloud platform-based coal mine underground offline scenario data storage and synchronization method may include: step S101 to step S106.
Step S101: and the mobile terminal acquires the task information to be executed from the cloud platform.
Step S102: and judging a service use scene according to the sensing device, if the service use scene is judged to be an offline scene, switching the mobile terminal into a down-hole mode by a user, and pulling first service data corresponding to the task information to be executed onto the mobile terminal by the cloud platform.
Step S103: and the mobile terminal intercepts the data changing action corresponding to the second service data of the sensing device according to the task information to be executed so as to obtain changing action data.
Step S104: and the mobile terminal stores the change action data into a database group.
Step S105: after logging in, the user switches the mobile terminal into a logging mode.
Step S106: and the mobile terminal performs restoration processing according to the change action data and the first service data to obtain the second service data, and synchronizes the second service data to the cloud platform.
According to the coal mine underground offline scene data storage and synchronization method based on the cloud platform, on one hand, all operation details are captured while the second service data generated by the sensing device are stored, and the data are downloaded, updated, restored and uploaded according to the scene requirements of the coal mine on the ground and the underground, so that excessive expenditure is avoided, and meanwhile, the reliability of data storage and synchronization is guaranteed. On the other hand, based on the scene of low concurrency of mine service, the full coverage data is provided, a small amount of storage is used for reducing a large amount of service processing complexity, only the data result is required to be focused, and the data synchronization efficiency is improved.
Hereinafter, each step of the above-described cloud platform-based coal mine downhole offline scenario data storage and synchronization method in the present exemplary embodiment will be described in more detail with reference to fig. 1 to 2.
In step S101, the user logs in to the mobile terminal before logging into the well, and each user has its own unique user identification information. After logging in, the user downloads the task information to be executed, which needs to be executed after the user logs in the well, from the cloud platform.
In step S102, the service performs a first round of standardization, and requires the user to clearly determine whether the current environment is in an "offline mode", if so, the mobile terminal is switched to a down-hole mode, that is, a down-hole operation button is clicked in the mobile terminal, and the corresponding system senses the environment switching, and is in an offline scene at this time.
In addition, when the mobile terminal senses that the 'well-down' operation is triggered, the first service data in the range of the cloud platform to be used is pulled to the local area of the mobile terminal in full, the past data, namely the old first service data, are directly covered, and after the coverage is completed, a user goes into the well; the first service data may be the last synchronized first service data.
In step S103, after the mobile terminal goes into the well, the mobile terminal implements an interceptor of the database, intercepts a data change action corresponding to the second service data generated by the sensing device and about to enter the database, and obtains change action data.
In step S104, each user has its own corresponding database, and after the mobile terminal intercepts the data change action, the mobile terminal stores the change action data of the current user into the database corresponding to the user.
In step S105, after logging in, the user clicks the "logging in" button on the mobile terminal, and when the button is clicked, the mobile terminal switches to the logging in mode; the corresponding system perceives the environment switching, and the mobile terminal is in an online scene at the moment.
In step S106, when the current environment belongs to "going up the well", the mobile terminal restores the stored change action data and the first service data in the mobile terminal, that is, the first service data is re-executed according to the sequence of the data change actions in the change action data, and finally the latest second service data is obtained and uploaded to the cloud platform.
In one embodiment, the sensing device acquires the position of the user according to a position sensor in the sensing device so as to judge whether the service usage scene is an offline scene.
Specifically, the judgment of the offline scene may be determined according to the current position of the user, for example, the position of the user is obtained according to the position sensor, the depth of the user is determined according to the position of the user, and if the depth reaches the set threshold, the condition of the offline scene is determined to be satisfied. Similarly, if the depth is less than the threshold, the well is in the upper mode.
In one embodiment, the change action data includes at least: insert operation information, update operation information, and delete operation information.
Specifically, the interception target of the first service data includes a processing mode that needs to change the data, such as adding, deleting, etc., for example: insert, update, delete, etc. Setting a corresponding interceptor in a database of the mobile terminal in the process of intercepting the first service data, for example, a SQL (Structured query Language ) statement filter can be used, and a stored procedure or a function filter can be also used; conditions are set in the filter, for example: filtering according to a certain field, and the like; according to the set conditions, the SQL sentences conforming to the conditions can be intercepted and processed.
In addition, the intercepted SQL statement (i.e. the changed action data) can be analyzed and analyzed according to the need, for example: and performing data analysis, alarming and other operations. Wherein the data analysis comprises: analyzing which of the change action data is insert operation information, update operation information and delete operation information; or analyzing whether the change operation data has errors, and if so, eliminating the error. The data alarm comprises: checking whether alarm information exists in the change action data, and if so, analyzing reasons and alarming so that a user can process the alarm in time.
Further, for the configuration and use of interceptors of mobile terminals, periodic optimization and adjustment can be performed to adapt to different business requirements and database environments. For example, interceptors to which different databases are adapted are different, and therefore, interceptors may be preferentially selected according to interceptors to which the databases are adapted.
Further, for the change operation (i.e. SQL statement) of the service data, the time of the change operation, the information of the user and the like can be recorded for subsequent analysis and tracing.
In a specific embodiment, during intercepting a data change request of the second service data, the mobile terminal detects target data (i.e., the first service data) corresponding to the data change request (i.e., the data change action); determining the weight corresponding to the data change request based on the generation information (the equipment weight for generating the data) corresponding to the target data, the data information (the weight corresponding to the data identification) and the current network load condition; judging whether the data change request is a non-interception object or not based on the weight corresponding to the data change request; if yes, the data change request is sent to the cloud platform for processing.
The process judges the importance degree of the data change request by identifying and detecting the data change request, and if the data change request obtained by judging is important, the process indicates that the data change request is intercepted possibly to cause data errors, so the data change request is not intercepted and is uploaded to the cloud platform for processing. The method can ensure real-time transmission of important data, reduce transmission delay of part of important data and improve reliability of data transmission.
In one embodiment, the database group includes a plurality of databases, one for each of the users.
Optionally, a plurality of databases may be provided in the mobile terminal, and may be set according to a user name, or may be set according to a data type. For example, a user corresponds to a database, and if a new user logs in, a new database is established. The database may be matched according to user identification information of the user.
Specifically, in the process of storing multiple databases in this embodiment, the user identifier of the current user may be usedIt is identified +.>Matching is carried out, and the correlation parameter between the two identifications is calculated>The method comprises the following steps:
wherein alpha represents a preset correlation factor, k represents the number of characters in the identifier, i represents the ith character in the identifier, and X i Representing the ith user identification in the user identifications, Y i Representing the ith data identity of the data identities. In the process, the user identification of the current user and the data identifications in the databases are matched and calculated to obtain related parameters, and the target database corresponding to the current user is determined according to the maximum related parameters. And the method is used for storing the database information generated by the current user into the corresponding target database so as to ensure the reliability of data storage.
In one embodiment, the step of storing the change action data to a database group comprises: and the mobile terminal stores the change action data into the database corresponding to the current user.
Specifically, since the mobile terminal may have many historical users, in this case, when the current user logs in the mobile terminal, the mobile terminal obtains the use authority of the database corresponding to the user according to the user identification information of the user, and after the user intercepts the first service data by using the mobile terminal, the intercepted first service data is stored in the database corresponding to the user, that is, the first service data is stored in an associated manner according to the user identification of the current user.
In addition, the first service data may be stored in groups according to the generation object of the first service data. The specific grouping mode is that the grouping can be performed according to a certain field, the grouping can be performed according to a certain grouping function, and the like.
In one embodiment, the mobile terminal stores the change action data in the database corresponding to the current user, including: and processing the change action data by using a storage process or function, and storing the change action data into the database in the form of SQL information.
Specifically, the grouped SQL sentences are stored in a database, and the stored procedures or functions can be used for storing the grouped SQL sentences in the database.
The resulting effect is that a series of business operations performed downhole are recorded sequentially in SQL for subsequent playback.
The stored SQL sentences are managed, so that the stored SQL sentences can be queried, updated and deleted, and operations such as grouping and filtering can be performed according to the needs.
When the SQL statement is stored, a caching mechanism can be used to avoid attacks such as repeated computation, SQL injection and the like.
In one embodiment, after the step of switching the mobile terminal to the logging mode, the method further includes: and inquiring according to the user identification of the user so as to extract the change action data from the corresponding database.
Specifically, when the 'well-up' operation is triggered, starting to prepare for playback, firstly inquiring the stored SQL according to the user identification of the current user to obtain the SQL stored by the user, and uploading the inquired result to the cloud platform through a network.
And the mobile terminal re-executes the SQL according to the sequence triggered by the user, namely re-executes the first service data according to the sequence of the SQL, so that the second service data can be obtained. And after execution is completed, all underground business operations including business content can be restored, and data consistency of the cloud platform and the mobile terminal is ensured.
And in the process of restoring the second service data by the mobile terminal, re-executing the stored first service data according to the stored data change action, triggering to generate restoring data (namely the second service data), and finally storing the restoring data to the cloud platform by the mobile terminal.
In one embodiment, the step of restoring the mobile terminal according to the change action data and the first service data to obtain second service data includes: and performing data cleaning on the second service data.
Specifically, after the data is restored to obtain the complete second service data, the complete second service data may be subjected to data cleaning based on the attribute of the second service data, so as to delete the redundant data.
In one embodiment, the step of synchronizing the second service data to the cloud platform includes: the mobile terminal identifies the second service data and generates a source data configuration file according to the second service data; and the mobile terminal packages the source data configuration file into a kafka file and sends the kafka file to a cloud platform.
Specifically, the mobile terminal automatically identifies second service data and generates a source data configuration file according to the second service data information; the mobile terminal packages the second service data into a (kafka) file according to the source data configuration file, and simultaneously sends the kafka file to the cloud platform.
When the mobile terminal needs to acquire second service data, the mobile terminal acquires the kafka file from the cloud platform and sends the kafka file to a (distributed file) storage system; the target database in the mobile terminal loads the second service data from the distributed file storage system to complete the loading of the second service data.
As shown in fig. 2, through the above-mentioned method for storing and synchronizing underground offline scene data of a coal mine based on a cloud platform, on one hand, all operation details are captured while second service data generated by a sensing device are stored, and downloading, updating, restoring and uploading processing are performed on the data in combination with scene requirements of an upper well and a lower well of the coal mine, so that excessive expenditure is avoided, and meanwhile, the reliability of data storage and synchronization is ensured. On the other hand, based on the scene of low concurrency of mine service, the full coverage data is provided, a small amount of storage is used for reducing a large amount of service processing complexity, only the data result is required to be focused, and the data synchronization efficiency is improved. And the cloud platform is used, so that the offline data can be stored completely, and the data integrity is ensured.
In an exemplary embodiment of the present disclosure, an electronic device is also provided, which may include a processor, and a memory for storing executable instructions of the processor. Wherein the processor is configured to perform the steps of the cloud platform based coal mine downhole offline scenario data storage and synchronization method of any of the embodiments described above via execution of the executable instructions.
Those skilled in the art will appreciate that the various aspects of the application may be implemented as a system, method, or program product. Accordingly, aspects of the application may be embodied in the following forms, namely: an entirely hardware embodiment, an entirely software embodiment (including firmware, micro-code, etc.) or an embodiment combining hardware and software aspects may be referred to herein as a "circuit," module "or" system.
An electronic device 600 according to this embodiment of the application is described below with reference to fig. 3. The electronic device 600 shown in fig. 3 is merely an example and should not be construed as limiting the functionality and scope of use of embodiments of the present application.
As shown in fig. 3, the electronic device 600 is embodied in the form of a general purpose computing device. Components of electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different system components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program code that is executable by the processing unit 610 such that the processing unit 610 performs the steps according to various exemplary embodiments of the present application described in the above description of the cloud platform based coal mine downhole offline scenario data storage and synchronization method section. For example, the processing unit 610 may perform the steps as shown in fig. 1.
The memory unit 620 may include readable media in the form of volatile memory units, such as Random Access Memory (RAM) 6201 and/or cache memory unit 6202, and may further include Read Only Memory (ROM) 6203.
The storage unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment.
Bus 630 may be a local bus representing one or more of several types of bus structures including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or using any of a variety of bus architectures.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), one or more devices that enable a user to interact with the electronic device 600, and/or any device (e.g., router, modem, etc.) that enables the electronic device 600 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 650. Also, electronic device 600 may communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet, through network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 over the bus 630. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with electronic device 600, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Thus, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a usb disk, a mobile hard disk, etc.) or on a network, and includes several instructions to cause a computing device (may be a personal computer, a server, or a network device, etc.) to perform the above-described method for storing and synchronizing offline scenario data under a coal mine based on a cloud platform according to the embodiments of the present disclosure.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (10)
1. A cloud platform-based coal mine underground offline scene data storage and synchronization method, which is characterized by comprising the following steps:
the mobile terminal acquires task information to be executed from the cloud platform;
judging a service use scene according to a sensing device, if the service use scene is an offline scene, switching the mobile terminal into a down-hole mode by a user, and pulling first service data corresponding to the task information to be executed onto the mobile terminal by the cloud platform;
the mobile terminal intercepts a data changing action corresponding to second service data of the sensing device according to the task information to be executed so as to obtain changing action data;
the mobile terminal stores the change action data into a database group;
after logging in, the user switches the mobile terminal into a logging mode;
and the mobile terminal performs restoration processing according to the change action data and the first service data to obtain the second service data, and synchronizes the second service data to the cloud platform.
2. The cloud platform-based underground coal mine offline scene data storage and synchronization method according to claim 1, wherein the sensing device obtains the position of the user according to a position sensor in the sensing device so as to judge whether the service usage scene is an offline scene.
3. The cloud platform based coal mine downhole offline scenario data storage and synchronization method of claim 1, wherein the altering action data comprises at least:
insert operation information, update operation information, and delete operation information.
4. The cloud platform based downhole offline scenario data storage and synchronization method of claim 1, wherein said database group comprises a plurality of databases, one for each of said users.
5. The cloud platform based coal mine downhole offline scenario data storage and synchronization method of claim 4, wherein the step of the mobile terminal storing the change action data to a database group comprises:
and the mobile terminal stores the change action data into the database corresponding to the current user.
6. The method for storing and synchronizing coal mine underground offline scene data based on a cloud platform according to claim 5, wherein the mobile terminal stores the change action data in the database corresponding to the current user, and comprises:
and processing the change action data by using a storage process or function, and storing the change action data into the database in the form of SQL information.
7. The cloud platform based coal mine downhole offline scenario data storage and synchronization method of claim 6, wherein after the step of switching the mobile terminal to the logging mode by the user, further comprising:
and inquiring according to the user identification of the user so as to extract the change action data from the corresponding database.
8. The method for storing and synchronizing coal mine underground offline scene data based on a cloud platform according to claim 7, wherein the step of restoring the mobile terminal according to the change action data and the first service data to obtain the second service data comprises the following steps:
and performing data cleaning on the second service data.
9. The cloud platform based coal mine downhole offline scenario data storage and synchronization method of claim 7, wherein said step of synchronizing said second business data to said cloud platform comprises:
the mobile terminal identifies the second service data and generates a source data configuration file according to the second service data;
and the mobile terminal packages the source data configuration file into a kafka file and sends the kafka file to a cloud platform.
10. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the steps of the cloud platform based coal mine downhole offline scenario data storage and synchronization method of any one of claims 1-9 via execution of the executable instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311076734.3A CN116827965B (en) | 2023-08-25 | 2023-08-25 | Coal mine underground offline scene data storage and synchronization method based on cloud platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311076734.3A CN116827965B (en) | 2023-08-25 | 2023-08-25 | Coal mine underground offline scene data storage and synchronization method based on cloud platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116827965A true CN116827965A (en) | 2023-09-29 |
| CN116827965B CN116827965B (en) | 2024-01-23 |
Family
ID=88139495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311076734.3A Active CN116827965B (en) | 2023-08-25 | 2023-08-25 | Coal mine underground offline scene data storage and synchronization method based on cloud platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116827965B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117708071A (en) * | 2024-02-06 | 2024-03-15 | 苔花科迈(西安)信息技术有限公司 | Processing method and device for coal mine equipment operation parameters based on big data |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2010124349A (en) * | 2008-11-21 | 2010-06-03 | Nec Corp | Rich internet application offline support apparatus, method, program and mobile terminal |
| CN102917020A (en) * | 2011-09-24 | 2013-02-06 | 国网电力科学研究院 | Mobile terminal based on data packet and method for synchronizing business system data |
| CN107990877A (en) * | 2017-12-06 | 2018-05-04 | 华中师范大学 | A kind of unmanned aerial vehicle remote sensing interpretation field investigation system and method based on internet |
| CN109471865A (en) * | 2018-11-06 | 2019-03-15 | 用友网络科技股份有限公司 | A kind of off-line data management method, system, server and storage medium |
| US20190149619A1 (en) * | 2017-11-16 | 2019-05-16 | Servicenow, Inc. | Field service management mobile offline synchronization |
| CN110716825A (en) * | 2018-07-12 | 2020-01-21 | 阿里巴巴集团控股有限公司 | Data disaster tolerance processing method, device and system |
| CN112258160A (en) * | 2020-10-30 | 2021-01-22 | 长江水利委员会水文局 | Hydrological test data recording and calculating method based on mobile equipment |
| CN116567013A (en) * | 2023-06-19 | 2023-08-08 | 浪潮通用软件有限公司 | Offline data synchronization method, device and medium |
| CN116628042A (en) * | 2022-02-14 | 2023-08-22 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and medium |
-
2023
- 2023-08-25 CN CN202311076734.3A patent/CN116827965B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2010124349A (en) * | 2008-11-21 | 2010-06-03 | Nec Corp | Rich internet application offline support apparatus, method, program and mobile terminal |
| CN102917020A (en) * | 2011-09-24 | 2013-02-06 | 国网电力科学研究院 | Mobile terminal based on data packet and method for synchronizing business system data |
| US20190149619A1 (en) * | 2017-11-16 | 2019-05-16 | Servicenow, Inc. | Field service management mobile offline synchronization |
| CN107990877A (en) * | 2017-12-06 | 2018-05-04 | 华中师范大学 | A kind of unmanned aerial vehicle remote sensing interpretation field investigation system and method based on internet |
| CN110716825A (en) * | 2018-07-12 | 2020-01-21 | 阿里巴巴集团控股有限公司 | Data disaster tolerance processing method, device and system |
| CN109471865A (en) * | 2018-11-06 | 2019-03-15 | 用友网络科技股份有限公司 | A kind of off-line data management method, system, server and storage medium |
| CN112258160A (en) * | 2020-10-30 | 2021-01-22 | 长江水利委员会水文局 | Hydrological test data recording and calculating method based on mobile equipment |
| CN116628042A (en) * | 2022-02-14 | 2023-08-22 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and medium |
| CN116567013A (en) * | 2023-06-19 | 2023-08-08 | 浪潮通用软件有限公司 | Offline data synchronization method, device and medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117708071A (en) * | 2024-02-06 | 2024-03-15 | 苔花科迈(西安)信息技术有限公司 | Processing method and device for coal mine equipment operation parameters based on big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116827965B (en) | 2024-01-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
| CN106874389B (en) | Data migration method and device | |
| US8290994B2 (en) | Obtaining file system view in block-level data storage systems | |
| CN1988535B (en) | Synchronous method, system for file storage and customer terminal | |
| CN110971655B (en) | Offline client playback and synchronization | |
| CN110309218B (en) | Data exchange system and data writing method | |
| CN107220142B (en) | Method and device for executing data recovery operation | |
| CA3068345C (en) | Witness blocks in blockchain applications | |
| CN116827965B (en) | Coal mine underground offline scene data storage and synchronization method based on cloud platform | |
| CN107315814B (en) | Method and system for verifying data consistency after data migration of KDB (KDB) database | |
| CN104781791A (en) | Universal pluggable cloud disaster recovery system | |
| CN107196998B (en) | Mobile Web request processing method, equipment and system based on data deduplication | |
| CN103460197A (en) | Computer system, file management method and metadata server | |
| CN110858172A (en) | Automatic test code generation method and device | |
| US9075722B2 (en) | Clustered and highly-available wide-area write-through file system cache | |
| CN113961510A (en) | File processing method, device, equipment and storage medium | |
| CN112149035A (en) | Website static resource processing method and device | |
| CN112395281A (en) | Heterogeneous multi-source data fusion system | |
| CN111190878B (en) | Method, device, equipment and storage medium for sharing access NAS snapshot | |
| CN112261114A (en) | Data backup system and method | |
| US9852031B2 (en) | Computer system and method of identifying a failure | |
| CN111459577A (en) | Application installation source tracking method, device, equipment and storage medium | |
| CN114443294B (en) | Big data service component deployment method, system, terminal and storage medium | |
| CN114625751A (en) | Data tracing query method and device based on block chain | |
| CN113722154A (en) | Data management method and system, monitoring server and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |