Unlock instant, AI-driven research and patent intelligence for your innovation.

SQL execution method and device

An execution method and type of technology, applied in the field of SQL execution methods and devices, can solve the problems of immature real-time memory database products and different levels of SQL support

Active Publication Date: 2018-07-06
CHINA MOBILE GROUP ZHEJIANG +1
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since real-time in-memory database products are not very mature, and their respective products support different levels of SQL, there is no solution to solve the above problems

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
  • SQL execution method and device
  • SQL execution method and device
  • SQL execution method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are the Some, but not all, embodiments are invented. 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.

[0046] see figure 1 , this embodiment discloses an SQL execution method, including:

[0047] S1. Obtain a business SQL request submitted by a client, wherein the business SQL request includes SQL to be processed;

[0048] S2. Using the trained classifier to classify the SQL to be processed, if the SQL to be processed does not belong to the pre-classified SQL type, pre...

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 SQL execution method and device. Through the SQL execution method and device, the problems that product learning difficulty is high, development, operation and maintenance and project management difficulty is high, and cost is high due to inconsistent SQL support standards in the prior art can be solved, and unified development of different SQL-type distributed memory databases is realized. The method comprises the steps that a service SQL request submitted by a client is acquired, wherein the service SQL request contains a to-be-processed SQL; a trained classifier is utilized to classify the to-be-processed SQL, if the to-be-processed SQL does not belong to a pre-divided SQL type, the to-be-processed SQL is preprocessed, and a standard SQL is obtained; the standard SQL is submitted to a corresponding SQL-type distributed memory database for execution; and after execution in the SQL-type distributed memory database is completed, an execution result is acquired and fed back to the client, wherein the pre-divided SQL type comprises an SQL type with a minimum SQL standard jointly supported by all the SQL-type distributed memory databases.

Description

technical field [0001] The invention relates to the field of business support, in particular to an SQL execution method and device. Background technique [0002] In-memory database technology greatly improves the processing capacity of the database system by storing the database content in the memory for direct processing and calculation. At present, in-memory databases are widely used in real-time billing, real-time business analysis and big data applications in the communication industry. There are many types of products, such as: Redis, eXtremeDB, HANA, Timesten, BerkeleyDB, FastDB, GemFireXD, VoltDB, MemSQL, SQLite, GBase8m, GigaBASE, etc., but most of the business chooses SQL-type distributed memory database to handle relatively complex OLTP or OLAP business. When the user submits the database in the common SQL writing form, some in-memory databases have high execution efficiency, some have very low execution efficiency, and some scripts cannot be executed at all. The...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/24534G06F16/27G06F16/35G06F2216/03
Inventor 汤人杰张式勤郭岳于祥兵严昱超周勋
Owner CHINA MOBILE GROUP ZHEJIANG