Metadata recovery method and device for complex data table object, equipment and medium

Abstract

The invention discloses a metadata recovery method and device for a complex data table object, equipment and a medium. The method comprises the following steps: recovering target data table object metadata based on target data table object information data to generate basic data recovery information; determining target association table object information and target table self-increasing column information based on a preset association foreign key index algorithm, a preset sequence index algorithm and the basic data recovery information; recovering basic association table object metadata based on the target association table object information data to generate association table object recovery information, and recovering basic self-increasing column metadata based on the target table self-increasing column information data to generate table self-increasing column recovery information; and based on a preset calibration mechanism, the association table object recovery information and the table self-increasing column recovery information, performing accuracy verification, determining target association table object metadata and target self-increasing column metadata, and performing data storage. According to the technical scheme, the metadata of different levels can be recovered, and the recovery efficiency of the metadata is improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device, equipment and medium for recovering metadata of a complex data table object. Background Art

[0002] As distributed database technology is widely used, the demand for ensuring high availability of data in distributed databases by restoring backup data is increasing. However, in distributed databases, there is a special table object that contains associated tables or table auto-increment columns, which is called a complex data table object. When backing up or restoring the metadata of a complex data table object, it is necessary to restore the metadata of the associated table objects and the table auto-increment columns of the complex data table object at the same time, which makes recovery difficult.

[0003] Existing metadata recovery technologies usually recover all metadata of a database instance to process complex data table objects. However, the metadata recovery methods in the prior art are not applicable to scenarios where only certain specified tables need to be recovered, and recovering all metadata incurs additional storage and time overhead. Therefore, how to recover metadata of different levels corresponding to complex data table objects and improve the efficiency of metadata recovery for complex data table objects is a problem that needs to be solved urgently. Summary of the invention

[0004] The present invention provides a method, device, equipment and medium for recovering metadata of complex data table objects, which can solve the problem of low efficiency of recovering metadata of complex data table objects.

[0005] According to one aspect of the present invention, a method for recovering metadata of a complex data table object is provided, comprising:

[0006] Obtaining target data table object information corresponding to the complex data table object, and performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object;

[0007] Determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information;

[0008] Based on the target associated table object information, data recovery is performed on the basic associated table object metadata corresponding to the complex data table object to generate associated table object recovery information corresponding to the complex data table object, and based on the target table auto-increment column information, data recovery is performed on the basic auto-increment column metadata corresponding to the complex data table object to generate table auto-increment column recovery information corresponding to the complex data table object;

[0009] Based on the preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, the basic associated table object metadata and the basic auto-increment column metadata are checked for accuracy, the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored.

[0010] According to another aspect of the present invention, a metadata recovery device for a complex data table object is provided, comprising:

[0011] A first data recovery module is used to obtain target data table object information corresponding to the complex data table object, and based on the target data table object information, perform data recovery on the target data table object metadata corresponding to the complex data table object to generate basic data recovery information corresponding to the complex data table object;

[0012] An additional information determination module is used to determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and to determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information;

[0013] A second data recovery module is used to perform data recovery on the basic associated table object metadata corresponding to the complex data table object based on the target associated table object information, generate associated table object recovery information corresponding to the complex data table object, and perform data recovery on the basic auto-increment column metadata corresponding to the complex data table object based on the target table auto-increment column information, generate table auto-increment column recovery information corresponding to the complex data table object;

[0014] A data storage module is used to verify the accuracy of the basic associated table object metadata and the basic auto-increment column metadata based on a preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, determine the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism, and store the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata.

[0015] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0016] at least one processor; and

[0017] a memory communicatively connected to the at least one processor; wherein,

[0018] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the metadata recovery method for complex data table objects described in any embodiment of the present invention.

[0019] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the metadata recovery method for a complex data table object described in any embodiment of the present invention when executed.

[0020] According to another aspect of the present invention, a computer program product is provided, comprising a computer program, wherein when the computer program is executed by a processor, the method for recovering metadata of a complex data table object according to any embodiment of the present invention is implemented.

[0021] The technical solution of the embodiment of the present invention is to perform data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information corresponding to the complex data table object, and generate the basic data recovery information corresponding to the complex data table object. Then, the target association table object information corresponding to the complex data table object is determined based on the preset association foreign key index algorithm and the basic data recovery information, and the target table auto-increment column information corresponding to the complex data table object is determined based on the preset sequence index algorithm and the basic data recovery information. Further, the basic association table object metadata corresponding to the complex data table object is restored based on the target association table object information to generate the association table object recovery information corresponding to the complex data table object, and the basic auto-increment column metadata corresponding to the complex data table object is restored based on the target table auto-increment column information to generate the table auto-increment column recovery information corresponding to the complex data table object. Finally, the basic association table object metadata and the basic auto-increment column metadata are checked for accuracy based on the preset calibration mechanism, the association table object recovery information and the table auto-increment column recovery information, and the target association table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target association table object metadata and the target auto-increment column metadata are stored. Since the index method is used to determine the associated table object information and table auto-increment column information corresponding to the complex data table object, the problem of low metadata recovery efficiency of the complex data table object is solved. It is possible to recover different levels of metadata corresponding to the complex data table object, saving the space and time overhead required for metadata recovery and improving the metadata recovery efficiency of the complex data table object.

