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.

Pending Publication Date: 2019-06-25
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

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.

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 management method and system, computer device and readable storage medium
  • Database management method and system, computer device and readable storage medium
  • Database management method and system, computer device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0051] figure 1 It is a flow chart of steps in a preferred embodiment of the database management method of the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

[0052] refer to figure 1 As shown, the database management method specifically includes the following steps.

[0053] Step S11, establishing a monitoring task for the target database table, and configuring the running frequency and start time of the monitoring task, wherein the monitoring task includes at least one SQL query statement.

[0054] In one embodiment, the monitoring task is an SQL script collected according to preset rules, and the SQL script includes at least one SQL query statement. The preset rule can be set according to the actual monitoring requirements. For example, the preset rule can be a keyword of a preset query statement, and the SQL script is collected from a SQL statement library through the keywor...

Embodiment 2

[0074] figure 2 It is a functional block diagram of a preferred embodiment of the database management system of the present invention.

[0075] refer to figure 2 As shown, the database management system 10 may include an establishment module 101 , an operation module 102 , an acquisition module 103 , a judgment module 104 , and an output module 105 .

[0076] The establishment module 101 is used to establish a monitoring task for the target database table, and configure the running frequency and start time of the monitoring task, wherein the monitoring task includes at least one SQL query statement.

[0077] In one embodiment, the monitoring task is an SQL script collected according to preset rules, and the SQL script includes at least one SQL query statement. The preset rule can be set according to the actual monitoring requirements. For example, the preset rule can be a keyword of a preset query statement, and the SQL script is collected from a SQL statement library thro...

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 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.

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242
Inventor 葛舒婷
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
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