Joe Celko's Analytics and OLAP in SQL

Joe Celko

  • 出版商: Morgan Kaufmann
  • 出版日期: 2006-07-24
  • 定價: $1,800
  • 售價: 9.0$1,620
  • 語言: 英文
  • 頁數: 208
  • 裝訂: Paperback
  • ISBN: 0123695120
  • ISBN-13: 9780123695123
  • 相關分類: SQL
  • 立即出貨 (庫存 < 3)

買這商品的人也買了...

商品描述

Description

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 SQL's declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught. This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face?if they want to grow.

 

Table of Contents

0. Introduction 1. Basic Reports & History 2. Crosstabs 3. Star and Snowflake Schemas 4. Data Migration 5. MERGE Statement 6. OLAP Basics 7. GROUPING Operators in SQL 8. OLAP Operators in SQL 9. Cubes 10. Data Quality 11. Correlation 12. Distributions 13. Market Baskets 14. Decision and Regression Trees 15. Computer Intensive Analysis 16. Relationship Analytics 17. Database Architectures

商品描述(中文翻譯)

描述

在SQL程序員開始使用OLTP(在線事務處理)系統之前,他們必須先放棄過程性、以記錄為導向的編程,然後轉向SQL的聲明性、以集合為導向的編程。本書涵蓋了您成長的下一步。OLAP(在線分析處理)、數據倉儲和分析涉及將數據視為整體和隨時間變化,而不是單個交易。再次,是時候放棄您之前所學的知識。本書不是對特定主題的深入研究,而是對許多主題的概述,將為工作中的RDBMS程序員提供一張未知領域的地圖,如果他們想要成長的話。

目錄

0. 簡介
1. 基本報表和歷史
2. 交叉表
3. 星型和雪花模式
4. 數據遷移
5. MERGE語句
6. OLAP基礎知識
7. SQL中的GROUPING運算符
8. SQL中的OLAP運算符
9. 立方體
10. 數據質量
11. 相關性
12. 分佈
13. 市場籃子
14. 決策和回歸樹
15. 計算密集型分析
16. 關係分析
17. 數據庫架構