[0022] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0024] Figure 1 is a flowchart of a metadata recovery method for a complex data table object provided according to the first embodiment of the present invention;

[0025] Figure 2 is a flowchart of a metadata recovery method for a complex data table object provided according to Embodiment 2 of the present invention;

[0026] Figure 3 is a flowchart of an optional method for recovering metadata of a complex data table object provided according to Embodiment 2 of the present invention;

[0027] Figure 4 is a flowchart of a process for determining object information of an association table provided according to Embodiment 2 of the present invention;

[0028] Figure 5 is a flowchart of a process for determining table auto-increment column information provided in accordance with Embodiment 2 of the present invention;

[0029] Figure 6 It is a schematic diagram of the structure of a metadata recovery device for a complex data table object provided according to a third embodiment of the present invention;

[0030] Figure 7 It is a structural schematic diagram of an electronic device for implementing the metadata recovery method of a complex data table object according to an embodiment of the present invention. DETAILED DESCRIPTION

[0031] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0032] It should be noted that the terms "first", "second", "target" and "base" in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0033] Embodiment 1

[0034] Figure 1 This is a flowchart of a method for recovering metadata of a complex data table object provided in the first embodiment of the present invention. This embodiment is applicable to recovering metadata of different levels corresponding to a complex data table object. The method can be executed by a metadata recovery device for a complex data table object. The metadata recovery device for a complex data table object can be implemented in the form of hardware and / or software. The metadata recovery device for a complex data table object can be configured in an electronic device. Figure 1 As shown, the method includes:

[0035] S110, obtaining target data table object information corresponding to the complex data table object, and performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object.

[0036] The data table object information may refer to the basic data information corresponding to the data table object metadata. Exemplarily, the data table object information may include the table object name and metadata storage location, etc. The target data table object information may refer to the data table object information corresponding to the complex data table object that needs to recover metadata.

[0037] Metadata may refer to information describing data attributes. Metadata may support functions such as indicating storage location, historical data, resource search, and file records. Data table object metadata may refer to metadata corresponding to a data table object. Target data table object metadata may refer to metadata corresponding to a complex data table object that needs metadata recovery.

[0038] Among them, data recovery may refer to the operation of importing backup metadata into the data storage object of the database. Data recovery information may refer to the recovery result displayed after the data recovery operation is completed. Exemplarily, the data recovery information may include the object name and the cluster to which it belongs. Basic data recovery information may refer to the data recovery information generated after the target data table object metadata is recovered.

[0039] It is worth noting that in the embodiment of the present invention, the data recovery operation can be implemented through the metadata recovery interface and the metadata recovery module, thereby realizing the recovery function of lightweight complex data table object metadata.

[0040] S120. Determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information.

[0041] Among them, the preset association foreign key index algorithm may refer to a preset algorithm for indexing association table objects by key values. The association table object corresponding to the complex data table object may be determined by the preset association foreign key index algorithm. The association table object information may refer to the basic data information corresponding to the association table object. Exemplarily, the association table object information may include the association table object name, the name of the database to which it belongs, the table creation statement, the partition information, and the distribution status. The target association table object information may refer to the association table object information corresponding to the complex data table object for which metadata recovery is required.

[0042] Among them, the preset sequence index algorithm may refer to a preset algorithm for indexing table auto-increment columns by field name. The table auto-increment column corresponding to the complex data table object may be determined by the preset sequence index algorithm. The table auto-increment column information may refer to the basic data information corresponding to the table auto-increment column. Exemplarily, the table auto-increment column information may include the table auto-increment column name, the name of the database to which it belongs, and the auto-increment column creation statement, etc. The target table auto-increment column information may refer to the table auto-increment column information corresponding to the complex data table object that needs to perform metadata recovery.

[0043] S130. Perform data recovery on the basic associated table object metadata corresponding to the complex data table object based on the target associated table object information to generate associated table object recovery information corresponding to the complex data table object, and perform data recovery on the basic auto-increment column metadata corresponding to the complex data table object based on the target table auto-increment column information to generate table auto-increment column recovery information corresponding to the complex data table object.

[0044] The associated table object metadata may refer to the metadata corresponding to the associated table object. The basic associated table object metadata may refer to the associated table object metadata corresponding to the complex data table object that needs to perform metadata recovery. The associated table object recovery information may refer to the data recovery information generated after the basic associated table object metadata is recovered. Exemplarily, the associated table object recovery information may include the successfully recovered basic associated table object metadata.

[0045] Among them, the auto-increment column metadata may refer to the metadata corresponding to the auto-increment column. The basic auto-increment column metadata may refer to the auto-increment column metadata corresponding to the complex data table object that needs to perform metadata recovery. The table auto-increment column recovery information may refer to the data recovery information generated after the basic auto-increment column metadata is recovered. Exemplarily, the table auto-increment column recovery information may include the basic auto-increment column metadata that was successfully recovered.

