CN-115237893-B - Data storage method, device and equipment for fully mechanized mining face

CN115237893BCN 115237893 BCN115237893 BCN 115237893BCN-115237893-B

Abstract

The application discloses a data storage method, device and equipment for a fully mechanized coal mining face, relates to the technical field of coal mining, and can solve the problem that the service system data of the fully mechanized coal mining face is low in use efficiency. The method comprises the steps of obtaining equipment data of a fully-mechanized mining face, converting the equipment data into object model data with uniform format, storing the object model data in an original database according to a preset sub-table strategy, and cleaning the object model data stored in the original database and having a time length longer than a preset first time length.

Inventors

HUANG HAI
LIU QIANG
MAO XIQUAN

Assignees

三一智矿科技有限公司

Dates

Publication Date: 20260505
Application Date: 20220608

Claims (8)

1. A method of data storage for a fully mechanized coal mining face, comprising: acquiring equipment data of a fully mechanized mining face, and converting the equipment data into object model data with uniform format; Storing the object model data in an original database according to a preset sub-table strategy, wherein the preset sub-table strategy comprises expanding from a current table to a new table; Cleaning the object model data stored in the original database and having a time length longer than a preset first time length; The method further comprises the steps of: establishing a transition database, wherein the transition database is arranged at the end and the side of the equipment and is used for storing object model data with the distance from the current moment being less than a preset third duration and synchronously uploading the object model data in the transition database to the original database; When communication abnormality occurs, the synchronization process is interrupted, and when the communication abnormality disappears, whether the synchronization task from the transition database to the original database is started is judged; if yes, starting the synchronous task until the synchronous task is completed; The determining whether to initiate a synchronization task from the transition database to the original database includes: When communication abnormality occurs, recording breakpoint moment of the object model data transmitted from the transition database to the original database; When communication abnormality disappears, judging whether object model data exist between the breakpoint moment and the communication abnormality disappearance moment, and if so, starting a synchronization task from the transition database to the original database; The method comprises the steps of starting a first data synchronization task, judging whether the first data synchronization task is completed, setting the first data synchronization task to be a completion state, cleaning the first data synchronization task, closing the first data synchronization task if the first data synchronization task is not completed, and re-creating a second data synchronization task, wherein the second data synchronization task is used for transmitting object model data from the failure moment of the first data synchronization task to the communication abnormal disappearance moment until all object model data between the breakpoint moment and the communication abnormal disappearance moment are transmitted.
2. The method of claim 1, wherein storing the object model data in the original database according to a preset sub-table policy comprises: acquiring the generation time of the object model data, and determining a sub-table time period in which the generation time is located; and determining the generation ordinal number of the object model data in the sub-table time period, and determining the sub-table of the object model data storage according to the generation ordinal number and the maximum storage number of each sub-table.
3. The method of claim 2, wherein said determining a sub-table of the object model data store based on the generated ordinal number and a maximum number of stored per sub-table comprises: and calculating a value obtained by dividing the generated ordinal number by the maximum storage number, determining a minimum integer greater than or equal to the value, and storing the object model data in the sub-table corresponding to the minimum integer.
4. The method of claim 1, wherein the cleaning the object model data stored in the raw database for a time period greater than a preset first time period comprises: backing up the object model data stored in the original database with a time length longer than the preset first time length and less than or equal to a preset second time length, wherein the preset second time length is longer than the preset first time length; And deleting the object model data stored in the original database and having the time length longer than the preset second time length.
5. The method according to claim 1, characterized in that the method further comprises: Establishing a mirror image database synchronous with the original database, wherein the original database realizes a read-write function and is used for storing the object model data, and the mirror image database realizes a read-only function and is used for a service system to read the object model data from the mirror image database.
6. A data storage device for a fully mechanized coal mining face, comprising: the acquisition module is used for acquiring equipment data of the fully mechanized mining face and converting the equipment data into object model data with uniform formats; The storage module is used for storing the object model data in an original database according to a preset sub-table strategy, and the preset sub-table strategy comprises expanding from a current table to a new table; The cleaning module is used for cleaning the object model data stored in the original database and having a time length longer than a preset first time length; The transition module comprises an establishing unit and a judging unit; The establishing unit is used for establishing a transition database, wherein the transition database is arranged at the end and the side of the equipment, is used for storing object model data with the distance from the current moment being smaller than a preset third duration, and synchronously uploads the object model data in the transition database to the original database; The judging unit is used for judging whether the synchronous task from the transition database to the original database is started or not when the communication abnormality occurs and judging whether the synchronous process is interrupted or not when the communication abnormality disappears, if so, starting the synchronous task until the synchronous task is completed; The judging unit is used for transmitting the recorded object model data from the transition database to the breakpoint moment of the original database when communication abnormality occurs, judging whether the object model data exists between the breakpoint moment and the communication abnormality disappearance moment when the communication abnormality disappears, and starting the synchronization from the transition database to the original database if the object model data exists; The judging unit is used for starting the first data synchronization task, judging whether the first data synchronization task is completed, if so, setting the first data synchronization task to be in a completed state, cleaning the first data synchronization task, and if not, closing the first data synchronization task, and re-creating the second data synchronization task, wherein the second data synchronization task is used for transmitting object model data between the failure moment of the first data synchronization task and the communication abnormality disappearance moment until all object model data between the breakpoint moment and the communication abnormality disappearance moment are transmitted.
7. A storage medium having stored thereon a computer program, wherein the program when executed by a processor implements the data storage method of a fully mechanized coal face of any of claims 1 to 5.
8. A computer device comprising a storage medium, a processor and a computer program stored on the storage medium and executable on the processor, characterized in that the processor implements the data storage method of the fully mechanized coal face of any of claims 1 to 5 when executing the program.

