Re: Good Database Philosophy Book?
On Wed, Jul 09, 2003 at 04:20:52AM -0700, David Thompson wrote: > > Looking for a book to help me develop a philosophy for building > databases (particularly on MySQL). And then taking them from concept to > construction. > > Something like Start by asking which queries you will be performing, > then define all data needed for each of those queries, then progress to > normalize this data, etc. I too have a favourite. :-) Relational Database Design Clearly Explained, by Jan L. Harrington. ISBN 0-12-326425-1 (Academic Press). It goes through the basics (normalized forms, ER diagrams, CASE tools, Codd's Rules, yadda), explains *why* you'd use them, and (refreshingly) doesn't assume you'll take the author's word as gospel. It has examples which it builds on throughout the book, and seems to advocate simplicity of design over showing off gadgetry. I recommend it. -- Paul Chvostek <[EMAIL PROTECTED]> Operations / Abuse / Whatever it.canada, hosting and development http://www.it.ca/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Good Database Philosophy Book?
David, If you want to learn about Databases and normalization and Relational Algebra, a really good book is: Fundamentals of Database Systems, by Elmasri and Navathe and Understanding Relational Database Query Languages by SW Dietrich I have studied the first book, cover to cover, and I still use it for reference. It is the best books for understanding Relational Algebra and Normalization. The second book was written by my Professor Dr. Dietrich and is also a very good book. Saqib Ali - http://www.xml-dev.com On Wed, 9 Jul 2003, David Thompson wrote: > Looking for a book to help me develop a philosophy for building > databases (particularly on MySQL). And then taking them from concept to > construction. > > Something like Start by asking which queries you will be performing, > then define all data needed for each of those queries, then progress to > normalize this data, etc. > > Any Ideasthanks... > > Regards, > > David Thompson > President > Provoix Corporation - Business Web Solutions > www.provoix.com > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Good Database Philosophy Book?
Database Systems: Design, Implementation, and Management, Fifth Edition by Peter Rob, Carlos Coronel. In 1997 I bought & used the 3rd edition of this book. And from an educational, theoretical and practical analysis, design, implementation perspective it is very comprehensive. See info / reviews: http://www.amazon.com/exec/obidos/tg/detail/-/061906269X/qid=1057733082/sr=- 1/ref=sr__1_etk-books/102-2736743-5299308?v=glance&s=books&n=283155 With respect to SQL, a recommendation: SQL Clearly Explained, Second Edition by Jan L. Harrington (Paperback - April 2003). See info / reviews: http://www.amazon.com/exec/obidos/search-handle-form/ref=dp_sr_00/102-273674 3-5299308 -Original Message- From: David Thompson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 1:21 PM To: 'MySQL Mailing List' Subject: Good Database Philosophy Book? Looking for a book to help me develop a philosophy for building databases (particularly on MySQL). And then taking them from concept to construction. Something like Start by asking which queries you will be performing, then define all data needed for each of those queries, then progress to normalize this data, etc. Any Ideasthanks... Regards, David Thompson President Provoix Corporation - Business Web Solutions www.provoix.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration or dissemination is prohibited. Lawyers Access Web (Pty) Ltd. accepts no liability whatsoever for any loss, whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Re: Good Database Philosophy Book?
Hi, all Who can recommend me a good tools for testing performance under heavy use of mysql. With large corcurrent queries. -Ares -- Nuclear Science & Technology Virtual Research Center http://nst.pku.edu.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Good Database Philosophy Book?
Joe Celko's SQL for Smarties: Advanced SQL Programming By Joe Celko -Original Message- From: David Thompson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 4:21 AM To: 'MySQL Mailing List' Subject: Good Database Philosophy Book? Looking for a book to help me develop a philosophy for building databases (particularly on MySQL). And then taking them from concept to construction. Something like Start by asking which queries you will be performing, then define all data needed for each of those queries, then progress to normalize this data, etc. Any Ideasthanks... Regards, David Thompson President Provoix Corporation - Business Web Solutions www.provoix.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
