Unlock instant, AI-driven research and patent intelligence for your innovation.

Zipper table synchronization method and device, electronic equipment and storage medium

An electronic device and zipper technology, applied in the field of data synchronization, can solve the problems of low storage space utilization and long time consumption

Pending Publication Date: 2022-03-25
AGRICULTURAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the first method takes a long time when the amount of data is large, and the second method needs to extract and store a copy of the valid data of the day every day, which will lead to the problem of low utilization of storage space

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
  • Zipper table synchronization method and device, electronic equipment and storage medium
  • Zipper table synchronization method and device, electronic equipment and storage medium
  • Zipper table synchronization method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] figure 1 It is a schematic flow chart of a method for synchronizing zipper tables provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation where the target zipper tables in other storage spaces are synchronized according to the source zipper table. This method can be synchronized by the zipper table The apparatus may be implemented by means of software and / or hardware, and the hardware may be an electronic device. Optionally, the electronic device may be a mobile terminal, a PC, or a server.

[0028] like figure 1 As described, the method of this embodiment specifically includes the following steps:

[0029] S110. When the zipper table synchronization instruction is received, determine the temporary table of change data according to the current date and the start date and end date corresponding to each source data in the source zipper table.

[0030] Wherein, the zipper table synchronization instruction may be an instruction fo...

Embodiment 2

[0041] figure 2 It is a schematic flow chart of a method for synchronizing zipper tables provided by Embodiment 2 of the present invention. On the basis of the above-mentioned embodiments, this embodiment aims at determining the temporary table of changing data, the determining method of data to be deleted, and the target zipper table. The update synchronization method can refer to the technical solution of this embodiment. Wherein, explanations of terms that are the same as or corresponding to the above embodiments are not repeated here.

[0042] like figure 2 As described, the method of this embodiment specifically includes the following steps:

[0043] S210. When receiving the zipper watch synchronization instruction, analyze the zipper watch synchronization instruction, and determine the current date, source zipper watch, and target zipper watch corresponding to the zipper watch synchronization instruction.

[0044] Specifically, when a zipper watch synchronization co...

Embodiment 3

[0073] As an optional implementation of the above-mentioned embodiments, image 3 It is a schematic flowchart of a method for synchronizing zipper watches provided by Embodiment 3 of the present invention. Wherein, explanations of terms that are the same as or corresponding to the above embodiments are not repeated here.

[0074] like image 3 As described, the method of this embodiment specifically includes the following steps:

[0075] 1. Extract the daily change data of the source zipper table (temporary table of change data).

[0076] Specifically, according to the zipper table rule, the change data of the current day is data whose start time (start date) is equal to the current day (current date) or end time (end date) is equal to the previous day (the previous date of the current date).

[0077] 2. Delete the change-affected data (data to be deleted) in the target table (target zipper table) to create difference increments.

[0078] Specifically, according to the rul...

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 embodiment of the invention discloses a zipper table synchronization method and device, electronic equipment and a storage medium, and the method comprises the steps: determining a change data temporary table according to a current date and a starting date and an ending date corresponding to each piece of source data in a source zipper table when a zipper table synchronization instruction is received; determining to-be-deleted data in the target zipper table according to the primary key value and the start date corresponding to each temporary data in the change data temporary table and the primary key value, the start date and the end date corresponding to each target data in the target zipper table; deleting the to-be-deleted data in the target zipper table, and adding each temporary data in the change data temporary table into the target zipper table, so as to synchronize each source data in the source zipper table into the target zipper table. Through the technical scheme of the embodiment of the invention, the technical effects of improving the zipper table synchronization efficiency and improving the storage space utilization rate are achieved.

Description

technical field [0001] Embodiments of the present invention relate to data synchronization technology, and in particular to a method, device, electronic device and storage medium for synchronizing a zip watch. Background technique [0002] The zipper table is a data model in the data warehouse, which is used to store information about all changes of an object from the beginning to the current state, and is a way to process changing data. When the business data changes, the zipper table will change accordingly, which not only retains the change information of the historical data, but also does not waste storage space. [0003] It is often necessary to synchronize the zipper table to other data warehouses or data marts. However, due to the zipper table rule, the source table is not a differential increment relative to the target table, and cannot be directly synchronized through the differential increment. There are generally two methods for synchronizing existing zipper tab...

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/22G06F16/27G06F16/28
CPCG06F16/2282G06F16/27G06F16/283
Inventor 杨红强王宏亮梁思维戴路
Owner AGRICULTURAL BANK OF CHINA