Data storage method and device, data query method and device, electronic equipment and storage medium

A data query and data storage technology, applied in the computer field, can solve the problems of not supporting query data, reducing the query performance of sub-table data, etc., to achieve the effect of improving query efficiency

Pending Publication Date: 2021-04-23
RAJAX NETWORK &TECHNOLOGY (SHANGHAI) CO LTD
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this sub-table technology does not support querying data stored in sub-tables based on another dimension (or field), so in this case only all sub-tables can be queried, which greatly reduces the query performance of sub-table data

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] Hereinafter, exemplary embodiments of the present disclosure will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily realize them. Also, for clarity, parts not related to describing the exemplary embodiments are omitted in the drawings.

[0066] In the present disclosure, it should be understood that terms such as "comprising" or "having" are intended to indicate the presence of features, numbers, steps, acts, components, parts or combinations thereof disclosed in the specification, and are not intended to exclude one or a plurality of other features, numbers, steps, acts, parts, parts or combinations thereof exist or are added.

[0067] In addition, it should be noted that, in the case of no conflict, the embodiments in the present disclosure and the features in the embodiments can be combined with each other. The present disclosure will be described in detail below with reference to the accompanying drawings...

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 discloses a data storage and query method and device, electronic equipment and a storage medium. The method comprises the steps of obtaining a received data storage statement; when to-be-stored data in the data storage statement comprises a sub-table field and at least one preset non-sub-table field, establishing a mapping relationship between the sub-table field and the non-sub-table field; and determining a sub-table storage position of the to-be-stored data according to the sub-table field. According to the embodiment of the invention, after the database middleware obtains the data storage statement, the mapping relationship between the non-sub-table fields and the sub-table fields in the data storage statement is established, so that the sub-table fields can be determined by utilizing the mapping relationship when the data is queried by utilizing the non-sub-table fields, and the query efficiency of the data storage statement is improved. Furthermore, the positions of the to-be-queried sub-tables are determined according to the sub-table fields, so that all the sub-tables are prevented from being queried, and the query efficiency of the sub-table storage data is improved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular to a data storage and query method, device, electronic equipment and storage medium. Background technique [0002] With the gradual increase of data storage, the database often realizes the function of sub-table storage and query by adding a database middleware, that is, according to the value of the preset field in the data storage or data query statement, calculate the current data storage To which sub-table, or from which sub-table to query data. Existing table splitting technologies currently use one dimension or field as table splitting, that is, according to the value of a certain dimension or field, use table splitting algorithms such as hashing and modulo to determine which sub-table the row of data is stored in. However, this sub-table technology does not support querying data stored in sub-tables based on another dimension (or field). Therefore, in this cas...

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/22G06F16/242G06F16/2453
CPCG06F16/22G06F16/2443G06F16/24535
Inventor 朱杰
Owner RAJAX NETWORK &TECHNOLOGY (SHANGHAI) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap