Real-time database error log statistical analysis system and method thereof

A statistical analysis and database technology, applied in the field of big data, can solve problems such as the inability to quickly obtain the health status of the database and locate the database

Pending Publication Date: 2021-07-20
SHANGHAI ZHONGTONGJI NETWORK TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the purpose of the present invention is to overcome the deficiencies of the prior art, to provide a real-time database error log statistical analysis system and method thereof, to solve the problem that the state of health of the database cannot be obtained quickly and the database can be quickly located in the prior art. The problem

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
  • Real-time database error log statistical analysis system and method thereof
  • Real-time database error log statistical analysis system and method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be described in detail below. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other implementations obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0029] A specific real-time statistical analysis system and method for database error logs provided in the embodiments of the present application will be described below with reference to the accompanying drawings.

[0030] Such as figure 1 As shown, the real-time database error log statistical analysis system provided in the embodiment of the present application includes:

[0031] The database server is provided with a slow log collection service unit, which ...

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 relates to a real-time database error log statistical analysis system and method, and the system database server is provided with: a slow log collection service unit, which collects the error logs when the error logs are generated; a message middleware, which receives and stores the error log; a service layer, which cleans the error log, matches data obtained after cleaning according to a preset rule to obtain matched data, performs statistical analysis on the matched data to obtain analysis data, obtaining original data of the error log, and cleaning the original data to obtain cleaned original data; and a display output layer, which outputs and displays the analysis data and the cleaned original data. According to the technical scheme, a user does not need to log in a command line window of a server, the error logs are directly collected in real time, the error logs of all the databases can be checked through the visual interface, and the error logs can be filtered according to the user-defined rules of the databases. And self-service and customization of the user are realized.

Description

technical field [0001] The invention belongs to the technical field of big data, and in particular relates to a real-time database error log statistical analysis system and a method thereof. Background technique [0002] In the database synchronization system of the log parsing architecture, the source-side data synchronization system is responsible for capturing the operation logs of the source-side database, and parsing and restoring the logs to obtain corresponding database operations, and then sending them to the target-side data synchronization system. The target-side data synchronization system is responsible for These operations are performed on the target database to complete the process of data synchronization. Error logs will be generated during this process, and the error log analysis of the database is to copy the log of the error query to the temporary directory on the server where the database is installed, and analyze the log through the plug-in installed on t...

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
IPC IPC(8): G06F16/18G06F16/215G06F16/2455G06F16/2458G06F16/26G06F16/27
CPCG06F16/1815G06F16/215G06F16/24564G06F16/2462G06F16/27G06F16/26
Inventor 陈建华
Owner SHANGHAI ZHONGTONGJI NETWORK TECH 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