WO2019242113A1

WO2019242113A1 - Service data table filing correction method, device, computer equipment and storage medium

Info

Publication number: WO2019242113A1
Application number: PCT/CN2018/104751
Authority: WO
Inventors: 刘四根
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-06-22
Filing date: 2018-09-10
Publication date: 2019-12-26
Also published as: CN108804708A; CN108804708B

Abstract

A service data table filing correction method, comprising: filing a service data table to a service data filing table; reading table structure information corresponding to the service data table and the service data filling table from within the service data table and the service data filing table respectively; comparing the table structure information corresponding to the service data table and the service data filing table to obtain a comparison result; determining filing problems which occur in the service data filing table according to the comparison result; acquiring a filing problem list generated according to the determined filing problems; and according to the filing problem list, automatically correcting the service data filing table.

Description

Business data table archiving correction method, device, computer equipment and storage medium

This application claims the priority of a Chinese patent application filed on June 22, 2018 with the Chinese Patent Office under the application number of 2018106514401, and the application name is "Business Data Sheet Archive Correction Method, Device, Computer Equipment and Storage Medium" Incorporated by reference in this application.

Technical field

The present application relates to a method, an apparatus, a computer device, and a storage medium for archiving and correcting a business data table.

Background technique

With the development of Internet technology, databases are widely used. Storing data in the database can ensure the security of the data, and it is also very convenient to organize the data.

In order to more conveniently organize the business data stored in the database, the business data can be stored in the business data table and the business data archive table, the business data that needs to be frequently modified is stored in the business data table, and the data that needs to be stored for a long time Archive from the business data table to the business data archive table, so that you can achieve efficient management of the database and business data in the database.

However, the inventors realized that the current data archiving method requires configuration of the table structure information of the business data archiving table. When the structure information of the business data archive table is configured, if it is not configured according to the specifications, it is easy to fail archiving. This requires manual reconfiguration of the table structure information of the business data archive table, which causes the business data table to take more time to archive. Make business data table archiving inefficient.

Summary of the Invention

According to various embodiments disclosed in the present application, a method, an apparatus, a computer device, and a storage medium for filing and modifying a business data table are provided.

A business data table archiving correction method includes:

Archive business data tables to business data archive tables;

Read the corresponding table structure information in the business data table and the business data archive table;

Compare the table structure information corresponding to the business data table with the business data archive table to get the comparison result;

According to the comparison result, an archiving problem in the business data archiving table is determined;

Obtain a list of archive issues generated from identified archive issues; and

The business data archive table is automatically corrected based on the archive problem list.

A business data table archive correction device includes:

Business data table archiving module, for archiving business data tables to business data archive tables;

A table structure information reading module, configured to read the corresponding table structure information in the business data table and the business data archive table;

The table structure information comparison module is used to compare the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result;

An archiving problem determination module, configured to determine an archiving problem in the business data archiving table according to the comparison result;

Archive question list acquisition module for obtaining a list of archive questions generated from the identified archive questions; and

The business data archive table correction module is used to automatically correct the business data archive table according to the archive problem list.

A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the one or more processors, the one or more Processors implement the steps of the business data table archiving correction method provided in any one of the embodiments of the present application.

One or more non-transitory computer-readable storage media storing computer-readable instructions that, when executed by one or more processors, cause the one or more processors to implement any of the present application The steps of the business data table archiving correction method provided in one embodiment.

Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features and advantages of the application will become apparent from the description, the drawings, and the claims.

BRIEF DESCRIPTION OF THE DRAWINGS

In order to explain the technical solutions in the embodiments of the present application more clearly, the drawings used in the embodiments are briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present application. Those of ordinary skill in the art can also obtain other drawings according to these drawings without paying creative labor.

FIG. 1 is an application scenario diagram of a business data table archiving correction method according to one or more embodiments.

FIG. 2 is a schematic flowchart of a business data table archiving correction method according to one or more embodiments.

FIG. 3 is a schematic flowchart of a business data table archiving correction method in another embodiment.

