Supercharge Your Innovation With Domain-Expert AI Agents!

Procedural SQL (structured query language) sentence executing method and equipment for distributed system

A distributed system and execution process technology, applied in the computer field, to achieve the effect of enhancing SQL language expression ability and reducing cost

Active Publication Date: 2017-03-08
TRANSWARP INFORMATION TECH SHANGHAI
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of this application is to provide a method and device for executing procedural SQL statements for distributed systems, so as to solve the problem of the completeness of SQL language support in existing big data platforms

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
  • Procedural SQL (structured query language) sentence executing method and equipment for distributed system
  • Procedural SQL (structured query language) sentence executing method and equipment for distributed system
  • Procedural SQL (structured query language) sentence executing method and equipment for distributed system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] The application will be described in further detail below in conjunction with the accompanying drawings.

[0060] figure 1 It shows a flow chart of a method for executing a procedural SQL statement for a distributed system according to one aspect of the present application, combined with figure 1 , the method includes: step S11 and step S12.

[0061] Wherein, in the step S11, lexical analysis and syntax analysis are performed on the procedural SQL statement to establish an intermediate representation of the procedural SQL statement; in the step S12, semantic analysis is performed on the intermediate representation to obtain into several execution blocks, and execute the execution blocks block by block.

[0062]Here, the source of the procedural SQL statement may include an input from a user device or a request sent by an intermediate device through a JDBC (Java Data Base Connectivity, JAVA database connection) / ODBC (OpenDatabase Connectivity, ODBC) standard interface....

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 purpose of the invention is achieved by providing a procedural SQL (structured query language) sentence executing method and procedural SQL sentence executing equipment for a distributed system. The procedural SQL sentence executing method comprises the following steps: performing lexical analysis and grammatical analysis on a procedural SQL sentence to establish intermediate representation of the procedural SQL sentence; performing semantic analysis on the intermediate representation to convert the intermediate representation into a plurality of execution blocks; executing the execution blocks one by one. Through the procedural SQL sentence executing method and the procedural SQL sentence executing equipment, the SQL language expression ability on a large data platform is enhanced, so that a user can complete a complex business logic in a database level; through grammatical compatibility with the conventional procedural SQL language, the cost for migrating the conventional application to the large data platform is greatly reduced.

Description

technical field [0001] The present application relates to the computer field, in particular to a technique for executing procedural SQL statements used in distributed systems. Background technique [0002] Traditional relational databases provide database users with SQL (Structured Query Language, Structured Query Language) language as an interface for database operations. Almost all database applications are built on the SQL language interface, and the degree of support for the SQL language is The most important indicator of the robustness of a database system. [0003] With the rapid development of enterprise business, the processing requirements of big data has become an inevitable problem in all industries. However, the existing big data platforms have very limited support for the SQL language, and at the same time lack many optimizations for the SQL language, let alone support for the procedural SQL language. This limitation has greatly increased the cost of migrating...

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): G06F17/30
CPCG06F16/24528G06F16/24553
Inventor 孙若曦
Owner TRANSWARP INFORMATION TECH SHANGHAI
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com