Comment Relational Database Patterns (Score 1) 14
Actually, quite alot of work was done in this area by a company called Synon (which was later swallowed by Sterling Software). Synon created a product called Obsydian which used both templates and inheritance to allow developers to build reusable patterns largely targeting enterprise scale business apps built over relational databases. the approach was quite successful. in fact, using these patterns one could essentially generate a large system in a matter of days. of course, in using a tool this powerful alot of care must go into the architecture of the patterns as they are essentially reused and leveraged in all the derived patterns. alot of programmers and dbas resist and fight patterns for a variety of reasons but in terms of building enterprise scale business apps they are invaluable in reducing risk and bringing systems online quickly.