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
> nathan-MSHXTcNGJzS8rjiVs5Nzzw@xxxxxxxxxxxxxxxx
> ------



-------------------------------------------------------
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