Data storage and query method for compound fields

Abstract

The invention discloses a data storage and query method of a compound field, comprising the following steps: 1. Data storage: storing a plurality of data in a data table meeting the requirements of the third paradigm, and each storage record includes field name information, Three types of information: specific value and primary key number; when storing composite fields, add the query quantity field and composite field attributes associated with the primary key number; 2. Data query; when querying composite fields, for any storage record, first read The query quantity n in the query quantity field, the number m of field name information that meets the query conditions is counted during the query process, and when m≥n, the query process of a stored record is completed; after that, continue to query until all data tables are queried. The invention has the advantages of reasonable design, convenient storage and query, small amount of data processing, and high query efficiency, and can solve the problems of low query efficiency, long time-consuming, inability to quickly and efficiently search and the like when querying compound fields.

Description

technical field [0001] The invention belongs to the technical field of data storage and query, and in particular relates to a data storage and query method of a composite field. Background technique [0002] In daily work, production and study, you will be exposed to a large number of complex data processing problems. Here are a few examples to illustrate: [0003] Example 1: In order to meet the requirements of a relational database, when storing the archive information of a university teacher, it is usually stored according to the information storage table shown in Table 1: [0004] Table 1 The file information storage table of teachers in a university [0005] teacher number Name Faculty phone number residence phone S1 X1 D1 T1 Z1 S2 X2 D2 T2 Z2 S3 X3 D3 T3 Z3 S4 X4 D4 T4 Z4 [0006] It can be seen from Ta...

AI Technical Summary

Problems solved by technology

[0013] The technical problem to be solved by the present invention is to provide a data storage and query method for composite fields in view of the deficiencies in the above-mentioned prior art, which has reasonable design, convenient data storage and query, small data processing workload, and high query efficiency. Solve the problems of low query efficiency, long time-consuming, and inability to quickly and efficiently search data tables when querying composite fields.

Images