Method and device for discovering low performance structural query language (SQL) statements, and method and device for forecasting SQL statement performance

A low-performance, statement technology, applied in the database field, can solve problems such as poor performance of SQL statements, database crashes, and performance degradation

Inactive Publication Date: 2015-08-05
SIEMENS AG
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The cause of these failures may be poor performance of some SQL statements used for the query
Since some systems such as bank operation and maintenance systems may contain tens of thousands of SQL statements, it becomes difficult to find out which SQL statements have poor performance
[0003] Even if the performance of the database is tolerable for a period of time, it is likely that with the increase of data in the database and the increase of concurrent business processing, the execution of SQL statements will become slower and slower, and eventually the database will crash due to resource bottlenecks
However, it is more difficult to predict SQL statements that may perform poorly and crash the database in the future

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 discovering low performance structural query language (SQL) statements, and method and device for forecasting SQL statement performance
  • Method and device for discovering low performance structural query language (SQL) statements, and method and device for forecasting SQL statement performance
  • Method and device for discovering low performance structural query language (SQL) statements, and method and device for forecasting SQL statement performance

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In the following, various embodiments of the present invention will be described in detail with reference to the accompanying drawings.

[0034] figure 1 The shown method can be used to discover low-performance SQL statements.

[0035] Execution cost is the total execution time of the SQL statement in units of single block read time. It can be derived from a snapshot of the database by prior art methods. It is an indicator that best reflects whether the performance of the SQL statement is good. However, judging implementation costs in isolation is meaningless. The same execution cost may be acceptable in some cases, but may become unacceptable in some cases, so the judgment should be made in combination with the cost threshold. The embodiments of the present invention can be used to discover low-performance SQL statements in real time by predicting the dynamic threshold of the execution cost of the SQL statement.

[0036] In step S101, the execution cost and relate...

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 a method and device for discovering low performance structural query language (SQL) statements, and a method and device for forecasting SQL statement performance. The method for discovering the low performance SQL statements comprises the steps of tracking executory costs and related cost index of SQL statements; and on the basis of the historical data of the tracked executory costs and the related cost index of the SQL statements, forecasting the dynamic thresholds of the costs of the SQL statements, so as to discover the low performance SQL statements on the basis of the executory costs at a particular moment and the corresponding forecast cost thresholds of the SQL statements. By using the method and the device provided by the invention, the low performance SQL statements in a database can be discovered efficiently.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for discovering low-performance SQL statements and predicting the performance of SQL statements. Background technique [0002] In some systems such as bank operation and maintenance systems, failures such as timeouts sometimes occur. The cause of these failures may be poor performance of some SQL statements used for the query. Since some systems such as bank operation and maintenance systems may contain tens of thousands of SQL statements, it becomes difficult to find SQL statements with poor performance. [0003] Even if the performance of the database is tolerable for a period of time, it is likely that with the increase of data in the database and the increase of concurrent business processing, the execution of SQL statements will become slower and slower, and eventually the database will crash due to resource bottlenecks. However, it is more difficult to predict...

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): G06F17/30
Inventor 方晓珊
Owner SIEMENS AG
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