FIG. 4 is a block diagram of a service data table archiving correction apparatus according to one or more embodiments.

FIG. 5 is a block diagram of a computer device according to one or more embodiments.

detailed description

In order to make the technical solution and advantages of the present application more clear and clear, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the application, and are not used to limit the application.

The business data table filing correction method provided in this application can be applied to the application environment shown in FIG. 1. The database 110 communicates with the server 120 through a network through a network or a cable. The server 120 archives the business data table 112 in the database 110 to the business data archive table 114, reads the respective table structure information of the business data table 112 and the business data archive table 114, and compares the business data table 112 and the business data archive table 114 respectively. Table structure information to get comparison results. The server 120 determines an archiving problem in the business data archiving table 114 according to the comparison result, obtains an archiving problem list generated according to the determined archiving problem, and then automatically corrects the business data archiving table 114 in the database 110 according to the archiving problem list. The database 110 and the server 120 may be implemented by independent servers or a server cluster composed of multiple servers.

In one embodiment, as shown in FIG. 2, a method for archiving and correcting a business data table is provided. The method is applied to the server in FIG. 1 as an example, and includes the following steps:

S202: Archive the business data table to a business data archive table.

A business data table is a table for storing business data. A table (TABLE) is an object used to store data in a database, and is a collection of structured data. The business data archive table is a table for storing archived business data. Archiving is the process of storing organized data. Archiving can be a process of transferring the processed business data with preservation value to the business data archive table after the system is organized.

In one embodiment, the server reads the new business data from the business data table, and imports the new business data into the business data archive table.

In one embodiment, the server compares the business data table with the business data archive table, and imports business data in the business data table that is different from the business data archive table into the business data archive table.

S204. Read the corresponding table structure information in the service data table and the service data archive table.

The table structure information is the structure information of the data table. The table structure information may specifically include at least one of a data table file name, a field included in the data table, a field name of each field, a field attribute of each field, a field type of each field, and a width of each field.

Field names can be less than 64 characters in length. Field names can include letters, Chinese characters, numbers, spaces, and other characters. Field names cannot include periods ".", Exclamation points "!", Square brackets "[]", and accents ", ", Field names cannot begin with a leading space. The field type may be at least one of text type, note type, number type, date and time type, currency type, automatic numbering type, yes / no type, OLE object type, hyperlink type, and lookup guide type. The field attribute may be at least one of a field size, a format, a default value, a required field, a validity rule, a validity text, and an index.

In one embodiment, the server reads the field name, field attribute, field type, and field length of each record in the business data table, and reads the fields of the record corresponding to the record of the business data table in the business data archive table Name, field attribute, field type, and field length.

S206: Compare the respective table structure information of the business data table and the business data archive table to obtain a comparison result.

The comparison result is the comparison result of the table structure information. Comparing the respective table structure information of the business data table and the business data archive table, specifically, the maximum field length of each record of the business data table and the business data archive table can be compared. A record is the smallest unit of data stored in a data table. A record can be a row of a data table.

S208. Determine an archiving problem that occurs in the business data archiving table according to the comparison result.

The archiving problem is a problem that the business data table is archived to the business data archive table incorrectly. Specifically, the server determines an archive problem that occurs in the business data archive table according to the type of the comparison result.

In one embodiment, the server identifies the comparison result according to the archiving problem judgment rule, and determines an archiving problem that occurs in the business data archiving table.

S210. Acquire a list of archive questions generated according to the determined archive question.

The archive question list is a consolidated list of archive questions. Specifically, the server arranges the determined archiving questions into the archiving question list in the order in which the archiving questions are determined.

In one of the embodiments, the server obtains the archive problem list from the database, enters the determined archive problem into the archive problem list, marks the archive problem entered in the archive problem list as an archive problem to be corrected, and marks the archive problem that is corrected Archive issues for history.

In one embodiment, the server sends the determined archiving questions to the verification e-mail address. After receiving the determination results fed back from the verification e-mail address, the archiving questions are filtered based on the determination results, and the archiving question list is generated based on the archiving questions obtained after the screening .

