Check patentability & draft patents in minutes with Patsnap Eureka AI!

Grammar parser generation method, SQL (Structured Query Language) access control method, device and equipment

A grammar parser and access control technology, applied in the field of distributed databases, can solve the problems of lack of unified specification of statements, database performance degradation, distributed database performance degradation, etc., and achieve the effect of avoiding database performance degradation.

Pending Publication Date: 2022-06-28
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, at present, when a large number of application systems access distributed databases, the SQL (Structured Query Language) statements used lack uniform specifications; such non-standard SQL statements are likely to cause performance degradation of distributed databases
Therefore, how to reduce or avoid the degradation of database performance caused by non-standard SQL statements accessing distributed databases has become a technical problem to be solved urgently.

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
  • Grammar parser generation method, SQL (Structured Query Language) access control method, device and equipment
  • Grammar parser generation method, SQL (Structured Query Language) access control method, device and equipment
  • Grammar parser generation method, SQL (Structured Query Language) access control method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0075] In order to make those skilled in the art better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below with reference to the accompanying drawings in the embodiments of this specification. Obviously, the described The embodiments are only some of the embodiments of the present specification, but not all of the embodiments. Based on the embodiments in this specification, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of this specification.

[0076] refer to figure 1 As shown, the SQL access control system of the embodiment of this specification may include a client 10 , a server 20 and a database 30 . The client 10 may initiate a database operation request including an SQL statement to the server 20, and the server 20 may, before executing the SQL statement (that is, befo...

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 relates to the technical field of distributed databases, and provides a grammar parser generation method and device and an SQL access control method and device. The method comprises the steps that before an application program executes an SQL statement, the SQL statement is intercepted based on a filter chain integrated in the application program; calling a filter in the filter chain to execute corresponding filtering processing on the SQL statement; wherein one filter is a syntactic analyzer configured with a user-defined access control rule; and when the SQL statement does not pass the auditing of the syntactic analyzer, forbidding the application program to execute the SQL statement. According to the embodiment of the invention, the performance reduction of the database caused by the access to the distributed database by the nonstandard SQL statement can be reduced or avoided.

Description

technical field [0001] The present specification relates to the technical field of distributed databases, and in particular, to a method for generating a grammar parser, a method, an apparatus, and a device for controlling SQL access. Background technique [0002] With the development of distributed database technology, many application systems can access distributed databases. However, the SQL (Structured Query Language) statements used by a large number of application systems currently lack uniform specifications when accessing distributed databases; such non-standard SQL statements are likely to cause performance degradation of the distributed database. Therefore, how to reduce or avoid the degradation of database performance caused by accessing a distributed database with irregular SQL statements has become an urgent technical problem to be solved. SUMMARY OF THE INVENTION [0003] The purpose of the embodiments of this specification is to provide a grammar parser gen...

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): G06F8/41G06F16/242G06F16/27
CPCG06F8/427G06F16/2433G06F16/27
Inventor 刘小强
Owner CHINA CONSTRUCTION BANK
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