Database Design for Mere Mortals

石头

作者：Michael J. Hernandez
副书名：A Hands-On Guide to Relational Database Design, Second Edition
出版日期：March 05, 2003
出版社：Addison Wesley
页数：672
ISBN：0-201-75284-0
文件格式：CHM


Perhaps you’re wondering why the world needs anotherbook on database design. When Mike Hernandez first discussed this bookwith me, I wondered. But the fact is you may have discovered from leafing through pages before landing here in the foreword the world doesneed a book like this one. You can certainly find many books detailingthe theories and concepts behind the science of database design, butyou won’t find many (if any) written from Mike’s particularperspective. He has made it his goal to provide a book that is clearlybased on the sturdy principles of mathematical study, but has geared ittoward practical use instead of theoretical possibilities. No matterwhat specific database package you’re using, the concepts in this bookwill make sense and will apply to your database-design projects.
I knew this was the book for me when I turned to the beginning of Chapter 6 and saw this suggestion:

Do not adopt the current database structure as the basis for the new database structure.

If I’d had someone tell me this when I was starting out on this database developer path years ago I could have saved a tonof time! And that’s my point here: Mike has spent many years designingdatabases for clients; he has spent lots of time thinking, reading, andstudying about the right way to create database applications; and he has put it all here, on paper, for the rest of us.
This book is full of the right stuff, illustratedwith easy-to-understand examples. That’s not to say that it doesn’tcontain the hardcore information you need to do databases right itdoes, of course. But it’s geared toward real developers, nottheoreticians.
I’ve spent some time talking with Mike aboutdatabase design. Over coffee, in meetings, writing courseware, it’salways the same: Mike is passionate about this material. Just as theoperating system designer seeks the perfect, elegant algorithm, Mikespends his time looking for just the right way to solve a design puzzleand you will read in this book best to explain it to others. I’velearned much of what I know about database design from Mike over theyears and feel sure that I have a lot more to learn from this book.After reading through this concise, detailed presentation of theinformation you need to know in order to create professional databases,I’m sure you’ll feel the same way.
Michael J. Hernandezcurrently works at Microsoft as a program manager for the DeveloperTools team of the Visual Studio .NET group. Previously, he was anindependent relational database consultant specializing in relationaldatabase design. Mike is a veteran database developer with more than 14years of experience developing applications for a wide variety ofclients in diverse industries. He has worked with several relationaldatabase management systems throughout his career and has been workingexclusively with Access since Version 1.0 and with SQL Server sinceversion 7.0. Mike is coauthor of the best-selling SQL Queries for Mere Mortals and has been a contributing author to, columnist for, and technical editor of various database books and periodicals.
Aside from his work on various database developmentprojects and writing projects, Mike has also been a veteran instructorfor nationally recognized training organizations such as AppDev, DeepTraining, and Focal Point, Inc., and traveled across the nationteaching Microsoft Access, SQL Server, SQL/92 query construction, andrelational database design. For more than 13 years, Mike trainedthousands of students from Fortune 500 companies, the military, thegovernment, and the private sector. He consistently received topratings from his students and became one of the premiere instructors inthe country. He’s spoken at various national and internationalconferences, such as the 2001 Microsoft Office Deployment andDevelopment Conference in Orlando, Florida, and the 2002 MicrosoftOffice Solutions Conference in Palm Springs, California. Mike becamedeeply involved in Microsoft’s .NET initiative and was one of the first200 Microsoft-authorized .NET instructors. He participated inMicrosoft’s nationwide .NET Developers Training Tour and in DeepTraining’s .NET Training Tour in San Jose, Costa Rica. Now he travelsacross the country on behalf of Microsoft.
Mike has been studying the guitar since 1967 and wasactually a professional guitarist for 15 years, playing a wide varietyof styles. His ability to enthuse his audiences comes from years ofentertaining, and Mike has a reputation among his colleagues for beingquite uninhibited. He’s played the guitar for his students, subjectedanyone within earshot to a collection of the world’s worst puns, playedthe game Charades to illustrate a point, and caused minor uproars withhis imitations of George Bush, Sr., and Ross Perot.
Some of Mike’s musician friends have talked him intocoming out of retirement, and he is playing once again in front ofgracious and appreciative audiences. He’s taken to playing a lot ofBossa Nova and finger-style jazz and is even composing his own music.With any kind of luck, he’ll eventually have enough material to producehis own music CD.
On those rare occasions when he has free time, Mikeusually spends it at one of three places: drinking a “Tall Americanowith room” at any immediately available Starbucks, hanging out in thedatabase section at any Barnes & Noble bookstore, or hitting golfballs at the local driving range and pretending he is Lee Trevino.
If you’d like to contact Mike, you can e-mail him at [email protected].

ccsrt

謝謝分享