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

Database migration method and system

A technology for migrating systems and databases, applied in digital data processing, special data processing applications, instruments, etc., can solve problems such as high performance consumption and application interruption, and achieve reduced performance consumption, unlimited data structures, and unlimited concurrent data The effect of seam migration

Active Publication Date: 2016-08-17
SHANGHAI CTRIP COMMERCE CO LTD
View PDF3 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The technical problem to be solved by the present invention is the defect of high performance consumption and application interruption in the process of implementing database migration in the prior art, providing a service and application for high production concurrency, and realizing seamless migration of heterogeneous database data , the database migration method and system that ensure no impact on production

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
  • Database migration method and system
  • Database migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0051] A database migration method such as figure 1 shown, including:

[0052] Step 101, publish the reading application and the writing application, pre-embed the first switch for switching the object read by the reading application and the second switch for switching the object written by the writing application, the object read by the reading application and Objects written by the writing application are defaulted as source databases, and the first switch and the second switch perform switching by receiving an instruction. Wherein, the reading application and the writing application are realized by using the prior art, and are respectively used for reading and writing the database. In this embodiment, the reading application defaults to reading the source database, and the writing application defaults to writing the source database.

[0053] The database migration method also includes:

[0054] Step 201, back up the source database offline to the offline database, and re...

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 database migration method and system. The method comprises the steps that a reading application and a writing application are released, and a first switch and a second switch are embedded; a source database is backed-up to an off-line database in an off-line mode; data of the off-line database is written into a target database; the target database is changed according to incremental data logs of the source database; whether the reading / writing application is switched to the target database is judged; if yes, recording of incremental data logs of the source database is stopped, and migration is completed; if not, the reading / writing application is recovered to be in a default stat; incremental data logs of the target database are obtained; according to the incremental data logs of the target database, the source database is changed; reasons are checked, and correction is carried out. The defects that performance consumption is large and application is intercepted when database migration is achieved in the prior art are overcome, and big data and big concurrent data seamless migration is achieved on the premise of not affecting database application and user using.

Description

technical field [0001] The invention relates to the field of computers, in particular to a database migration method and system. Background technique [0002] With the rapid development of Internet companies in recent years, all large companies have adopted the business department management method to improve company efficiency and cope with industry competition, and the decoupling of data has become a major trend. At the same time, due to the continuous expansion and growth of the company's business, the original data structure can no longer meet the ever-changing business needs, so data reconstruction is particularly important. In addition, with the promotion of NoSQL (generally referring to non-relational database) technology, seamless data migration between SQL (Structured Query Language for relational database) databases, and between SQL and NoSQL databases has also become a topic of discussion in the industry. hot topic. [0003] Traditional database migration soluti...

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): G06F17/30
CPCG06F16/214
Inventor 周源陈秋成张妮冯毅
Owner SHANGHAI CTRIP COMMERCE 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