Re: Partly OT - Database Programming textbook
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Tue, 2 Apr 2013 07:44:13 -0700 (PDT)
Message-ID: <1364913853.9874.YahooMailClassic_at_web181203.mail.ne1.yahoo.com>
# I'm short on theory and long on correctness and efficiency; my idea of a successful database instruction isn't being able to parrot the definition of 23 normal forms and requiring a procedure and five cursors to perform 20 times slower what can be done in a single query.
Date: Tue, 2 Apr 2013 07:44:13 -0700 (PDT)
Message-ID: <1364913853.9874.YahooMailClassic_at_web181203.mail.ne1.yahoo.com>
# I'm short on theory and long on correctness and efficiency; my idea of a successful database instruction isn't being able to parrot the definition of 23 normal forms and requiring a procedure and five cursors to perform 20 times slower what can be done in a single query.
...
Ummm ... 23 normal forms?
Unfortunately so many people even experienced Oracle DBA's are often weak on theory. Experience and mistakes and learning do count for a lot over time but working in "Database Programming" without a good understanding of the fundamentals of relational design ...
If one is looking for a very readable and shorter book that still captures much of the theory I highly recommend CJ Date's book (O'Reilly ) "Database in Depth Relational Theory for Practitioners".
Everyone in the Oracle industry as far as I know ( hoping here! ) does understand the Tom Kyte mantra of "Do it in 1 SQL statement if you possibly can" before tackling stuff in cursors/procedures/etc!
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 02 2013 - 16:44:13 CEST