Data change storage method and device, electronic equipment and medium

A data and database technology, applied in the computer field, can solve the problems of data source interference and large storage space, and achieve the effect of avoiding interference, reducing the amount of data, and reducing the amount of stored data.

Pending Publication Date: 2022-06-24
BEIJING GRIDSUM TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The existing traceability implementation method needs to make structural changes to the data source and add fields, which interferes with the data source itself, and regularly extracts the records of the previous period, and needs to extract the entire record for storage every time. Large technical issues

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 change storage method and device, electronic equipment and medium
  • Data change storage method and device, electronic equipment and medium
  • Data change storage method and device, electronic equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] This embodiment provides a storage method for data changes, such as figure 1 shown, including:

[0034] Step S101, obtaining the change data capture logs of N source databases that have the change data capture function enabled, where N is a positive integer, wherein the change data recorded in the change data capture log includes the change position and the change content;

[0035] Step S102, according to the change position, determine the target table in the target storage database corresponding to the change data in the distributed storage system;

[0036] Step S103, according to the change type represented by the change content, store the change data in the corresponding target column cluster in the target table.

[0037] It should be noted that the device storing the source database and the device storing the distributed storage system may be the same device or different devices, which are not limited herein.

[0038] Combine below figure 1 , to introduce the imp...

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 change storage method and device, electronic equipment and a medium, and the method comprises the steps: obtaining change data capture logs of N source databases with started change data capture functions, N being a positive integer, and change data recorded by the change data capture logs comprising change positions and change contents; according to the change position, determining a target table in a target storage database corresponding to the change data in a distributed storage system; and according to a change type represented by the change content, storing the change data to a corresponding target column cluster in the target table. The method and device, the electronic equipment and the medium are used for solving the technical problems that in the prior art, data change storage needs to change the structure of a source database, and the storage amount is large, and the technical effects that data change storage does not need to change the structure of the source database, and storage consumption is reduced are achieved.

Description

technical field [0001] The present invention relates to the field of computer technology, and in particular, to a storage method, device, electronic device and medium for data modification. Background technique [0002] With the development of computer, network and other technologies, the amount of data to be managed is increasing. In order to ensure the security and auditability of data in the database, it is necessary to manage the data changes of each data source to achieve traceability, that is, the data can be viewed information such as historical values, date of change, etc. [0003] Currently, the traceability of data changes is achieved mainly by adding data change fields in the data source. In various business logics, when a data change occurs, the modification of the data change field is triggered. Then configure a regular incremental extraction task, extract the change data records of the previous period according to the change field, and finally store the data ...

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/23G06F16/22G06F16/27
CPCG06F16/2358G06F16/2282G06F16/27
Inventor 朱学通
Owner BEIJING GRIDSUM 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