Data historical archiving method and apparatus

A data and history technology, applied in the computer field, can solve the problems of unguaranteed data security, low archiving efficiency, and incorrect data migration.

Active Publication Date: 2018-11-02
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF10 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: manual migration of database data, resulting in no guarantee of data security; each business sub-table requires associated query, and then another table Then do historical archiving for each table, resulting in low archiving efficiency; the historical database is generally not the same as the production database, because different data sources are connected, so data integrity cannot be guaranteed, for example, some business sub-tables may The data has been migrated to the historical database, but there are still related tables whose data has not been migrated correctly

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data historical archiving method and apparatus
  • Data historical archiving method and apparatus
  • Data historical archiving method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0036] In order to solve the following shortcomings in the prior art, that is, data security cannot be fully guaranteed due to manual migration of the database; since each business sub-table needs to be associated with the query, and then do historical archiving one by one, resulting in Archiving is inefficient; moreover, data integrity cannot be fully guaranteed. An embo...

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

No PUM Login to view more

Abstract

The invention provides a data historical archiving method and apparatus. The method comprises the following steps of providing condition parameters of data needed to be historically archived by a configuration file; querying service main table data conforming to the condition parameters and putting the service main table data into a task queue based on a scheduling task; traversing and processingthe service main table data in the task queue; and processing a failure table, wherein the failure table and the service main table data are subjected to associated query, and the corresponding service main table data in the failure table is put into the task queue based on the scheduling task and is subjected to traversal processing.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for archiving data history. Background technique [0002] With the development of business, the amount of database data will become larger and larger, and the business table of general design will design a business master table and multiple business sub-tables associated with it. Historical archiving is required. [0003] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: manual migration of database data, resulting in no guarantee of data security; each business sub-table requires associated query, and then another table Then do historical archiving for each table, resulting in low archiving efficiency; the historical database is generally not the same as the production database, because different data sources are connected, so data integrity cannot be guaranteed, for examp...

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 郭玉杰
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap