Database system optimization method and device

A system optimization and database technology, applied in the database field, can solve problems such as low optimization efficiency, inability to accurately locate SQL statements, and inability to improve the response speed of the application system, so as to achieve the effect of improving optimization efficiency and response speed

Active Publication Date: 2018-02-13
PING AN TECH (SHENZHEN) CO LTD
View PDF7 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the selected SQL statement is not frequently used, the response speed of the application system cannot be improved even after optimization. Therefore, the manual selection method cannot accurately locate the SQL statement that needs to be optimized, and the optimization efficiency is low.

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 system optimization method and device
  • Database system optimization method and device
  • Database system optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0044] Such as figure 1 as shown, figure 1 It is a schematic flow chart of an embodiment of the method for optimizing the database system of the present invention, the method for optimizing the database system includes the following steps:

[0045] Step S1, taking a snapshot of the performance data of each SQL statement of the database system every preset first time, and arranging and saving the snapshots in chronological order;

[0046] In this embodiment, a SQL statement optimization system can be used to optimize the database system. Take a snapshot (i.e. snapshot) of the performance data of each SQL statement of the database system every preset first time, for example, take a snapshot of the performance data o...

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 database system optimization method and device. The database system optimization method includes the steps: snap-shooting performance data of SQL (structured query language)statements of a database system every preset first time, arranging snapshots according to a time sequence, and saving the arranged snapshots; correspondingly performing variance calculation on performance data of a current snapshot and performance data of a snapshot of front sequence, and calculating total cache read data quantity and single average cache read data execution quantity corresponding to each SQL statement within the preset first time; acquiring the sum of number valves of the total cache read data quantity and the single average cache read data execution quantity of each SQL statement, and selecting SQL statements to be optimized based on the sum of the number valves. The performance data comprises execution times and cache read data quantity. According to the method, the SQL statements needing to be optimized can be accurately positioned, and optimizing efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for optimizing a database system. Background technique [0002] Database query SQL (Structured Query Language, Structured Query Language) statements have various writing methods, and different writing methods of SQL statements are related to the performance of the application system. In the initial stage of application system development, the data in the database is relatively small, and SQL statements written in different ways have little impact on the application system. In practical applications, the data in the database will continue to increase, and the response speed of the application system will be greatly affected. Therefore, SQL statements need to be optimized in order to optimize the application system. [0003] At present, when a DBA (Database Administrator, database administrator) faces a large number of SQL statements, he usually manually sele...

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
CPCG06F16/24539G06F16/2453G06F11/3409G06F2201/80G06F2201/84G06F16/2433G06F16/24564
Inventor 汪洋
Owner PING AN TECH (SHENZHEN) 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