Supercharge Your Innovation With Domain-Expert AI Agents!

Database log optimization analysis method and device

An analysis method and database technology, applied in the field of database log analysis, can solve problems such as unfavorable server operation, disk reading and writing pressure, redundant reading, etc., and achieve the effect of reducing redundant reading, reducing disk pressure, and speeding up synchronization efficiency

Active Publication Date: 2019-11-15
WUHAN DAMENG DATABASE
View PDF15 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, provide a database log optimization analysis method and device, and solve the technical problem in the prior art that redundant reading of database container log analysis causes disk read and write pressure, and is not conducive to server operation

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
  • Database log optimization analysis method and device
  • Database log optimization analysis method and device
  • Database log optimization analysis method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0018] like figure 1 As shown, Embodiment 1 of the present invention provides a log optimization analysis method for a database, which is used to analyze the logs of a database container containing multiple plug-in databases, including the following steps:

[0019] S1. Create a plurality of log capture threads that are equal in number to the plug-in database and correspond one-to-one, and create a virtual log capture thread;

[0020] S2. Capture the archive log of the database container through the virtual log capture thread;

[0021] S3. Identify the ownership of each log record in the archived log, and deliver each log record to the log capture thread to which it belongs;

[0022] S4. Each of the log capture threads parses corresponding log records.

[0023] Hereinafter, the database container is called CDB for short, and the plug-in database is called PDB for short. like figure 2 As shown, there can be multiple PDBs in a CDB, where there is a root container PDB$ROOT, a...

Embodiment 2

[0041] Embodiment 2 of the present invention provides a log optimization and analysis device for a database, including a processor and a memory, and a computer program is stored in the memory, and when the computer program is executed by the processor, it can realize the information provided by any of the above embodiments. Database log optimization analysis method.

[0042] Specifically, the database log optimization analysis method is as follows:

[0043] Create a plurality of log capture threads that are equal in number to the plug-in database and correspond one-to-one, and create a virtual log capture thread;

[0044]Capture the archive log of the database container by the virtual log capture thread;

[0045] Identify the attribution of each log record in the archive log, and deliver each log record to the log capture thread to which it belongs;

[0046] Each of the log capture threads parses corresponding log records.

[0047] The database log optimization analysis dev...

Embodiment 3

[0049] Embodiment 3 of the present invention provides a computer storage medium, on which a computer program is stored. When the computer program is executed by a processor, the log optimization and analysis method for a database provided in any of the above embodiments is implemented.

[0050] Specifically, the database log optimization analysis method is as follows:

[0051] Create a plurality of log capture threads that are equal in number to the plug-in database and correspond one-to-one, and create a virtual log capture thread;

[0052] Capture the archive log of the database container by the virtual log capture thread;

[0053] Identify the attribution of each log record in the archive log, and deliver each log record to the log capture thread to which it belongs;

[0054] Each of the log capture threads parses corresponding log records.

[0055] The computer storage medium provided by the present invention is used to implement the database log optimization analysis me...

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 the technical field of database log analysis, and discloses a database log optimization analysis method, which is used for analyzing logs of a database container containing aplurality of plug-in databases, and comprises the following steps: creating a plurality of log capture threads which are equal to the plug-in databases in quantity and are in one-to-one correspondencewith the plug-in databases, and creating virtual log capture threads; capturing an archiving log of the database container through the virtual log capturing thread; identifying the affiliation of each log record in the archived log, and delivering each log record to a log capture thread to which the log record belongs; and each log capture thread analyzing the corresponding log record. The methodhas the technical effects of avoiding redundant log reading, reducing the disk read-write pressure and accelerating the database synchronization efficiency.

Description

technical field [0001] The invention relates to the technical field of database log analysis, in particular to a database log optimization analysis method and device. Background technique [0002] As a database software, Oracle has a wide range of applications. Oracle12c, as its newer version, proposes the concepts of CDB and PDB. The full name of CDB is Container Database, which is a database container. It consists of multiple PDBs and is managed uniformly. The full name of PDB is Pluggable Database, that is, plug-in database. As a component of the database container, it can enter and exit from the database container at any time without affecting the external services provided by the database. Due to the introduction of different database types, the traditional database log analysis method is not very suitable. The traditional database log analysis method will provide a separate log analysis thread for each database. If there are multiple PDBs in a CDB, then the log analy...

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): G06F11/30G06F16/18G06F16/27
CPCG06F11/302G06F11/3051G06F11/3065G06F16/1815G06F16/27Y02D10/00
Inventor 孙峰付铨陈艳彭青松刘启春
Owner WUHAN DAMENG DATABASE
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com