Re: OT -- MySQL/general database info

At 06:05 AM 5/2/2003, you wrote:
>On Fri, 2 May 2003, Tigran wrote:
>
> > Sorry about the off topic post.
> > If posts like this are strictly against the rules please let me know.
> >
>
>Eh.. we like tangents. :)
>
> > I'm looking for a good book on database creation.
> > I'd like to make my own database in MySQL but I'm not sure how to go 
> about it.
> > How data should be organized and such.
> > I'm looking for a book that's more about databases then MySQL itself.
> > What book do you recommend?
> >
>
>Your local college bookstore should have plenty of DB theory/design books
>that would probably be worth a read if you wanted to know many of the
>fundamentals.  I'm partial to O'Reilly's _mSQL & MySQL_ which takes a
>looks at some basic db design stuff, and then applies those principals to
>building databses with both MySQl and mSQL (which is nice for a
>point-counterpoint kind of thought process, making you see what's MySQL
>specific, etc..)  It also covers some very light php, perl, and other
>tools to create frontends.  There are tons others, slashdot has reviewd a
>few LAMP/datadriven web app books as well.  Try books.slashdot.org

sorry for not getting back sooner.
I checked the library and found lots of interesting books on database 
design. I have two checked out Database Solutions by Thomas Connolly and 
Database Development for Dummies by Allen G. Taylor.
I actually just finished reading O'Reilly's mSQL & MySQL. A good book 
overall but I found it a bit outdated and not very detailed as to how 
someone should start the database design. The one I read was published in 
1999 so maybe they have a new one, I'll see if I can find it.




> > More specifically I need to create a database of devices that are stored in
> > an XY grid. The database must keep the XY location and lots of other
> > information that goes with each device.
> >
>
>Err.. that sounds like a spreadsheet.  Db's aren't spreadsheets.  You can
>populate a spreadsheet with a db, and can probably do a simple XY grid,
>though I think that would be limiting.
>
>-n
>--
>------
>nathan hruby
>[email protected]
>------



-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com