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

A device and method for dynamically parsing SQL annotations based on amoeba

An annotated and dynamic technology, applied in the computer field, to achieve the effect of extending SQL interface, low intrusion, and enriching SQL functions

Active Publication Date: 2017-06-13
深圳市远行科技股份有限公司
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This scenario can only be matched according to SQL conditions, and cannot be matched through other means

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 device and method for dynamically parsing SQL annotations based on amoeba
  • A device and method for dynamically parsing SQL annotations based on amoeba
  • A device and method for dynamically parsing SQL annotations based on amoeba

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to make the technical problems, technical solutions and beneficial effects to be solved by the present invention clearer and clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0034] Such as figure 1 As shown, the present invention provides a device for dynamically parsing SQL annotations based on Amoeba, including: Amoeba agent 10 and Amoeba router 20 . in:

[0035] Amoeba agent 10 is used to parse and verify SQL with ASCA syntax, convert ASCASQL into ASCA data model, locate corresponding function realization according to ASCA data model, replace corresponding result with standard SQL, and convert standard SQL Send to Amoeba SQL router 20. It includes: syntax parser 12, model converter 14, data processor 16, routing distr...

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 provides a device based on Amoeba for dynamically analyzing SQL annotation. The device comprises an Amoeba proxy and an Amoeba router. The Amoeba proxy is used for converting received ASCA SQL into standard SQL and providing a standard Amoeba router to the Amoeba router. The Amoeba router is used for transmitting the received standard SQL to a corresponding bottom database through an SQL protocol and executing the SQL. The invention further provides a method based on Amoeba for dynamically analyzing SQL annotation. By the aid of the device and method based on Amoeba for dynamically analyzing SQL annotation, defects of distributing-type SQL can be solved on the premise of no influence on original SQL, SQL function can be enriched, and SQL interfaces can be extended.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method and device ASCA (Amoeba SQL Comment API) for dynamically parsing SQL annotations based on Amoeba. Background technique [0002] Due to the sharp increase in business data in various industries in recent years, the traditional centralized database management model has been unable to meet the requirements, which has caused great problems to the stability and scalability of the system. The distributed database management mode can solve such problems (read-write separation, horizontal segmentation, etc.) very well. [0003] Undoubtedly, horizontal sharding of the database can reduce the load on a single machine and minimize the loss caused by downtime. Through the load balancing strategy, the access load of a single machine is effectively reduced, and the possibility of downtime is reduced; through the cluster solution, the problem of inaccessibility of single-point databases cause...

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): G06F17/30H04L12/701
CPCG06F16/2433G06F16/2471
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