Description

Data storage method, device and equipment for fully mechanized mining face Technical Field The application relates to the technical field of coal mining, in particular to a data storage method, device and equipment of a fully mechanized coal mining face. Background The fully-mechanized coal face is a coal face of comprehensive mechanized equipment of underground coal mine equipment, and in order to ensure efficient and safe operation of underground equipment and the like, each service system needs to process data generated by the underground equipment. In the existing design, the equipment of the fully-mechanized mining face is various and numerous, each equipment generates a large amount of data, the formats among the data are not uniform, and the data generated by the independent access equipment of each service system are used according to the own use mode, so that each service system is in war in data processing, the system resources are wasted greatly, and the data use efficiency is low. Disclosure of Invention In view of the above, the application provides a data storage method, a device and equipment for a fully-mechanized coal mining face, relates to the technical field of coal mining, and can solve the problem of low data use efficiency of each service system of the fully-mechanized coal mining face. According to an aspect of the present application, there is provided a data storage method of a fully mechanized coal mining face, the method comprising: acquiring equipment data of a fully mechanized mining face, and converting the equipment data into object model data with uniform format; Storing the object model data in an original database according to a preset sub-table strategy; and cleaning the object model data stored in the original database and having a time length longer than a preset first time length. According to another aspect of the present application, there is provided a data storage device for a fully mechanized coal mining face, the device comprising: the acquisition module is used for acquiring equipment data of the fully mechanized mining face and converting the equipment data into object model data with uniform formats; the storage module is used for storing the object model data in an original database according to a preset sub-table strategy; The cleaning module is used for cleaning the object model data stored in the original database and having a time length longer than a preset first time length. According to yet another aspect of the present application, there is provided a non-volatile readable storage medium having stored thereon a computer program which when executed by a processor implements the data storage method of the fully mechanized coal mining face described above. According to still another aspect of the present application, there is provided a computer device including a non-volatile readable storage medium, a processor, and a computer program stored on the non-volatile readable storage medium and executable on the processor, the processor implementing the data storage method of the fully-mechanized coal mining face described above when executing the program. By means of the technical scheme, the data storage method, the device and the equipment for the fully-mechanized mining face are disclosed, equipment data of the fully-mechanized mining face can be firstly obtained, the equipment data are converted into object model data with uniform formats, the object model data are stored in an original database according to a preset sub-table strategy, and object model data with time length longer than a preset first time length stored in the original database are cleaned. According to the technical scheme, the object model data with the uniform format is used for data storage, the magnitude of data storage is greatly reduced, the overall data volume processed during data use is reduced, the data use efficiency is improved, object model data with the uniform format is stored in a centralized mode, all service systems extract needed object model data from the object model data, the problem that all service systems are independently connected into the data to be used in a self use mode and are difficult to reuse and waste system resources and are difficult to fuse is solved, the object model data is stored in an original database according to a preset sub-table strategy, the data volume of a single table is reduced, compared with the situation that all object model data are stored in one table, the overall data volume processed is reduced, the data use efficiency is improved, the object model data with the large size longer than a preset first time length during the process of storing in the original database is cleaned, the fact that all service systems use the original database is reduced in efficiency is prevented, the transition database is built, the problem that when communication is abnormal is caused, the data acquired from a working face cannot be directly synch