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

Database monitoring method, device, terminal equipment and storage medium

A database and data scanning technology, applied in the database field, can solve the problem that data cannot be monitored and so on

Active Publication Date: 2021-03-26
PING AN TECH (SHENZHEN) CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present invention provides a database monitoring method, device, terminal equipment and storage medium to solve the problem that the data stored in the database with a time limit of more than one day cannot be monitored

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 monitoring method, device, terminal equipment and storage medium
  • Database monitoring method, device, terminal equipment and storage medium
  • Database monitoring method, device, terminal equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 A flow chart of the database monitoring method in this embodiment is shown. The database monitoring method is applied to a terminal device installed with a database to monitor data and improve the performance of the database system. Such as figure 1 As shown, the database monitoring method includes the following steps:

[0027] S10: Create a temporary table in the SQL database.

[0028] Wherein, the SQL database is a database based on SQL. SQL is an operation command set specially established for databases, and it is a fully functional database language for managing databases. Both SQL instructions and corresponding SQL execution plans in the SQL database are cached in the performance table of the SQL database. Specifically, the SQL instruction is cached in the performance table v$sql, and the SQL execution plan is cached in the performance table v$sql_plan. However, the SQL commands and their corresponding SQL execution plans are only stored for one day ...

Embodiment 2

[0086] image 3 A functional block diagram of a database monitoring device corresponding to the database monitoring method in Embodiment 1 is shown. Such as image 3 As shown, the database monitoring device includes a temporary table creation module 10, a data scanning instruction acquisition module 20, a data scanning result acquisition and storage module 30, a data monitoring instruction acquisition module 40, a target data sending module 50, a target data deletion module 60 and a target Data analysis and storage module 70. Wherein, the temporary table creation module 10, the data scanning instruction acquisition module 20, the data scanning result acquisition and storage module 30, the data monitoring instruction acquisition module 40, the target data sending module 50, the target data deletion module 60 and the target data analysis and storage module 70 The implementation functions correspond to the corresponding steps of the database monitoring method in the embodiment,...

Embodiment 3

[0106] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the database monitoring method in Embodiment 1 is implemented. To avoid repetition, details are not repeated here. Alternatively, when the computer program is executed by the processor, the functions of each module / unit in the database monitoring device in Embodiment 2 are realized, and details are not repeated here to avoid repetition.

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

A database monitoring method, apparatus, terminal device (80) and storage medium. The database monitoring method comprises: creating a temporary table in a structured query language (SQL) database (S10); acquiring a data scan instruction sent by a local server (S20); acquiring a corresponding data scan result from the SQL database on the basis of the data scan instruction, and storing the data scan result in the temporary table (S30); acquiring a data monitoring instruction sent by the local server, wherein the data monitoring instruction comprises a monitoring period (S40); and acquiring the data scan result in the monitoring period from the temporary table to serve as target data, and sending the target data to the local server (S50). The database monitoring method may carry out long-term storage and monitoring of data having a short effective period which is stored in the database, and improve the performance of the database system on the basis of monitoring results.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database monitoring method, device, terminal equipment and storage medium. Background technique [0002] Full table scan and implicit conversion are two methods for querying data in SQL databases. Among them, full table scan is the process used by the database server to search for each record in the table until all records meeting the given conditions are returned. It is generally used to query tables without indexes. Implicit conversion is the direct assignment of one data type to another data type. When querying data in an SQL database, it is usually necessary to use SQL instructions to query. The SQL (Structured Query Language) instruction will generate a SQL execution plan during the execution of the instruction. The SQL instruction and the corresponding SQL execution plan are cached in the performance of the SQL database. In table v$sql and performance table v$sql_plan, you can ...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/21
CPCG06F16/21G06F16/2282
Inventor 李坤
Owner PING AN TECH (SHENZHEN) CO LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com