Can OpenProfiler be used in the following ways:
1) Customer or Product duplicate checks based on similar names. There are algorithms that will try and match two words based on their phonetics (soundex) or similar spellings (metaphones). Can the product be extended if I write my own Java coded to perform this analysis of the data?
2)Address validation using a library of address data for the US (provided by the post office ? like Zip+4), find any address that is not considered valid.
3) Relationships between tables / records - Check that relationships between objects / records in the database are valid. For example, how often does an order occur without a valid customer foreign key? Also, orders are often stored in a database in two tables ? lets call them Order Header and Order Item (detail). Can the software find any Order Item records that do not belong to an Order Header record (orphans)?