Create a logical layer that mirrors the physical model.  The logical layer should be database independent.  There should be a way to keep tables/columns as logical only or physical only.  Logical tables and column names should have spaces replaced and words should be converted to abbreviations via a mapping table.