[0046] It is worth noting that in the embodiment of the present invention, the order of data recovery of the basic association table object metadata and the order of data recovery of the basic auto-increment column metadata can be implemented in parallel or in sequence, and the embodiment of the present invention does not specifically limit this.

[0047] S140, based on the preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, the basic associated table object metadata and the basic auto-increment column metadata are checked for accuracy, the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored.

[0048] The preset calibration mechanism may refer to a preset rule for evaluating metadata recovery results. Exemplarily, the preset calibration mechanism may be an integrity assessment mechanism or a consistency assessment mechanism. The target association table object metadata may refer to the association table object metadata that satisfies the preset calibration mechanism. The target auto-increment column metadata may refer to the auto-increment column metadata that satisfies the preset calibration mechanism.

[0049] The data storage may refer to the operation of writing metadata into a relational database (RDB). All metadata information that needs to be restored can be recorded through the RDB.

[0050] The technical solution of the embodiment of the present invention is to perform data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information corresponding to the complex data table object, and generate the basic data recovery information corresponding to the complex data table object. Then, the target association table object information corresponding to the complex data table object is determined based on the preset association foreign key index algorithm and the basic data recovery information, and the target table auto-increment column information corresponding to the complex data table object is determined based on the preset sequence index algorithm and the basic data recovery information. Further, the basic association table object metadata corresponding to the complex data table object is restored based on the target association table object information to generate the association table object recovery information corresponding to the complex data table object, and the basic auto-increment column metadata corresponding to the complex data table object is restored based on the target table auto-increment column information to generate the table auto-increment column recovery information corresponding to the complex data table object. Finally, the basic association table object metadata and the basic auto-increment column metadata are checked for accuracy based on the preset calibration mechanism, the association table object recovery information and the table auto-increment column recovery information, and the target association table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target association table object metadata and the target auto-increment column metadata are stored. Since the index method is used to determine the associated table object information and table auto-increment column information corresponding to the complex data table object, the problem of low metadata recovery efficiency of the complex data table object is solved. It is possible to recover different levels of metadata corresponding to the complex data table object, saving the space and time overhead required for metadata recovery and improving the metadata recovery efficiency of the complex data table object.

[0051] Embodiment 2

[0052] Figure 2 A flowchart of a method for recovering metadata of a complex data table object provided in the second embodiment of the present invention. This embodiment is refined based on the above-mentioned embodiment. In this embodiment, the operation of performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information and generating basic data recovery information corresponding to the complex data table object is specifically refined. Specifically, it may include: determining the target data table object metadata corresponding to the complex data table object based on the basic data table object name in the target data table object information; performing data recovery on the target data table object metadata based on the data storage location in the target data table object information and generating basic data recovery information corresponding to the complex data table object. Figure 2 As shown, the method includes:

[0053] S210: Obtain target data table object information corresponding to the complex data table object.

[0054] S220: Determine the target data table object metadata corresponding to the complex data table object based on the basic data table object name in the target data table object information.

[0055] The basic data table object name may refer to a table object name corresponding to a complex data table object that needs to perform metadata recovery.

[0056] S230 , performing data recovery on the target data table object metadata based on the data storage location in the target data table object information, and generating basic data recovery information corresponding to the complex data table object.

[0057] The data storage location may refer to a table object metadata storage location corresponding to a complex data table object that needs to perform metadata recovery.

[0058] Specifically, after obtaining the target data table object information corresponding to the complex data table object, the target data table object metadata corresponding to the complex data table object can be determined based on the basic data table object name in the target data table object information, and then, the target data table object metadata is restored based on the data storage location in the target data table object information to generate the basic data recovery information corresponding to the complex data table object. In this way, data recovery of the data table object metadata is achieved, providing an effective basis for subsequent data storage.

[0059] S240. Obtain basic key value information and a preset association table set corresponding to a complex data table object based on the basic data recovery information.

[0060] The basic key value information may refer to the key value information corresponding to the complex data table object. Exemplarily, the basic key value information may be a primary key or a unique key. Generally, the basic key value information may be determined by a table creation statement in the metadata information.

[0061] The preset association table set may refer to a preset set for unified management of various association tables. Usually, each association table in the preset association table set has a unique identification number (ID), and the key value information corresponds to the corresponding association table in the preset association table set.

[0062] S250: performing an index operation on the preset association table set based on the basic key value information to generate target association table object information corresponding to the complex data table object.

[0063] Specifically, after performing data recovery on the target data table object metadata and generating the basic data recovery information corresponding to the complex data table object, it is possible to determine whether to perform subsequent operations based on whether there is specific metadata information in the basic data recovery information. If there is specific metadata information in the basic data recovery information, the basic key value information and the preset association table set corresponding to the complex data table object are obtained, and the preset association table set is indexed based on the basic key value information to generate the target association table object information corresponding to the complex data table object. In this way, the association table object information corresponding to the complex data table object can be determined, providing an effective basis for the subsequent association table object metadata recovery.

