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

Data management method, device and equipment and storage medium

A data management and equipment technology, applied in the database field, can solve the problem of not being able to find modification records

Active Publication Date: 2019-09-10
SIMPLECREDIT MICRO LENDING CO LTD
View PDF15 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] When the amount of data stored in the database is large, the database will periodically delete binlog logs that have been stored for a long time. Therefore, for data that has been modified for a long time, there may be cases where relevant modification records cannot be found

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
  • Data management method, device and equipment and storage medium
  • Data management method, device and equipment and storage medium
  • Data management method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0030]This application is mainly applied to a data management device, and the data management device may be a traditional data management device, a database server, a web server, or the data management device described in the fourth embodiment of this application, which is not limited in this application. When the data management device interacts with other terminal devices, both the data management device and other terminal devices record and tr...

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 data management method and device, equipment and a storage medium, and the method is applied to a MySQL database, and comprises the steps: receiving a data modification request work order submitted by a user through a work order system, the data modification request work order comprising work order information; modifying the MySQL database according to the data modification request work order; recording modification information of the data modification request work order, wherein the modification information is used for indicating modified data in the database; and storing the modification information in a search engine, and associating the modification information with the work order information. Thus, the modification information is stored in the search engine,and the modification information is associated with the work order information of the data modification request work order, so that the modification records of the database can be stored in the searchengine and the work order system for a long time, and a user can conveniently trace back the modification condition of the database at any time.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data management method, device, equipment and storage medium. Background technique [0002] The MySQL database can store information such as data and data relationships, and the information in the database can also be modified by adding and deleting. The information obtained by recording the modification is called a modification record, because the modification record can reflect historical modifications It is convenient for managers to better manage the database, so it is of great significance to save modification records. [0003] The MySQL database obtains modification records through incremental backup. Compared with backing up all the data of the modified database, incremental backup only needs to record the modified data in the database to obtain the binlog log containing the modification records. The data modification records include the modification time an...

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/21G06F16/242
CPCG06F16/219G06F16/2433
Inventor 陈岗冉元
Owner SIMPLECREDIT MICRO LENDING 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

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

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