Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for acquiring database operation logs

An acquisition method and acquisition system technology, applied in the field of database operation log acquisition method and system, can solve the problem of low real-time performance and achieve the effect of guaranteeing performance

Inactive Publication Date: 2015-11-25
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Based on this, it is necessary to provide a database operation log acquisition method and system for the technical problem of low real-time data acquisition in the prior art

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 system for acquiring database operation logs
  • Method and system for acquiring database operation logs
  • Method and system for acquiring database operation logs

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0019] Such as figure 1 Shown is a work flow diagram of a database operation log acquisition method of the present invention, including:

[0020] Step S101, comprising: after the main database operates the business data through the database interface, collects the log generated by the database operation on the business data and encapsulates it into an operation log, and adds the operation log to the memory queue;

[0021] Step S102, comprising: obtaining an operation log from the memory queue, using the obtained operation log as an operation log to be sent, packaging the operation log to be sent into a log push request and pushing it to the client;

[0022] Step S103 includes: when the client listens to the log push request, restores the business data from the log push request and sends it to the real-time application.

[0023] 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 method and system for acquiring database operation logs. The method comprises acquiring logs generated when a database operates business data and packaging the logs into an operation log by a main database, after the business data is operated through a database interface, and adding the operation log into a memory queue; acquiring the operation log from the memory queue, configuring the acquired operation log into an operation log to be sent, and packaging the operation log to be sent into a log push request and pushing the log push request to a client; and reducing the business data from the log push request and sending to a real-time application when the log push request is monitored by the client. In the method, the main database packages business data into an operation log an actively push the operation log to a client, so a data access mode between the main database and the client is changed, the performance of the main database and the access speed of mass data can be guaranteed.

Description

technical field [0001] The invention relates to the technical field related to databases, in particular to a method and system for acquiring database operation logs. Background technique [0002] With the development of real-time computing technology, enterprises have higher and higher requirements for the timeliness of applications. The offline extraction of similar data is accompanied by the inherent high latency characteristics of the solution, which makes the data unable to be used by real-time applications. Some scenarios with high time-efficiency requirements cannot be met, and the value of data is therefore discounted. It seems feasible to meet real-time applications through database-based computing, but with the blowout growth of data volume, whether it is RDBMS (relational database management system) or the current popular NoSQL database (non-relational database system), for The query and calculation of massive data will be a big challenge. Therefore, a set of re...

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/252G06F16/25
Inventor 刘若曦刘瑞东张侃韩飞
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products