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

A data source migration method and system

A technology for migrating systems and data sources, applied in the database field, can solve the problems of laborious procedural processing, increase the time and cost of data source migration, and cannot be reused, and achieve the effect of reducing time and cost.

Inactive Publication Date: 2019-03-01
CHENGDU SEFON SOFTWARE CO LTD
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] SQL itself is a structured query language with some controls (assignment, loop and exception handling, etc.), but it is not object-oriented, and it is still procedural in nature. In the face of complex business logic, procedural processing will very strenuous
In addition, the stored procedure depends on a specific database. In the big data and open source environment, it cannot be transplanted to other open source storage. Once the storage is changed, the original stored procedure code is completely rewritten and cannot be reused. Brings a lot of work, which increases the time and cost of data source migration

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
  • A data source migration method and system
  • A data source migration method and system
  • A data source migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. The components of the embodiments of the invention generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts belong to the protection scope of the present invention.

[0042] It should be noted that like numerals and let...

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

Embodiments of the present invention provide a data source migration method and system. The method comprises the following steps: obtaining a stored procedure of a data source to be migrated, whereinthe stored procedure comprises one or more SQL statements; parsing the SQL statement to generate a java syntax corresponding to each SQL statement, wherein the java syntax is a syntax recognizable bya target database; storing the data source to be migrated to the target database according to the java syntax. The system is configured to perform the method described above. The embodiment of the invention obtains a storage procedure of a data source to be migrated. The SQL statements in the stored procedure are parsed to generate the corresponding Java syntax, and then the migrated data source is stored according to the Java syntax. Even after the underlying data storage changes, the stored procedure service code can still smoothly transition to the target database, reducing the time and cost of secondary development.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a data source migration method and system. Background technique [0002] With the advent of the big data era, traditional relational databases can no longer meet the needs of many companies, so more and more companies need to migrate data stored in traditional relational databases to big data platforms. Among them, a stored procedure (Stored Procedure) is a set of SQL statement sets in a large database system in order to complete a specific function, stored in the database. Name and give parameters (if the stored procedure has parameters) to execute it. A stored procedure is an important object in the database. [0003] SQL itself is a structured query language with some controls (assignment, loop and exception handling, etc.), but it is not object-oriented, and it is still procedural in nature. In the face of complex business logic, procedural processing will Very s...

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/21G06F16/2453G06F16/242
Inventor 廖伟王纯斌易祖建张奇
Owner CHENGDU SEFON SOFTWARE 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