Data processing method and device, database system, electronic equipment and storage medium

A data processing and database technology, which is applied in the computer field, can solve problems such as time-consuming, manual determination, and inaccessible users, and achieve the effects of improving interaction efficiency, eliminating abnormalities, and intuitive interaction

Pending Publication Date: 2020-06-19
ALIBABA GRP HLDG LTD
View PDF7 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The problem with this alarm interaction method is that the database administrator needs to manually determine the root cause of the abnormal operation indicators after seeing the abnormal operation indicators. This requires the database administrator to check more than 20 key operation indicators first, and then pass The data of key operating indicators infers more fine-grained operating indicators, and then queries the associated events corresponding to the operating indicators, and finally infers the root cause
This process requires the database administrator to spend 5 minutes or more to locate the root cause of an abnormal running indicator, resulting in a long time-consuming, unable to provide users with stable and reliable database services, and relying on the personal experience of the database administrator

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
  • Data processing method and device, database system, electronic equipment and storage medium
  • Data processing method and device, database system, electronic equipment and storage medium
  • Data processing method and device, database system, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] refer to Figure 1a , shows a flowchart of steps of a data processing method according to Embodiment 1 of the present invention.

[0028] In this embodiment, the data processing method can be applied to a server configured with a database system (the server includes a server or a cloud), and an alarm for a failure of the database system is used as an example for description. Of course, in other embodiments, the data processing method can be applied to a terminal device.

[0029] The data processing method of the present embodiment includes the following steps:

[0030] Step S102: Obtain the failure analysis result data generated according to the abnormality index of the database system.

[0031] The abnormal index of the database system may be an abnormal part of the monitored operating index, and the operating index is used to indicate the operating state of the database system. For example, the running indicators include but are not limited to CPU usage, memory usag...

Embodiment 2

[0058] refer to Figure 2a , shows a flowchart of steps of a data processing method according to Embodiment 2 of the present invention.

[0059] In this embodiment, the data processing method can be applied to a server configured with a database system (the server includes a server or a cloud), and an alarm for a failure of the database system is used as an example for description. Of course, in other embodiments, the data processing method can be applied to a terminal device.

[0060] The data processing method of this embodiment includes the aforementioned steps S102 to S104.

[0061] which, combined with Figure 2b The database system shown in , uses a specific example to illustrate the implementation of generating a directed alarm graph and interacting through the directed alarm graph. In the database system, the client is used to interact with the user, such as receiving user requests. The data processing server is used to process user requests and interact with the d...

Embodiment 3

[0124] refer to image 3 , shows a structural block diagram of a data processing device according to Embodiment 3 of the present invention.

[0125] The data processing device in this embodiment includes: an acquisition module 302, configured to acquire the fault analysis result data generated according to the abnormal index of the database system, the fault analysis result includes the associated abnormal index in the abnormal index that has a correlation relationship, and the The abnormal propagation relationship between the associated abnormal indicators; the generating module 304, configured to generate an abnormal cause and Directed warning graph of causal relationships among anomalies.

[0126] Optionally, the generation module 304 includes: a first determination module 3041, configured to determine the root anomaly index and the remaining anomaly indexes in the associated anomaly indexes according to the anomaly propagation relationship between the associated anomaly i...

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 provides a data processing method and device, a database system, electronic equipment and a storage medium. The data processing method comprises the steps of obtainingfault analysis result data generated according to abnormal indexes of a database system, the fault analysis result comprising associated abnormal indexes having an association relationship in the abnormal indexes, and an abnormal propagation relationship between the associated abnormal indexes; according to the associated abnormal indexes and the abnormal propagation relationship between the associated abnormal indexes, generating a directed alarm graph used for displaying the causal relationship between the abnormal reasons and abnormal phenomena corresponding to the associated abnormal indexes; and displaying the directed alarm graph to give an alarm. Through the embodiment of the invention, an alarm can be given more intuitively and efficiently.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer technology, and in particular, to a data processing method, device, database system, electronic equipment, and storage medium. Background technique [0002] As a system that can store and maintain data, the database system's stable and reliable operation is the basis for providing good services to users. In order to ensure the stable and reliable operation of the database system, it is necessary to monitor the database system, and find and eliminate faults in time. [0003] In the prior art, by monitoring more than 100 operating indicators of the database system, it is determined whether there is an alarm or an abnormal event in the database system. If there is an alarm or an abnormal event, the database administrator (DBA) will be shown abnormal running indicators by sending a message, etc., so as to achieve the purpose of alarming. [0004] The problem with this alarm interact...

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/32G06F11/30
CPCG06F11/327G06F11/302G06F11/3055G06F2201/80G06F16/215G06F11/079G06F11/0709G06F11/3409G06F11/3466G06F2201/865G06F11/0751G06F11/0727G06F11/0772
Inventor 殷征
Owner ALIBABA GRP HLDG LTD
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