Re: Database design question [was: free software alternative to Access]
On Apr 19, 2005, at 9:01 AM, Paul Lussier wrote: So, does anyone have any decent references or pointers to basic relational database design? I'm looking for something generic to SQL, and not tied to any specific implementation. That's what I do for a living, design database applications, and teach, mentor and develop the software that runs them. There's a 524Kb PDF white paper at my site at: http://www.tedroche.com/Present/2004/RocheDataDesign.pdf Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
Re: Database design question
Richard Soule <[EMAIL PROTECTED]> writes: > Paul, > > You could try: > > http://www.amazon.com/gp/product/customer-reviews/1558606726/ref=cm_cr_dp_2_1/103-8170352-9419859?%5Fencoding=UTF8&customer-reviews.sort%5Fby=-SubmissionDate&n=283155 Thanks, I'll check it out. > At Oracle we've been working on a tool to 'replace access' (it's not > really there yet, it's more powerful in many ways and less user > friendly in some ways) for a number of years. It seems that Oracle has been working on a tool to replace every offering from MS for some time now, but as always, "it's not really there yet..." ;) Gotta love that Larry vs. BillG rivalry :) -- Seeya, Paul ___ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
Re: Database design question [was: free software alternative to Access]
Paul Lussier <[EMAIL PROTECTED]> writes: > So, does anyone have any decent references or pointers to basic > relational database design? I'm looking for something generic to SQL, > and not tied to any specific implementation. The O'Reilly mSQL and MySQL book has a chapter or two that discusses this subject (in general, like you asked for) Regards, --kevin -- GnuPG ID: B280F24E And the madness of the crowd alumni.unh.edu!kdc Is an epileptic fit -- Tom Waits ___ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
Re: Database design question [was: free software alternative to Access]
Paul, You could try: http://www.amazon.com/gp/product/customer-reviews/1558606726/ref=cm_cr_dp_2_1/103-8170352-9419859?%5Fencoding=UTF8&customer-reviews.sort%5Fby=-SubmissionDate&n=283155 Not sure about the above, but it seems highly rated (even though there are only 9 ratings). All the books that I've liked over the years have been Oracle specific like this one: http://www.amazon.com/exec/obidos/tg/detail/-/0072121203/qid=1113922379/sr=1-10/ref=sr_1_10/103-8170352-9419859?v=glance&s=books WARNING!!! Discussion of software that costs money to use for business purposes follows!!! At Oracle we've been working on a tool to 'replace access' (it's not really there yet, it's more powerful in many ways and less user friendly in some ways) for a number of years. I think I even showed a version of it years ago (8 years ago?) at UNH to the group once. We now call the tool HTMLDB. It allows the development of applications with a web based front end against an Oracle database. It has some pretty nice features including the ability to copy a spreadsheet/access database into a form and have the tool automatically create tables (and lookup tables) for you. I'm guessing that this is kind of similar to the PHP web admin tools that others were talking about before, but hopefully it is a bit more powerful. HTMLDB on OTN: http://www.oracle.com/technology/products/database/htmldb/index.html Viewlet (flash) of HTMLDB in action: http://otn.oracle.com/products/database/htmldb/viewlets/htmldb_quicktour_viewlet.html As always you can download all Oracle software from http://otn.oralce.com for personal use without sending Oracle any money. (Here is the 'big daddy' of database design tools: http://www.oracle.com/technology/products/designer/index.html) We've also come up with a very low price point for Oracle Standard Edition One: $750 for 5 users (5 user minimum, each additional user would be $150) or $5,000/cpu for unlimited users with a limit of 2 cpus to compete with other companies that offer low cost 'databases'. And of course databases from Oracle really are ANSI SQL compliant. :) Rich Paul Lussier wrote: All this talk about databases reminded me of a project I was working on a while back in which I had some fundamental database design questions, but not the time to properly research the answers. (of course, like all great projects driven by marketing, the immediate crisis which prompted the project was quickly solved by "changing direction" and subsequently resulted in them forgetting I was even doing anything to help them :( At any rate, I found myself trying to set up several tables for a database, but realized, that in general, other than gluing the tables together with basic SQL queries wrapped up in a spiffy perl CGI, I know next to nothing about "proper database design". So, does anyone have any decent references or pointers to basic relational database design? I'm looking for something generic to SQL, and not tied to any specific implementation. Thanks. ___ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
Database design question [was: free software alternative to Access]
All this talk about databases reminded me of a project I was working on a while back in which I had some fundamental database design questions, but not the time to properly research the answers. (of course, like all great projects driven by marketing, the immediate crisis which prompted the project was quickly solved by "changing direction" and subsequently resulted in them forgetting I was even doing anything to help them :( At any rate, I found myself trying to set up several tables for a database, but realized, that in general, other than gluing the tables together with basic SQL queries wrapped up in a spiffy perl CGI, I know next to nothing about "proper database design". So, does anyone have any decent references or pointers to basic relational database design? I'm looking for something generic to SQL, and not tied to any specific implementation. Thanks. -- Seeya, Paul ___ gnhlug-discuss mailing list gnhlug-discuss@mail.gnhlug.org http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss