Method and device for migrating database data

A database and device technology, applied in the computer field, can solve problems such as stuck, service suspension, etc., to reduce the phenomenon of suspension or stuck, and improve access performance.
CN106970920AInactive Publication Date: 2017-07-21ALIBABA GRP HLDG LTD
5 Cites 16 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
ALIBABA GRP HLDG LTD
Publication Date
2017-07-21
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention aims at providing a method and device for migrating database data. Specifically, the method comprises the steps of obtaining a database statement performed by a user in a corresponding source database instance according to a database migration request submitted by a user; determining a to-be-performed target data object by analyzing the database statement; and caching the target data object to a target source database instance by performing search operation about the target data object in the corresponding source database instance. Compared with the prior art, the method and the device have the advantages that the database statement performed by the user in the corresponding source database instance is obtained according to the database migration request and the target data object is cached to the target source database instance by performing the search operation of the target data object in the corresponding source database instance, wherein the target data object is determined after the database statement is analyzed, so pause or delay phenomena in migration and switching processes when the database is used by the user are reduced, and the access performance of the user for the database in the database migration process is improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present application relates to the computer field, and in particular to a technology for database data migration. Background technique

[0002] With the development of the network, the use of databases has gradually expanded, and the demand for database migration has also expanded. For example, when database applications are used in cloud computing environments, database instance users will trigger database cross-physical machines when they purchase more resources. Migration requirements, in the process of data cross-machine migration, because the target machine cannot read the cache in the original memory to speed up data reading and writing, user access may freeze or freeze. In order to avoid that all access data has to be reloaded from the hard disk to the upper-level cache, so that when the memory is large and the disk reading speed is constant, it will take too much time and the user will be blocked. The existing technology first stops the cur...

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