[0064] In an optional embodiment, the indexing operation on the preset association table set based on the basic key value information to generate the target association table object information corresponding to the complex data table object may include: performing an indexing operation on the preset association table set based on the basic key value information to generate a first index result; determining the association table object information corresponding to the first index result in the preset association table set based on the first index result as the target association table object information corresponding to the complex data table object. The index result may refer to the matching result obtained after the indexing operation. The first index result may refer to the index result obtained after the indexing operation based on the basic key value information. Exemplarily, the first index result may be the name of the association table in the preset association table set that matches the basic key value information. Specifically, after obtaining the basic key value information and the preset association table set corresponding to the complex data table object, the basic key value information may be used to perform an indexing operation on the preset association table set to generate a first index result, and determine the corresponding association table object information from the preset association table set according to the first index result as the target association table object information corresponding to the complex data table object. Thus, the association table object information corresponding to the complex data table object is obtained, providing an effective basis for the subsequent recovery of the metadata of the association table object.

[0065] S260. Obtain basic field information and a preset field identification mechanism corresponding to a complex data table object based on the basic data recovery information.

[0066] The basic field information may refer to all field information corresponding to the complex data table object. The preset field identification mechanism may refer to a pre-set rule for evaluating the field type of the basic field information. Exemplarily, the preset field identification mechanism may be to query all auto-increment type fields through the identity identification field in the data dictionary.

[0067] S270: Perform discrimination processing on the basic field information based on a preset field discrimination mechanism to generate a discrimination result, and determine the target table auto-increment column information corresponding to the complex data table object based on the discrimination result.

[0068] The discrimination result may refer to the result obtained after the basic field information is discriminated. For example, the discrimination result may be that there is an auto-increment column or that there is no auto-increment column.

[0069] In an optional embodiment, the determining the target table auto-increment column information corresponding to the complex data table object based on the discrimination result includes: if the discrimination result is that the auto-increment column exists, indexing the preset sequence set based on the basic field information to generate a second index result; determining the table auto-increment column information corresponding to the second index result in the preset sequence set based on the second index result as the target table auto-increment column information corresponding to the complex data table object. The preset sequence set may refer to a sequence set that is pre-set for unified management of each auto-increment field. Usually, each auto-increment field corresponds to a sequence. The second index result may refer to an index result obtained after indexing the preset sequence set based on the basic field information. Exemplarily, the second index result may be the auto-increment field name. Specifically, after the basic field information is discriminated based on the preset field discrimination mechanism to generate the discrimination result, if the discrimination result is that the auto-increment column exists, the indexing operation is performed in the preset sequence set according to the basic field information to generate the second index result, and then, the table auto-increment column information corresponding to the second index result is determined in the preset sequence set as the target table auto-increment column information corresponding to the complex data table object. Thus, the table auto-increment column information corresponding to the complex data table object is obtained, providing an effective basis for the subsequent metadata recovery of the associated table object.

[0070] S280. Perform data recovery on the basic associated table object metadata corresponding to the complex data table object based on the target associated table object information to generate associated table object recovery information corresponding to the complex data table object, and perform data recovery on the basic auto-increment column metadata corresponding to the complex data table object based on the target table auto-increment column information to generate table auto-increment column recovery information corresponding to the complex data table object.

[0071] Specifically, after generating the target association table object information and the target table auto-increment column information, the name and database storage information of the basic association table object metadata corresponding to the complex data table object can be determined according to the target association table object information, and the name and database storage information of the basic auto-increment column metadata corresponding to the complex data table object can be determined according to the target table auto-increment column information. Then, the basic association table object metadata is obtained according to the name and database storage information of the basic association table object metadata, and the data of the basic association table object metadata is restored, and the basic auto-increment column metadata is obtained according to the name and database storage information of the basic auto-increment column metadata, and the data of the basic auto-increment column metadata is restored.

[0072] S290: Perform consistency check on the basic association table object metadata and the basic auto-increment column metadata based on a preset consistency check rule, the association table object recovery information, and the table auto-increment column recovery information to generate a first check result.

[0073] Among them, the preset consistency verification rules may refer to pre-set rules for consistency evaluation of basic association table object metadata and basic auto-increment column metadata. Exemplarily, the preset consistency verification rules may be that the basic association table object metadata is consistent with the corresponding data nodes in the database, and that the basic auto-increment column metadata is consistent with the corresponding data nodes in the database. It is worth noting that the data nodes in the database corresponding to the basic association table object metadata can be determined from the association table object recovery information. Similarly, the data nodes in the database corresponding to the basic auto-increment column metadata can be determined from the table auto-increment column recovery information.

[0074] Among them, consistency check may refer to the operation of comparing the corresponding data node in the database with the associated table object metadata or the auto-increment column metadata. The first check result may refer to the check result generated after consistency check of the basic associated table object metadata and the basic auto-increment column metadata. Exemplarily, the first check result may be that both the basic associated table object metadata and the basic auto-increment column metadata meet the preset consistency check rules, neither the basic associated table object metadata nor the basic auto-increment column metadata meet the preset consistency check rules, the basic associated table object metadata meets the preset consistency check rules while the basic auto-increment column metadata does not meet the preset consistency check rules, and the basic associated table object metadata does not meet the preset consistency check rules while the basic auto-increment column metadata meets the preset consistency check rules.

