Wednesday, March 21, 2012

Patterns for table design

I am looking for something similar to patterns for table design, but I have been unable to find anything on that, or good rule of thumb performance guides for table design.

Most of the situations we face look like perfect candidates for patterns, and some good rules of thumb -- problems like scalable OLAP requirements PLUS real time reporting.

I am looking for several differnet approaches and a good summary of the trade-offs for each one.

Thanks!

You're in luck...the newest book in the Martin Fowler Signature Series is on Database Refactoring

http://martinfowler.com/books.html#refactoringDatabases

I haven't read it yet but looking at the website (that has a catalog of the patterns), it seems to be pretty thorough. It goes hand in hand with Martin's Patterns of Enterprise Application Architecture and the other book in the series on Enterprise Integration Patterns.

No comments:

Post a Comment