Joe Celko's analytics and OLAP in SQL
Title:
Joe Celko's analytics and OLAP in SQL
Author:
Celko, Joe.
Personal Author:
Publication Information:
San Francisco, Calif. : Morgan Kaufmann ; Oxford : Elsevier Science [distributor], 2006.
Physical Description:
xx, 181 pages.
Language:
English
Contents:
Basic reports and history -- Cross-tabulations -- Dimension tables -- Data migration and scrubbing -- MERGE statement -- OLAP basics -- GROUPING operators -- OLAP operators in SQL -- Sparseness in cubes -- Data quality -- Correlation -- Data distributions -- Market-basket analysis -- Decision, classification, and regression trees -- Computer-intensive analysis -- Relationship analytics -- Database architectures -- MDX from a SQL viewpoint.
ISBN:
9780123695123
Format :
Book
