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

Online migration method based on sql database

A database and data technology, applied in the field of data transmission, can solve problems such as abnormal use and lack of operation instructions in the database, and achieve the effects of improving stability and security, improving stability and improving timeliness.

Active Publication Date: 2021-11-30
深圳市中科鼎创科技股份有限公司
View PDF15 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Therefore, the present invention provides an online migration method based on SQL database, which can solve the problem that the database cannot be used normally due to lack of operation instructions

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
  • Online migration method based on sql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] In order to make the objects and advantages of the present invention clearer, the present invention will be further described below in conjunction with the examples; it should be understood that the specific examples described here are only for explaining the present invention, and are not intended to limit the present invention.

[0056] Preferred embodiments of the present invention are described below with reference to the accompanying drawings. Those skilled in the art should understand that these embodiments are only used to explain the technical principle of the present invention, and are not intended to limit the protection scope of the present invention.

[0057] see figure 1 As shown, the SQL database-based online migration method provided by the embodiment of the present invention includes:

[0058] Step S100: Determine the database to be operated, and construct the structure of the second SQL database in the database to be operated, and the operation instruc...

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 relates to an online migration method based on a SQL database. The method includes determining a database to be operated, constructing a second SQL database structure in the database to be operated, and operating instructions in the second SQL data to operate the database to be operated; Obtain the type of operation instruction in the first SQL database; create the operation model of the database to be operated, and determine the operation cycle of the operation of the database to be operated and the operation with the largest number of executions in the cycle according to the operation model; when migrating the SQL database, execute according to the cycle The number of operations is arranged in descending order to obtain an operation priority list, and the operation instructions in the first SQL database are migrated to the second SQL database according to the order in the operation priority list. During data migration, data migration is performed according to the operation priority, so that during the migration period, the operation of the database to be operated can be performed without interruption, and the stability and security of the online migration database can be improved.

Description

technical field [0001] The invention relates to the technical field of data transmission, in particular to an online migration method based on an SQL database. Background technique [0002] A database is a warehouse that organizes, stores and manages data according to the data structure. SQL database, as a kind of operation command set specially established for database, is a fully functional database language. When migrating the database, it is also necessary to migrate the SQL database as needed, so as to realize the query and modification of the database according to the operation command set in the SQL database. [0003] However, when migrating the SQL database, due to the huge and complicated data volume, it takes a long time, and because the time-consuming is too long, the operation of the database will also be delayed, which will affect the normal operation of the database, resulting in inconvenient. Contents of the invention [0004] Therefore, the present inven...

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 Patents(China)
IPC IPC(8): G06F16/21
CPCG06F16/214
Inventor 金树柏罗玲
Owner 深圳市中科鼎创科技股份有限公司
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