Re: RE: Any articles/books that take relational theory and make it
which noted O-O author said that about DBs? > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003/11/20 Thu PM 02:59:58 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Any articles/books that take relational theory and make it > > Paula - It may get worse. A noted O-O author said "a database is just a > means to persist an object". I also see a lot of young developers that > haven't taken much Computer Science, so haven't been exposed to underlying > theories like relational modeling. Well, we DBAs just have to be lights > shining into the darkness. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 20, 2003 12:45 PM > To: Multiple recipients of list ORACLE-L > > > Why in an IT shop - do us DBA's only seem to understand this? As I see it > most programmers don't understanding data models at all! It makes it easier > for them to ignore the DBA's as being theoretical, academic > > -Original Message- > Sent: Thursday, November 20, 2003 1:30 PM > To: Multiple recipients of list ORACLE-L > > > Hear, hear! > > pb > --- Michael Milligan <[EMAIL PROTECTED]> wrote: > > As Date is want to say, "Theory is practical!" (Chapter One, > > Relational > > Database Writings 1991-1994). > > > > IMHO, a lack of understanding of relational database theory leads > > directly > > to database designs so flawed that they can't possibly allow their > > application to accomplish their goals. If you don't think in terms of > > functional dependencies, if you don't know the trade-offs in using > > nulls, if > > you don't why you want to put some attributes in one entity and > > others in > > others, you'll be in trouble. Some people call all of this "theory". > > I see > > it as the "fundamental principles" that you'll be dead in the water > > without. > > > > > > If you don't know what the "relational" in RDBMS means (nothing to do > > with > > foreign keys), you'll make a bunch of mistakes over and over, knowing > > something is wrong but not able to put your finger on what's wrong. > > Then > > you'll limp along with an unfixable application, held together with > > prayers, > > and not able to deliver performance or even the right data. > > > > I've been doing this for 17 years and I've seen it happen more times > > than I > > like to remember. My suggestion, my strong suggestion, is to learn > > the > > theory to such an extent that you'll know why a model is good or why > > it's > > flawed. If you don't know what a good model is, how can you possibly > > create > > one? > > > > Data modeling is hard work. There is no shortcut for it. There is > > also no > > shortcut for learning it. But you can learn from people who > > understand it > > well and can express it well, also. In my opinion, those names > > include C.J. > > Date, Hugh Darwen, Fabian Pascal, and a number of others. > > > > HTH > > > > Michael Milligan > > Oracle DBA > > Ingenix, Inc. > > 2525 Lake Park Blvd. > > Salt Lake City, Utah 84120 > > wrk 801-982-3081 > > mbl 801-628-6058 > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Wednesday, November 19, 2003 2:35 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Agreed. And I think you'll admit it's better to be familiar with and > > aware > > of the theory, even if current db products don't live up to the model > > 100%, > > so you know to bring up the kinds of issues you mention in the first > > place. > > In that sense, I think the knowledge to be gained from Date, Darwen, > > Pascal, > > etc., can be very practical. > > > > > > This e-mail, including attachments, may include confidential and/or > > proprietary information, and may be used only by the person or entity > > to > > which it is addressed. If the reader of this e-mail is not the > > intended > > recipient or his or her authorized agent, the reader is hereby > > notified that > > any dissemination, distribution or copying of this e-mail is > > prohibited. If > > you have received this e-mail in error, please notify the sender by > > replying > > to this message and delete this e-mail immediately. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Michael Milligan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __ > Do you Ya
Re: RE: Any articles/books that take relational theory and make it
Well, Pascal has this to say about it: http://www.dbdebunk.com/page/page/622521.htm (This also links to some comments by Date on some articles by Ralph Kimball). What it comes down to for me is this, the relational model provides a way (by being based on set theory and predicate logic) to ensure that your query results are mathematically sound, and thus you can trust your data. To paraphrase Pascal, a database is simply a set of axioms, which we can use (via queries) to form proofs about various aspects of our enterprise. If we ensure our data is normalized, and ensure that appropriate constraints are in place, we can trust that the axioms we store in the database are valid, and that our 'proofs' are also accurate, and ultiumately we can trust the information we are getting out of the database. Again, I'd recommend Pascal's book, 'Practical issues...' as he explains these things more clearly than I can. Granted our bosses/managers/clients, etc., may not be interested in hearing about normalization and predicate logic, but I think they do put value in having accurate data with which to pursure business interests. Being aware of the theoretical issues associated with the relational model can only help in our position as 'guardians of the data'. Fwiw, -- Dan On Thu, 20 Nov 2003 [EMAIL PROTECTED] wrote: > how does dimensional modelling used by datawarehousing fit into relational theory? > > > > From: Daniel Hanks <[EMAIL PROTECTED]> > > Date: 2003/11/19 Wed PM 04:35:03 EST > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Any articles/books that take relational theory and make it > > > > Agreed. And I think you'll admit it's better to be familiar with and aware of the > > theory, even if current db products don't live up to the model 100%, so you know > > to bring up the kinds of issues you mention in the first place. In that sense, I > > think the knowledge to be gained from Date, Darwen, Pascal, etc., can be very > > practical. > > > > -- Dan > > > > On Wed, 19 Nov 2003, Niall Litchfield wrote: > > > > > I obviously can't speak for the list, but I find Fabian Pascal to be > > > very interesting, but quite academic. What I *think* that I mean by this > > > is that a lot of what he says seems to make theoretical sense, but I'm > > > unsure how applicable it is to practice. IOW the general feel that I get > > > from Fabian (and indeed Date) is that if something doesn't meet > > > relational theory then it is flawed. This may well be a good default > > > position to have, but I'm unprepared to say to folk who pay my wages > > > 'sorry your data model isn't in 3NF' or 'you shall not use a > > > materialized view'. I *will* quite happily say 'so how will you ensure > > > data integrity?' 'what happens if another program uses the same data' or > > > 'why did you use computed summaries?' > > > > > > Niall > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > > Behalf Of Daniel Hanks > > > > Sent: 19 November 2003 16:25 > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Any articles/books that take relational theory > > > > and make it > > > > > > > > > > > > On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: > > > > > > > > > I swapped emails with a member of the list and Im having trouble > > > > > seeing how you can take 3NF, BCNF, etc... and turn that into DBA > > > > > speak. One of the guys told me that BCNF essentially means > > > > you have a > > > > > key that you can put a unique constraint on. Well that > > > > makes this much > > > > > easier to understand. > > > > > > > > > > > > > Hrm, I thought a key, by definition, implied a unique constraint... > > > > > > > > > All my theory books just discuss theory. Anyone know some > > > > that split > > > > > the difference. IE, not Codd, not CJ Date, Not the academic > > > > textbooks. > > > > > > > > > > > > > I'm not sure what the opinion on Fabian Pascal is here on the > > > > list, but I found his "Practical issues in Database > > > > Management" to be very good. It's subtitled "A reference for > > > > the thinking practitioner". It's not a textbook, but it does > > > > make you use your brain a bit. It might be what you're > > > > looking for. It has helped to clarify the relational model > > > > for me, but might put some people off as it's critical > > > > (without naming specific products) of most current > > > > implementations of 'relational' databases. > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > -- Dan > > > > == > > > > == > > > >Daniel Hanks - Systems/Database Administrator > > > >About Inc., Web Services Division > > > > == > > > > == > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > >
Re: Re: Any articles/books that take relational theory and make it
there are used copies for sale right on there. > > From: "KENNETH JANUSZ" <[EMAIL PROTECTED]> > Date: 2003/11/20 Thu AM 11:20:15 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Any articles/books that take relational theory and make it > > Unfortunately according to Amazon.com this book is out of print. > > Ken Janusz, CPIM > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, November 19, 2003 8:40 AM > > > > > > "Data Modeling Essentials" by Graeme C Simsion is a very good book. > > > > > > > > American Express made the following > > annotations on 11/19/2003 07:36:46 AM > > -- > > > > > ** > > > > "This message and any attachments are solely for the intended > recipient and may contain confidential or privileged information. If you are > not the intended recipient, any disclosure, copying, use, or distribution of > the information included in this message and any attachments is prohibited. > If you have received this communication in error, please notify us by reply > e-mail and immediately and permanently delete this message and any > attachments. Thank you." > > > > > > ** > > > > > > > > == > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Tracy Rahmlow > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: KENNETH JANUSZ > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Any articles/books that take relational theory and make it
how does dimensional modelling used by datawarehousing fit into relational theory? > > From: Daniel Hanks <[EMAIL PROTECTED]> > Date: 2003/11/19 Wed PM 04:35:03 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Any articles/books that take relational theory and make it > > Agreed. And I think you'll admit it's better to be familiar with and aware of the > theory, even if current db products don't live up to the model 100%, so you know to > bring up the kinds of issues you mention in the first place. In that sense, I think > the knowledge to be gained from Date, Darwen, Pascal, etc., can be very practical. > > -- Dan > > On Wed, 19 Nov 2003, Niall Litchfield wrote: > > > I obviously can't speak for the list, but I find Fabian Pascal to be > > very interesting, but quite academic. What I *think* that I mean by this > > is that a lot of what he says seems to make theoretical sense, but I'm > > unsure how applicable it is to practice. IOW the general feel that I get > > from Fabian (and indeed Date) is that if something doesn't meet > > relational theory then it is flawed. This may well be a good default > > position to have, but I'm unprepared to say to folk who pay my wages > > 'sorry your data model isn't in 3NF' or 'you shall not use a > > materialized view'. I *will* quite happily say 'so how will you ensure > > data integrity?' 'what happens if another program uses the same data' or > > 'why did you use computed summaries?' > > > > Niall > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > Behalf Of Daniel Hanks > > > Sent: 19 November 2003 16:25 > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Any articles/books that take relational theory > > > and make it > > > > > > > > > On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: > > > > > > > I swapped emails with a member of the list and Im having trouble > > > > seeing how you can take 3NF, BCNF, etc... and turn that into DBA > > > > speak. One of the guys told me that BCNF essentially means > > > you have a > > > > key that you can put a unique constraint on. Well that > > > makes this much > > > > easier to understand. > > > > > > > > > > Hrm, I thought a key, by definition, implied a unique constraint... > > > > > > > All my theory books just discuss theory. Anyone know some > > > that split > > > > the difference. IE, not Codd, not CJ Date, Not the academic > > > textbooks. > > > > > > > > > > I'm not sure what the opinion on Fabian Pascal is here on the > > > list, but I found his "Practical issues in Database > > > Management" to be very good. It's subtitled "A reference for > > > the thinking practitioner". It's not a textbook, but it does > > > make you use your brain a bit. It might be what you're > > > looking for. It has helped to clarify the relational model > > > for me, but might put some people off as it's critical > > > (without naming specific products) of most current > > > implementations of 'relational' databases. > > > > > > > Thanks. > > > > > > > > > > > > > > -- Dan > > > == > > > == > > >Daniel Hanks - Systems/Database Administrator > > >About Inc., Web Services Division > > > == > > > == > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Daniel Hanks > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > > and in the message BODY, include a line containing: UNSUB > > > ORACLE-L (or the name of mailing list you want to be removed > > > from). You may also send the HELP command for other > > > information (like subscribing). > > > > > > > > > -- > >Daniel Hanks - Systems/Database Administrator >About Inc., Web Services Division > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daniel Hanks > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be remo