S212: Automatically correct the business data archive table according to the archive problem list.

In one embodiment, the server sends the archived problem list to the correction terminal, and upon receiving the correction instruction feedback from the correction terminal, corrects the table structure information of the business data archive table, and re-archives the business data of the business data table to the business Data archive table.

In the above business data table archiving correction method, after the business data table in the database is archived to the business data archive table, the comparison results are obtained by reading and comparing the respective table structure information of the business data table and the business data archive table. The comparison result obtained by comparing the table structure information can determine the problems in the table structure of the business data archive table, and thus determine the archive problems in the business data archive table. The identified archiving problems are then organized into an archiving problem list, and the business data archiving table can be automatically corrected according to the archiving problem list. The speed of automatically correcting the business data archiving table is much faster than manually configuring the table structure information of the business data archiving table. This can avoid wasting time by manually configuring the table structure information of the business data archiving table, thereby improving the efficiency of amending the business data archiving table, and thereby improving the archiving efficiency of the business data table.

In one embodiment, comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result includes: respectively converting the business data table and the business data archive table into their corresponding unified formats. Data table; from the uniformly formatted data table corresponding to the business data table and the business data archive table, select records with inconsistent content to obtain a difference table; the comparison result includes the difference table.

The uniformly formatted data table may specifically be a data table with the same table structure. The difference table is a data table used to store records with different table structure information.

In one embodiment, the server multiplies the maximum string length of each record in the business data table by a preset value to obtain a business data table with a modified table structure, and then compares the business data table with a modified structure and a business data archive table. Select the corresponding records in the business data table and business data archive table that modify the structure and have different table structure information to generate a difference table.

In this embodiment, by converting the business data table and the business data archive table into data tables of a uniform format, it is possible to more quickly find the differences in the respective table structures of the business data table and the business data archive table, from the business data table and the business data. Inconsistent records are selected from the corresponding uniformly formatted data tables of the archive tables. The selected records record corresponding table structure information. The obtained difference table stores the comparison results between the business data table and the business data archive table.

In one of the embodiments, the archiving problem includes incorrect table structure information; each record in the discrepancy table has a one-to-one corresponding record in the discrepancy table; and the archiving that occurs in the business data archiving table is determined according to the comparison result Questions include: identifying the maximum string length of each record in the difference table; obtaining the respective maximum string lengths of two one-to-one corresponding records; when the maximum string length of a record selected from the business data archive table is different from When the ratio of the maximum string length of the records selected by the business data table is not a preset value, it is determined that the record with the ratio not being two has a table structure information error.

The table structure information error may specifically be that the maximum string lengths of the records corresponding to the business data table and the business data archive table do not match. The maximum string length is the maximum length of a string that a record can store. The preset value is a preset condition for archiving the business data table to the business data archive table. The preset ratio may be specifically 1.5 or 2. It can also be 2.5. The one-to-one corresponding record is specifically a record in the business data table for storing the business data to be archived and a record in the business data archive table for archiving the business data.

In this embodiment, by identifying the maximum string length of each record in the difference table, and the ratio of the maximum string length of the record selected in the business data archive table to the maximum string length of the record selected from the business data table is not When the value is preset, the records whose ratio is not the preset value have table structure information errors, which can quickly determine the archiving problem, so that the archiving problem can be corrected faster, and the business data table archiving efficiency can be improved.

In one embodiment, after obtaining the archived question list generated according to the determined archive question, the method further includes: obtaining an email address of a database maintenance person; and sending the archived question list to an electronic designated by the email address mailbox.

Database maintainers are staff who can operate the database manually. E-mail address is the network address required for receiving and sending e-mail.

In this embodiment, after the archived problem list is obtained, the archived problem list is emailed to the email address of the database maintenance staff, so that errors can be automatically corrected or manually corrected. To ensure that the data sheet archive is error-free.

