• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Rogerio Kioshi
Ranch Hand
Posts: 690
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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

Thank you.
 
Bill Karwin
author
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 222
Chrome Eclipse IDE Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the prior knowledge you assume the reader must have?
 
Bill Karwin
author
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic