Practical International Data Management Online

Storage

index | Index | Properties

Practical international data management - storage

Storage of postal addresses

Considerations

  • 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 number 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 - beta.  A free resource from GRC Data Intelligence. For comments, questions or feedback: pidm@grcdi.nl

Hosted By Web Hosting by FatCow