A Fuzzy Query Method for Family Database

A fuzzy query and database technology, applied in the computer field, can solve problems such as fuzzy query

Active Publication Date: 2019-04-30
WENZHOU UNIV
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problem of querying family-oriented databases based on the names of both parties, especially the fuzzy query problem in the case of information defects such as missing items in the couple field, incomplete names, dislocations, and swapping, the present invention adopts the following scheme

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
  • A Fuzzy Query Method for Family Database
  • A Fuzzy Query Method for Family Database
  • A Fuzzy Query Method for Family Database

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0088] Example 1: Assume that only according to the attached figure 1 , attached figure 2 Implementation, and the fuzzy matching result contains the exact matching result, and it is assumed that the fuzzy matching module has the ability to find the fuzzy record "Zhang Weijia" of "Zhang Jiawei", but is unable to find the fuzzy record "Chen Weijia", and has the ability to find the fuzzy record of "Wei Xiaoying" "(empty string), but can't find "Weiying" and "Xiaoying". The query results and similarities are as follows:

[0089] For record No. 1, attach figure 2 Processes A1 to A4 can all query the record, and the similarities are 1, p, p, p 2 , with the couple's name appended figure 2 Processes A1-A4 cannot find this record. Finally, the similarity of this record is 1.

[0090] For record No. 2, attach figure 2 The records cannot be queried in processes A1~A4, but when the second fuzzy query is performed after exchanging the names of the couple, the attached figure 2...

example 2

[0094] Example 2: Assume that only according to the attached figure 1 , attached figure 2Implementation, and the fuzzy matching result contains the exact matching result, and it is assumed that the fuzzy matching module has the ability to find the fuzzy record "Zhang Weijia" of "Zhang Jiawei", but has no ability to find "Chen Weijia". Input the name of the wife to be queried without inputting, i.e. h="Zhang Jiawei", w="", because w is empty, append figure 2 After the process A1~A4 is optimized, there are only two parallel processes left. We might as well only take the process A1 and A2, and only take the process A1 and A3 after swapping the names of the couple, so:

[0095] For record No. 1, attach figure 2 Both processes A1 and A2 can query the record, and the similarities are 1 and p respectively. figure 2 Processes A1 and A3 cannot find this record. Finally, the similarity of this record is 1.

[0096] For record No. 2, attach figure 2 Neither process A1 nor A2 c...

example 3

[0100] Example 3: Assuming that the attached figure 1 , attached figure 2 , attached image 3 Implementation, notice that at this time the fuzzy matching module has the ability to find the fuzzy records "Zhang Weijia", "Chen Weijia", etc. of "Zhang Jiawei", and also has the ability to find the fuzzy records "", "Weiying", "Xiaoying" of "Wei Xiaoying" Wait. The query results and similarities are as follows:

[0101] For record No. 1, attach figure 2 Processes A1 to A4 can all query the record, and the similarities are 1, p, p, p 2 , with the couple's name appended figure 2 Processes A1-A4 cannot find this record. Finally, the similarity of this record is 1.

[0102] For record No. 2, attach figure 2 None of the processes A1-A4 can find the record, but when the second fuzzy query is performed after swapping the names of the couple, the attached figure 2 Processes A1 to A4 can all be found, and the similarities are q, qp, qp, qp 2 . Finally, the similarity of this...

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 home database-oriented fuzzy query method. The method comprises the steps of reading to-be-queried husband name and wife name, and performing queries according to four combination modes of husband name and wife name accurate matching or fuzzy matching; exchanging the husband and wife names; executing the queries according to the four combination modes; and finally combining record sets obtained by the query to serve as query results, wherein the fuzzy matching comprises matching queries after surname removal, exchange of two characters of a name and deletion of a first character of the name. Meanwhile, the similarity of the query records is calculated; the query results are alternatively accessed according to a high similarity principle if a plurality of the same records exist when the record sets are combined; and the query results are output in sequence from high to low according to the similarity. According to the method, the fuzzy query problem under common Chinese name information defects such as lack of the surname, exchange of the two characters, the fuzzy first character of the name, wrongly filled fields of the name, a simplified name and the like is solved, so that the fuzzy query under semantic-level significance of a field meaning, a name structure and the like is realized.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database fuzzy query method. Background technique [0002] In computer information management systems, family-based databases are very common, such as management information systems for water, electricity and gas supply, cable TV services, family planning, real estate registration, and compulsory education. This type of database usually has two fields: the husband’s name and the wife’s name. When the database was actually built, it was not required to enter the names of both parties or only one of them was required. The complete names of the husband and wife were gradually added later, so only one of them was often entered in the database. field, or the husband (wife) name is mistakenly filled in the wife (husband) field. For a single name, there may be lack of surname, two characters reversed, ambiguity of the first character of the first name, regional surname abbreviation...

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 Patents(China)
IPC IPC(8): G06F16/2458
CPCG06F16/2468
Inventor 胡明晓金可仲
Owner WENZHOU UNIV
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