In one embodiment, after obtaining the archived question list generated according to the determined archived question, the method further includes: counting the archived questions in the archived question list; analyzing the archived questions appearing within a preset time period; An archive issue that occurs more than a preset threshold is marked as a high frequency issue; the high frequency issue is topped in the archive issue table.

The preset time period is specifically a time period for statistical archiving issues. The preset time period can be specifically set to one week. The preset threshold is a trigger condition for archiving issues to be marked as high frequency issues. High frequency issues are specifically archiving issues that need to be addressed first in the archiving issue list. Pin high-frequency issues on the archived question list. Specifically, you can arrange high-frequency questions in the archived question list according to the number of occurrences, or you can place high-frequency questions in the archived question list according to the time when they are marked as high-frequency issues. In order.

In one of the embodiments, the server counts the occurrence time and the number of occurrences of historical archiving problems in the archiving problem list, and adjusts the position of the archiving problem to be corrected corresponding to the historical archiving problem in the archiving problem list according to the statistics of the occurrence time and the occurrence number. .

In this embodiment, by archiving problems in the archiving problem list, marking archiving problems that occur more than a preset threshold as high-frequency problems, and placing high-frequency problems on the archiving problem list, the archiving problem list can be prioritized. Topped high-frequency problem corrections, so as to prioritize prone archiving problems, speed up the archiving of archiving business data tables, and improve the efficiency of archiving business data tables.

In one embodiment, the method further includes: constructing an archive problem model according to the archive problem list; and before archiving the business data table to the business data archive table, detecting the business data table and the business data through the archive problem model Archive table; correct detected table structure information errors; archive the table after correcting the table structure information of the business data table and the business data archive table.

An archiving problem model is a data model that predicts archiving problems in business data archiving tables. The business data table and the business data archive table are detected through the archive problem model. Specifically, the table structure information of the business data table and the business data archive table can be imported into the archive problem model. Correcting the detected table structure error may specifically reconfigure the table structure information of the business data archive table according to the table structure information of the business data table.

In one embodiment, the server obtains the corresponding location information and problem type of the record where the archive problem occurs in the archive problem list, enters the obtained location information and problem type into the archiving problem model to be trained, and continuously inputs the location information and problem type to After a preset duration of the training archived problem model, an archived problem model is obtained. The preset duration can be fifteen days.

In one embodiment, when the business data table is archived and the business data table fails to be archived, the server quickly determines the archiving problem according to the archiving problem model, and corrects the business data archiving table according to the determined archiving problem, and the business in the business data table The data is re-archived to the business data archive table.

In this embodiment, by constructing an archiving problem model according to the archiving problem list, before the business data table is archived to the business data archiving table, errors in the table structure information of the business data archiving table can be detected. After archiving, you can avoid errors when archiving business data tables, which leads to an increase in the time it takes to archive, thereby improving the efficiency of archiving business data tables.

In one of the embodiments, the automatic correction of the business data archive table according to the archive problem list includes: identifying the maximum string length recorded in the business data table; and comparing the business data table with the business data table in the business data archive table The maximum string length of the corresponding record is adjusted to twice the maximum string length of the record in the business data table; the business data recorded in the business data table is re-archived to the adjusted corresponding record in the business data archive table in.

The business data recorded in the business data table is re-archived into the adjusted corresponding records in the business data archiving table. Specifically, the business data in the record where the archiving problem occurs is re-archived.

In one embodiment, the server identifies the maximum string length of the corresponding record in the business data table according to the archive question list, and adjusts the maximum string length of the record corresponding to the business data table in the business data archive table to the A preset multiple of the maximum string length recorded in the business data table, and then re-archive the business data of the records corresponding to the archiving question list in the business data table to the adjusted corresponding records in the business data archive table.

In this embodiment, by adjusting the maximum string length of the record corresponding to the business data table in the business data archive table to twice the maximum string length of the record in the business data table, the business data table can be successfully The business data is archived to the business data archive table, so that the problem of archiving of the business data table can be corrected.

