Database refactoring. For the beginning…. Avoid overspecialization. Barrier. Application developer. Database developer. Communication Cooperation Exchange of experience. Developer. Developer. Definition.
CommunicationCooperationExchange of experience
The stored code doesn’t differ from any other code (it should be tested)
The scheme of data (tables, indexes, etc.)
The availability of data complicates the refactoring of the scheme!
All the smells of codes can be applied to the stored code including:
Smells characteristic for DB:
Highly controlled deployment