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

Method and device for determining criticality of sql statement

A hazard degree and statement technology, applied in the field of determining the hazard degree of SQL statements, can solve problems such as damage to database data security, difficulty in covering SQL statements, heavy burden on users, etc., and achieve the effect of protecting security.

Inactive Publication Date: 2018-02-06
INT BUSINESS MASCH CORP
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the large variety of SQL statements, users need to set as many security rules as possible to define various unsafe SQL statements, which brings a heavy burden to users
In addition, it is difficult for the security rules set by the user to cover all unsafe SQL statements. Once an unsafe SQL statement is not covered by the security rules, the SQL statement will not be identified, thus compromising the data security of the database.

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
  • Method and device for determining criticality of sql statement
  • Method and device for determining criticality of sql statement
  • Method and device for determining criticality of sql statement

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] Some preferred embodiments of the present disclosure are shown in the drawings and will be described in more detail below with reference to the drawings. However, the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0013] Those skilled in the art know that various aspects of the present invention can be implemented as a system, method or computer program product. Therefore, various aspects of the present invention can be embodied in the following forms, that is: a complete hardware implementation, a complete software implementation (including firmware, resident software, microcode, etc.), or a combination of hardware and software implementations, These may collectively be referred to herein as "circuits," "modules," or "systems....

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 a method and equipment for determining the criticality of SQL statements. The method includes: extracting a plurality of elements in the SQL statement; calculating the score of the SQL statement based on the association relationship between each element in the plurality of elements and the basic score of each element; and calculating the score of the SQL statement based on the SQL statement The score determines the criticality of the SQL statement. In this way, the manager of the database only needs to define a small number of rules according to his own needs, and at the same time, the method and device according to the above aspects of the present invention can automatically analyze the received simple or complex SQL statements based on the small number of rules defined by the user to determine Its degree of harm, without missing the harmful SQL statement, thereby protecting the security of the data in the database.

Description

technical field [0001] The present invention relates to Structured Query Language (SQL), and more particularly to a method and device for determining the criticality of SQL statements. Background technique [0002] SQL is a data query language for databases. Users can use a series of SQL statements to access the database in order to operate on the data in the database, such as query, update or delete. On the other hand, for the database manager, it is very important to ensure the data security of the database, so it is necessary to determine the criticality of the SQL statement executed on the data in the database, that is, to determine whether the SQL statement may damage the data in the database Safety. Specifically, for databases containing confidential information, especially commercial databases, users may intentionally or unintentionally use SQL statements with direct or potential harm to access the database, so that the data in the database will be leaked to unautho...

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/30
CPCG06F16/284
Inventor 孙盛艳冯浩李硕杨新颖
Owner INT BUSINESS MASCH CORP