As shown in FIG. 3, in one of the embodiments, a business data table archiving correction method is also provided, which specifically includes the following steps:

S302. Archive the business data table to a business data archive table.

S304. Read the respective table structure information of the service data table and the service data archive table.

S306. Convert the business data table and the business data archive table into a data table in a unified format.

S308. Select inconsistent records from the corresponding unified format data tables of the business data table and the business data archive table to obtain a difference table.

The comparison result includes the difference table; each record in the difference table has a one-to-one corresponding record.

S310. Identify the maximum string length of each record in the difference table.

S312. Obtain the maximum string length of each of the two one-to-one records.

When the ratio of the maximum string length of the record selected from the business data archive table to the maximum string length of the record selected from the business data table is not two, step S314 is performed.

S314. It is determined that the record whose ratio is not two has a table structure information error.

S316. Identify the maximum string length of a record in which the table structure information error occurs in the service data table.

S318. Adjust the maximum string length of the record corresponding to the business data table in the business data archive table to twice the maximum string length of the record in the business data table.

S320: Re-archive the business data recorded in the business data table into the adjusted corresponding records in the business data archiving table.

In the above business data table archiving correction method, after the business data table in the database is archived to the business data archive table, the comparison results are obtained by reading and comparing the respective table structure information of the business data table and the business data archive table. The comparison result obtained by comparing the table structure information can determine the problems in the table structure of the business data archive table, and thus determine the archive problems in the business data archive table. The identified archiving problems are organized into an archiving problem list, and the business data archiving table can be automatically corrected according to the archiving problem list. The speed of automatically correcting the business data archiving table is much faster than the speed of manually configuring the table structure information of the business data archiving table. This can avoid wasting time by manually configuring the table structure information of the business data archiving table, thereby improving the efficiency of amending the business data archiving table, and thereby improving the archiving efficiency of the business data table.

It should be understood that although the steps in the flowchart of FIG. 3 are sequentially displayed in accordance with the directions of the arrows, these steps are not necessarily performed in the order indicated by the arrows. Unless explicitly stated in this document, the execution of these steps is not strictly limited, and these steps can be performed in other orders. Moreover, at least a part of the steps in FIG. 3 may include multiple sub-steps or stages. These sub-steps or stages are not necessarily performed at the same time, but may be performed at different times. The execution of these sub-steps or stages The order is not necessarily performed sequentially, but may be performed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.

In one embodiment, as shown in FIG. 4, a business data table archive correction device 400 is provided, which includes: a business data table archive module 402, a table structure information reading module 404, a table structure information comparison module 406, and an archive. A problem determination module 408, an archive problem list acquisition module 410, and a business data archive table correction module 412, of which: a business data table archive module 402 is used to archive a business data table to a business data archive table; a table structure information reading module 404, Used to read the corresponding table structure information in the business data table and the business data archive table; the table structure information comparison module 406 is used to compare the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result ; Archiving problem determination module 408, which is used to determine the archiving problems that occur in the business data archiving table according to the comparison result; archiving problem list acquisition module 410, which is used to obtain the archiving problem list generated according to the determined archiving problems; business data archiving table correction Module 412 is configured to automatically correct the business data archive table according to the archive problem list.

The business data table archiving correction device 400, after archiving the business data table in the database to the business data archive table, reads and compares the respective table structure information of the business data table and the business data archive table to obtain a comparison result. The comparison result obtained by comparing the table structure information can determine the problems in the table structure of the business data archive table, and thus determine the archive problems in the business data archive table. The identified archiving problems are organized into an archiving problem list, and the business data archiving table can be automatically corrected according to the archiving problem list. The speed of automatically correcting the business data archiving table is much faster than the speed of manually configuring the table structure information of the business data archiving table. This can avoid wasting time by manually configuring the table structure information of the business data archiving table, thereby improving the efficiency of amending the business data archiving table, and thereby improving the archiving efficiency of the business data table.

