Hi All.
During application deployment there is sometimes a need to change some columns' names in a table(s). I was wondering what is the best approach to do this and I think that the best would be to have an additional layer of procedures/functions which maps real column names in DB tables to column names used by Java layer (for example). This way when a column in table change its name the application will still work because "interface" function/procedure used by Java still returns original column names.
I don't know, however, what are the best practices to implement above. Do you know that, maybe?
Best regards,
Jacek