[0075] S2100: Perform integrity check on the basic association table object metadata and the basic auto-increment column metadata based on a preset integrity check rule, the association table object recovery information and the table auto-increment column recovery information to generate a second check result.

[0076] The preset integrity check rule may refer to a preset rule for evaluating the integrity of the basic association table object metadata and the basic auto-increment column metadata. Exemplarily, the preset integrity check rule may be that the basic association table object metadata all corresponds to the association table object recovery information, and the basic auto-increment column metadata all corresponds to the table auto-increment column recovery information.

[0077] Among them, the integrity check may refer to the operation of comparing metadata with recovery information. The second check result may refer to the check result generated after the metadata and recovery information are checked for integrity. Exemplarily, the second check result may be that both the basic association table object metadata and the basic auto-increment column metadata meet the preset integrity check rules, the basic association table object metadata and the basic auto-increment column metadata do not meet the preset integrity check rules, the basic association table object metadata meets the preset integrity check rules while the basic auto-increment column metadata does not meet the preset integrity check rules, and the basic association table object metadata does not meet the preset integrity check rules while the basic auto-increment column metadata meets the preset integrity check rules.

[0078] S2110. The first verification result and the second verification result are judged and processed based on a preset calibration mechanism. If the first verification result and the second verification result satisfy the preset calibration mechanism, the basic association table object metadata is used as the target association table object metadata, and the basic auto-increment column metadata is used as the target auto-increment column metadata.

[0079] Specifically, after performing consistency check and integrity check, the preset calibration mechanism can be used to judge and process the first check result and the second check result. If both the first check result and the second check result satisfy the preset calibration mechanism, that is, both the first check result and the second check result comply with the corresponding rules, then the basic association table object metadata is used as the target association table object metadata, and the basic auto-increment column metadata is used as the target auto-increment column metadata.

[0080] On the basis of the above embodiments, if the first verification result is that both the basic association table object metadata and the basic auto-increment column metadata do not meet the preset consistency verification rules, and the second verification result is that both the basic association table object metadata and the basic auto-increment column metadata do not meet the preset integrity verification rules, then there is no target association table object metadata or target auto-increment column metadata. If the first verification result is that the basic association table object metadata meets the preset consistency verification rules and the basic auto-increment column metadata does not meet the preset consistency verification rules, and the second verification result is that the basic association table object metadata meets the preset integrity verification rules and the basic auto-increment column metadata does not meet the preset integrity verification rules, then only the basic association table object metadata is used as the target association table object metadata. Similarly, if the first verification result is that the basic association table object metadata does not meet the preset consistency verification rules and the basic auto-increment column metadata meets the preset consistency verification rules, and the second verification result is that the basic association table object metadata does not meet the preset integrity verification rules and the basic auto-increment column metadata meets the preset integrity verification rules, then only the basic auto-increment column metadata is used as the target auto-increment column metadata.

[0081] It is worth noting that in the embodiment of the present invention, for a verification object, such as basic association table object metadata or basic auto-increment column metadata, the verification object must be used as target metadata when both the first verification result and the second verification result of the verification object satisfy the preset calibration mechanism. If any of the first verification result and the second verification result of the verification object does not satisfy the preset calibration mechanism, the verification object will not be used as target metadata.

[0082] S2120, storing the target data table object metadata, the target association table object metadata and the target auto-increment column metadata.

[0083] The technical solution of the embodiment of the present invention determines the target data table object metadata corresponding to the complex data table object based on the basic data table object name in the target data table object information, performs data recovery on the target data table object metadata based on the data storage location in the target data table object information, and generates the basic data recovery information corresponding to the complex data table object. Further, based on the basic data recovery information, the basic key value information and the preset association table set corresponding to the complex data table object are obtained, and the preset association table set is indexed based on the basic key value information to generate the target association table object information corresponding to the complex data table object. And, based on the basic data recovery information, the basic field information and the preset field discrimination mechanism corresponding to the complex data table object are obtained, and the basic field information is discriminated based on the preset field discrimination mechanism to generate the discrimination result, and the target table auto-increment column information corresponding to the complex data table object is determined based on the discrimination result. Further, based on the target association table object information, the basic association table object metadata corresponding to the complex data table object is data recovered to generate the association table object recovery information corresponding to the complex data table object, and based on the target table auto-increment column information, the basic auto-increment column metadata corresponding to the complex data table object is data recovered to generate the table auto-increment column recovery information corresponding to the complex data table object. Finally, the basic associated table object metadata and the basic auto-increment column metadata are checked for consistency based on the preset consistency check rule, the associated table object recovery information and the table auto-increment column recovery information to generate a first check result. The basic associated table object metadata and the basic auto-increment column metadata are checked for integrity based on the preset integrity check rule, the associated table object recovery information and the table auto-increment column recovery information to generate a second check result. The first check result and the second check result are judged and processed based on the preset calibration mechanism. If the first check result and the second check result meet the preset calibration mechanism, the basic associated table object metadata is used as the target associated table object metadata, and the basic auto-increment column metadata is used as the target auto-increment column metadata. The target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored. Since the associated table object information and the table auto-increment column information corresponding to the complex data table object are determined by the index method, the problem of low metadata recovery efficiency of the complex data table object is solved, and the metadata of different levels corresponding to the complex data table object can be recovered, which saves the space overhead and time overhead required for metadata recovery and improves the metadata recovery efficiency of the complex data table object.