In one embodiment, the apparatus further includes: a data table conversion module for converting the business data table and the business data archive table into data tables of corresponding uniform formats; a difference table generation module for From the business data table and the business data archive table corresponding to the uniformly formatted data table, records with inconsistent content are selected to obtain a difference table; the comparison result includes the difference table.

In one embodiment, the archiving problem includes incorrect table structure information; each record in the difference table has a one-to-one corresponding record in the difference table; the device further includes: a string length identification module, configured to: Identify the maximum string length of each record in the difference table; a string length acquisition module is used to obtain the maximum string lengths of two one-to-one corresponding records; an error judgment module is used to retrieve the data from the business data archive table When the ratio between the maximum string length of the selected record and the maximum string length of the record selected from the business data table is not a preset value, it is determined that the record with the ratio other than the preset value has a table structure information error.

In one of the embodiments, after obtaining the archive question list generated according to the determined archive question, the method further includes:

Obtain the email address of the database maintainer;

Send the list of archived questions to the email address specified by this email address.

In one embodiment, the device further includes: an archive problem statistics module for counting archive problems in the archive problem list; an archive problem analysis module for analyzing archive problems occurring within a preset time period; high The high-frequency problem flagging module is used to mark an archiving problem that occurs more than a preset threshold as a high-frequency problem; the high-frequency problem pinning module is used to pin the high-frequency problem in the archiving problem table.

In one embodiment, the apparatus further includes: a model building module configured to build an archive problem model according to the archive problem list; a data table detection module configured to archive the business data table to the business data archive table, The business data table and business data archive table are detected through the archiving problem model; the business data archive table correction module 412 is used to correct errors in the detected table structure information; the business data table archive module 402 is also used to After correcting the table structure information of the business data table and the business data archiving table, the data is archived.

In one embodiment, the string length identification module is further configured to identify a maximum string length recorded in the service data table; the device further includes: a string length adjustment module configured to archive the business data in the table The maximum string length of the record corresponding to the business data table is adjusted to twice the maximum string length of the record in the business data table; the business data table archiving module 402 is also used for the business data table The recorded business data is re-archived to the corresponding adjusted records in the business data archiving table.

Regarding the specific limitation of the service data table archiving and correction device, please refer to the limitation on the business data table archiving and correction method described above, which is not repeated here. Each module in the above-mentioned business data table archive correction device may be implemented in whole or in part by software, hardware, and a combination thereof. The above-mentioned modules may be embedded in the hardware in or independent of the processor in the computer device, or may be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. 5. The computer device includes a processor, a memory, a network interface, and a database connected through a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer-readable instructions, and a database. The internal memory provides an environment for the operation of the operating system and computer-readable instructions in a non-volatile storage medium. The database of the computer equipment is used to store at least one of a business data table, a business data archive table, and the like. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer-readable instructions are executed by the processor, a business data table archiving correction method is implemented.

Those skilled in the art can understand that the structure shown in FIG. 5 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. The specific computer equipment may be Include more or fewer parts than shown in the figure, or combine certain parts, or have a different arrangement of parts.

In one embodiment, a computer device is provided, which includes a memory and a processor. The memory stores computer-readable instructions. When the processor executes the computer-readable instructions, the following steps are implemented: archiving a business data table to business data Archive table; read the corresponding table structure information in the business data table and the business data archive table; compare the table structure information corresponding to the business data table and the business data archive table to get the comparison result; determine the business based on the comparison result Archive problems that occur in the data archive table; obtain an archive problem list generated based on the identified archive problems; automatically correct the business data archive table according to the archive problem list.

A computer device includes a memory and one or more processors. Computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by one or more processors, the one or more processors implement any one of the present application. The steps of the business data table archiving correction method provided in the embodiment.

One or more non-transitory computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors implement one of the embodiments of the present application. Provide the steps of the business data sheet archive correction method.

