A big data system and method for converting traditional database scripts to the cloud in batches

A database and big data technology, applied in the field of big data systems, can solve problems such as repetition and inefficiency, and achieve the effect of simple and convenient operation, and accurate semantic capture and recognition.

Active Publication Date: 2021-12-24
WHALE CLOUD TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] It turns out that traditional relational databases calculate and process data through scripts such as stored procedures to realize related ETL (data warehouse technology) functions. After the data is uploaded to the cloud, the related calculation and processing logic ETL functions need to be migrated to the cloud. After a long period of accumulated business logic results, if the migration to the cloud is done manually, there will be a large amount of manual conversion workload caused by differences in heterogeneous database syntax, functions, and keywords. At the same time, these tasks may be repetitive and inefficient. Work

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 big data system and method for converting traditional database scripts to the cloud in batches
  • A big data system and method for converting traditional database scripts to the cloud in batches
  • A big data system and method for converting traditional database scripts to the cloud in batches

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] In order to further illustrate the various embodiments, the present invention provides accompanying drawings, which are part of the disclosure of the present invention, and are mainly used to illustrate the embodiments, and can be used in conjunction with the relevant descriptions in the specification to explain the operating principles of the embodiments, for reference Those of ordinary skill in the art should be able to understand other possible implementations and advantages of the present invention. The components in the figures are not drawn to scale, and similar component symbols are generally used to represent similar components.

[0048] According to the embodiment of the present invention, a big data system and method for converting traditional database scripts to the cloud in batches is provided, which solves the problem of huge migration workload caused by scripts going to the cloud in batches in the current data cloud process. This method refines the relevant...

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 discloses a big data system and method for converting traditional database scripts to the cloud in batches. The system includes: a syntax parser module, a conversion mapping module between heterogeneous databases, and a script conversion module. Beneficial effects: the present invention quickly and accurately identifies and extracts the business SQL that needs to be transformed, and converts and recognizes the syntax on the cloud according to the needs, and performs syntax reconstruction and transformation on the SQL, with a success rate of over 96.7%, and an accuracy rate of semantic extraction, recognition, and syntax transformation of up to More than 85.4%.

Description

technical field [0001] The present invention relates to the field of big data products, in particular to a big data system and method for converting traditional database scripts to the cloud in batches. Background technique [0002] The rapid development of information technology is driving changes in all aspects of IT technology. In recent years, the IT field is stepping into the era of cloud computing. The introduction of cloud computing has triggered new computing revolutions, spawned new IT service models, and fundamentally changed working methods and business models. Tracing back to the source, cloud computing is not unrelated to parallel computing, distributed computing and grid computing, but also virtualization, utility computing, SaaS (Software-as-a-Service, software as a service), SOA (service-oriented architecture , is a component model) and other technology hybrid evolution results. Through the organic interaction with related technologies, business models, an...

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/242G06F16/25G06F16/28
CPCG06F16/2433G06F16/258G06F16/284
Inventor 罗剑锋王强陈学明黄志翔赵涛吴名朝
Owner WHALE CLOUD TECH 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