Database-based operation log information monitoring obtaining method and apparatus

An acquisition method and database technology, applied in the field of acquisition of operation log information, can solve problems such as low efficiency of operation log information acquisition, failure to obtain operation log information in time, and complicated process of obtaining operation log information, so as to simplify the acquisition steps and improve Get the effect of efficiency

Inactive Publication Date: 2017-09-01
与米信息技术(上海)有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, by suspending the operation of the database to make the caller obtain the operation log information, the operation log information cannot be obtained in time, and the process of obtaining the operation log information is complicated, resulting in low efficiency of obtaining the operation log information

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-based operation log information monitoring obtaining method and apparatus
  • Database-based operation log information monitoring obtaining method and apparatus
  • Database-based operation log information monitoring obtaining method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0023] The embodiment of the present invention provides a method for acquiring database-based operation log information, such as figure 1 As shown, the method includes:

[0024] 101. When it is necessary to acquire database-based operation log information, determine a modified database source code.

[0025] Wherein, the database may be a Structured Query Language (Structured Query Language, SQL) database, a MYSQL database, and the...

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 discloses a database-based operation log information obtaining method and apparatus, which relates to the technical field of information and can improve database-based operation log information obtaining efficiency. The method comprises the steps of determining modified database source codes when database-based operation log information needs to be obtained; turning on a monitor corresponding to each operation action inserted in the modified database source codes; monitoring operation log information generated by each operation action in real time through the monitor; and transmitting the monitored operation log information to a call end, thereby enabling the call end to display the operation log information. The method and the apparatus are suitable for obtaining the database-based operation log information.

Description

technical field [0001] The invention relates to the field of information technology, in particular to a method and device for acquiring operation log information based on a database. Background technique [0002] With the continuous development of information technology, various databases appear. In order to operate data tables and data objects in the database, database providers provide database-based operations when developing databases, such as data A manipulation language (Data Manipulation Language, DML) operation, where the DML operation may include an insert operation, a delete operation, an update operation, and the like. When the above-mentioned operations exist in the database, the database will record the operation log information generated by the above-mentioned operations. [0003] At present, when the caller invokes the operation log information generated in the database, the database needs to be suspended, that is, the required operation log information can b...

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): G06F17/30
CPCG06F16/2358
Inventor 李永克
Owner 与米信息技术(上海)有限公司
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