Joe Celko's analytics and OLAP in SQL / Joe Celko.

Joe Celko's analytics and OLAP in SQL /

Show other versions (1)

Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQLs declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processin...

Full description

Saved in:
Bibliographic Details
Main Author: Celko, Joe
Format: Electronic eBook
Language:English
Published: San Francisco, Calif. : Oxford : Morgan Kaufmann ; Elsevier Science [distributor], 2006.
Series:Morgan Kaufmann series in data management systems.
Subjects:
SQL (Computer program language)
OLAP technology.
Online Access: Full text (Wentworth users only)
Table of 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.

Similar Items