A method and system for replicating database tables

A replication method and database technology, applied in the database field, can solve the problems of low replication efficiency of database tables and many CPU resources, etc.

Inactive Publication Date: 2019-03-19
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF10 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This application provides a method and system for duplicating database tables to solve the problem of low duplication efficiency of database tables and the use of more CPU resources in the prior art

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
  • A method and system for replicating database tables
  • A method and system for replicating database tables
  • A method and system for replicating database tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] In order to enable those skilled in the art to better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described The embodiments are only some of the embodiments of the present application, but not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0053] In order to better understand the present application, the implementation manner of the present application will be explained in detail below in conjunction with the accompanying drawings.

[0054] see figure 1 , figure 1 It is a schematic flowchart of a method for duplicating a database table provided in the embodiment of the pr...

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 present application discloses a method and system for replicating database tables, the method firstly obtains all the table data blocks matched with the source table, then copies all the table data blocks and stores them in the storage area of the target table, and finally updates the blocks and table directories of all the table data blocks according to the storage address and the target table name of the target table, thereby completing the replication of the database table. The system includes table data block acquisition module, replication module and update module. The invention realizes table data replication by means of data block replication, avoids the traditional migration process of first reading table records in the data block and then inserting the table records into the data block, can greatly improve the replication efficiency of the database table, and is advantageous in saving CPU resources because there is no table record reading and inserting operation.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database table replication method and system. Background technique [0002] In the process of using the database, it is often encountered that the data of one table is completely copied to another table, that is, the copy of the database table. [0003] The current database table replication method usually adopts the method of table query record re-insertion. Specifically, the database provides a method similar to the create table XX as select*from YY statement for creating tables and copying data. After executing this statement, first use select to query the table records from the initial table, read the table records, and then Insert table records one by one into the new table until the entire table is copied. [0004] Yet, in the duplication method of database table at present, owing to need to inquire out each table record in the initial table and insert in 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/22G06F16/23G06F11/14G06F9/50
CPCG06F9/5027G06F11/1453
Inventor 马国良
Owner ZHENGZHOU YUNHAI INFORMATION 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