DATA STORAGE METHOD, DATA QUERY METHOD, APPARATUS AND DEVICE AND STORAGE MEDIUM

摘要

A data storage method, a data query method and device, a computer device and a storage medium. The method comprises: acquiring a data storage request, the data storage request comprising a data identifier (S10); acquiring, according to the data identifier, data to be stored (S20); performing a serialization process on the data to be stored to obtain a serialized JSON string comprising N JSON substrings (S30); matching, in a one-to-one manner, each JSON substring with a preset fixed field in a target data sheet (S40); writing the JSON substring that is successfully matched with the fixed field to a list region corresponding to the fixed field (S50); and writing the JSON substring that is not successfully matched with the fixed field to a list region corresponding to a custom field in the target data sheet (S60). The present invention performs a serialization process on frequently changing data and writes the serialized JSON strings to list regions corresponding to custom fields in a target data sheet, such that the efficiency of data storage in a relational database is improved.