Warning: Creating default object from empty value in /home/johnnz/public_html/wp-content/themes/simplicity/functions/admin-hooks.php on line 160

Address Universal Modelling Tool

Address Modelling Magic

The different structures of addresses in different countries and different languages can seem to be an insurmountable obstacle when trying to bring consistency of address structures for the purposes of Data Quality and Master Data Management.

Without the right tool it is insurmountable.  However, with the right tool is becomes relatively simple.

What is this tool? How much does it cost?  Can all enterprises afford it?

The truth is that no enterprise can afford to be without!

However the good news is that the tool is absolutely free!  and can be used by any member of the business with just a little training.

And what is the tool called?  It goes under the trade name of LDM.

It’s Only Logical to Use It!

The Logical Data Model (LDM) makes the mapping of the disparate address structures around the globe relatively simple.

Address elements universal modelling tool - the Logical Data Model

The  data structure shown in the diagram above means that, once you know the country and the language, the sequence and format of all of the elements of an address are known and can be displayed in the correct order and format, and this is the case for both address input and retrieval.

Start at the End

Once you know this structure, it becomes obvious that, contrary to normal practice, the first elements to be specified when entering an address are the Country and the Language.

Address Input Screen Structure

Once these two elements are known all of the relevant fields for that language and country can be displayed and completed in the correct order.

Learn More About the LDM

I will be describing many more ways in which using the Logical Data Model can make the seemingly impossible become easy to achieve in my forthcoming FREE Webinar on Master Data Management (MDM) and in my new Online MDM Course.

If you would like to find out more then please leave a reply below and I will get back to you.

Please also share this with any colleague or friend who might find it of value.

Tags:

2 Responses to “Address Universal Modelling Tool”

  1. Tommy Hägvall July 20, 2012 5:41 am #

    Great article. Please keep us posted on more information on the “tooling”.
    I have multi processes and domain ownership heading in to an outsourced environment. Taking the Functional approach seems most business future proof. Best reg Tommy Solution Architect Insurance industry.

    • John Owens July 23, 2012 12:11 am #

      Hi Tommy

      Thank you for your kind remarks.

      The Business Functions definitely give the most stable view of any enterprise. Over time many things in an enterprise may change, such as processes, procedures, organisation structure or technology.

      However, contrary to popular belief, the Business Functions, by and large, remain the same over time. This is actually true for most industries.

      Because of this, knowing and modelling the Business Functions enables an enterprise to build a robust business and information architecture.

      Regards
      John

Leave a Reply