A person of ordinary skill in the art can understand that all or part of the processes in the methods of the foregoing embodiments can be implemented by using computer-readable instructions to instruct related hardware. The computer-readable instructions can be stored in a non-volatile computer. In the readable storage medium, the computer-readable instructions, when executed, may include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined. In order to make the description concise, all possible combinations of the technical features in the above embodiments have not been described. However, as long as there is no contradiction in the combination of these technical features, it should be It is considered to be the range described in this specification.

The above-mentioned embodiments only express several implementation manners of the present application, and the description thereof is more specific and detailed, but cannot be understood as a limitation on the scope of the invention patent. It should be noted that, for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of this application patent shall be subject to the appended claims.

Claims

A business data table archiving correction method includes:

Archive business data tables to business data archive tables;

Reading the corresponding table structure information in the business data table and the business data archive table;

Comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result;

Determining an archiving problem that occurs in the business data archiving table according to the comparison result;

Obtain a list of archive issues generated from identified archive issues; and

The business data archive table is automatically corrected according to the archive problem list.
The method according to claim 1, wherein comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result comprises:

Respectively converting the business data table and the business data archive table into respective corresponding unified format data tables; and

Selecting records with inconsistent content from the business data table and the business data archive table corresponding to a uniform format data to obtain a difference table; the comparison result includes the difference table.
The method according to claim 2, wherein the archiving problem includes incorrect table structure information; each record in the difference table has a one-to-one corresponding record in the difference table; and according to the The comparison results determine archiving problems in the business data archiving table, including:

Identify the maximum string length of each record in the difference table;

Obtain the respective maximum string lengths of two one-to-one corresponding records; and

When the ratio of the maximum string length of a record selected from the business data archive table to the maximum string length of a record selected from the business data table is not a preset value, then

Records that determine that the ratio is not a preset value have table structure information errors.
The method according to claim 1, wherein after obtaining the archive question list generated according to the determined archive question, the method further comprises:

Obtain the email address of the database maintainer; and

Send the archive question list to the email address specified by the email address.
The method according to claim 1, wherein after obtaining the archive question list generated according to the determined archive question, the method further comprises:

Counting archive issues in the archive issue list;

Analyze archiving issues that occur within a preset time period;

Mark archiving issues that occur more than a preset threshold as high frequency issues; and

Pin the high frequency question in the archive question table.
The method according to claim 5, further comprising:

Construct an archive problem model according to the archive problem list;

Before archiving the business data table to the business data archive table, detecting the business data table and the business data archive table through the archiving problem model;

Fix errors in detected table structure information; and

After correcting the table structure information of the business data table and the business data archive table, the file is archived.
The method according to claim 1 to 6, wherein the automatically modifying the business data archive table according to the archive problem list comprises:

Identifying the maximum string length recorded in the business data table;

Adjusting the maximum string length of a record corresponding to the business data table in the business data archive table to twice the maximum string length of a record in the business data table; and

The business data recorded in the business data table is re-archived into the adjusted corresponding records in the business data archiving table.
A business data table archive correction device includes:

Business data table archiving module, for archiving business data tables to business data archive tables;

A table structure information reading module, configured to read the corresponding table structure information in the business data table and the business data archive table;

The table structure information comparison module is configured to compare table structure information corresponding to the business data table and the business data archive table to obtain a comparison result;

An archiving problem determination module, configured to determine an archiving problem occurring in the business data archiving table according to the comparison result;

Archive question list acquisition module for obtaining a list of archive questions generated from the identified archive questions; and

The business data archive table correction module is configured to automatically correct the business data archive table according to the archive problem list.
A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the one or more processors, the one or more Each processor performs the following steps:

Archive business data tables to business data archive tables;

Reading the corresponding table structure information in the business data table and the business data archive table;

Comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result;

Determining an archiving problem that occurs in the business data archiving table according to the comparison result;

Obtain a list of archive issues generated from identified archive issues; and

The business data archive table is automatically corrected according to the archive problem list.
The computer device according to claim 9, wherein comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result comprises:

Respectively converting the business data table and the business data archive table into respective corresponding unified format data tables; and

