Joe Celko's analytics and OLAP in SQL [electronic resource] / Joe Celko
| Joe Celko's analytics and OLAP in SQL [electronic resource] / Joe Celko |
| Autore | Celko, Joe. |
| Pubbl/distr/stampa | San Francisco, Calif. : Morgan Kaufmann |
| Descrizione fisica | xx, 181 p. |
| Disciplina | 005.7585 |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
SQL (Computer program language)
OLAP technology SQL (Langage de programmation) OLAP, Technologie |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9780123695123
0123695120 |
| Formato | Risorse elettroniche |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction -- Chapter 1: Basic Reports & History -- Chapter 2: Crosstabs -- Chapter 3: Star and Snowflake Schemas -- Chapter 4: Data Migration -- Chapter 5: MERGE Statement -- Chapter 6: OLAP Basics -- Chapter 7: GROUPING Operators in SQL -- Chapter 8: OLAP Operators in SQL -- Chapter 9: Cubes -- Chapter 10: Data Quality -- Chapter 11: Correlation -- Chapter 12: Distributions -- Chapter 13: Market Baskets -- Chapter 14: Decision and Regression Trees -- Chapter 15: Computer Intensive Analysis -- Chapter 16: Relationship Analytics -- Chapter 17: Database Architectures. |
| Altri titoli varianti | Data warehouse and analytical queries in SQL |
| Record Nr. | UNISALENTO-991003244059707536 |
Celko, Joe.
|
||
| San Francisco, Calif. : Morgan Kaufmann | ||
| Lo trovi qui: Univ. del Salento | ||
| ||
SQL:1999 [electronic resource] : understanding relational language components / Jim Melton, Alan R. Simon
| SQL:1999 [electronic resource] : understanding relational language components / Jim Melton, Alan R. Simon |
| Autore | Melton, Jim, 1946- |
| Pubbl/distr/stampa | San Francisco, Calif. ; London : Morgan Kaufmann, c2002 |
| Descrizione fisica | xxxii, 893 p. : ill. ; 24 cm. |
| Disciplina | 005.7565 |
| Altri autori (Persone) | Simon, Alan R. |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
SQL (Computer program language)
Database management Bases de données relationnelles SQL (Langage de programmation) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9781558604568
1558604561 |
| Formato | Risorse elettroniche |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Preface -- Chapter 1 - Database and Technology Foundations -- Chapter 2 - Introduction to SQL:1999 -- Chapter 3 - Basic Table Creation and Data Manipulation -- Chapter 4 - Basic Data Definition Language -- Chapter 5 - Values, Basic Functions and Expressions -- Chapter 6 - Advanced Value Expressions -- Chapter 7 - Predicates -- Chapter 8 - Working with Multiple Tables -- Chapter 9 - Advanced SQL Query Expressions -- Chapter 10 - Constraints, Assertions, and Referential Integrity -- Chapter 11 - Active Databases -- Chapter 12 - Accessing SQL From the Real World -- Chapter 13 - Cursors -- Chapter 14 - Privileges, Users, and Security -- Chapter 15 - Transaction Management -- Chapter 16 - Connections and Remote Database Access -- Chapter 17 - Routines and Routine Invocations -- Chapter 18 - Dynamic SQL: 1999 -- Chapter 19 - Call-Level Interface -- Chapter 20 - Diagnostics and Error Management -- Chapter 21 - Internationalization Aspects of SQL: 1999 -- Chapter 22 - Information Schema -- Chapter 23 - A Look to the Future -- Appendix A - Designing SQL:1999 Databases -- Appendix B - An SQL:1999 Application Example -- Appendix C - The SQL:1999 Annexes -- Appendix D - Relevant Standards Bodies -- Appendix E - Status Codes -- Appendix F - The SQL Standardization Process. |
| Record Nr. | UNISALENTO-991003248059707536 |
Melton, Jim, 1946-
|
||
| San Francisco, Calif. ; London : Morgan Kaufmann, c2002 | ||
| Lo trovi qui: Univ. del Salento | ||
| ||