Database management method and system, computer device and readable storage medium

A management method and database technology, applied in the field of computer readable storage medium and database management, can solve the problems of small record volume, slow query database table, affecting user experience, etc., to ensure normal operation and improve user experience.
CN109933601APending Publication Date: 2019-06-25ONE CONNECT SMART TECH CO LTD SHENZHEN
0 Cites 10 Cited by

Patent Information

Authority / Receiving Office
CN ยท China
Patent Type
Applications(China)
Current Assignee / Owner
ONE CONNECT SMART TECH CO LTD SHENZHEN
Publication Date
2019-06-25

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides a database management method and system, a computer device and a computer readable storage medium. The database management method comprises the steps of establishing a monitoring task for a target database table, and configuring operation parameters of the monitoring task; Running the monitoring task in the target database table according to the running parameters of the monitoring task; Obtaining and judging whether the total response time of the monitoring task executing once under the current data volume of the target database table and the response time of each SQL query statement in the monitoring task are greater than a corresponding threshold value or not; And outputting an SQL query statement list with overtime execution time according to the judgment result,and pushing a management and control suggestion matched with the judgment result. According to the method, the database system data is monitored by configuring the SQL monitoring task, the problem that the data size of a database table is too large can be found in time, and normal operation of a database is guaranteed.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the field of databases, in particular to a database management method, system, computer device and computer-readable storage medium. Background technique

[0002] The database system is a data management system commonly used by upper-level applications, and the query operation accounts for the largest proportion in the database system. Some database tables in the database may insert a large amount of data every day (such as data acquisition tables). When the database table was first launched, because of its small record volume, its query response time is very fast. With the increase of database table data, querying the database table The response time of the database table becomes longer and longer. When the data volume of the database table reaches a certain level (such as millions / tens of millions), querying the database table will become slower and slower, which will affect the user experience. Contents of the inve...

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