Selecting records with inconsistent content from the business data table and the business data archive table corresponding to a uniform format data to obtain a difference table; the comparison result includes the difference table.
The computer device according to claim 10, wherein the archiving problem includes a table structure information error; each record in the difference table has a one-to-one corresponding record in the difference table; The comparison results determine the archiving problems in the business data archiving table, including:

Identify the maximum string length of each record in the difference table;

Obtain the respective maximum string lengths of two one-to-one corresponding records; and

When the ratio of the maximum string length of a record selected from the business data archive table to the maximum string length of a record selected from the business data table is not a preset value, then

Records that determine that the ratio is not a preset value have table structure information errors.
The computer device according to claim 9, wherein when the computer-readable instructions are executed by the processor, the processor causes the processor to execute the obtaining of an archive question list generated according to the determined archive question, The following steps are also performed:

Obtain the email address of the database maintainer; and

Send the archive question list to the email address specified by the email address.
The computer device according to claim 9, wherein when the computer-readable instructions are executed by the processor, the processor causes the processor to execute the obtaining of an archive question list generated according to the determined archive question, The following steps are also performed:

Counting archive issues in the archive issue list;

Analyze archiving issues that occur within a preset time period;

Mark archiving issues that occur more than a preset threshold as high frequency issues; and

Pin the high frequency question in the archive question table.
The computer device of claim 13, wherein the processor further executes the following steps when executing the computer-readable instructions:

Construct an archive problem model according to the archive problem list;

Before archiving the business data table to the business data archive table, detecting the business data table and the business data archive table through the archiving problem model;

Fix errors in detected table structure information; and

After correcting the table structure information of the business data table and the business data archive table, the file is archived.
The computer device according to claim 9 to 14, wherein the automatically modifying the business data archive table according to the archive problem list comprises:

Identifying the maximum string length recorded in the business data table;

Adjusting the maximum string length of a record corresponding to the business data table in the business data archive table to twice the maximum string length of a record in the business data table; and

The business data recorded in the business data table is re-archived into the adjusted corresponding records in the business data archiving table.
One or more non-volatile computer-readable storage media storing computer-readable instructions, which when executed by one or more processors, cause the one or more processors to perform the following steps:

Archive business data tables to business data archive tables;

Reading the corresponding table structure information in the business data table and the business data archive table;

Comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result;

Determining an archiving problem that occurs in the business data archiving table according to the comparison result;

Obtain a list of archive issues generated from identified archive issues; and

The business data archive table is automatically corrected according to the archive problem list.
The storage medium according to claim 16, wherein comparing the table structure information corresponding to the business data table and the business data archive table to obtain a comparison result comprises:

Respectively converting the business data table and the business data archive table into respective corresponding unified format data tables; and

Selecting records with inconsistent content from the business data table and the business data archive table corresponding to a uniform format data to obtain a difference table; the comparison result includes the difference table.
The storage medium according to claim 17, wherein the archiving problem includes incorrect table structure information; each record in the difference table has a one-to-one corresponding record in the difference table; and The comparison results determine the archiving problems in the business data archiving table, including:

Identify the maximum string length of each record in the difference table;

Obtain the respective maximum string lengths of two one-to-one corresponding records; and

When the ratio of the maximum string length of a record selected from the business data archive table to the maximum string length of a record selected from the business data table is not a preset value, then

Records that determine that the ratio is not a preset value have table structure information errors.
The storage medium according to claim 16, wherein when the computer-readable instructions are executed by the processor, the processor causes the processor to execute the obtaining of an archive question list generated according to the determined archive question, The following steps are also performed:

Obtain the email address of the database maintainer; and

Send the archive question list to the email address specified by the email address.
The storage medium according to claim 16, wherein when the computer-readable instructions are executed by the processor, the processor causes the processor to execute the obtaining of an archive question list generated according to the determined archive question, The following steps are also performed:

Counting archive issues in the archive issue list;

Analyze archiving issues that occur within a preset time period;

Mark archiving issues that occur more than a preset threshold as high frequency issues; and

Pin the high frequency question in the archive question table.