Skip to Main Content
Joe Celko’s Complete Guide to NoSQL
book

Joe Celko’s Complete Guide to NoSQL

by Joe Celko
October 2013
Beginner to intermediate content levelBeginner to intermediate
244 pages
5h 53m
English
Morgan Kaufmann
Content preview from Joe Celko’s Complete Guide to NoSQL
Chapter 11

Analytic Databases

Abstract

Analytic databases were created to do analysis as opposed to simple data retrieval and aggregation that we have with a traditional SQL database used for OLTP. This model uses different structures for data, such as cubes and rollups. The theoretical foundation of OLAP came from the same Dr. Codd that gave use RDBMS. Dr. Codd described four analysis models in his whitepaper: (1) categorical—this is the typical descriptive statistics we have had in reports since the beginning of data processing; (2) exegetical—this is what we have been doing with spreadsheets, slice, dice, and drilldown reporting on demand; (3) contemplative—this is “what if” analysis; and (4) formulaic—these are goal-seeking models. You know ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

NoSQL for Mere Mortals®

NoSQL for Mere Mortals®

Dan Sullivan
Seven NoSQL Databases in a Week

Seven NoSQL Databases in a Week

Sudarshan Kadambi, Xun (Brian) Wu

Publisher Resources

ISBN: 9780124071926