Process language SQL statement processing method and device, medium and electronic equipment

A processing method and procedural technology, applied in the field of database

Pending Publication Date: 2021-01-01
北京人大金仓信息技术股份有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there is no related technology that pays attention to this problem

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
  • Process language SQL statement processing method and device, medium and electronic equipment
  • Process language SQL statement processing method and device, medium and electronic equipment
  • Process language SQL statement processing method and device, medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.

[0045] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.

[0046] Currently, in related technologies, there are some ways of encrypting PL / SQL statements in a database, but in most cases, the normal operation of the database will be seriously affected, and system performance will be affected.

[0047] figure 1 A procedural language SQL statement proces...

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 a process language SQL statement processing method and device, a medium and electronic equipment. The process language SQL statement processing method comprises the steps of:analyzing a first process language SQL statement, and acquiring a statement header and a statement body of the first process language SQL statement; encrypting the statement body of the first processlanguage SQL statement; and determining an encrypted first process language SQL statement based on the encrypted statement body, the statement header and an encryption keyword, wherein the encryptionkeyword is used for instructing that grammatical analysis is not performed on the statement body of the encrypted first process language SQL statement before the encrypted first process language SQL statement is compiled and executed. According to the process language SQL statement processing method and the device of the invention, the encrypted PL/SQL statement is used in a database, the use of normal functions of the database is not influenced basically, the influence on a database system is reduced, the system performance is improved, and meanwhile, the security of PL/SQL object codes is improved.

Description

technical field [0001] The embodiments of the present disclosure relate to the technical field of databases, and in particular to a procedural language (PL) SQL statement processing method, a procedural language SQL statement processing device, and a computer-readable storage medium for realizing the procedural language SQL statement processing method and electronic equipment. Background technique [0002] As an integral part of the computer system, the database plays a vital role in data storage and processing. With the increasing frequency of use and the increasing number of usage scenarios, the database has an increasing demand for data code security. Big. [0003] The current database system not only supports structured query language SQL (Structured Query Language), usually also supports procedural language PL / SQL, PL / SQL is an extension of SQL statement, adding the characteristics of programming language to the use of ordinary SQL statement , based on PL / SQL statemen...

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): G06F16/242G06F8/20G06F8/41G06F21/60
CPCG06F8/22G06F8/41G06F21/602G06F16/2433
Inventor 谢鹏飞杜春魁冯玉
Owner 北京人大金仓信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap