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

Event processing method and device, equipment and storage medium

An event processing and event technology, applied in the computer field, can solve problems such as changes in the data table structure and affect data synchronization, and achieve the effect of high applicability and reduced data synchronization delay

Pending Publication Date: 2022-07-01
PINGCAP XINGCHEN (BEIJING) TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, since the specific event content and execution sequence of the DDL events corresponding to the upstream sub-tables in the upstream database may be different, if the DDL events corresponding to the upstream sub-tables are synchronized to the downstream database in the order of execution time, it may cause The table structure of the data combination table in the downstream database changes and affects data synchronization

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
  • Event processing method and device, equipment and storage medium
  • Event processing method and device, equipment and storage medium
  • Event processing method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0027] The event processing method provided by the embodiment of the present application can be applied to the process of synchronizing the data update event performed by each upstream sub-table of the upstream database to the downstream database after migrating the full amount of data of the upstream database to the downstream database, so as to update the above data event is processed.

[0028] Among them, in the process of full data ...

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 an event processing method and device, equipment and a storage medium. The method comprises the following steps: acquiring a data updating event when a target upstream sub-table in an upstream database is subjected to data updating; in response to the situation that the target upstream sub-table is not in the preset state and the data updating event is not executed for the downstream database, determining a data definition language DDL event or a data manipulation language DML event included in the data updating event; in response to the data update event including the DML event, executing the data update event for the downstream database; and in response to the fact that the data updating event comprises a DDL event, determining a compatible state of a target table structure of the target upstream sub-table before data updating and table structures of other upstream sub-tables in the upstream database, and processing the data updating event based on the compatible state. By adopting the embodiment of the invention, the data updating event corresponding to the upstream sub-table in the upstream database can be flexibly processed, and the applicability is high.

Description

technical field [0001] The present application relates to the field of computer technologies, and in particular, to an event processing method, apparatus, device, and storage medium. Background technique [0002] Data migration refers to the process of migrating data stored in an upstream database to a downstream database. Data migration in a database often includes full data migration at a certain moment, and incremental data migration after this moment. Among them, in the process of full data migration, the sub-table data in the upstream database will be written into the combined table in the downstream database. [0003] After the full data migration, the corresponding Data Definition Language (DDL) and Data Manipulation Language (DML) when the upstream database is updated will be synchronized to the downstream database, such as incremental data in the upstream database. The corresponding DDL and DML are synchronized to the downstream database. [0004] However, since ...

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/21G06F16/23G06F16/27
CPCG06F16/214G06F16/2358G06F16/2365G06F16/27
Inventor 郭铭浩李淳竹刘奇黄东旭崔秋
Owner PINGCAP XINGCHEN (BEIJING) TECH CO LTD
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