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

Data management method and device, electronic equipment and storage medium

A data management and data technology, which is applied in the computer field, can solve the problems that the database cannot be written, time-consuming and laborious, and the online service has an excessive impact, so as to avoid the unrecoverable data.

Pending Publication Date: 2020-09-11
JINGDONG TECH HLDG CO LTD
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, in the process of implementing this application, the inventor found that, for example, for the current MYSQL database (an open source relational database), deletion is not a real deletion. After deleting data, there will still be a large number of fragments in the data table, which still occupy space At this time, in order to free up space, it is necessary to defragment the data table after data deletion
However, the defragmentation work is relatively cumbersome. Since there may still be some undeleted data after the data table is deleted, it is necessary to filter out the fragmented data before defragmenting, and then organize the fragmented data, which is time-consuming and laborious.
Moreover, when defragmenting the data table, the database cannot perform write operations and can only support read operations, which has a great impact on online services.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0069] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, but not all of them. Based on the embodiments in the present application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present application.

[0070] At present, in order to free up the storage space of the database, some data considered useless are usually manually deleted, because the data in the database cannot be recovered after deletion, and a vacuum state will appear when the deleted data is queried, which leads to the fact that if the data is deleted by mistake, Data de...

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 embodiment of the invention provides a data management method and device, electronic equipment and a storage medium. The data management method includes: detecting whether the to-be-managed data table in the database meets a preset filing condition or not; if yes, modifying the pointing direction of a data table pointer pointing to the to-be-managed data table from the to-be-managed data tableto a preset standby data table corresponding to the to-be-managed data table, and performing filing processing on the data stored in the to-be-managed data table, and performing defragmentation processing on the to-be-managed data table after all the data stored in the to-be-managed data table is subjected to filing processing. According to the method, before data in the to-be-managed data tableis archived, the pointing direction of the data table pointer pointing to the to-be-managed data table is modified into the corresponding alternative data table, so that the influence on data writingduring subsequent archiving processing and fragmentation processing is avoided, and the data can be normally written into a database.

Description

technical field [0001] The present application relates to the computer field, and in particular to a data management method, device, electronic equipment and storage medium. Background technique [0002] When the historical stock data in the database is too large, the disk space of the database will be insufficient, and if the data volume of a single table is too large, the speed of data insertion and data query will be reduced. The existing data management method is usually to manually delete unimportant historical data in each data table contained in the database at regular intervals. [0003] However, in the process of implementing this application, the inventor found that, for example, for the current MYSQL database (an open source relational database), deletion is not a real deletion. After deleting data, there will still be a large number of fragments in the data table, which still occupy space At this time, in order to free up space, it is necessary to defragment the...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/215G06F16/22G06F11/14
CPCG06F16/215G06F16/2282G06F11/1458
Inventor 崔博文
Owner JINGDONG TECH HLDG 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