Database management method and device, electronic equipment and storage medium

A database and grammar technology, applied in the field of database management, can solve the problems of inefficient and error-prone manual auditing of SQL statements, and achieve the effect of automatic auditing

Pending Publication Date: 2021-11-30
JINGDONG TECH HLDG CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The invention provides a method, device, electronic equipment and storage medium for database management, whic

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
  • Database management method and device, electronic equipment and storage medium
  • Database management method and device, electronic equipment and storage medium
  • Database management method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0049] In order to make the objectives, technical solutions and advantages of the present invention clearer, the technical solutions in the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention. , not all examples. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0050] The technical terms involved in the present invention are described below.

[0051] SQL (Structured Query Language, Structured Query Language) is a standard computer language for accessing and processing databases, and is used to access and operate database systems. SQL statements are used to retrieve and update data in the database. SQL works with database programs such as MS Access, DB2, Informix, MS SQL...

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 provides a database management method and device, electronic equipment and a storage medium, and belongs to the technical field of database management. The method comprises the steps of, after input SQL statements are analyzed, generating a syntax tree, and obtaining an SQL statement conforming to grammars; performing standard auditing on the SQL statements conforming to the grammars according to a preset auditing rule to obtain SQL statements conforming to standards; and carrying out load detection on a preset database instance, and executing the SQL statements meeting the standards after the detection is passed. The method is used for solving the problems that manual SQL data auditing is not high in efficiency and prone to errors in the prior art, automatic auditing of SQL data is achieved, and the risk of database management is reduced.

Description

technical field [0001] The invention relates to the technical field of database management, in particular to a database management method, device, electronic equipment and storage medium. Background technique [0002] As the functions of Internet products continue to be enriched and improved, the table structure of the back-end database may also need to be changed accordingly to meet new requirements. At present, when Internet companies need to make changes to online databases, one is for developers to directly log in to the database to complete SQL (Structured Query Language, Structured Query Language) changes; the other is for developers to propose SQL changes, and then professional The DBA (Database Administrator, database administrator) manually reviews the SQL specification and assesses the risk, and finally the DBA logs in to the database to execute the SQL to complete the change. [0003] Based on the above two situations, it can be seen that the entire management me...

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): G06F16/242G06F8/41
CPCG06F16/2433G06F8/42G06F8/427
Inventor 程鹏兴张小鹏曲喆孙文晖高新刚
Owner JINGDONG TECH HLDG CO LTD
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