The database should be structured in such a way that it can hold a postal address froma any country in the world without compromise
The data should be fragmented into different fields to such an extent that it is possible to use certain key elements, such as postal code and Building Numbers in key processes such as searching and de-duplication. However, it must not be so fragemented that it requires specialist knowledge to recognise each element of the address and allow them to be put into the correct field. It must also not be so fragmented that it prevents the successful re-formulation of the postal address for output in a format which allows .
There is no right or wrong way to store address data - storage rules are dictated by the use to which the data will be put, ensuring naturally that the rules for good data quality are followed.
Practical International Data Management Online. A free resource from GRC Data Intelligence. For comments, questions or feedback: pidm@grcdi.nl
