<p>Design patterns are usually related to object oriented design.<br>
<strong>Are there <a href="http://en.wikipedia.org/wiki/Design_pattern_(computer_science)" rel="noreferrer">design patterns</a> for creating and programming <a href="http://en.wikipedia.org/wiki/Relational_database" rel="noreferrer">relational databases</a>?</strong><br>
Many problems surely must have reusable solutions.</p>

<p>Examples would include patterns for table design, stored procedures, triggers, etc...</p>

<p>Is there an online repository of such patterns, similar to <a href="http://martinfowler.com" rel="noreferrer">martinfowler.com</a>?</p>

<hr>

<p>Examples of problems that patterns could solve:</p>

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

There's a book in Martin Fowler's Signature Series called
Refactoring Databases
. That provides a list of techniques for refactoring databases. I can't say I've heard a list of database patterns so much.
I would also highly recommend David C. Hay's
Data Model Patterns
and the follow up
A Metadata Map
which builds on the first and is far more ambitious and intriguing. The Preface alone is enlightening.
Also a great place to look for some pre-canned database models is Len Silverston's Data Model Resource Book Series
Volume 1
contains universally applicable data models (employees, accounts, shipping, purchases, etc),
Volume 2
contains industry specific data models (accounting, healthcare, etc),
Volume 3
provides data model patterns.
Finally, while this book is ostensibly about UML and Object Modelling, Peter Coad's
Modeling in Color With UML
provides an "archetype" driven process of entity modeling starting from the premise that there are 4 core archetypes of any object/data model