Unlock instant, AI-driven research and patent intelligence for your innovation.

Database maintenance method and device

A technology of database and knowledge base, applied in the field of database, can solve the problems of labor cost and time cost waste, and spend a lot of time, so as to reduce the difficulty and improve the efficiency of operation and maintenance

Active Publication Date: 2021-06-18
BEIJING UXSINO SOFTWARE
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing databases usually require dedicated operation and maintenance personnel to maintain, and users usually spend a lot of time monitoring the database when locating inefficient SQL statements, and the diagnosis and tuning of SQL statements require the expense of experienced operation and maintenance personnel. It takes a lot of time to analyze, which is easy to cause waste of labor cost and time cost

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] In order to make the purpose, technical solutions and advantages of the embodiments of the present disclosure clearer, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings in the embodiments of the present disclosure. Obviously, the described embodiments It is a part of the embodiments of the present disclosure, but not all of the embodiments, and in the case of no conflict, the implementation modes and the features of the implementation modes in the present disclosure can be combined with each other. Based on the embodiments in the present disclosure, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present disclosure.

[0068] Before discussing the exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as ...

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 databases, in particular to a database maintenance method and device. According to the method, the SQL statements used by the user in the database are normalized, the execution time of the normalized SQL statements is obtained, the low-efficiency SQL statements in the normalized SQL statements are obtained according to the execution time, and then the rewriting prompt information corresponding to the low-efficiency SQL statements is pushed to the user, so that the low-efficiency statements can be found and processed in time, and the user experience is improved. The operation and maintenance efficiency of the database can be improved, and the operation and maintenance difficulty of the database can be greatly reduced due to the fact that technicians do not need to learn servicees borne by the database.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular to a database maintenance method and device. Background technique [0002] Structured Query Language (Structured Query Language, SQL) is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage database systems. Existing databases usually require dedicated operation and maintenance personnel to maintain, and users usually spend a lot of time monitoring the database when locating inefficient SQL statements, and the diagnosis and tuning of SQL statements require the expense of experienced operation and maintenance personnel. A large amount of time for analysis is likely to cause waste of labor costs and time costs. Contents of the invention [0003] In order to solve at least one of the above technical problems, the present disclosure provides a database maintenance method and device. [0004] On...

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/242G06F16/22G06F16/215
CPCG06F16/2433G06F16/2228G06F16/215
Inventor 周征王若楠段坤
Owner BEIJING UXSINO SOFTWARE