Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
MIGRATION METHOD BASED ON POSTGRESQL BLOCK STORAGE DEVICE
Document Type and Number:
WIPO Patent Application WO/2017/101505
Kind Code:
A1
Abstract:
A migration method based on a PostgreSQL block storage device, using a PostgreSQL block storage device read-write module to perform read and write operations to PostgreSQL blocks, the PostgreSQL block storage device read-write module managing, by means of an idle PostgreSQL block table and a table of mapping relationship between the PostgreSQL blocks and data tables, the PostgreSQL blocks in the PostgreSQL block storage device, copying the idle PostgreSQL block table and the table of mapping relationships between the PostgreSQL blocks and the data tables from an original database to a new database, and migrating the PostgreSQL block storage device from the computer in which the original database is located to the computer in which the new database is located. Migrating database between different systems by means of the migration method based on the PostgreSQL block storage device is easy, without a high requirement for the professional knowledge to operators. The query speed and the read-write speed can be improved, the speeds being improved by 10%-20% under the same condition of backend storage.

Inventors:
ZHU XIAOWEI (CN)
Application Number:
PCT/CN2016/096971
Publication Date:
June 22, 2017
Filing Date:
August 26, 2016
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
CHINA COMMUNICATION SOFTWARE TECH CO LTD (CN)
CHINA COMMUNICATION TECH CO LTD (CN)
International Classes:
G06F17/30; G06F3/06
Domestic Patent References:
WO2010005447A12010-01-14
Foreign References:
CN105824879A2016-08-03
CN105573678A2016-05-11
CN105630879A2016-06-01
CN102768672A2012-11-07
CN101009645A2007-08-01
CN102243629A2011-11-16
Attorney, Agent or Firm:
BEIJING LAWSING IP FIRM (CN)
Download PDF: