Re: Database Design Patterns?

On Apr 2, 2:05 pm, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
> Sigh. At least, they will learn powerful recipes.- Hide quoted text -

Those are entirely different goals. One is database fundamentals, and the other one is how to write a query that solves a particular problem. Yes, it is better to approach any query with good theory knowledge, but standard database theory don't cover many problems that one would encounter in practice. For example, aggregation with grouping is arguably the most important operator after join, and yet it is not covered in standard database theory textbook. Case operator is another very important operator which is out of scope of the standard textbook.

I must admit that I started the whole project as a set of challenging SQL problems, so that "SQL puzzles" were perhaps a more appropriate title. After some time, however, several themes appeared, so that the manuscript became organized into patterns. Received on Thu Apr 05 2007 - 20:22:52 CEST