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 ;
2006.
|
| Σειρά: |
Morgan Kaufmann series in data management systems.
|
| Θέματα: | |
| Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9780123695123 |
| Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
Πίνακας περιεχομένων:
- 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.