A data archiving method for centralized management of sub-tables through metadata database
A data archiving and database technology, applied in the field of data processing, can solve problems such as difficulty in batching and inability to achieve automatic verification, and achieve the effect of reducing management costs
Active Publication Date: 2022-04-15
SICHUAN XW BANK CO LTD
View PDF13 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The invention provides a data archiving method through the centralized management of metadata and sub-tables, which intends to realize the centralized management of metadata, and solve the problem that the existing archiving method mentioned in the prior art cannot realize automatic verification, and batches are concurrent difficult question
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0023] The following clearly and completely describes the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.
[0024] The best embodiment of the present invention is as follows, a data archiving method for centralized management of sub-tables through metadata, including the following steps:
[0025] Step 1: Insert metadata in the metadata database;
[0026] Step 2: Add a scheduled task to the operating system to obtain the calling frequency;
[0027] Step 3: Import and export the metadata, and perform verification and archiving. After the verification and archiving is completed, send an email, and the archiving task is completed.
[0028] ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention belongs to the technical field of data processing, and in particular relates to a data archiving method through the centralized management and sub-table of the metadata database, and intends to solve the problems mentioned in the prior art that the existing archiving method cannot realize automatic verification, and batches are concurrently launched. problem; the following steps are taken to solve the above problem: Step 1: Insert metadata into the metadata database; Step 2: Add a scheduled task to the operating system to obtain the calling frequency; Step 3: Import and export metadata, and perform verification and archiving, After the verification and archiving is completed, the email is sent, and the archiving task is completed. It realizes batching to achieve batching and simultaneous concurrent functions of different tasks, and realizes automatic verification without manual operation.
Description
technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a data archiving method for centrally managing sub-tables through a metadata database. Background technique [0002] Database archiving technology is a common management technology for database management. It is used to archive historical data and store it in a specific archive library or medium to optimize the space and performance of the production database. Database table splitting is also a common technique for database management, generally referring to partition tables or horizontal split tables, such as splitting into different partition tables according to dimensions such as year, month, and day, or splitting a large table horizontally It is divided into tables with the same name under different libraries, and the backend uses middleware or custom routing to perform unified query. [0003] At present, the archiving technology of the MySQL database is ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/27G06F16/23
CPCG06F16/2282G06F16/27G06F16/23
Inventor 苟李平冯钊朱小容谢明阳
Owner SICHUAN XW BANK CO LTD