Database optimization method and device based on database

An optimization method and a technology for optimizing devices, which are applied in the field of database processing, can solve problems such as data query efficiency impact, low efficiency, and weak automation

Active Publication Date: 2020-06-05
GUANGZHOU HUYA TECH CO LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in practice, it is found that during the query processing of the database, the query efficiency of the data is affected to a certain extent due to the large number of slow queries, so that relevant personnel must perform corresponding pro

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 optimization method and device based on database
  • Database optimization method and device based on database
  • Database optimization method and device based on database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0063] Please see figure 1 , figure 1 A schematic flowchart of a database-based database optimization method is provided for the embodiment of the present application. This method can be applied to any database management scenario with databases. Specifically, this method can be applied to databases where slow SQL is common in databases, so that more slow SQL can be automatically identified and processed, thereby saving the database. Optimized time for database administrators to perform more work and tasks.

[0064] Specifically, slow SQL, as the main factor that kills the database, often brings considerable trouble to database administrators and related personnel. However, although slow SQL can kill the database, this process is not caused by one slow SQL, but slowed down by a bunch of slow SQL. Therefore, it is imminent to propose an automatic optimization method for SQL. Some of the current solutions almost require manual secondary confirmation by R&D or database admini...

Embodiment 2

[0088] Please see figure 2 , figure 2 It is a schematic flowchart of another database-based database optimization method provided in the embodiment of the present application. figure 2 The flow diagram of the described database-based database optimization method is based on figure 1 The flow diagram of the described database-based database optimization method is improved. Wherein, the database-based database optimization method includes:

[0089] S201. Receive the slow data log of the database at a preset time.

[0090] In this embodiment, the slow data log corresponds to the slow sql log.

[0091] In this embodiment, the preset time is a fixed time or time interval preset by the user, which is not limited in this embodiment.

[0092] In this embodiment, no limitation is made on the acquisition port and terminal of the slow data log.

[0093] S202. Parameterize the statement query conditions included in the data slow log to obtain the parameterized conditions.

[009...

Embodiment 3

[0143] Please see image 3 , image 3 It is a schematic structural diagram of a database-based database optimization device provided in the embodiment of the present application. Wherein, the database-based database optimization device includes:

[0144] A receiving unit 310, configured to receive the analysis log of the database;

[0145] A judging unit 320, configured to judge whether the analysis log meets a preset optimization trigger condition;

[0146] An acquisition unit 330, configured to acquire an optimization scheme of the database when the analysis log meets the optimization trigger condition;

[0147] The optimization unit 340 is configured to optimize the database according to the optimization scheme.

[0148] In this embodiment, the optimization algorithm includes an index optimization algorithm, and the optimization scheme includes an index optimization scheme.

[0149] In this embodiment, the database may be any kind of database, which is not limited in t...

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 embodiment of the invention provides a database optimization method and device based on a database, and relates to the technical field of database processing, and the method comprises the steps: receiving an analysis log of the database; judging whether the analysis log meets a preset optimization triggering condition or not; when the analysis log meets the optimization triggering condition, obtaining an optimization scheme of the database; and optimizing the database according to the optimization scheme. Visibly, by implementing the implementation mode, database optimization can be performed on the database, so that the use efficiency of the database is improved, and the automation degree of the database is improved.

Description

technical field [0001] The present application relates to the technical field of database processing, in particular, to a database-based database optimization method and device. Background technique [0002] At present, with the rise and popularization of databases, the management requirements for databases are becoming higher and higher, and the query processing efficiency of data, as an important indicator, has attracted the attention of all relevant personnel. However, in practice, it is found that during the query processing of the database, the query efficiency of the data is affected to a certain extent due to the large number of slow queries, so that relevant personnel must perform corresponding processing to ensure that the database is in the production environment. under normal execution. It can be seen that the existing database requires human intervention in the process of use, which leads to problems of low efficiency and weak automation. Contents of the inven...

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
IPC IPC(8): G06F16/21
CPCG06F16/217Y02D10/00
Inventor 周伟
Owner GUANGZHOU HUYA TECH 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