Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OCR'd License Plates

652362Jul 29 2008 — edited Jul 29 2008
I 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2008
Added on Jul 29 2008
2 comments
1,549 views