SQL antipatterns: do you talk about OLAP, MOLAP, ROLAP,...?

[Rogerio Kioshi]

Hi,

I'd like to know if in this book do you talk about Datawarehouses, OLAP, MOLAP, ROLAP, etc?

Thank you.

[Bill Karwin]

Hi Rogerio,

I didn't delve into data warehousing, MOLAP, or Dimensional Modeling (DM) in my book. Date warehousing leads us to use denormalization techniques to optimize the database schema for certain types of reporting. Instead I covered standard relational design, with normalization being the default, which is better for OLTP or OLCP type applications.

Overall, my book tries to address the most common mistakes that I see database developers make. These naturally tend to be more to do with fundamentals of database usage, instead of the most advanced usage.

[Elchin Asgarli]

What is the prior knowledge you assume the reader must have?

[Bill Karwin]

Hi Elchin,

I do assume the reader has moderate knowledge of SQL or at least she has access to a reference for basic SQL queries, data definition, data types, and other terminology. My book is not an introduction to SQL concepts or syntax.