|
 |
|
Oracle regular expression syntax
Oracle Tips by Burleson Consulting
|
See also:
Oracle
Regular expressions indexes as a tuning tool
Oracle's implementation of "regular expression"
syntax in their SQL is a powerful tool for data cleansing, the
identification of typo's and inconsistent entry of names, addresses,
&c.
Regular expressions allow for sophisticated
pattern-matching and allow us to create a super-robust and
intelligent data cleansing mechanism very quickly.
Best of all, there are pre-written regular expression patterns that
are freely available
on the web.
The challenge will be to create a "does this look like that"?
algorithm that accurately simulates a human comparison, and also
anticipate common data entry issues such as numerical transposition,
name mis-spelling (using the Oracle soundex function) and name
truncation.
| Oracle regular expressions allow the data
warehouse administrator to create routines that incorporate
fuzzy logic and AI to quickly find and resolve duplicates
and improve the quality of the data source. |
 |
We are experts at this cutting edge technology
and BC consultants can be hired to quickly implement data cleansing
technology for your Oracle database.
|
