ENHANCED DATABASE SEARCHING AND STORAGE

• US 20150052161A1
• Filed: 08/19/2013
• Published: 02/19/2015
• Est. Priority Date: 08/19/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Oliver, William J., Boyko, Adrian M.
• Granted Patent: US 9,928,273 B2
• Time in Patent Office: Days
• US Class Current: 707/756
• 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 a set of data containing at least a first character;

creating 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;

searching the computer database for a previously stored data entry using the converted set of data; and

returning a retrieved result of the searching.

2. The method of claim 1, wherein the step of creating the converted set of data by converting the first character in the received set of data into the second character, wherein the second character represents the first character and the one or more additional characters based upon the predetermined equivalency, 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, wherein the second character represents the first character and one or more additional characters, 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 predetermined equivalency is based upon common typographical errors on a keyboard.

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

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

7. The method of claim 1, wherein the set of data is one or more license plate numbers.

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

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

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

program instructions to create 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;

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

program instructions to return a retrieved result of the searching.

9. The computer program product of claim 8, wherein program instructions to create the converted set of data by converting the first character in the received set of data into the second character, wherein the second character represents the first character and the one or more additional characters based upon the predetermined equivalency, 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, wherein the second character represents the first character and one or more additional characters, according to the set of one or more rules.

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

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

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

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

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

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 set of data containing at least a first character;

program instructions to create 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;

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

program instructions to return a retrieved result of the searching.

16. The computer system of claim 15, wherein program instructions to create the converted set of data by converting the first character in the received set of data into the second character, wherein the second character represents the first character and the one or more additional characters based upon the predetermined equivalency, 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, wherein the second character represents the first character and one or more additional characters, 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 predetermined equivalency is based upon common typographical errors on a keyboard.

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

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