CN110178121A - 一种数据库的检测方法及其终端 - Google Patents

一种数据库的检测方法及其终端 Download PDF

Info

Publication number
CN110178121A
CN110178121A CN201780000979.4A CN201780000979A CN110178121A CN 110178121 A CN110178121 A CN 110178121A CN 201780000979 A CN201780000979 A CN 201780000979A CN 110178121 A CN110178121 A CN 110178121A
Authority
CN
China
Prior art keywords
database
fault
fault message
running state
alarming information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201780000979.4A
Other languages
English (en)
Other versions
CN110178121B (zh
Inventor
卢汉利
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujing Technology Shenzhen Co ltd
Original Assignee
Fujing Technology Shenzhen Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fujing Technology Shenzhen Co ltd filed Critical Fujing Technology Shenzhen Co ltd
Publication of CN110178121A publication Critical patent/CN110178121A/zh
Application granted granted Critical
Publication of CN110178121B publication Critical patent/CN110178121B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
    • G06F11/0793—Remedial or corrective actions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
    • G06F11/0706—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment
    • G06F11/0727—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment in a storage system, e.g. in a DASD or network based storage system
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Debugging And Monitoring (AREA)
  • Test And Diagnosis Of Digital Computers (AREA)

Abstract

一种数据库的检测方法及其终端，属于数据库技术领域，包括：基于与数据库的特征相匹配的巡检算法，获取数据库的运行状态数据(S101)；将运行状态数据导入至预设的数据库故障分析模型，生成故障分析数据(S102)；提取故障分析数据包含的故障信息以及故障预警信息，并确定各个故障信息以及故障预警信息对应的修复方案(S103)；分别执行修复方案对应的修复操作，以修复数据库的故障情况(S104)。所述检测方法及其终端解决了现有的数据库的检查技术，依赖于数据库工程师的专业技术水平，并且不同工程师之间的检测标准不一致，从而导致异常判定存在较大的差异，检测的准确性较低，运营成本较大的问题。

Description

PCT国内申请，说明书已公开。

Claims (1)

  1. PCT国内申请，权利要求书已公开。
CN201780000979.4A 2017-09-06 2017-09-06 一种数据库的检测方法及其终端 Active CN110178121B (zh)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2017/100753 WO2019047072A1 (zh) 2017-09-06 2017-09-06 一种数据库的检测方法及其终端

Publications (2)

Publication Number Publication Date
CN110178121A true CN110178121A (zh) 2019-08-27
CN110178121B CN110178121B (zh) 2023-04-21

Family

ID=65633310

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201780000979.4A Active CN110178121B (zh) 2017-09-06 2017-09-06 一种数据库的检测方法及其终端

Country Status (2)

Country Link
CN (1) CN110178121B (zh)
WO (1) WO2019047072A1 (zh)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110955647A (zh) * 2019-12-04 2020-04-03 世纪龙信息网络有限责任公司 数据库辅助方法、装置、计算机设备和存储介质
CN111290930A (zh) * 2020-02-17 2020-06-16 京东数字科技控股有限公司 一种进程处理方法、装置、系统及存储介质
CN112231133A (zh) * 2020-10-16 2021-01-15 杭州中奥科技有限公司 一种数据修复处理方法、装置及电子设备
CN113886130A (zh) * 2021-10-21 2022-01-04 深信服科技股份有限公司 一种处理数据库故障的方法，装置及介质
CN113886132A (zh) * 2021-12-07 2022-01-04 深圳市明源云科技有限公司 web端错误智能修复方法、设备及计算机可读存储介质
CN115865751A (zh) * 2022-11-25 2023-03-28 南方电网数字平台科技(广东)有限公司 基于多态数据的故障检测方法及装置

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110502499A (zh) * 2019-06-26 2019-11-26 中电万维信息技术有限责任公司 基于贝叶斯算法的数据故障事件处理方法以及维护系统
CN111611131B (zh) * 2020-05-18 2023-06-30 中移（杭州）信息技术有限公司 基于Saltstack的运维方法、装置、系统及存储介质
CN112948459B (zh) * 2021-02-08 2024-04-30 中国铁道科学研究院集团有限公司 铁路基础设施巡检装置、方法及系统

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102081623A (zh) * 2009-11-30 2011-06-01 中国移动通信集团浙江有限公司 一种数据库异常检测方法和系统
CN103902542A (zh) * 2012-12-25 2014-07-02 百度在线网络技术（北京）有限公司 一种测试环境中数据库的运维方法及系统
WO2015100577A1 (en) * 2013-12-31 2015-07-09 Siemens Aktiengesellschaft Devices and methods for arc fault detection
CN105183614A (zh) * 2015-11-03 2015-12-23 华夏银行股份有限公司 一种数据库故障预测方法及装置
CN105337765A (zh) * 2015-10-10 2016-02-17 上海新炬网络信息技术有限公司 一种分布式hadoop集群故障自动诊断修复系统
CN106126403A (zh) * 2016-06-16 2016-11-16 北京中亦安图科技股份有限公司 Oracle数据库故障分析方法和装置
CN106161046A (zh) * 2015-03-18 2016-11-23 国家电网公司 一种面向电力光传输网的通信安全防御模型及其控制方法
CN106156202A (zh) * 2015-04-22 2016-11-23 中国移动通信集团广东有限公司 一种数据库故障的处理方法及装置
CN106249690A (zh) * 2016-09-29 2016-12-21 黑龙江八农垦大学 一种电气控制系统

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6199069B1 (en) * 1997-08-25 2001-03-06 International Business Machines Corporation System and method for switching between databases without disruption to applications
US8275907B2 (en) * 2008-06-26 2012-09-25 Microsoft Corporation Adding individual database failover/switchover to an existing storage component with limited impact
CN101321207B (zh) * 2008-07-22 2011-07-20 中国移动通信集团江苏有限公司 一种电信客户服务系统数据库故障处理方法
CN106021030A (zh) * 2016-05-30 2016-10-12 浪潮电子信息产业股份有限公司 一种数据库的系统、一种处理数据库故障的方法及装置

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102081623A (zh) * 2009-11-30 2011-06-01 中国移动通信集团浙江有限公司 一种数据库异常检测方法和系统
CN103902542A (zh) * 2012-12-25 2014-07-02 百度在线网络技术（北京）有限公司 一种测试环境中数据库的运维方法及系统
WO2015100577A1 (en) * 2013-12-31 2015-07-09 Siemens Aktiengesellschaft Devices and methods for arc fault detection
CN106161046A (zh) * 2015-03-18 2016-11-23 国家电网公司 一种面向电力光传输网的通信安全防御模型及其控制方法
CN106156202A (zh) * 2015-04-22 2016-11-23 中国移动通信集团广东有限公司 一种数据库故障的处理方法及装置
CN105337765A (zh) * 2015-10-10 2016-02-17 上海新炬网络信息技术有限公司 一种分布式hadoop集群故障自动诊断修复系统
CN105183614A (zh) * 2015-11-03 2015-12-23 华夏银行股份有限公司 一种数据库故障预测方法及装置
CN106126403A (zh) * 2016-06-16 2016-11-16 北京中亦安图科技股份有限公司 Oracle数据库故障分析方法和装置
CN106249690A (zh) * 2016-09-29 2016-12-21 黑龙江八农垦大学 一种电气控制系统

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
于锋等: "数据库智能化运维与故障预测平台研究与实践", 《金融电子化》 *
周世超: "基于内存数据库的智能化故障处理方法", 《移动通信》 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110955647A (zh) * 2019-12-04 2020-04-03 世纪龙信息网络有限责任公司 数据库辅助方法、装置、计算机设备和存储介质
CN111290930A (zh) * 2020-02-17 2020-06-16 京东数字科技控股有限公司 一种进程处理方法、装置、系统及存储介质
CN112231133A (zh) * 2020-10-16 2021-01-15 杭州中奥科技有限公司 一种数据修复处理方法、装置及电子设备
CN112231133B (zh) * 2020-10-16 2023-06-30 杭州中奥科技有限公司 一种数据修复处理方法、装置及电子设备
CN113886130A (zh) * 2021-10-21 2022-01-04 深信服科技股份有限公司 一种处理数据库故障的方法，装置及介质
CN113886132A (zh) * 2021-12-07 2022-01-04 深圳市明源云科技有限公司 web端错误智能修复方法、设备及计算机可读存储介质
CN115865751A (zh) * 2022-11-25 2023-03-28 南方电网数字平台科技(广东)有限公司 基于多态数据的故障检测方法及装置
CN115865751B (zh) * 2022-11-25 2024-05-14 南方电网数字平台科技(广东)有限公司 基于多态数据的故障检测方法及装置

Also Published As

Publication number Publication date
CN110178121B (zh) 2023-04-21
WO2019047072A1 (zh) 2019-03-14

Similar Documents

Publication Publication Date Title
CN110178121A (zh) 一种数据库的检测方法及其终端
Chen et al. Towards intelligent incident management: why we need it and how we make it
CN110574338B (zh) 根本原因发现方法及系统
CN108427632B (zh) 自动测试方法及装置
US10693711B1 (en) Real-time event correlation in information networks
CN110088744B (zh) 一种数据库维护方法及其系统
US11860721B2 (en) Utilizing automatic labelling, prioritizing, and root cause analysis machine learning models and dependency graphs to determine recommendations for software products
US9860109B2 (en) Automatic alert generation
CN104615476A (zh) 用于所选择的虚拟机复制和虚拟机重新启动的方法和系统
US11561875B2 (en) Systems and methods for providing data recovery recommendations using A.I
US20230016199A1 (en) Root cause detection of anomalous behavior using network relationships and event correlation
CN108932249A (zh) 一种管理文件系统的方法及装置
WO2019061364A1 (zh) 故障分析方法及相关设备
CN113238924A (zh) 分布式图数据库系统中的混沌工程实现方法和系统
CN110063042A (zh) 一种数据库故障的响应方法及其终端
CN114816820A (zh) chproxy集群故障修复方法、装置、设备及存储介质
CN111865673A (zh) 一种自动化故障管理方法、装置及系统
CN113407374A (zh) 故障处理方法、装置、故障处理设备及存储介质
CN112714022A (zh) 多套集群的控制处理方法、装置及计算机设备
CN116723085A (zh) 服务冲突的处理方法、装置、存储介质及电子装置
CN110968456A (zh) 分布式存储系统中故障磁盘的处理方法及装置
CN113268206B (zh) 一种网络靶场资源热插拔实现方法与系统
CN115150253A (zh) 一种故障根因确定方法、装置及电子设备
Kuang et al. Knowledge-aware Alert Aggregation in Large-scale Cloud Systems: a Hybrid Approach
CN114650211A (zh) 故障修复方法、装置、电子设备和计算机可读存储介质

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant