Joe Celko's analytics and OLAP in SQL /

Mostrar otras versiones (3)

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Celko, Joe
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Francisco, Calif. : Oxford : Morgan Kaufmann ; Elsevier Science [distributor], 2006.
Colección:Morgan Kaufmann series in data management systems.
Temas:
SQL (Computer program language)
OLAP technology.
SQL (Langage de programmation)
OLAP, Technologie.
COMPUTERS > Data Processing.
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • 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.

Ejemplares similares