Database state determination method and device, equipment and storage medium

A determination method and database technology, applied in the information field of financial technology, can solve problems such as slow query of sentences, difficulty in accurately determining abnormal locations, and difficulty in troubleshooting, so as to ensure normal operation and avoid the effect of business logic.

Active Publication Date: 2021-01-05
WEBANK (CHINA)
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the system resources are completely occupied, some statements with high efficiency will also become slow queries, which makes troubleshooting more difficult and it is difficult to accurately determine the location of the exception

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to make the purpose, technical solution and advantages of the application more clear, the technical solution of the application will be further elaborated below in conjunction with the accompanying drawings and embodiments. The described embodiments should not be considered as limiting the application. All other embodiments obtained under the premise of no creative work belong to the scope of protection of this application.

[0023] In the following description, references to "some embodiments" describe a subset of all possible embodiments, but it is understood that "some embodiments" may be the same subset or a different subset of all possible embodiments, and Can be combined with each other without conflict.

[0024] If there is a similar description of "first / second" in the application documents, add the following explanation. In the following description, the terms "first\second\third" are only used to distinguish similar objects and do not mean Regarding ...

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 embodiment of the invention discloses a database state determination method and device, equipment and a storage medium. The method comprises the steps: determining an SQL statement executed in a database; obtaining first resource consumption information from an information database, wherein the first resource consumption information is resource consumption information of a device where a backup database is located obtained by executing the SQL statement on the backup database; calculating the consumption of the SQL statement according to the first resource consumption information to obtaina resource consumption score; and determining the running state of the database according to the resource consumption score.

Description

technical field [0001] The embodiments of the present application relate to but are not limited to financial technology (Fintech) information technology, and in particular relate to a method, device, device, and storage medium for determining a database state. Background technique [0002] In the application scenario of financial technology (Fintech), the method of locating high-consumption statements is very inefficient, and there are certain skills that rely on experience and luck. It is generally accepted that expensive statements are equivalent to slow queries. However, when the system resources are completely occupied, some statements with high efficiency will also become slow queries, which makes troubleshooting more difficult and it is difficult to accurately determine the location of the exception. Therefore, how to accurately determine the abnormality is a problem that those skilled in the art need to consider. Contents of the invention [0003] In view of this,...

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): G06F11/36G06F11/30G06F16/242
CPCG06F11/3688G06F11/3055G06F16/2433
Inventor 梁梓锋胡盼盼卢道和
Owner WEBANK (CHINA)
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