A multi-dimensional comprehensive database sql audit and optimization method and system

A database, multi-dimensional technology, applied in the field of SQL database, can solve problems such as online environment impact and difficulty in auditing SQL database statements, and achieve the effect of preventing impact, improving SQL development experience, and reducing daily work pressure

Active Publication Date: 2021-08-10
绿城科技产业服务集团有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The purpose of the present invention is to provide a multi-dimensional comprehensive database SQL audit and optimization method and system to solve the problem in the prior art that SQL database statement audit is difficult and has a great impact on the online environment

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
  • A multi-dimensional comprehensive database sql audit and optimization method and system
  • A multi-dimensional comprehensive database sql audit and optimization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, but not all of the embodiments. 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.

[0056] see figure 1 , the present invention provides a technical solution: a multi-dimensional comprehensive database SQL auditing system, including a WEB front end, a service background and a database,

[0057] The WEB front end includes a work order submission module, a work order review module, an optimization record module, a specification configuration module and a quality visualization module,

[0058] Submit a work order modul...

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 present invention relates to the technical field of SQL databases, in particular to a multi-dimensional comprehensive database SQL audit and optimization method and system, including a WEB front end, a service background and a database. The WEB front end includes a work order submission module, a work order audit module, Optimizing record module, standard configuration module and quality visualization module, the service background includes API service module, data acquisition module, SQL management module, audit engine module, optimization engine module and task scheduling module, and the described database includes audit intermediate library module, test database module and online database module, the present invention can greatly accelerate the speed of SQL audit, database structure optimization, and SQL optimization, reduce the daily work pressure of database DBA, and effectively prevent the hidden danger of SQL performance from affecting the online environment .

Description

technical field [0001] The invention relates to the technical field of SQL databases, in particular to a multi-dimensional comprehensive database SQL audit and optimization method and system. Background technique [0002] The SQL statement auditing of the database is actually the standardized management of SQL, which is an important part of the software development process. At present, there are some automatic and manual auditing methods and systems, such as "A SQL Auditing Method and System" with patent number CN108415991A, but the following problems and deficiencies still exist: [0003] The automatic audit only checks the grammar and normative aspects, and cannot fully control the quality of SQL; [0004] The workload of manual review is relatively large, and it is difficult to control the implementation of regulations and supervision constraints, which often depends on the reviewer's own level; [0005] SQL performance hidden dangers will have a great impact on the onl...

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): G06F16/21
CPCG06F16/21G06F16/217
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