Data storage and query method for compound fields

A query method and data storage technology, which are applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as long time consumption, low query efficiency, and inability to efficiently search data tables.

Inactive Publication Date: 2011-11-16
NORTHWEST UNIV(CN) +1
View PDF3 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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.

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 and query method for compound fields
  • Data storage and query method for compound fields
  • Data storage and query method for compound fields

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0062] like figure 1 A composite field data storage and query method shown includes the following steps:

[0063] Step 1, data storage: using a PC and storing multiple data to be stored respectively according to conventional data storage methods, and storing the stored multiple data to the pre-established storage device of the PC In the data table; the data table meets the requirements of the third normal form, and the number of the data table is one or more; the data storage method of each data table is the same.

[0064] When actually storing data, first organize the data to be stored according to the storage requirements of the conventional third normal form, and then store all the sorted data in the storage device, and the storage process is as follows:

[0065] Step 101, organize the original data according to the relational schema.

[0066] Step 102, making the relational schema R after data sorting satisfy the first normal form, that is, all attributes of the relation...

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 discloses a data storage and query method for compound fields. The method comprises the following steps of: 1, data storage: storing multiple data in a data table meeting requirements of the third normal form, wherein all storage recordings comprise field names, specific values and serial numbers of major keys; when the compound fields are stored, adding attributes of query quantityfields and the compound fields, related to the serial numbers of the major keys; 2, data query: when the compound fields are queried, for every storage recording, firstly reading query quantity n in the query quantity fields; in the query process, counting the name information quantity m of fields meeting query requirements, and completing the query process of one storage recording when m is not less than n; and then, continuing to perform query till all data tables are queried. The storage and query method has the advantages of reasonable design, convenience for storage and query, small dataprocessing quantity and high query efficiency; and by the adoption of the storage and query method, the problems of low query efficiency, long query time, low search speed, low search efficiency and the like, existing in compound field query, can be solved.

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 certain 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...

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): G06F17/30
Inventor 赵宏安陈林关博通王博赵凤起耿国华王冰李康牛晓霞李玉芹江静雷元元高红旭徐司雨王浩张玉成胡荣祖
Owner NORTHWEST UNIV(CN)
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