Enhanced database searching and storage

• US 9,928,273 B2
• Filed: 08/19/2013
• Issued: 03/27/2018
• Est. Priority Date: 08/19/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Boyko, Adrian M., Oliver, William J.
• Primary Examiner(s): Nguyen, Chau
• Application Number:
  US13/970,064
• Publication Number:
  US 20150052161A1
• Time in Patent Office: 1,681 Days
• Field of Search: 715234, 715255-257, 715259, 715271, 707756, 382309-310, 382321-323
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 40/10 Text processing natural language analysis G06F40/20; semantic analysis G06F40/30; processing or translation of natural language G06F40/40
• CPC Class Codes: G06F 40/109 Font handling; Temporal or kinetic typography
• CPC Class Codes: G06F 40/126 Character encoding
• CPC Class Codes: G06F 40/157 using dictionaries or tables
• CPC Class Codes: G06F 40/16 Automatic learning of transformation rules, e.g. from examples
• CPC Class Codes: G06V 30/142 using hand-held instruments; Constructional details of the instruments

Abstract

In a method for searching a computer database, a processor receives a set of data containing at least a first character. A processor creates a converted set of data by converting the first character in the received set of data into a second character, wherein the second character represents the first character and one or more additional characters based upon a predetermined equivalency. A processor searches the computer database for a previously stored data entry using the converted set of data. A processor returns a retrieved result of the searching.

Claims

1. A method for searching a computer database, the method comprising:

receiving, by one or more processors, a search inquiry comprising a set of data containing at least a first character;

determining, by one or more processors, that the first character in the received set of data is a member of a group of characters that are grouped based upon a predetermined equivalency;

creating, by one or more processors, a converted set of data for the search inquiry by converting the first character in the received set of data into a second character, wherein the second character is a single character that is a representation equivalent to any one character of the group of characters including the first character and one or more additional characters;

searching, by one or more processors, the computer database for a previously stored data entry using the converted set of data wherein;

the previously stored data entry includes a data entry source character form and a converted form;

the converted form of the previously stored data entry includes the second character; and

the search comprises matching the converted set of data with the converted form of the previously stored data entry; and

returning, by one or more processors, a retrieved result of the searching, wherein the retrieved result comprises the data entry source character form of the previously stored data entry.

2. The method of claim 1, wherein the step of creating the converted set of data for the search inquiry by converting the first character in the received set of data into the second character comprises:

receiving information identifying a source of input of the received set of data;

selecting a set of one or more rules based upon the received information identifying the source of input of the received set of data; and

converting the first character in the received set of data into the second character, according to the set of one or more rules.

3. The method of claim 1, wherein the predetermined equivalency is based upon optical similarity of characters.

4. The method of claim 1, wherein the set of data is received from images captured by an optical character recognition (OCR) device.

5. The method of claim 4, wherein the OCR device is an automatic license plate recognition (ALPR) device.

6. A computer program product for searching a computer database, the computer program product comprising:

one or more computer-readable hardware storage media and program instructions stored on the one or more computer-readable hardware storage media, the program instructions comprising;

program instructions to receive a search inquiry comprising a set of data containing at least a first character;

program instructions to determine that the first character in the received set of data is a member of a group of characters that are grouped based upon a predetermined equivalency;

program instructions to create a converted set of data for the search inquiry by converting the first character in the received set of data into a second character, wherein the second character is a single character that is a representation equivalent to any one character of the group of characters including the first character and one or more additional characters;

program instructions to search the computer database for a previously stored data entry using the converted set of data wherein;

the previously stored data entry includes a data entry source character form and a converted form;

the converted form of the previously stored data entry includes the second character; and

the search comprises matching the converted set of data with the converted form of the previously stored data entry; and

program instructions to return a retrieved result of the searching, wherein the retrieved result comprises the data entry source character form of the previously stored data entry.

7. The computer program product of claim 6, wherein program instructions to create the converted set of data for the search inquiry by converting the first character in the received set of data into the second character comprise:

program instructions to receive information identifying a source of input of the received set of data;

program instructions to select a set of one or more rules based upon the received information identifying the source of input of the received set of data; and

program instructions to convert the first character in the received set of data into the second character according to the set of one or more rules.

8. The computer program product of claim 6, wherein the predetermined equivalency is based upon optical similarity of characters.

9. The computer program product of claim 6, wherein the predetermined equivalency is based upon common typographical errors on a keyboard.

10. The computer program product of claim 6, wherein the set of data is received from images captured by an optical character recognition (OCR) device.

11. The computer program product of claim 10, wherein the OCR device is an automatic license plate recognition (ALPR) device.

12. The computer program product of claim 6, wherein the set of data is one or more license plate numbers.

13. The computer program product of claim 6, wherein the second character is a unique character that is different than each of the first character and the one or more additional characters.

14. The computer program product of claim 6, wherein:

each character of the first character and the one or more additional characters of the group of characters is a character of an alphanumeric set of characters; and

the second character is a character of an alternate set of characters, wherein the alternate set of characters includes fewer characters than the alphanumeric set of characters.

15. A computer system for searching a computer database, the computer system comprising:

one or more computer processors, one or more computer-readable storage media, and program instructions stored on the computer-readable storage media for execution by at least one of the one or more processors, the program instructions comprising;

program instructions to receive a search inquiry comprising a set of data containing at least a first character;

program instructions to determine that the first character in the received set of data is a member of a group of characters that are grouped based upon a predetermined equivalency;

program instructions to create a converted set of data for the search inquiry by converting the first character in the received set of data into a second character, wherein the second character is a single character that is a representation equivalent to any one character of the group of characters including the first character and one or more additional characters;

program instructions to search the computer database for a previously stored data entry using the converted set of data wherein;

the previously stored data entry includes a data entry source character form and a converted form;

the converted form of the previously stored data entry includes the second character; and

the search comprises matching the converted set of data with the converted form of the previously stored data entry; and

program instructions to return a retrieved result of the searching, wherein the retrieved result comprises the data entry source character form of the previously stored data entry.

16. The computer system of claim 15, wherein program instructions to create the converted set of data for the search inquiry by converting the first character in the received set of data into the second character comprise:

program instructions to receive information identifying a source of input of the received set of data;

program instructions to select a set of one or more rules based upon the received information identifying the source of input of the received set of data; and

program instructions to convert the first character in the received set of data into the second character according to the set of one or more rules.

17. The computer system of claim 15, wherein the predetermined equivalency is based upon optical similarity of characters.

18. The computer system of claim 15, wherein the set of data is received from images captured by an optical character recognition (OCR) device.

19. The computer system of claim 18, wherein the OCR device is an automatic license plate recognition (ALPR) device.