Method and device for processing faults of database

A processing method and a processing device technology, applied in the field of database, can solve the problems of the in-memory database not being able to monitor table statistics and collection in time, and achieve the effects of ensuring normal operation, solving faults, and improving processing efficiency

Active Publication Date: 2016-11-23
CHINA MOBILE GRP GUANGDONG CO LTD
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is to provide a processing method and device for database faults, which can solve the problem that existing memory databases cannot monitor and process faults caused by untimely collection of table statistics

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
  • Method and device for processing faults of database
  • Method and device for processing faults of database
  • Method and device for processing faults of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] In order to make the technical problems, technical solutions and advantages to be solved by the present invention clearer, the following will describe in detail with reference to the drawings and specific embodiments.

[0058] In the communication industry, TimesTen memory database is used in billing system. Since the billing system involves customer billing, voice communication, short and multimedia messages, GPRS (General Packet Radio Service, general packet radio service technology) Internet access (especially 4G), the customer sensitivity is very high. Affect customer perception, affect the company's business and reputation.

[0059] The TimesTen database product itself does not provide table statistics collection function, and statistics collection itself needs to consume certain resources. Under normal circumstances (business peaks), statistics collection cannot be performed on database table objects, which will affect the normal operation of the system. Therefor...

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 method and a device for processing faults of a database, relates to the field of databases and aims at solving the problem that existing memory databases cannot timely monitor and process faults of the databases. The method include: acquiring a first detection value of a preset monitoring event to detection on database running efficiency in the running process of the database; determining a first running state of the database according to the first detection value, and statistically collecting an intermediate temporary table of the database for the first time when the first running state of the database is in a fault state; acquiring a second detection value of the preset monitoring event to detection on database running efficiency after first-time statistical collection is performed on the intermediate temporary table of the database; determining a second running state of the database according to the second detection value, and statistically collecting a whole database table of the database for the second time when the second running state of the database is in a fault state. By the method and device, faults caused by untimely table statistical collection can be timely monitored and processed, so that processing efficiency is improved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for processing database faults. Background technique [0002] TimesTen memory database is a database in which all data and transaction change operations are completed in memory during the running process. Memory is currently recognized as the fastest storage device in the industry, so TimesTen memory data is often used in scenarios that require very high timeliness of business response. In the current communication service system, the billing system has very high service response requirements, and generally requires the response to be completed within 1 second. Therefore, in the communication industry, TimesTen memory database is used in the billing system. [0003] However, the Timesten database product itself does not provide the statistical collection function of the table, and whether the statistical information of the table is accurate plays a decisive role in ...

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): G06F17/30
Inventor 张炳华陈东明陈辉周世超何林艳
Owner CHINA MOBILE GRP GUANGDONG CO 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