Oracle Scratchpad

January 17, 2008

Book Reviews

Filed under: Indexing,Infrastructure,Oracle — Jonathan Lewis @ 9:10 pm GMT Jan 17,2008

Over the last few weeks I’ve read a couple of very good books about database theory and practice. Rather than saying anything about them on the blog, I decided to put my comments into Amazon reviews (UK site).

The two books were: Applied Mathematics for Database Professionals – by Lex de Haan and Toon Koppelaars, and Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach.

The Indexing book is likely to have a more immediate practical impact for DBAs, but the Applied Mathematics book has a wonderful chapter 11 that will be of particular benefit to developers who want to make sure that the only data that gets into their database is correct data.

For American readers, the links (without my reviews, of course, but with reviews from other readers) are: Applied Mathematics, and Indexing.

(This blog item operates in association with and


  1. I have heard about “Relational Database Index Design and the Optimizers” before. After reading your review it looks very promising.

    Comment by Yas — January 18, 2008 @ 8:56 am GMT Jan 18,2008 | Reply

  2. Summary: Some people will find the symbolic logic heavy going, but everyone who has to deal with designing or coding an Oracle database ought to read chapter 11 and do their best to read chapter 7.

    That sounds like a plan!

    Comment by Doug Burns — January 18, 2008 @ 12:39 pm GMT Jan 18,2008 | Reply

  3. Applied Mathematics for Database Professionals, is an interesting and hard book (hard…perhaps I’m not so good at mathematics…)

    But if you have time to read it carefully, it’s a definitive “Thumbs up!”.


    Comment by lascoltodelvenerdi — January 21, 2008 @ 9:48 am GMT Jan 21,2008 | Reply

  4. “For American readers, the links (without my reviews, of course, but with reviews from other readers) are: Applied Mathematics, and Indexing.”

    I would leave it at both Jonathan (especially with the increased orders from this side of the Pond with the weak USD), provided the books are identical, respectively. Neither Amazon site has a purchase with that particular outlet as a pre-condition for submitting a review.

    Comment by SeánMacGC — January 22, 2008 @ 1:10 pm GMT Jan 22,2008 | Reply

  5. @lascoltodelvenerdi

    It’s hard, yes, the cover is… ;-)
    Glad you enjoyed it.

    Comment by Toon Koppelaars — January 22, 2008 @ 6:47 pm GMT Jan 22,2008 | Reply

  6. Sean, When I created the review on the UK Amazon, one of the conditions was that I had purchased something from them – so I assumed it was the same on the US site. I’ll have to check when I get home.

    Comment by Jonathan Lewis — January 22, 2008 @ 8:37 pm GMT Jan 22,2008 | Reply

  7. @Toon Koppelaars


    Comment by lascoltodelvenerdi — January 23, 2008 @ 7:47 am GMT Jan 23,2008 | Reply

  8. […] other Oracle news, Jonathan Lewis offers on his Oracle Scratchpad offers brief reviews of two books, Applied Mathematics for Database Professionals and Relational Database Index Design and the […]

    Pingback by Log Buffer #81: a Carnival of the Vanities for DBAs — January 25, 2008 @ 5:53 pm GMT Jan 25,2008 | Reply

  9. […] – the data, we won’t consider the options for creating a ‘fat index’ (see Book Reviews for an explanation of this […]

    Pingback by Manual Optimisation « Oracle Scratchpad — April 27, 2008 @ 5:21 pm BST Apr 27,2008 | Reply

  10. Jonathan,

    I just scan roughly the chapter 11 indexes and reorganization of this book, relational database index design and the optimizers. They summarized a debate on index reorganization by claiming Don Burleson. I would like to know what and how do you think ?

    Thank you very much

    Comment by Bunditj — January 21, 2009 @ 10:37 am GMT Jan 21,2009 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by