CN116841798A - Data backup method, device, electronic equipment and storage medium - Google Patents
Data backup method, device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116841798A CN116841798A CN202310760208.2A CN202310760208A CN116841798A CN 116841798 A CN116841798 A CN 116841798A CN 202310760208 A CN202310760208 A CN 202310760208A CN 116841798 A CN116841798 A CN 116841798A
- Authority
- CN
- China
- Prior art keywords
- data table
- source data
- configuration file
- granularity
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000012545 processing Methods 0.000 claims abstract description 21
- 239000012634 fragment Substances 0.000 claims description 38
- 238000006243 chemical reaction Methods 0.000 claims description 13
- 238000012216 screening Methods 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 10
- 238000005516 engineering process Methods 0.000 abstract description 5
- 238000012423 maintenance Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000013507 mapping Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 238000012795 verification Methods 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1435—Saving, restoring, recovering or retrying at system level using file system or storage system metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1474—Saving, restoring, recovering or retrying in transactions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosure relates to a data backup method, a data backup device, electronic equipment and a storage medium, and belongs to the technical fields of financial science and technology, information technology industry and data backup. The method comprises the following steps: acquiring a configuration file set of a source data table, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity; generating a data backup statement of the source data table based on the table granularity configuration information and the field granularity configuration information of the source data table; executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate the target data table. Therefore, the configuration information of the table granularity of the source data table and the configuration information of the field granularity are separately arranged in different files, and the configuration information of the table granularity and the configuration information of the field granularity of the source data table are comprehensively considered to generate data backup sentences, so that the flexibility of data backup is improved.
Description
Technical Field
The present disclosure relates to the technical fields of financial science and technology, information technology industry and data backup, and in particular, to a data backup method, apparatus, electronic device, computer readable storage medium and computer program product.
Background
At present, with the continuous development of big data technology, a large amount of data needs to consume more system resources to affect the system performance, so that the data in the system needs to be backed up. However, the data backup method in the related art has the problems of high data backup difficulty, high cost and low flexibility.
Disclosure of Invention
The disclosure provides a data backup method, a device, an electronic apparatus, a computer readable storage medium and a computer program product, so as to at least solve the problems of high data backup difficulty, high cost and low flexibility of the data backup method in the related art. The technical scheme of the present disclosure is as follows:
according to a first aspect of an embodiment of the present disclosure, there is provided a data backup method, including: acquiring a configuration file set of a source data table, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity; generating a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table; executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate a target data table.
In one embodiment of the present disclosure, the generating the data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table includes: generating a first statement fragment of the source data table based on configuration information of table granularity of the source data table; generating a second statement fragment of the source data table based on configuration information of field granularity of the source data table; and splicing the first statement fragment and the second statement fragment to obtain the data backup statement.
In one embodiment of the present disclosure, the generating the data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table includes: generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table; and carrying out grammar conversion on the initial sentence according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs to obtain the data backup sentence.
In one embodiment of the present disclosure, further comprising: extracting the identification of the database to which the source data table belongs and the identification of the database to which the target data table belongs from the configuration information of the table granularity of the source data table; acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs; and acquiring a grammar rule corresponding to the identification of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs.
In one embodiment of the present disclosure, further comprising: acquiring adjustment information of a configuration file set of the source data table; identifying the adjustment information as configuration information of table granularity, and adjusting a table level configuration file of the source data table based on the adjustment information; and identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
In one embodiment of the present disclosure, the obtaining the configuration file set of the source data table includes: acquiring the identification of the source data table; screening a table-level configuration file carrying the identification of the source data table from a table-level configuration file library to serve as the table-level configuration file of the source data table; screening a field-level configuration file carrying the identification of the source data table from a field-level configuration file library to serve as the field-level configuration file of the source data table; and associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
In one embodiment of the disclosure, the obtaining the identification of the source data table includes: acquiring a data backup task, wherein the data backup task comprises identification of a candidate data table to be backed up and backup time of the candidate data table; and if the current moment reaches the backup moment of the candidate data table, determining the identification of the candidate data table as the identification of the source data table.
According to a second aspect of the embodiments of the present disclosure, there is provided a data backup apparatus, including: the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is configured to acquire a configuration file set of a source data table, the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity; a generation module configured to generate a data backup statement of the source data table based on the table granularity configuration information of the source data table and the field granularity configuration information of the source data table; and the execution module is configured to execute the data backup statement, and perform data backup processing on the source data table based on the data backup statement to generate a target data table.
In one embodiment of the present disclosure, the generating module is further configured to: generating a first statement fragment of the source data table based on configuration information of table granularity of the source data table; generating a second statement fragment of the source data table based on configuration information of field granularity of the source data table; and splicing the first statement fragment and the second statement fragment to obtain the data backup statement.
In one embodiment of the present disclosure, the generating module is further configured to: generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table; and carrying out grammar conversion on the initial sentence according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs to obtain the data backup sentence.
In one embodiment of the present disclosure, the generating module is further configured to: extracting the identification of the database to which the source data table belongs and the identification of the database to which the target data table belongs from the configuration information of the table granularity of the source data table; acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs; and acquiring a grammar rule corresponding to the identification of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs.
In one embodiment of the present disclosure, the acquisition module is further configured to: acquiring adjustment information of a configuration file set of the source data table; identifying the adjustment information as configuration information of table granularity, and adjusting a table level configuration file of the source data table based on the adjustment information; and identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
In one embodiment of the present disclosure, the acquisition module is further configured to: acquiring the identification of the source data table; screening a table-level configuration file carrying the identification of the source data table from a table-level configuration file library to serve as the table-level configuration file of the source data table; screening a field-level configuration file carrying the identification of the source data table from a field-level configuration file library to serve as the field-level configuration file of the source data table; and associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
In one embodiment of the present disclosure, the acquisition module is further configured to: acquiring a data backup task, wherein the data backup task comprises identification of a candidate data table to be backed up and backup time of the candidate data table; and if the current moment reaches the backup moment of the candidate data table, determining the identification of the candidate data table as the identification of the source data table.
According to a third aspect of embodiments of the present disclosure, there is provided an electronic device, comprising: a processor; a memory for storing the processor-executable instructions; wherein the processor is configured to execute the instructions to implement the data backup method as described in the previous first aspect.
According to a fourth aspect of embodiments of the present disclosure, there is provided a computer readable storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the data backup method as described in the previous first aspect.
According to a fifth aspect of embodiments of the present disclosure, there is provided a computer program product comprising a computer program which, when executed by a processor, implements the data backup method as described in the previous first aspect.
The technical scheme provided by the embodiment of the disclosure at least brings the following beneficial effects: the configuration information of the table granularity and the configuration information of the field granularity of the source data table are separately arranged in different files, so that the maintenance difficulty and the cost of the configuration files are reduced, the difficulty and the cost of data backup are further reduced, the configuration information of the table granularity and the configuration information of the field granularity of the source data table can be comprehensively considered, data backup sentences are generated, the flexibility of the data backup sentences is improved, and the flexibility of the data backup is further improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure and do not constitute an undue limitation on the disclosure.
Fig. 1 is a flow chart illustrating a data backup method according to a first embodiment of the present disclosure.
Fig. 2 is a flow chart illustrating a data backup method according to a second embodiment of the present disclosure.
Fig. 3 is a flow chart illustrating a data backup method according to a third embodiment of the present disclosure.
Fig. 4 is a flow chart of a data backup method according to a fourth embodiment of the present disclosure.
Fig. 5 is a block diagram of a data backup apparatus according to a first embodiment of the present disclosure.
Fig. 6 is a block diagram of an electronic device, according to an example embodiment.
Detailed Description
In order to enable those skilled in the art to better understand the technical solutions of the present disclosure, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.
It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present disclosure as detailed in the accompanying claims.
The data acquisition, storage, use, processing and the like in the technical scheme of the present disclosure all conform to the relevant regulations of the national laws and regulations.
Fig. 1 is a flow chart illustrating a data backup method according to a first embodiment of the present disclosure.
As shown in fig. 1, the data backup method of the first embodiment of the present disclosure includes the following steps:
s101, acquiring a configuration file set of a source data table, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity.
It should be noted that, the execution body of the data backup method of the present disclosure is an electronic device. The data backup method of the embodiment of the present disclosure may be performed by the data backup apparatus of the embodiment of the present disclosure, and the data backup apparatus of the embodiment of the present disclosure may be configured in any electronic device to perform the data backup method of the embodiment of the present disclosure.
It should be noted that, the source data table refers to a data table to be backed up, and the source data table is not excessively limited.
It should be noted that, the configuration information of the table granularity is not limited too much, for example, the configuration information may include a backup policy, an identifier of the source data table, an identifier of the target data table, an identifier of a database to which the source data table belongs, an identifier of a database to which the target data table belongs, and a backup condition of the source data table. It will be appreciated that the databases to which the source and destination data tables pertain may be the same or different.
The target data table refers to a data table obtained by carrying out data backup processing on the source data table.
The backup policy may include an incremental backup policy, a full backup policy, a backup scope, a backup frequency, and the like. The backup scope is composed of data to be backed up in the source data table, for example, the backup scope may be composed of data of the first column to the third column in the source data table. The backup frequency refers to a frequency of performing data backup on the source data table, for example, the backup frequency may be once a day.
It should be noted that, the configuration information of the field granularity is not limited too much, for example, may include a source field name in the source data table, a target field name in the target data table, a field mapping relationship between the source field name and the target field name, a primary key identifier, a backup identifier for indicating whether the source field is backed up, a backup rule of the source field, an external key identifier of the source field, an update identifier for indicating whether the source field is updated, and so on.
It is understood that different source data tables may correspond to different sets of profiles.
In one embodiment, obtaining the configuration file set of the source data table includes obtaining the identifier of the source data table, and screening the configuration file set carrying the identifier of the source data table from the configuration file set library to serve as the configuration file set of the source data table. It is understood that the profile set library includes a plurality of profile sets.
S102, generating a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table.
It should be noted that the data backup statement is not excessively limited, and may include, for example, SQL (Structured Query Language ) statements.
In an embodiment of the present disclosure, generating a data backup statement of a source data table based on table granularity configuration information of the source data table and field granularity configuration information of the source data table includes the following possible embodiments:
mode 1, the configuration information identifying the table granularity of the source data table includes an incremental backup policy, an incremental backup statement is generated based on the configuration information identifying the field granularity of the source data table as a data backup statement, or the configuration information identifying the table granularity of the source data table includes a full backup policy, and a full backup statement is generated based on the configuration information identifying the field granularity of the source data table as a data backup statement.
In some examples, generating the incremental backup statement based on the configuration information of the field granularity of the source data table includes generating the incremental backup statement based on a primary key identification of the source data table, a field mapping relationship between a source field name and a target field name, and a backup rule of the source field.
In some examples, generating the full back-up statement based on the configuration information of the field granularity of the source data table includes generating the full back-up statement based on a field mapping relationship between the source field name and the target field name, a back-up rule of the source field.
And 2, splicing the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table to generate a data backup statement.
In some examples, splicing the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table to generate the data backup statement includes splicing the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table according to a set splicing rule to generate the data backup statement. It should be noted that the setting splicing rule is not limited too much, and may include, for example, a splicing position of table-granularity configuration information of the source data table, a splicing position of field-granularity configuration information of the source data table, and the like.
And 3, generating a first statement fragment of the source data table based on the configuration information of the table granularity of the source data table, generating a second statement fragment of the source data table based on the configuration information of the field granularity of the source data table, and splicing the first statement fragment and the second statement fragment to obtain a data backup statement.
Therefore, in the method, the first statement fragment can be generated by considering the configuration information of the table granularity of the source data table, and the second statement fragment can be generated by considering the configuration information of the field granularity of the source data table, so that the data backup statement can be obtained.
In some examples, generating the first statement fragment of the source data table based on the table-granularity configuration information of the source data table includes concatenating the plurality of table-granularity configuration information of the source data table according to a first concatenation rule to generate the first statement fragment.
In some examples, generating the second statement fragment of the source data table based on the field-granularity configuration information of the source data table includes concatenating the plurality of field-granularity configuration information of the source data table according to a second concatenation rule to generate the second statement fragment.
It should be noted that the first splicing rule and the second splicing rule are not excessively limited.
S103, executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate the target data table.
It should be noted that, the content related to executing the data backup statement and performing the data backup processing on the source data table may be implemented by any method in the related art, which is not limited herein.
In one embodiment, executing the data backup statement includes checking the data backup statement, and executing the data backup statement if the data backup statement passes the checking. Therefore, the method can execute the data backup statement when the data backup statement passes the verification, can avoid the problem that the execution of the data backup statement is abnormal due to the error of the data backup statement, and improves the reliability of the data backup.
In some examples, if the data backup statement fails the verification, the process of obtaining the data backup statement is returned to reacquire the data backup statement, that is, when the data backup statement fails the verification, the data backup statement is reacquired, so that the accuracy of the data backup statement is improved.
In one embodiment, performing data backup processing on a source data table based on a data backup statement to generate a target data table includes identifying whether a database to which the source data table belongs is consistent with a database to which the target data table belongs based on the data backup statement, if the database to which the source data table belongs is consistent with the database to which the target data table belongs, indicating that data backup is performed in the same database, creating a target data table with empty data in the database to which the source data table belongs, and performing data backup processing on the source data table to update the target data table.
If the database of the source data table is inconsistent with the database of the target data table, indicating that data backup is performed across the databases, transmitting the source data table from the database of the source data table to the database of the target data table, creating a temporary table with empty data in the database of the target data table, analyzing the source data table transmitted to the database of the target data table into the temporary table, setting the identification of the temporary table as the identification of the source data table, creating a target data table with empty data in the database of the target data table, and performing data backup processing on the temporary table to update the target data table.
In summary, according to the data backup method provided by the embodiment of the present disclosure, a configuration file set of a source data table is obtained, where the configuration file set includes a table-level configuration file and a field-level configuration file, the table-level configuration file includes configuration information of a table granularity, the field-level configuration file includes configuration information of a field granularity, a data backup statement of the source data table is generated based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table, the data backup statement is executed, and data backup processing is performed on the source data table based on the data backup statement, so as to generate a target data table. Therefore, the configuration information of the table granularity and the configuration information of the field granularity of the source data table are separately arranged in different files, so that the maintenance difficulty and the cost of the configuration files are reduced, the difficulty and the cost of data backup are further reduced, the configuration information of the table granularity and the configuration information of the field granularity of the source data table can be comprehensively considered to generate data backup sentences, the flexibility of the data backup sentences is improved, and the flexibility of the data backup is further improved.
Fig. 2 is a flow chart illustrating a data backup method according to a second embodiment of the present disclosure.
As shown in fig. 2, the data backup method according to the second embodiment of the present disclosure includes the following steps:
s201, a configuration file set of a source data table is obtained, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity.
The relevant content of step S201 may be referred to the above embodiments, and will not be described herein.
S202, generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table.
The relevant content of step S202 may refer to the relevant content of step S102 in the above embodiment, and will not be described herein.
S203, performing grammar conversion on the initial sentence according to the grammar rule of the database of the source data table and the grammar rule of the database of the target data table to obtain the data backup sentence.
It will be appreciated that the grammar rules for the different databases may be the same or different and are not so limited.
In one embodiment, the method further comprises determining a grammar rule of the database to which the source data table belongs and a grammar rule of the database to which the target data table belongs based on a correspondence between the database and the grammar rule.
In one embodiment, the method further comprises the steps of extracting the identifier of the database to which the source data table belongs and the identifier of the database to which the target data table belongs from configuration information of the table granularity of the source data table, acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs, and acquiring a grammar rule corresponding to the identifier of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs. Thus, the method can pre-establish the corresponding relation between the identification of the database and the grammar rules, and determine the grammar rules of the database based on the corresponding relation.
In one embodiment, the method includes performing syntax conversion on an initial sentence according to a syntax rule of a database to which a source data table belongs and a syntax rule of a database to which a target data table belongs to obtain a data backup sentence, including the following possible embodiments:
mode 1, recognizing that the grammar rule of the database of the source data table is consistent with the grammar rule of the database of the target data table, and carrying out grammar conversion on the initial sentence according to the grammar rule of the database of the source data table to obtain a data backup sentence.
For example, if the database to which the source data table belongs is consistent with the database to which the target data table belongs, the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs are identified to be consistent.
And 2, recognizing that the grammar rule of the database of the source data table is inconsistent with the grammar rule of the database of the target data table, and carrying out grammar conversion on the initial sentence according to the grammar rule of the database of the source data table and the grammar rule of the database of the target data table to obtain a data backup sentence.
And 3, dividing the initial sentence into a third sentence fragment corresponding to the database of the source data table and a fourth sentence fragment corresponding to the database of the target data table, carrying out grammar conversion on the third sentence fragment according to the grammar rule of the database of the target data table to obtain a fifth sentence fragment, carrying out grammar conversion on the fourth sentence fragment according to the grammar rule of the database of the target data table to obtain a sixth sentence fragment, and splicing the fifth sentence fragment and the sixth sentence fragment to generate a data backup sentence.
S204, executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate the target data table.
The relevant content of step S204 may be referred to the above embodiments, and will not be described herein.
In summary, according to the data backup method provided by the embodiment of the present disclosure, based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table, an initial sentence of the source data table is generated, and the initial sentence is subjected to grammar conversion according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs, so as to obtain a data backup sentence. Therefore, the grammar rules of the database of the source data table and the grammar rules of the database of the target data table can be comprehensively considered, grammar conversion is carried out on the initial statement to obtain the data backup statement, so that the data backup statement is applicable to the database of the source data table and the database of the target data table.
Fig. 3 is a flow chart illustrating a data backup method according to a third embodiment of the present disclosure.
As shown in fig. 3, a data backup method according to a third embodiment of the present disclosure includes the following steps:
S301, acquiring a configuration file set of a source data table, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity.
The relevant content of step S301 may be referred to the above embodiments, and will not be described herein.
S302, acquiring adjustment information of a configuration file set of a source data table.
S303, identifying the adjustment information as configuration information of table granularity, and adjusting the table level configuration file of the source data table based on the adjustment information.
S304, identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
It should be noted that the adjustment information may include configuration information with a table granularity and configuration information with a field granularity.
In one embodiment, adjusting the table-level configuration file of the source data table based on the adjustment information includes identifying whether the adjustment information is consistent with a category of table-granularity configuration information in the table-level configuration file of the source data table, and if the table-granularity target configuration information in the table-level configuration file of the source data table is consistent with the category of adjustment information, replacing the table-granularity target configuration information with the adjustment information.
In one embodiment, adjusting the field level configuration file of the source data table based on the adjustment information includes identifying whether the adjustment information is consistent with a category of field-granularity configuration information in the field level configuration file of the source data table, and if the field-granularity target configuration information in the field level configuration file of the source data table is consistent with the category of adjustment information, replacing the field-granularity target configuration information with the adjustment information.
For example, the adjustment information of the configuration file set of the source data table includes an incremental backup policy, once a day, and a data backup rule 1 of the source field a, the configuration information of the table granularity in the table-level configuration file of the source data table includes a full backup policy, once a month, and the configuration information of the field granularity in the field-level configuration file of the source data table includes a data backup rule 2 of the source field a.
The incremental backup policy can be identified as configuration information of table granularity, the type of the incremental backup policy and the type of the full backup policy in the table-level configuration file of the source data table are both identified as backup policies, and the full backup policy in the table-level configuration file of the source data table is replaced by the incremental backup policy.
The configuration information of the table granularity can be identified once a day, the category of once a day and once a month in the table-level configuration file of the source data table can be identified as the backup frequency, and once a month in the table-level configuration file of the source data table is replaced by once a day.
The data backup rule 1 of the source field a can be identified as configuration information of field granularity, the data backup rule 1 of the source field a and the data backup rule 2 of the source field a in the field level configuration file of the source data table are identified as the data backup rule of the source field, and the data backup rule 2 of the source field a in the field level configuration file of the source data table is replaced by the data backup rule 1 of the source field a.
S305, generating a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table.
S306, executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate the target data table.
The relevant content of steps S305-S306 can be seen in the above embodiments, and will not be described here again.
In summary, according to the data backup method provided by the embodiment of the present disclosure, adjustment information of a configuration file set of a source data table is obtained, the adjustment information is identified as configuration information of a table granularity, a table-level configuration file of the source data table is adjusted based on the adjustment information, the identification adjustment information is identified as configuration information of a field granularity, and the field-level configuration file of the source data table is adjusted based on the adjustment information. Therefore, the table-level configuration file or the field-level configuration file of the source data table can be respectively adjusted based on the granularity of the adjustment information, so that the maintenance difficulty and the cost of the configuration file are reduced, and the difficulty and the cost of data backup are further reduced.
Fig. 4 is a flow chart of a data backup method according to a fourth embodiment of the present disclosure.
As shown in fig. 4, a data backup method according to a fourth embodiment of the present disclosure includes the steps of:
s401, obtaining the identification of the source data table.
In one embodiment, obtaining the identification of the source data table includes obtaining a data backup request, and extracting the identification of the source data table from the data backup request. It will be appreciated that the data backup request may be issued by the client or may be generated by the server itself, without limitation.
In one embodiment, obtaining the identifier of the source data table includes obtaining a data backup task, where the data backup task includes the identifier of the candidate data table to be backed up and a backup time of the candidate data table, and if the current time reaches the backup time of the candidate data table, determining the identifier of the candidate data table as the identifier of the source data table. Therefore, the method can preset the data backup task, and when the current moment reaches the preset backup moment, the identification of the candidate data table is determined as the identification of the source data table, so that the timing backup of the source data table can be realized.
It will be appreciated that the data backup task may include identification of a plurality of candidate data tables, backup times of the candidate data tables, the backup times of the candidate data tables being associated with the identification of the candidate data tables, the backup times of different candidate data tables may be the same or different.
For example, the data backup task includes the identifier of the candidate data table A, B, C and the backup time, where the backup time of the candidate data table a is 10 am on 8 months and 10 am, the backup time of the candidate data table B is 11 am on 8 months and 10 am on 8 months, if the current time reaches 10 am on 8 months and 10 am, the identifier of the candidate data table A, C may be determined as the identifier of the source data table, and if the current time reaches 11 am on 8 months and 10 am, the identifier of the candidate data table B may be determined as the identifier of the source data table.
S402, table-level configuration files carrying the identification of the source data table are screened out from the table-level configuration file library and used as the table-level configuration files of the source data table.
S403, selecting the field level configuration file carrying the identification of the source data table from the field level configuration file library as the field level configuration file of the source data table.
S404, associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
It is understood that the table level configuration file library includes a plurality of table level configuration files, and the field level configuration file library includes a plurality of field level configuration files.
For example, the identifier of the source data table a is x, the table-level configuration file library includes table-level configuration files 1 to 10, the field-level configuration file library includes field-level configuration files 11 to 20, if the table-level configuration file 5 carries the identifier x, the field-level configuration file 15 carries the identifier x, the table-level configuration file 5 may be screened out from the table-level configuration file as the table-level configuration file of the source data table a, the field-level configuration file 15 may be screened out from the field-level configuration file library as the field-level configuration file of the source data table a, and the table-level configuration file 5 and the field-level configuration file 15 are associated to obtain the configuration file set of the source data table a.
In one embodiment, associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table includes establishing a mapping relationship and/or a corresponding relationship between the table-level configuration file of the source data table and the field-level configuration file of the source data table to obtain the configuration file set of the source data table.
In one embodiment, associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table includes combining the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain the configuration file set of the source data table. It should be noted that the combination of the files is not limited too much, and may include file merging, for example.
S405, generating a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table.
S406, executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate the target data table.
In summary, according to the data backup method provided by the embodiment of the present disclosure, a table-level configuration file and a field-level configuration file of a source data table may be screened based on an identifier of the source data table, and the table-level configuration file and the field-level configuration file of the source data table may be associated to obtain a configuration file set of the source data table, so as to achieve acquisition of the configuration file set of the source data table.
Fig. 5 is a block diagram of a data backup apparatus according to a first embodiment of the present disclosure.
As shown in fig. 5, a data backup apparatus 500 of an embodiment of the present disclosure includes: an acquisition module 501, a generation module 502 and an execution module 503.
An obtaining module 501 configured to obtain a set of configuration files of a source data table, where the set of configuration files includes a table-level configuration file and a field-level configuration file, the table-level configuration file includes configuration information of a table granularity, and the field-level configuration file includes configuration information of a field granularity;
A generating module 502 configured to generate a data backup statement of the source data table based on the table granularity configuration information of the source data table and the field granularity configuration information of the source data table;
and the execution module 503 is configured to execute the data backup statement, and perform data backup processing on the source data table based on the data backup statement to generate a target data table.
In one embodiment of the present disclosure, the generating module 502 is further configured to: generating a first statement fragment of the source data table based on configuration information of table granularity of the source data table; generating a second statement fragment of the source data table based on configuration information of field granularity of the source data table; and splicing the first statement fragment and the second statement fragment to obtain the data backup statement.
In one embodiment of the present disclosure, the generating module 502 is further configured to: generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table; and carrying out grammar conversion on the initial sentence according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs to obtain the data backup sentence.
In one embodiment of the present disclosure, the generating module 502 is further configured to: extracting the identification of the database to which the source data table belongs and the identification of the database to which the target data table belongs from the configuration information of the table granularity of the source data table; acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs; and acquiring a grammar rule corresponding to the identification of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs.
In one embodiment of the present disclosure, the obtaining module 501 is further configured to: acquiring adjustment information of a configuration file set of the source data table; identifying the adjustment information as configuration information of table granularity, and adjusting a table level configuration file of the source data table based on the adjustment information; and identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
In one embodiment of the present disclosure, the obtaining module 501 is further configured to: acquiring the identification of the source data table; screening a table-level configuration file carrying the identification of the source data table from a table-level configuration file library to serve as the table-level configuration file of the source data table; screening a field-level configuration file carrying the identification of the source data table from a field-level configuration file library to serve as the field-level configuration file of the source data table; and associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
In one embodiment of the present disclosure, the obtaining module 501 is further configured to: acquiring a data backup task, wherein the data backup task comprises identification of a candidate data table to be backed up and backup time of the candidate data table; and if the current moment reaches the backup moment of the candidate data table, determining the identification of the candidate data table as the identification of the source data table.
The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.
In summary, the data backup device provided in the embodiments of the present disclosure obtains a configuration file set of a source data table, where the configuration file set includes a table-level configuration file and a field-level configuration file, where the table-level configuration file includes table-granularity configuration information, the field-level configuration file includes field-granularity configuration information, generates a data backup statement of the source data table based on the table-granularity configuration information of the source data table and the field-granularity configuration information of the source data table, executes the data backup statement, and performs data backup processing on the source data table based on the data backup statement, so as to generate a target data table. Therefore, the configuration information of the table granularity and the configuration information of the field granularity of the source data table are separately arranged in different files, so that the maintenance difficulty and the cost of the configuration files are reduced, the difficulty and the cost of data backup are further reduced, the configuration information of the table granularity and the configuration information of the field granularity of the source data table can be comprehensively considered to generate data backup sentences, the flexibility of the data backup sentences is improved, and the flexibility of the data backup is further improved.
Fig. 6 is a block diagram of an electronic device, according to an example embodiment.
As shown in fig. 6, the electronic device 600 includes:
a memory 610 and a processor 620, a bus 630 connecting the different components (including the memory 610 and the processor 620), the memory 610 storing a computer program that when executed by the processor 620 implements the data backup method described in the embodiments of the present disclosure.
Bus 630 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, and a local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include Industry Standard Architecture (ISA) bus, micro channel architecture (MAC) bus, enhanced ISA bus, video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.
Electronic device 600 typically includes a variety of electronic device readable media. Such media can be any available media that is accessible by electronic device 600 and includes both volatile and nonvolatile media, removable and non-removable media.
Memory 610 may also include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 640 and/or cache memory 650. The electronic device 600 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 660 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 6, commonly referred to as a "hard disk drive"). Although not shown in fig. 6, a magnetic disk drive for reading from and writing to a removable non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive for reading from or writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In such cases, each drive may be coupled to bus 630 through one or more data medium interfaces. Memory 610 may include at least one program product having a set (e.g., at least one) of program modules configured to carry out the functions of the various embodiments of the disclosure.
A program/utility 680 having a set (at least one) of program modules 670 may be stored in, for example, memory 610, such program modules 670 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment. Program modules 670 generally perform the functions and/or methods in the embodiments described in this disclosure.
The electronic device 600 may also communicate with one or more external devices 690 (e.g., keyboard, pointing device, display 691, etc.), one or more devices that enable a user to interact with the electronic device 600, and/or any device (e.g., network card, modem, etc.) that enables the electronic device 600 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 692. Also, the electronic device 600 may communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network, such as the Internet, through a network adapter 693. As shown in fig. 6, the network adapter 693 communicates with other modules of the electronic device 600 over the bus 630. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with electronic device 600, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
The processor 620 executes various functional applications and data processing by running programs stored in the memory 610.
It should be noted that, the implementation process and the technical principle of the electronic device in this embodiment refer to the foregoing explanation of the data backup method in the embodiment of the disclosure, and are not repeated herein.
In summary, the electronic device provided in the embodiments of the present disclosure may perform the foregoing data backup method, obtain a configuration file set of a source data table, where the configuration file set includes a table-level configuration file and a field-level configuration file, and the table-level configuration file includes configuration information of a table granularity, and the field-level configuration file includes configuration information of a field granularity, generates a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table, executes the data backup statement, and performs data backup processing on the source data table based on the data backup statement, so as to generate a target data table. Therefore, the configuration information of the table granularity and the configuration information of the field granularity of the source data table are separately arranged in different files, so that the maintenance difficulty and the cost of the configuration files are reduced, the difficulty and the cost of data backup are further reduced, the configuration information of the table granularity and the configuration information of the field granularity of the source data table can be comprehensively considered to generate data backup sentences, the flexibility of the data backup sentences is improved, and the flexibility of the data backup is further improved.
To achieve the above embodiments, the present disclosure also proposes a computer-readable storage medium.
Wherein the instructions in the computer-readable storage medium, when executed by a processor of the electronic device, enable the electronic device to perform the data backup method as described above. Alternatively, the computer readable storage medium may be ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, etc.
To achieve the above embodiments, the present disclosure further provides a computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements a data backup method as described above.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This disclosure is intended to cover any adaptations, uses, or adaptations of the disclosure following the general principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims (17)
1. A method of data backup, comprising:
acquiring a configuration file set of a source data table, wherein the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity;
generating a data backup statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table;
executing the data backup statement, and carrying out data backup processing on the source data table based on the data backup statement to generate a target data table.
2. The method of claim 1, wherein generating the data backup statement for the source data table based on the table-granularity configuration information for the source data table and the field-granularity configuration information for the source data table comprises:
Generating a first statement fragment of the source data table based on configuration information of table granularity of the source data table;
generating a second statement fragment of the source data table based on configuration information of field granularity of the source data table;
and splicing the first statement fragment and the second statement fragment to obtain the data backup statement.
3. The method of claim 1, wherein generating the data backup statement for the source data table based on the table-granularity configuration information for the source data table and the field-granularity configuration information for the source data table comprises:
generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table;
and carrying out grammar conversion on the initial sentence according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs to obtain the data backup sentence.
4. A method according to claim 3, further comprising:
extracting the identification of the database to which the source data table belongs and the identification of the database to which the target data table belongs from the configuration information of the table granularity of the source data table;
Acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs;
and acquiring a grammar rule corresponding to the identification of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs.
5. The method as recited in claim 1, further comprising:
acquiring adjustment information of a configuration file set of the source data table;
identifying the adjustment information as configuration information of table granularity, and adjusting a table level configuration file of the source data table based on the adjustment information;
and identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
6. The method of any of claims 1-5, wherein the obtaining the set of profiles of the source data table comprises:
acquiring the identification of the source data table;
screening a table-level configuration file carrying the identification of the source data table from a table-level configuration file library to serve as the table-level configuration file of the source data table;
screening a field-level configuration file carrying the identification of the source data table from a field-level configuration file library to serve as the field-level configuration file of the source data table;
And associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
7. The method of claim 6, wherein the obtaining the identification of the source data table comprises:
acquiring a data backup task, wherein the data backup task comprises identification of a candidate data table to be backed up and backup time of the candidate data table;
and if the current moment reaches the backup moment of the candidate data table, determining the identification of the candidate data table as the identification of the source data table.
8. A data backup apparatus, comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is configured to acquire a configuration file set of a source data table, the configuration file set comprises a table-level configuration file and a field-level configuration file, the table-level configuration file comprises configuration information of table granularity, and the field-level configuration file comprises configuration information of field granularity;
a generation module configured to generate a data backup statement of the source data table based on the table granularity configuration information of the source data table and the field granularity configuration information of the source data table;
And the execution module is configured to execute the data backup statement, and perform data backup processing on the source data table based on the data backup statement to generate a target data table.
9. The apparatus of claim 8, wherein the generation module is further configured to:
generating a first statement fragment of the source data table based on configuration information of table granularity of the source data table;
generating a second statement fragment of the source data table based on configuration information of field granularity of the source data table;
and splicing the first statement fragment and the second statement fragment to obtain the data backup statement.
10. The apparatus of claim 8, wherein the generation module is further configured to:
generating an initial statement of the source data table based on the configuration information of the table granularity of the source data table and the configuration information of the field granularity of the source data table;
and carrying out grammar conversion on the initial sentence according to the grammar rule of the database to which the source data table belongs and the grammar rule of the database to which the target data table belongs to obtain the data backup sentence.
11. The apparatus of claim 10, wherein the generation module is further configured to:
Extracting the identification of the database to which the source data table belongs and the identification of the database to which the target data table belongs from the configuration information of the table granularity of the source data table;
acquiring a grammar rule corresponding to the identifier of the database to which the source data table belongs as the grammar rule of the database to which the source data table belongs;
and acquiring a grammar rule corresponding to the identification of the database to which the target data table belongs as the grammar rule of the database to which the target data table belongs.
12. The apparatus of claim 8, wherein the acquisition module is further configured to:
acquiring adjustment information of a configuration file set of the source data table;
identifying the adjustment information as configuration information of table granularity, and adjusting a table level configuration file of the source data table based on the adjustment information;
and identifying the adjustment information as configuration information of field granularity, and adjusting the field level configuration file of the source data table based on the adjustment information.
13. The apparatus of any of claims 8-12, wherein the acquisition module is further configured to:
acquiring the identification of the source data table;
screening a table-level configuration file carrying the identification of the source data table from a table-level configuration file library to serve as the table-level configuration file of the source data table;
Screening a field-level configuration file carrying the identification of the source data table from a field-level configuration file library to serve as the field-level configuration file of the source data table;
and associating the table-level configuration file of the source data table with the field-level configuration file of the source data table to obtain a configuration file set of the source data table.
14. The apparatus of claim 13, wherein the acquisition module is further configured to:
acquiring a data backup task, wherein the data backup task comprises identification of a candidate data table to be backed up and backup time of the candidate data table;
and if the current moment reaches the backup moment of the candidate data table, determining the identification of the candidate data table as the identification of the source data table.
15. An electronic device, comprising:
a processor;
a memory for storing the processor-executable instructions;
wherein the processor is configured to execute the instructions to implement the data backup method of any of claims 1-7.
16. A computer readable storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the data backup method of any of claims 1-7.
17. A computer program product comprising a computer program which, when executed by a processor, implements a data backup method as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310760208.2A CN116841798A (en) | 2023-06-26 | 2023-06-26 | Data backup method, device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310760208.2A CN116841798A (en) | 2023-06-26 | 2023-06-26 | Data backup method, device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116841798A true CN116841798A (en) | 2023-10-03 |
Family
ID=88166294
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310760208.2A Pending CN116841798A (en) | 2023-06-26 | 2023-06-26 | Data backup method, device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116841798A (en) |
-
2023
- 2023-06-26 CN CN202310760208.2A patent/CN116841798A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108647357B (en) | Data query method and device | |
| US10296497B2 (en) | Storing a key value to a deleted row based on key range density | |
| CN109376142B (en) | Data migration method and terminal equipment | |
| CN113360519B (en) | Data processing method, device, equipment and storage medium | |
| CN111241111B (en) | Data query method and device, data comparison method and device, medium and equipment | |
| CN107766353B (en) | Method and device for migrating statistical information of database | |
| US20230014427A1 (en) | Global secondary index method for distributed database, electronic device and storage medium | |
| CN111061740A (en) | Data synchronization method, equipment and storage medium | |
| US7703074B2 (en) | Method and apparatus for tracking changes in a system | |
| CN110874364B (en) | Query statement processing method, device, equipment and storage medium | |
| CN110737710A (en) | Distributed data automatic structured warehousing method and system | |
| US10838947B2 (en) | Consistency check for foreign key definition | |
| CN116841798A (en) | Data backup method, device, electronic equipment and storage medium | |
| CN115080666A (en) | Data synchronization method, system, electronic device and storage medium | |
| CN114153461A (en) | Script processing method and device, electronic equipment and storage medium | |
| CN116303102B (en) | Test data generation method and device, electronic equipment and storage medium | |
| CN113626423B (en) | Log management method, device and system of business database | |
| CN112035486B (en) | Partition establishing method, device and equipment of partition table | |
| US11513862B2 (en) | System and method for state management of devices | |
| CN113641572B (en) | Debugging method for massive big data computing development based on SQL | |
| EP4099234A1 (en) | Uncertainty determination | |
| CN114064642A (en) | Data processing method and device, computer equipment and storage medium | |
| CN114282260A (en) | Method and device for auditing and executing Clickhouse DDLSQL semantic grammar | |
| CN116361318A (en) | Data processing method, device, electronic equipment and storage medium | |
| CN117591390A (en) | Buried point regression method, medium, device and computing equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |