Skip to content

So you think you have data quality challenges?

One of the issues faced by most CRM systems is handling (preferably avoiding) duplicates. Inaport provides a range of different matching techniques to assist in avoiding duplicates when importing data.

This interesting article in the New York Times provides some insight into the difficulties faced in China. By some estimates, just 100 surnames cover 85% of China’s 1.3 billion citizens. By contrast, 70,000 surnames cover 90% of American citizen’s.

Chinese citizens try to overcome some of the potential for confusion by creative use of the extensive Chinese character set of 55,000 characters. Unfortunately, this runs directly counter to the government’s efforts to computerize and standardise, with a set of “only” 32,252 characters. An even more restricted list of 8,000 approved characters is to be issued later this year. This is leading to situations where people cannot get identity cards issued, because the characters used in their name are not available in the government systems.

Inaport supports Unicode, so in principle can be used for matching against the full Chinese character set. However, I have to confess that (so far) we have not had to put this to the test, even though Inaport is currently being used by customers in Chine (and Japan). Should this happen, I’ll update the post with the results.

Regards

David

Computing and storage in the cloud

IBM DeveloperWorks has an interesting article here comparing various “cloud” computing resources, with an emphasis on open source alternatives.

The main names in this space are Amazon, with their “Elastic Compute Cloud“; Google, with their “App Engine“; and Microsoft, with the very recently launched “Azure” platform. Of the three, Amazon looks to me to provide the best balance between completeness of functionality and ease of use. Azure provides access to the full Microsoft technology stack, but doesn’t seem to provide easy monetization mechanisms; Google looks very low friction to get going, but is currently restricted to Python (soon to include Java, but with restricted library support)  and a Google entity based data store.

The IBM article mentions a number of other services, and provides brief overviews and comparisons.

I would be interested to know if CRM users are starting to consider cloud based resources for temporary or permanent storage of extracts from their CRM databases. It might be interesting to add an Amazon or Google driver to Inaport and see if any creative uses emerge…

Regards

David

InaPlex at Sage Insights – Nashville, May 10-14 2009

InaPlex will be exhibiting at Sage Insights in Nashville, May 10-14 2009.

We will be in Booth 527, and look forward to renewing old acquaintances and forming new friendships.

Perhaps most importantly, we will be hosting the CRM “Meet and Greet” session on Monday evening – Govenors’ Ballroom B. Please come along and join us to start the conference in style!

Inaport adds GoldMine relationship tree building capability

Inaport now has the ability to build GoldMine relationship trees, solving a major issue with using this functionality.

Read more