Database notes:

Jul 21, 2009 at 1:51 PM
  • The time taken by the database load and the nature of the load indicate that the data should be loaded to a separate database and the Postcode table copied by SSIS to its final destination.
  • Local administrator / database owner access is required as tables are truncated prior to loading.
  • It is desirable to transpose the Postcode and PostStreet columns in the Postcode table so that the primary key is the first column.
  • The PostStreet column is a synthetic primary key comprised of the post code and the Id values of the thoroughfares (a.k.a. streets) that the post code serves.
  • In this version, access is only optimised by a wild card access to the PostStreet column using a given post code.