OCR'd License Plates
652362Jul 29 2008 — edited Jul 29 2008I am on a project in which we are using License Plate Recognition (LPR) technology. Basically it boils down to OCR'ing the license plate and storing it in the database. Of course OCR is not perfect technology and some license plates are not recognized correctly i.e. a plate that is actually '123ABC' may get stored in the database as 'I23A8C'. I see that ORACLE TEXT supports fuzzy searching using OCR as a language.
It appears that ORACLE TEXT is geared more towards documents, web pages, etc containing hundreds of thousands of lines of text. My question: Is ORACLE TEXT a good solution for a smaller table (it gets purged daily at a maximum of 2000 records) to get fuzzy serch capabilities on OCR'd license plates or is this too much overhead for something like this? If this isn't a good idea is anyone aware of a more simplistic approach to fuzzy searching OCR text with Oracle. I'd like to query for license plate '123ABC' and have it return the record of 'I23A8C'. Thanks in advance for your time!