SharePoint

Here is a very good article on Data Patterns. Document is available in PDF format for download. Check it out: http://msdn2.microsoft.com/en-us/architecture/ms998446.aspx