Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data table filing method and related device

A data table and data technology, applied in the database field, can solve problems such as low efficiency and trouble, and achieve the effect of improving efficiency and high efficiency

Pending Publication Date: 2022-08-09
中银金融科技有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this way, for the newly added original table to be archived, it is necessary to write a corresponding archiving program to realize the archiving of the newly added original table to be archived, which is cumbersome and inefficient

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 table filing method and related device
  • Data table filing method and related device
  • Data table filing method and related device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present invention are shown in the drawings, it should be understood that the present invention may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided so that the present invention will be more thoroughly understood, and will fully convey the scope of the present invention to those skilled in the art.

[0054] like figure 1 As shown, the present invention provides a data table filing method, including: S100, S200, S300, S400 and S500;

[0055] S100, obtain the information of the original table to be archived from the configuration table, and obtain the original table and the archived table;

[0056] Optionally, the original table mentioned in the present invention is a table that needs to be archived, that is, some data in the o...

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 discloses a data table archiving method and a related device, and the method comprises the steps: obtaining the information of a to-be-archived original table from a configuration table, and obtaining the original table and an archiving table; according to the information of the original table, an intermediate table of archived data in the original table is created, and the intermediate table synchronizes a table name annotation, a column name annotation and a column default value of the original table; performing primary key deletion processing, failure index processing, failure constraint processing and partition addition processing on the archiving table; storing the archiving data to a newly added partition of the archiving table; and performing primary key reconstruction processing, index reconstruction processing and effective constraint processing on the archiving table in a parallel mode. According to the method, corresponding data archiving can be achieved by modifying the configuration table without rewriting and writing a program, the efficiency is high, a parallel mode can be adopted in the data archiving process, and the efficiency of the method is further improved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data table filing method and a related device. Background technique [0002] In an online transaction system using a relational database, the amount of data generated by transaction data gradually increases over time, and the transaction data needs to be archived regularly. Archive the table and delete the data to be archived in the original table. In this way, for the newly added original table to be archived, a corresponding archiving program needs to be written to realize the archiving of the newly added original table to be archived, which is troublesome and inefficient. SUMMARY OF THE INVENTION [0003] In view of the above problems, the present invention provides a data table filing method and related apparatuses that overcome the above problems or at least partially solve the above problems. [0004] In a first aspect, a data table filing method includes: [0005] Obtain th...

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): G06F16/28G06F16/21G06F16/22
CPCG06F16/284G06F16/21G06F16/22
Inventor 阳华吴正唐棣方孔双曹振民
Owner 中银金融科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com