Multi-dimensional comprehensive database SQL auditing and optimizing method and system

An optimization method and database technology, applied in the field of SQL database, can solve problems such as the difficulty of auditing SQL database statements and the impact of online environment, and achieve the effects of facilitating supervision and improvement, speeding up SQL auditing, and reducing daily work pressure

Active Publication Date: 2020-04-28
绿城科技产业服务集团有限公司
View PDF6 Cites 5 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
  • Multi-dimensional comprehensive database SQL auditing and optimizing method and system
  • Multi-dimensional comprehensive database SQL auditing and optimizing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0056] see figure 1 , the present invention provides a technical solution: a multi-dimensional comprehensive database SQL audit 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 work order module, used to create SQL audit wor...

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 SQL databases, in particular to a multi-dimensional comprehensive database SQL auditing and optimizing method and system. The system comprises a WEB front end, a service background and a database, the WEB front end comprises a work order submitting module, a work order auditing module, an optimization recording module, a standard configuration moduleand a quality visualization module. The service background comprises an API service module, a data acquisition module, an SQL management module, an auditing engine module, an optimization engine module and a task scheduling module. The database comprises an audit intermediate library module, a test database module and an online database module, the SQL audit speed, the database structure optimization speed and the SQL optimization speed can be greatly increased, the daily work pressure of database DBA is reduced, and the influence of SQL performance hidden danger on the online environment iseffectively prevented.

Description

technical field [0001] The invention relates to the technical field of SQL databases, and the specific field is a multi-dimensional comprehensive database SQL audit and optimization method and system. Background technique [0002] Database SQL statement review is actually a standardized management of SQL, which is an important part of the software development process. Currently there are some automatic and manual auditing methods and systems, such as "A SQL Auditing Method and System" in Patent No. CN108415991A, but the following problems and deficiencies still exist: [0003] The automatic review only checks the grammar standardization, 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 level of the reviewer himself; [0005] Hidden SQL performance risks will have a great impact on the online environ...

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/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