[0084] Figure 3The flowchart of an optional metadata recovery method for a complex data table object provided by an embodiment of the present invention is shown. Specifically, first, the target data table object information corresponding to the complex data table object is obtained, and then, based on the target data table object information, the target data table object metadata corresponding to the complex data table object is recovered to generate the basic data recovery information corresponding to the complex data table object. Further, it is determined whether the data table object metadata is successfully recovered. If the recovery is successful, that is, there is recovery data in the basic data recovery information, then the target associated table object information corresponding to the complex data table object is determined based on the preset associated foreign key index algorithm and the basic data recovery information, and the target table auto-increment column information corresponding to the complex data table object is determined based on the preset sequence index algorithm and the basic data recovery information. Further, based on the target associated table object information, the basic associated table object metadata corresponding to the complex data table object is recovered to generate the associated table object recovery information corresponding to the complex data table object, and based on the target table auto-increment column information, the basic auto-increment column metadata corresponding to the complex data table object is recovered to generate the table auto-increment column recovery information corresponding to the complex data table object. Finally, based on the preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, the basic associated table object metadata and the basic auto-increment column metadata are checked for accuracy, the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored. Thus, metadata recovery of complex data table objects is achieved.

[0085] Figure 4 The flowchart of a process for determining the object information of an association table provided by an embodiment of the present invention is shown. Specifically, first, the basic key value information corresponding to the complex data table object is obtained. Then, an index operation is performed on the preset association table set based on the basic key value information to generate a first index result. Finally, based on the first index result, the association table object information corresponding to the first index result is determined in the preset association table set as the target association table object information corresponding to the complex data table object. Thus, the process for determining the object information of the association table is completed.

[0086] Figure 5The flowchart shown is a process for determining table auto-increment column information provided by an embodiment of the present invention. Specifically, first, the basic field information corresponding to the complex data table object is obtained. Then, the basic field information is discriminated and processed based on the preset field discrimination mechanism to generate a discrimination result. Further, it is determined whether the discrimination result is that there is an auto-increment column. If the discrimination result is that there is an auto-increment column, an index operation is performed on the preset sequence set based on the basic field information to generate a second index result. Finally, based on the second index result, the table auto-increment column information corresponding to the second index result is determined in the preset sequence set as the target table auto-increment column information corresponding to the complex data table object. In this way, the process for determining the table auto-increment column information is completed.

[0087] Embodiment 3

[0088] Figure 6 This is a schematic diagram of the structure of a metadata recovery device for a complex data table object provided by the third embodiment of the present invention. Figure 6 As shown, the device includes: a first data recovery module 310, an additional information determination module 320, a second data recovery module 330 and a data storage module 340;

[0089] The first data recovery module 310 is used to obtain target data table object information corresponding to the complex data table object, and perform data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object;

[0090] The additional information determination module 320 is used to determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and to determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information;

[0091] The second data recovery module 330 is used to perform data recovery on the basic associated table object metadata corresponding to the complex data table object based on the target associated table object information, and generate associated table object recovery information corresponding to the complex data table object, and perform data recovery on the basic auto-increment column metadata corresponding to the complex data table object based on the target table auto-increment column information, and generate table auto-increment column recovery information corresponding to the complex data table object;

[0092] The data storage module 340 is used to verify the accuracy of the basic associated table object metadata and the basic auto-increment column metadata based on a preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, determine the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism, and store the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata.

[0093] The technical solution of the embodiment of the present invention is to perform data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information corresponding to the complex data table object, and generate the basic data recovery information corresponding to the complex data table object. Then, the target association table object information corresponding to the complex data table object is determined based on the preset association foreign key index algorithm and the basic data recovery information, and the target table auto-increment column information corresponding to the complex data table object is determined based on the preset sequence index algorithm and the basic data recovery information. Further, the basic association table object metadata corresponding to the complex data table object is restored based on the target association table object information to generate the association table object recovery information corresponding to the complex data table object, and the basic auto-increment column metadata corresponding to the complex data table object is restored based on the target table auto-increment column information to generate the table auto-increment column recovery information corresponding to the complex data table object. Finally, the basic association table object metadata and the basic auto-increment column metadata are checked for accuracy based on the preset calibration mechanism, the association table object recovery information and the table auto-increment column recovery information, and the target association table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target association table object metadata and the target auto-increment column metadata are stored. Since the index method is used to determine the associated table object information and table auto-increment column information corresponding to the complex data table object, the problem of low metadata recovery efficiency of the complex data table object is solved. It is possible to recover different levels of metadata corresponding to the complex data table object, saving the space and time overhead required for metadata recovery and improving the metadata recovery efficiency of the complex data table object.

