Unlock instant, AI-driven research and patent intelligence for your innovation.

Data archiving query method and system, storage medium and equipment

A technology of data archiving and query method, applied in the database field, can solve problems such as low data efficiency, and achieve the effect of improving query efficiency

Inactive Publication Date: 2021-04-09
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF2 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the purpose of the present invention is to propose a data archiving query method to solve the problem of low efficiency of querying long-term unused data 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
  • Data archiving query method and system, storage medium and equipment
  • Data archiving query method and system, storage medium and equipment
  • Data archiving query method and system, storage medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to make the object, technical solution and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0032] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are used to distinguish two entities with the same name or different parameters. It can be seen that "first" and "second" " is only for the convenience of expression, and should not be understood as limiting the embodiment of the present invention. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, of a process, method, system, product or other steps or elements inherent in a process, method, system, product, or device comprising a series of steps or elements.

[0033] Based on the above purpo...

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 data archiving query method and system, a storage medium and equipment, and the method comprises the following steps: dividing to-be-archived data into different n parts according to a preset archiving rule, carrying out m-time distribution, respectively distributing the n parts of to-be-archived data to corresponding n storage nodes each time; wherein m different to-be-archived data blocks exist in each storage node, and m is greater than 1; archiving all to-be-archived data blocks in respective storage nodes and generate respective index files; in response to the received query command, issuing the query command to each storage node; respectively loading respective index files in each storage node based on the query command, and querying a main index file in each storage node, the main index file corresponding to a to-be-archived data block distributed to each storage node for the first time; and obtaining and returning a query result based on the main index file. According to the invention, the efficiency of querying long-term unused data is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data archiving and querying method, system, storage medium and equipment. Background technique [0002] In the current technology, to query data that has not been used for a long time is to query the specified expired data from the database and persist it to the disk in text form. However, if the data in the form of text is to be queried, all of it can only be read into the memory, and the traversal query is performed, which is very inefficient. In the prior art, the log files of the database can also be used for dumping, but different databases have different log forms, which cannot be analyzed uniformly, are not easy to save, and the database logs cannot be directly queried, and the data needs to be imported into the database and then queried , The import of data may cause abnormal conditions such as primary key conflicts or locked tables, which will destroy the operation ...

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): G06F11/14G06F16/13G06F16/14
CPCG06F16/148G06F16/13G06F11/1448
Inventor 丁麒森田琳
Owner INSPUR SUZHOU INTELLIGENT TECH CO LTD