Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database maintenance method and device

A database and knowledge base technology, applied in the database field, can solve the problems of labor cost and time cost waste, and a lot of time

Active Publication Date: 2021-06-08
BEIJING UXSINO SOFTWARE
View PDF4 Cites 2 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

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

[0063] 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. The method comprises the steps: acquiring the calling times and / or the calling time of the SQL statements used by the user in the database, acquiring the low-efficiency SQL statements according to the calling times and / or the calling time of the SQL statements, and then deleting the low-efficiency SQL statements or pushing the rewriting prompt information corresponding to the low-efficiency SQL statements to the user, so the low-efficiency statements can be found and processed in time, the operation 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 businesses 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/215G06F16/2228G06F16/2433
Inventor 周征王若楠段坤
Owner BEIJING UXSINO SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products