Low-efficiency SQL statement analysis method and system based on distributed database cluster

An analysis method and database technology, applied in the field of low-efficiency SQL statement analysis methods and systems, can solve problems affecting user experience, affecting SQL execution efficiency, etc.

Active Publication Date: 2020-04-21
CHINA CONSTRUCTION BANK
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In turn, for a distributed database, there may be millions of query statements every day. Whether these statements are written properly and whether the database table design is reasonable will affect the SQL execution efficiency, thereby affecting the user experience.

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
  • Low-efficiency SQL statement analysis method and system based on distributed database cluster
  • Low-efficiency SQL statement analysis method and system based on distributed database cluster
  • Low-efficiency SQL statement analysis method and system based on distributed database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] 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.

[0058] figure 1 It shows a method for analyzing an inefficient SQL statement based on a distributed database cluster in the embodiment of the present application, specifically including:

[0059] S1: Obtain analysis basis information and inefficient SQL statements of the distributed database cluster, where the analysis basis information includes: application information and system information;

[0060] S2: Input the inefficient SQL statement and the analysis...

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 low-efficiency SQL statement analysis method and system based on a distributed database cluster. By setting an SQL performance analysis model, the function of automatically analyzing the input SQL statements can be realized, wherein the SQL performance analysis model is formed by carrying out training according to historical data; and application data and system data are both known data, the known data serve as the basis of performance results, and the analysis results tend to be reasonable day by day through training. Manpower can be liberated, efficiency can be improved, and analysis and diagnosis of a low-efficiency SQL can be completed quickly.

Description

technical field [0001] The present invention relates to the technical field of database query, and more specifically, relates to an inefficient SQL statement analysis method and system based on distributed database clusters. Background technique [0002] In most cases, distributed databases are more suitable as storage engines, computing engines, and analysis engines for big data. For example, Greenplum, as an enterprise-level database product, has the advantages of "supporting massive data storage and processing", "high cost performance", "supporting BI real-time analysis", "realizing dynamic data warehouse", "system ease of use", and "using MPP parallelism". The processing structure supports thread expansion", "good concurrency support and high availability support", "supports MapReduce", "database internal compression" and other characteristics, which can be said to be one of the most advanced OLAP open source databases in the world. [0003] A distributed database is a ...

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/242G06F16/27G06F16/21
CPCG06F16/2433G06F16/27G06F16/21Y02D10/00
Inventor 徐国柱欧万翔邓智鸿张东凯
Owner CHINA CONSTRUCTION BANK
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