Joe Celko's analytics and OLAP in SQL /
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...
| Основен автор: | Celko, Joe. |
|---|---|
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
San Francisco, Calif. : Oxford :
Morgan Kaufmann ; Elsevier Science [distributor],
2006.
|
| Серия: |
Morgan Kaufmann series in data management systems.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=195632 |
| Подобни документи: |
Print version::
Joe Celko's analytics and OLAP in SQL. |
Съдържание:
- 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.