Database storage process migration method and system

A stored procedure and database technology, applied in the database field, can solve the problems of not being able to migrate to the Sql database, consuming a lot of time and manpower, and not being able to roll back, so as to improve the efficiency of migration.
CN110688378APending Publication Date: 2020-01-14CHINA PING AN PROPERTY INSURANCE CO LTD
0 Cites 6 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
CHINA PING AN PROPERTY INSURANCE CO LTD
Publication Date
2020-01-14

Smart Images

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

Abstract

The embodiment of the invention provides a database storage process migration method. The migration method comprises the steps of obtaining a first storage process of a first database, a first syntaxstructure of the first database and a second syntax structure of a second database; converting the first storage process into a second storage process of a second database according to the first syntax structure and the second syntax structure; packaging the second storage process into a second database; obtaining first data stored in a first database, and synchronizing the first data to a seconddatabase to obtain second data; and according to the second storage process, performing data processing on the second data, and checking a processing result of the second data. According to the embodiment of the invention, the storage process of the traditional database can be converted into the storage process of the Hive database according to the storage process syntax structure of the Hive database; and then, the conversion accuracy of the storage process is checked according to the processing result of the data in the Hive database, so that the migration efficiency of the database storageprocess is greatly improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a database storage process migration method, system, computer equipment, and computer-readable storage medium. Background technique

[0002] With the widespread application of big data, more and more Internet companies are beginning to migrate the traditional data warehouse structure to the big data platform. Hive is a data warehouse tool based on Hadoop, which can map structured data files into a database table, and Hive also uses Structured Query Language (Sql), which can provide simple Sql query functions, and can also Convert Sql statements into MapReduce tasks to run, and most existing databases perform data operations based on MapReduce tasks. Therefore, for managers of traditional data warehouses, they can quickly implement simple MapReduce statistics in Hive data warehouses through Sql-like statements, without using special MapReduce, and...

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