-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 sean peters wrote:
> Hi all, I just recently figured out a style of SQL book (or on-line info) that > would greatly help me. I have been reading a book entitled "Design Patterns > in Object Oriented Programming", and realized that analogous info probably > exists for database design. > > So, im looking for literature on SQL design patterns. Such a book would > basically entail examining a variety of (seemingly different) situations > where a good design (normalized, etc) of the SQL tables follow certian > patterns. Then, that pattern can be generalized and re-used for other related > situations. Having a catalogue of many of the most often encountered patterns > would allow for quicker design of SQL schema. You might find the two-volume series of books from Len Silverston, entitled 'The Data Model Resource Book: A Library of Universal Data Models for All Enterprises' from Wiley to be up your alley: http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+25MjtvXNTca6JD8RAkIWAKCQJP7saajwyg8lfn0JM3RWXMPymwCdHKgO PfFlUzD3erWa1XNaKWUMiJ4= =qEvS -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
