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

Abstract

The invention discloses a data storage method and device, a data query method and device, computer equipment and a storage medium, and the method comprises the steps: obtaining a data storage requestwhich comprises a data identifier; obtaining to-be-stored data according to the data identifier; performing serialization processing on the to-be-stored data to obtain serialized json character strings, the serialized json character strings comprising N sub json character strings, and then performing one-to-one matching on each sub json character string and a preset fixed field in a target data table; finally writing the sub-json character string successfully matched with the fixed field into a list area corresponding to the fixed field; and writing the sub-json character string which fails tobe matched with the fixed field into a list area corresponding to the custom field in the target data table. According to the method, serialization processing is carried out on frequently-changed data, and then the json character string subjected to serialization processing is written into the list area corresponding to the self-defined field in the target data table, so that the data storage efficiency in the relational database is improved.

Description

technical field [0001] The present invention relates to the field of cloud storage, in particular to a data storage method, a data query method, a device, computer equipment and a storage medium. Background technique [0002] With the increasing development of computer technology, various types of databases have been continuously developed. At present, the more common databases mainly include relational databases and non-relational databases. Different types of databases have different advantages. Although non-relational databases are more and more popular with developers due to their flexible scalability and allowing the creation of many different types of unstructured or arbitrary format fields, but Also due to the immaturity of the technology, there are defects such as weak transaction processing ability, no integrity constraints, and poor support for complex business scenarios. Therefore, many technology developers still choose traditional relational databases when pro...

AI Technical Summary

Problems solved by technology

[0003] Embodiments of the present invention provide a data storage method, device, computer equipment, and storage medium to solve the problem of low data storage efficiency in relational databases

[0004] Embodiments of the present invention provide a data query method, device, computer equipment, and storage medium to solve the problem of inaccurate data query results in relational databases

Images