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.

Pending Publication Date: 2020-01-14
CHINA PING AN PROPERTY INSURANCE CO LTD
View PDF0 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the Sql-like language used by Hive is a query language (Hibernate Query Language, Hql), and there are many differences between the Sql syntax of traditional data warehouses such as Oracle and the Sql syntax of Hive. In traditional databases, Update, The Delete statement is convenient for data update and data deletion, but Hive does not support Sql language Update, delete and other statements to directly perform data update, data deletion and other operations
In addition, Hive cannot roll back after data update and data deletion
Therefore, the stored procedures of traditional data wa

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] see figure 1 , shows a flow chart of the steps of the database storage process migration method according to Embodiment 1 of the present invention. It can be understood that the flowchart in this method embodiment is not used to limit the sequence of execution steps. The following is an exemplary description taking computer equipment as the execution subject, as follows:

[0048] Step S100, acquiring a first stored procedure of a first database, a first grammatical structure of the first database, and a second grammatical structure of a second database.

[0049] Specifically, the database login information input by the user is first obtained, the database login information at least includes the physical address of the first database, a user name, and a password, and the user name and password are used to log in to the first database. Therefore, it is possible to connect and log in to the first database according to the database login information, obtain the name of th...

Embodiment 2

[0071] see figure 2 , shows a schematic diagram of the program modules of the database storage process migration system according to the second embodiment of the present invention. In this embodiment, the migration system 20 based on computer-based database stored procedures may include or be divided into one or more program modules, one or more program modules are stored in storage media, and processed by one or more implemented by the server to complete the present invention, and can realize the migration method of the above-mentioned database stored procedure. The program module referred to in the embodiment of the present invention refers to a series of computer program instruction segments capable of completing specific functions, which is more suitable than the program itself to describe the execution process of the migration system 20 of the database storage process in the storage medium. The following description will specifically introduce the functions of each prog...

Embodiment 3

[0095] refer to image 3 , is a schematic diagram of the hardware architecture of the computer device according to Embodiment 3 of the present invention. In this embodiment, the computer device 2 is a device capable of automatically performing numerical calculation and / or information processing according to preset or stored instructions. The computer device 2 may be a rack server, a blade server, a tower server or a cabinet server (including an independent server, or a server cluster composed of multiple servers) and the like. Such as image 3 As shown, the computer device 2 at least includes, but is not limited to, a memory 21, a processor 22, a network interface 23, and a migration system 20 that can communicate with each other through a system bus. in:

[0096]In this embodiment, the memory 21 includes at least one type of computer-readable storage medium, and the readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD...

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 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.

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

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/22G06F16/21
CPCG06F16/22G06F16/214
Inventor 卢显锋
Owner CHINA PING AN PROPERTY INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap