Author: Peter FlynnPeter Flynn Date: Feb 2, 2007 14:04
Leila wrote:
> Hi, I'm looking for some guidelines to design, develop and maintain a
> standard database. I mean standard in terms of naming conventions,
> schema, security, availability, maintenance and every aspect that
> there is standards. However I'm not sure if there can be standard
> rule for all of them. Recently I read "Joe Celko's SQL Programming
> Style" book, it was great but as I mentioned, more aspects of
> database standardization I need. Maybe this is controversial question
> but I like to know your ideas!
The nice thing about standards is that there are so many to choose from.
Ex-mainframers always make fieldnames UPPER.CASE; Java programmers use
camelCase; Unix bods only do all_lowercase. Every corporation and every
professional and industry institution seems to have its own take on
standards, so all I can suggest is you adhere to whatever is prevalent
in the environment you're working in, unless it's obviously way out of
line (like being so silly it prevents interoperation).
Wouldn't life be boring if we had one single Schema or DTD for every
application on the planet?
///Peter
| 
