Index processing method, system and device based on ORACLE database and storage medium

A processing method and indexing technology, applied in database indexing, electrical digital data processing, special data processing applications, etc., can solve problems such as meaninglessness, index failure, etc., and achieve more targeted effects in monitoring and processing

Pending Publication Date: 2020-08-25
CHINA CONSTRUCTION BANK
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, due to the different characteristics of the business running on different databases, some databases may experience certain index failures within a specific time range every day. These are failures within the planned range, and once the index failure is found Just give an alert immediately, and a lot of meaningless alerts will be generated

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
  • Index processing method, system and device based on ORACLE database and storage medium
  • Index processing method, system and device based on ORACLE database and storage medium
  • Index processing method, system and device based on ORACLE database and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Various aspects of the present invention will be described in detail below with reference to the drawings and specific embodiments. Wherein, well-known modules, units and their mutual connections, links, communications or operations are not shown or described in detail. Also, the described features, architectures, or functions may be combined in any manner in one or more implementations. It should be understood by those skilled in the art that the various implementations described below are only for illustration, rather than limiting the protection scope of the present invention. It can also be easily understood that the modules or units or processing methods in the embodiments described herein and shown in the accompanying drawings can be combined and designed in various configurations.

[0028] The following is a brief description of the terms used in this article.

[0029] Index, in the ORACLE database, an index is a database structure for the server to quickly fin...

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 failure index processing method, system and device based on an ORACLE database and a storage medium. The failure index processing method comprises the steps of obtaining configuration content in a configuration file; querying an index in a failure state at present, and judging whether the index in the failure state meets an alarm condition corresponding to the configuration content or not; and giving an alarm to the index which is judged to meet the alarm condition and is in the failure state. According to the failure index processing method provided by the invention,the monitoring processing of the failure index is more targeted by configuring the corresponding configuration content, and meaningless alarm can be avoided by alarming the failure index conforming tothe alarm condition corresponding to the configuration content, so that the alarm content is processed in a targeted manner.

Description

technical field [0001] The present invention relates to the technical field of computer application, and more specifically, relates to an ORACLE database-based failure index processing method, system, device and storage medium. Background technique [0002] During the use of ORACLE (Oracle) database, there are many reasons that may lead to index failure. Index failure will affect the execution efficiency of SQL statements that originally use this index. In addition, if the invalid index is a unique index, it will cause the data insert operation to the base table to fail. However, since the index failure of the ORACLE database is a normal mechanism, the ORACLE database itself will not report an error when the index fails, and needs to implement the monitoring of the failed index by itself. [0003] However, due to the different characteristics of the business running on different databases, some databases may experience certain index failures within a specific time range ev...

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/30G06F16/22G06F16/28
CPCG06F11/327G06F11/3093G06F16/2272G06F16/284G06F2201/80
Inventor 秦雨
Owner CHINA CONSTRUCTION BANK
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