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

Method and device for realizing multi-modal database analysis engine

A technology of analysis engine and implementation method, which is applied in the field of realization of multi-modal database analysis engine, and can solve problems such as restricting application migration, orafce is not a compatible solution, etc.

Pending Publication Date: 2020-05-12
湖南亚信软件有限公司
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the present invention provides a method and device for implementing a multimodal database analysis engine to solve the problem that oracle is not a complete compatible solution, which greatly limits the migration of applications from Oracle to PostgreSQL

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
  • Method and device for realizing multi-modal database analysis engine
  • Method and device for realizing multi-modal database analysis engine
  • Method and device for realizing multi-modal database analysis engine

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] 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. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0049] The above description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention will not be limited to the embodiments shown herein...

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 an implementation method of a multi-modal database analysis engine, which comprises the following steps: establishing a first grammar file and a second grammar file by adoptingan Oracle grammar for an SQL (Structured Query Language) statement, the first grammar file comprising a keyword and a token; converting keywords and tokens of the first grammar file in a grammar analysis process of the SQL statement to obtain a target SQL statement; performing grammar analysis on the target SQL statement according to the second grammar file to obtain a structural body; performingsemantic analysis on the structural body to obtain a query tree, and determining a target implementation mode according to the query tree; and executing the SQL statement according to the target implementation mode. According to the implementation method, a grammar compatibility and dynamic loading mechanism is realized by establishing the first grammar file and the second grammar file, so that expansion of the SQL parsing engine is realized, and compatibility and adaptation of various databases are realized.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for realizing a multimodal database analysis engine. Background technique [0002] orafce is an extension of PostgreSQL. It mainly provides compatibility with some Oracle syntax, functions, and dictionary tables for PostgreSQL. For example, it only supports several data types such as date, varchar2 and nvarchar2, and the supported data types and functions are very limited. [0003] The implementation of orafce is based on functions and views. Therefore, if complete syntax compatibility is to be achieved, the approach of orafce cannot be realized. Because postgres' syntax analysis is before calling views and functions. The hook must be cut in before the syntax analysis to use the implementation of the extension for syntax compatibility. Therefore, orafce is not a complete compatible solution, which greatly limits the migration of applications from Oracl...

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/242G06F16/33
CPCG06F16/214G06F16/2433G06F16/3335Y02D10/00
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