Database coding

The software engineering principles should be applied on database coding. This is important to keep the code clean and to speed development cycles. This section will address several issues such as naming convention, documentation, and version control.

If you are familiar with these concepts, feel free to skip the section. Some of these principles are:

Database naming conventions

A naming convention describes how names are to be formulated. Naming conventions allow some information to be derived based on patterns, which helps the developer to easily search for and predict the database object names. Database naming conventions should be standardized across the organization. There is a lot of debate on how to name database objects. For example, some developers prefer to have prefixes or suffixes to distinguish the database object type from the names. For example, one could suffix a table or a view with tbl and vw respectively.

With regard to database object names, one should try...