Supercharge Your Innovation With Domain-Expert AI Agents!

MySQL data auditing method and storage medium

A data auditing and database technology, applied in database design/maintenance, digital data processing, structured data retrieval, etc., can solve problems such as increasing the difficulty of MySQL data analysis and query, and achieve the effect of data auditing and supervision

Inactive Publication Date: 2019-07-09
福建省天奕网络科技有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this also increases the difficulty of MySQL data parsing and query

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
  • MySQL data auditing method and storage medium
  • MySQL data auditing method and storage medium
  • MySQL data auditing method and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0071] Please refer to Figure 2 to Figure 4 , this embodiment provides a MySQL data audit method, which can be used for both MySQL data backtracking and MySQL data backtracking, and does not require business task adjustment, so as to audit and monitor target data more conveniently and accurately .

[0072] Such as Figure 4 As shown, the method of this embodiment may include the following:

[0073] S1: Parse the database binlog log file to obtain a collection of MySQL execution statements.

[0074] Specifically, it is realized by acquiring (synchronizing) the binlog log file of the MySQL database and parsing it into an executable set of plaintext MySQL execution statements.

[0075] Optionally, the set of MySQL execution statements is stored in the form of a list.

[0076] Optionally, use the mysqlbinlog command to parse binlog log files.

[0077] In a specific embodiment, the S1 specifically includes:

[0078] S10: Determine the target time period according to the targ...

Embodiment 2

[0149] This embodiment corresponds to the MySQL data tracking process of Embodiment 1, and provides a specific application scenario:

[0150] Assume player 1 feedback: an item coded 1000 that he once owned suddenly disappeared; I hope the official response to the problem of missing item 1000.

[0151] For game officials, the MySQL data tracking method provided in the first embodiment above can be used for analysis to obtain the circulation process of item 1000 and provide technical support for answering questions.

[0152] Specifically, the data tracking process is as follows:

[0153] 1. Use the user account information "Player 1" to query the user data table, and get his user_id as 1. Among them, the user data table is the data of the current user table in the database, and the format can be shown in Table 1 below:

[0154] id username level score 1 player 1 30 580025 2 player 2 3 1500 3 player 3 2 1500 4 player 4 0 1350 ...

Embodiment 3

[0185] This embodiment corresponds to the MySQL data backtracking situation in Embodiment 1, and provides a specific application scenario:

[0186] Assume that the level experience value of player 1 is 580025, which is rather weird and reaches a value that cannot be reached normally. At this time, if you want to see why the player has reached such a value, you can use the method in Example 1 to perform the following operations;

[0187] It is assumed here that the user account was not created on the same day, but was created a long time ago. Analysis from the time of creation to the current one consumes a lot of resources, so we choose to push back from the current time.

[0188] 1. According to the user account of player 1, the id value of the corresponding user table can be obtained as 1; among them, the user data table is the data of the current user table in the database, and the format can be shown in Table 1 below:

[0189] id username level score 1 ...

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 MySQL data auditing method and a storage medium. The method comprises the following steps: S1, analyzing a database binlog file to obtain a MySQL execution statement set; S2,matching the key field value of the target data with the MySQL execution statement set to obtain a corresponding execution statement; and S3, performing matching according to the newly obtained execution statement and the key field value corresponding to the execution result obtained by reverse or forward analysis of the execution statement to obtain the latest execution statement, circularly executing the step, and obtaining reverse or forward data change record information of the target data according to the execution result obtained each time. According to the invention, data auditing and supervision are facilitated, and the realization mode is more convenient and effective.

Description

technical field [0001] The invention relates to the field of database data analysis, in particular to a MySQL data audit method and a storage medium. Background technique [0002] MySQL is a relational database management system. Relational databases store data in different tables instead of putting all data in a large warehouse, thereby increasing read speed and improving flexibility. However, this also increases the difficulty of MySQL data parsing and querying. [0003] The present invention provides a MySQL data audit method and a corresponding storage medium, which can perform pre- and post-event review of target data in MySQL data, thereby realizing the tracking and backtracking of MySQL data changes, which is conducive to the supervision of MySQL data, and compared with In terms of existing technology, it can be realized without business task adjustment, which is more convenient and efficient. Contents of the invention [0004] The technical problem to be solved 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): G06F16/2455G06F16/21
Inventor 刘德建詹彦安范福生黄钟贵江洪郑含章郑涛李正岳万恕陈宏展
Owner 福建省天奕网络科技有限公司
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