Return to Question

Design patterns are usually related to object oriented design.
Are there design patterns for creating and programming relational databases?
Many problems surely must have reusable solutions.

Examples would include patterns for table design, stored procedures, triggers, etc...

Is there an online repository of such patterns, similar to martinfowler.com?

Design patterns are usually related to object oriented design.
Are there design patterns for creating and programming relational databases?
Many problems surely must have reusable solutions.

Examples would include patterns for table design, stored procedures, triggers, etc...

Is there an online repository of such patterns, similar to martinfowler.com?

Examples of problems that patterns could solve:

• Storing hierarchical data (e.g. single table with type vs multiple tables with 1:1 key and differences...)
• Storing data with variable structure (e.g. generic columns vs xml vs delimited column...)
• Denormalize data (how to do it with minimal impact, etc...)