[0094] Optionally, the first data recovery module 310 may be specifically used for:

[0095] Determine the target data table object metadata corresponding to the complex data table object based on the basic data table object name in the target data table object information;

[0096] The target data table object metadata is restored based on the data storage location in the target data table object information to generate basic data recovery information corresponding to the complex data table object.

[0097] Optionally, the additional information determination module 320 may be specifically used to:

[0098] Based on the basic data recovery information, basic key value information and a preset association table set corresponding to the complex data table object are obtained;

[0099] An index operation is performed on the preset association table set based on the basic key value information to generate target association table object information corresponding to the complex data table object.

[0100] Optionally, the additional information determination module 320 may be specifically used to:

[0101] Performing an index operation on the preset association table set based on the basic key value information to generate a first index result;

[0102] Based on the first index result, the associated table object information corresponding to the first index result is determined in the preset associated table set as the target associated table object information corresponding to the complex data table object.

[0103] Optionally, the additional information determination module 320 may be specifically used to:

[0104] Based on the basic data recovery information, basic field information corresponding to the complex data table object and a preset field identification mechanism are obtained;

[0105] The basic field information is discriminated based on a preset field discrimination mechanism to generate a discrimination result, and the target table auto-increment column information corresponding to the complex data table object is determined based on the discrimination result.

[0106] Optionally, the additional information determination module 320 may be specifically used to:

[0107] If the determination result is that there is an auto-increment column, an index operation is performed on the preset sequence set based on the basic field information to generate a second index result;

[0108] Based on the second index result, the table auto-increment column information corresponding to the second index result is determined in a preset sequence set as the target table auto-increment column information corresponding to the complex data table object.

[0109] Optionally, the data storage module 340 may be used to:

[0110] Performing consistency check on the basic association table object metadata and the basic auto-increment column metadata based on a preset consistency check rule, the association table object recovery information and the table auto-increment column recovery information to generate a first check result;

[0111] Performing integrity check on the basic association table object metadata and the basic auto-increment column metadata based on a preset integrity check rule, the association table object recovery information, and the table auto-increment column recovery information to generate a second check result;

[0112] The first verification result and the second verification result are judged and processed based on a preset calibration mechanism. If the first verification result and the second verification result meet the preset calibration mechanism, the basic association table object metadata is used as the target association table object metadata, and the basic auto-increment column metadata is used as the target auto-increment column metadata.

[0113] The metadata recovery device for complex data table objects provided in the embodiment of the present invention can execute the metadata recovery method for complex data table objects provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0114] Embodiment 4

[0115] Figure 7 A schematic diagram of an electronic device 410 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0116] like Figure 7 As shown, the electronic device 410 includes at least one processor 420, and a memory connected to the at least one processor 420 in communication, such as a read-only memory (ROM) 430, a random access memory (RAM) 440, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 420 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 430 or the computer program loaded from the storage unit 490 to the random access memory (RAM) 440. In the RAM 440, various programs and data required for the operation of the electronic device 410 can also be stored. The processor 420, the ROM 430, and the RAM 440 are connected to each other via a bus 450. An input / output (I / O) interface 460 is also connected to the bus 450.

[0117] Multiple components in the electronic device 410 are connected to the I / O interface 460, including: an input unit 470, such as a keyboard, a mouse, etc.; an output unit 480, such as various types of displays, speakers, etc.; a storage unit 490, such as a disk, an optical disk, etc.; and a communication unit 4100, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 4100 allows the electronic device 410 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0118] The processor 420 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 420 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The processor 420 executes the various methods and processes described above, such as a metadata recovery method for a complex data table object.

[0119] The method includes:

[0120] Obtaining target data table object information corresponding to the complex data table object, and performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object;

[0121] Determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information;

[0122] Based on the target associated table object information, data recovery is performed on the basic associated table object metadata corresponding to the complex data table object to generate associated table object recovery information corresponding to the complex data table object, and based on the target table auto-increment column information, data recovery is performed on the basic auto-increment column metadata corresponding to the complex data table object to generate table auto-increment column recovery information corresponding to the complex data table object;

[0123] Based on the preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, the basic associated table object metadata and the basic auto-increment column metadata are checked for accuracy, the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored.

[0124] In some embodiments, the metadata recovery method for complex data table objects may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 490. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 410 via the ROM 430 and / or the communication unit 4100. When the computer program is loaded into the RAM 440 and executed by the processor 420, one or more steps of the metadata recovery method for complex data table objects described above may be performed. Alternatively, in other embodiments, the processor 420 may be configured to execute the metadata recovery method for complex data table objects in any other appropriate manner (e.g., by means of firmware).

[0125] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0126] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0127] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0128] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0129] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0130] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0131] The present application also discloses a computer program product, which includes a computer program. When the computer program is executed by a processor, the computer program implements the metadata recovery method for a complex data table object provided in any embodiment of the present application. The program product and the metadata recovery method for a complex data table object disclosed in each embodiment of the present application belong to the same inventive concept, so they are not described here in detail.

