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

Method and device for copying information after table structure modification

A technology after structural change and change, which is applied in the field of communication and can solve problems affecting the progress of data replication

Inactive Publication Date: 2017-01-11
NEUSOFT CORP
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

These methods need to suspend or interrupt the entire data copy process, which will affect the progress of data copy

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
  • Method and device for copying information after table structure modification
  • Method and device for copying information after table structure modification
  • Method and device for copying information after table structure modification

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] Specific embodiments of the present disclosure will be described in detail below in conjunction with the accompanying drawings. It should be understood that the specific embodiments described here are only used to illustrate and explain the present disclosure, and are not intended to limit the present disclosure.

[0020] figure 1 It is a flowchart of a method for copying information after a table structure change provided by an exemplary embodiment. The method is applied to an information replication platform between a source-end database and a target-end database. Such as figure 1 As shown, the method may include the following steps.

[0021] In step S11 , when the structure of the source table in the source database is changed, the source data definition language (Data Definition Language, DDL) statement corresponding to the structure change of the source table is extracted.

[0022] In step S12, according to the source DDL statement, the structure of the target ...

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 method and a device for copying information after table structure modification. The method comprises the following steps: extracting source-end DDL (Data Definition Language) statements corresponding to structure modification of a source table when the structure of the source table in a source-end database varies; and modifying the structure of a target table in a target-end database to be the same as the structure of the source table according to the source-end DDL statements. Thus, the table structure modification can be copied automatically without pausing or interrupting a data copying process, so that artificial participation is reduced, and project implementation and maintenance cost is lowered.

Description

technical field [0001] The present disclosure relates to the communication field, and in particular, relates to a method and device for copying information after a table structure is changed. Background technique [0002] Today, with the rapid development of the Internet and information technology, the generation of data has exploded. The original single database has long been unable to support existing applications, and technical solutions such as read-write separation and sub-database have emerged. Therefore, the original database is split into multiple databases. In order to ensure data consistency, data replication technology has been widely used, that is, data changes generated by the source database are copied to the target database within a certain period of time. [0003] During the data replication process, if the structure of the source table (Table) in the source database changes (for example, a new field is added, or a field is deleted), it will cause the source...

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
IPC IPC(8): G06F17/30
CPCG06F16/27
Inventor 井玉成牟晓光
Owner NEUSOFT CORP
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