[0132] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0133] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for recovering metadata of a complex data table object, characterized in that: include: Obtaining target data table object information corresponding to the complex data table object, and performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object; Determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information; Based on the target associated table object information, data recovery is performed on the basic associated table object metadata corresponding to the complex data table object to generate associated table object recovery information corresponding to the complex data table object, and based on the target table auto-increment column information, data recovery is performed on the basic auto-increment column metadata corresponding to the complex data table object to generate table auto-increment column recovery information corresponding to the complex data table object; Based on the preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, the basic associated table object metadata and the basic auto-increment column metadata are checked for accuracy, the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism are determined, and the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata are stored.

2. The method according to claim 1, characterized in that The step of performing data recovery on the target data table object metadata corresponding to the complex data table object based on the target data table object information to generate basic data recovery information corresponding to the complex data table object includes: Determine the target data table object metadata corresponding to the complex data table object based on the basic data table object name in the target data table object information; The target data table object metadata is restored based on the data storage location in the target data table object information to generate basic data recovery information corresponding to the complex data table object.

3. The method according to claim 1, characterized in that The determining the target associated table object information corresponding to the complex data table object based on the preset associated foreign key index algorithm and the basic data recovery information includes: Based on the basic data recovery information, basic key value information and a preset association table set corresponding to the complex data table object are obtained; An index operation is performed on the preset association table set based on the basic key value information to generate target association table object information corresponding to the complex data table object.

4. The method according to claim 3, characterized in that The indexing operation is performed on the preset association table set based on the basic key value information to generate target association table object information corresponding to the complex data table object, including: Performing an index operation on the preset association table set based on the basic key value information to generate a first index result; Based on the first index result, the associated table object information corresponding to the first index result is determined in the preset associated table set as the target associated table object information corresponding to the complex data table object.

5. The method according to claim 1, characterized in that The determining the target table auto-increment column information corresponding to the complex data table object based on the preset sequence index algorithm and the basic data recovery information includes: Based on the basic data recovery information, basic field information corresponding to the complex data table object and a preset field identification mechanism are obtained; The basic field information is discriminated based on a preset field discrimination mechanism to generate a discrimination result, and the target table auto-increment column information corresponding to the complex data table object is determined based on the discrimination result.

6. The method according to claim 5, characterized in that The determining the target table auto-increment column information corresponding to the complex data table object based on the discrimination result includes: If the determination result is that there is an auto-increment column, an index operation is performed on the preset sequence set based on the basic field information to generate a second index result; Based on the second index result, the table auto-increment column information corresponding to the second index result is determined in a preset sequence set as the target table auto-increment column information corresponding to the complex data table object.

7. The method according to claim 1, characterized in that The step of checking the accuracy of the basic association table object metadata and the basic auto-increment column metadata based on the preset calibration mechanism, the association table object recovery information, and the table auto-increment column recovery information, and determining the target association table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism, includes: Based on the preset consistency check rule, the association table object recovery information and the table auto-increment column recovery information, the basic association table object metadata and the basic auto-increment column metadata are checked for consistency, and a first check result is generated; Performing integrity check on the basic association table object metadata and the basic auto-increment column metadata based on a preset integrity check rule, the association table object recovery information, and the table auto-increment column recovery information to generate a second check result; The first verification result and the second verification result are judged and processed based on a preset calibration mechanism. If the first verification result and the second verification result meet the preset calibration mechanism, the basic association table object metadata is used as the target association table object metadata, and the basic auto-increment column metadata is used as the target auto-increment column metadata.

8. A metadata recovery device for complex data table objects, characterized in that: include: A first data recovery module is used to obtain target data table object information corresponding to the complex data table object, and based on the target data table object information, perform data recovery on the target data table object metadata corresponding to the complex data table object to generate basic data recovery information corresponding to the complex data table object; An additional information determination module is used to determine the target associated table object information corresponding to the complex data table object based on a preset associated foreign key index algorithm and the basic data recovery information, and to determine the target table auto-increment column information corresponding to the complex data table object based on a preset sequence index algorithm and the basic data recovery information; A second data recovery module is used to perform data recovery on the basic associated table object metadata corresponding to the complex data table object based on the target associated table object information, generate associated table object recovery information corresponding to the complex data table object, and perform data recovery on the basic auto-increment column metadata corresponding to the complex data table object based on the target table auto-increment column information, generate table auto-increment column recovery information corresponding to the complex data table object; A data storage module is used to verify the accuracy of the basic associated table object metadata and the basic auto-increment column metadata based on a preset calibration mechanism, the associated table object recovery information and the table auto-increment column recovery information, determine the target associated table object metadata and the target auto-increment column metadata that meet the preset calibration mechanism, and store the target data table object metadata, the target associated table object metadata and the target auto-increment column metadata.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the metadata recovery method for a complex data table object according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the metadata recovery method for a complex data table object according to any one of claims 1 to 7 when executed.

Images