top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.

Biblioteca

MARC Lista (tabellare)
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
Edizione [1st edition]
Pubbl/distr/stampa San Francisco, Calif., : Morgan Kaufmann, c2006
Descrizione fisica 1 online resource (205 p.)
Disciplina 005.7585
Collana The Morgan Kaufmann series in data management systems
Soggetto topico OLAP technology
SQL (Computer program language)
Soggetto genere / forma Electronic books.
ISBN 1-281-01197-5
9786611011970
0-08-049593-1
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Joe Celko's Analytics and OLAP in SOL; Copyright Page; Contents; Introduction; Beyond Queries; Some of the Differences between OLAP and OLTP; Corrections and Additionsx; Chapter 1. Basic Reports and History; 1.1 Cases; 1.2 Control-Break Reports; 1.3 Cross-Tabulation Reports; 1.4 Presentation Graphics; 1.5 Local Databases; Chapter 2. Cross-Tabulations; 2.1 Crosstabs by Cross-Join; 2.2 Crosstabs by Outer Joins; 2.3 Crosstabs by Subquery; 2.4 Crosstabs by CASE Expression; 2.5 Crosstabs with Row and Column Summaries; Chapter 3. Dimension Tables; 3.1 Star and Snowflake Schemas
3.2 Kinds of Dimensions3.3 Calendars and Temporal Data; 3.4 Helper Tables; 3.5 Surrogate Keys; 3.6 Degenerate Dimensions; Chapter 4. Data Migration and Scrubbing; 4.1 Pumping Data; 4.2 Verification and Validation; 4.3 Extract, Transform, and Load (ETL); 4.4 Databases Also Evolved; 4.5 Data Warehouses; 4.6 Extract, Load, and then Transform (E-L-T); 4.7 Scrubbing Data with Non-First-Normal-Form (1NF) Tables; Chapter 5. MERGE Statement; 5.1 Simple MERGE Statement; 5.2 Merging without the MERGE Statement; 5.3 TRIGGERs and MERGE; 5.4 Self-Referencing MERGE; Chapter 6. OLAP Basics; 6.1 Cubes
6.2 Dr. Codd's OLAP Rules6.3 MOLAP; 6.4 ROLAP; 6.5 HOLAP; 6.6 OLAP Query Languages; Chapter 7. GROUPING Operators; 7.1 GROUP BY GROUPING SET; 7.2 ROLLUP; 7.3 CUBES; 7.4 Notes about Usage; Chapter 8. OLAP Operators in SQL; 8.1 OLAP Functionality; 8.2 NTILE(); 8.3 Nesting OLAP functions; 8.4 Sample Queries; Chapter 9. Sparseness in Cubes; 9.1 Hypercube; 9.2 Dimensional Hierarchies; 9.3 Drilling and Slicing; Chapter 10. Data Quality; 10.1 Checking Columns for Value Counts; 10.2 Finding Rules in a Schema; 10.3 Feedback for Data Quality; 10.4 Further Reading; Chapter 11. Correlation
11.1 Causes and Correlation11.2 Linear Correlation; 11.3 Nesting Functions; 11.4 Further Reading; Chapter 12. Data Distributions; 12.1 Flat Distribution; 12.2 Zipfian Distribution; 12.3 Gaussian, Normal, or Bell Curve; 12.4 Poisson Distribution; 12.5 Logistic or "S" Distribution; 12.6 Pareto Distribution; 12.7 Distribution Discovery; 12.8 References; Chapter 13. Market-Basket Analysis; 13.1 Simple Example of a Market Basket; 13.2 Relational Division; 13.3 Romney's Division; 13.4 How to Use Relational Divisions; Chapter 14. Decision, Classification, and Regression Trees; 14.1 Casual Caldistics
14.2 Decision and Correlation Trees14.3 Entropy; 14.4 Other Algorithms and Software; Chapter 15. Computer-Intensive Analysis; 15.1 Bootstraps; 15.2 Subgroups; 15.3 Bayesian Analysis; 15.4 Clustering; Chapter 16. Relationship Analytics; 16.1 Adjacency List Model for General Graphs; 16.2 Covering Paths Model for General Graphs; 16.3 Conclusion and Solution; 16.4 Further Reading; Chapter 17. Database Architectures; 17.1 Parallelism; 17.2 Hashing; 17.3 Bit Vector Indexes; 17.4 Streaming Databases; 17.5 Further Reading; Chapter 18. MDX from a SQL Viewpoint; 18.1 MDX SELECT Statement
18.2 Hierarchical Navigation
Altri titoli varianti Joe Celko's Analytics & OLAP in SQL
Analytics and OLAP in SQL
Record Nr. UNINA-9910458636803321
Celko Joe  
San Francisco, Calif., : Morgan Kaufmann, c2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
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
Edizione [1st edition]
Pubbl/distr/stampa San Francisco, Calif., : Morgan Kaufmann, c2006
Descrizione fisica 1 online resource (205 p.)
Disciplina 005.7585
Collana The Morgan Kaufmann series in data management systems
Soggetto topico OLAP technology
SQL (Computer program language)
ISBN 1-281-01197-5
9786611011970
0-08-049593-1
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Joe Celko's Analytics and OLAP in SOL; Copyright Page; Contents; Introduction; Beyond Queries; Some of the Differences between OLAP and OLTP; Corrections and Additionsx; Chapter 1. Basic Reports and History; 1.1 Cases; 1.2 Control-Break Reports; 1.3 Cross-Tabulation Reports; 1.4 Presentation Graphics; 1.5 Local Databases; Chapter 2. Cross-Tabulations; 2.1 Crosstabs by Cross-Join; 2.2 Crosstabs by Outer Joins; 2.3 Crosstabs by Subquery; 2.4 Crosstabs by CASE Expression; 2.5 Crosstabs with Row and Column Summaries; Chapter 3. Dimension Tables; 3.1 Star and Snowflake Schemas
3.2 Kinds of Dimensions3.3 Calendars and Temporal Data; 3.4 Helper Tables; 3.5 Surrogate Keys; 3.6 Degenerate Dimensions; Chapter 4. Data Migration and Scrubbing; 4.1 Pumping Data; 4.2 Verification and Validation; 4.3 Extract, Transform, and Load (ETL); 4.4 Databases Also Evolved; 4.5 Data Warehouses; 4.6 Extract, Load, and then Transform (E-L-T); 4.7 Scrubbing Data with Non-First-Normal-Form (1NF) Tables; Chapter 5. MERGE Statement; 5.1 Simple MERGE Statement; 5.2 Merging without the MERGE Statement; 5.3 TRIGGERs and MERGE; 5.4 Self-Referencing MERGE; Chapter 6. OLAP Basics; 6.1 Cubes
6.2 Dr. Codd's OLAP Rules6.3 MOLAP; 6.4 ROLAP; 6.5 HOLAP; 6.6 OLAP Query Languages; Chapter 7. GROUPING Operators; 7.1 GROUP BY GROUPING SET; 7.2 ROLLUP; 7.3 CUBES; 7.4 Notes about Usage; Chapter 8. OLAP Operators in SQL; 8.1 OLAP Functionality; 8.2 NTILE(); 8.3 Nesting OLAP functions; 8.4 Sample Queries; Chapter 9. Sparseness in Cubes; 9.1 Hypercube; 9.2 Dimensional Hierarchies; 9.3 Drilling and Slicing; Chapter 10. Data Quality; 10.1 Checking Columns for Value Counts; 10.2 Finding Rules in a Schema; 10.3 Feedback for Data Quality; 10.4 Further Reading; Chapter 11. Correlation
11.1 Causes and Correlation11.2 Linear Correlation; 11.3 Nesting Functions; 11.4 Further Reading; Chapter 12. Data Distributions; 12.1 Flat Distribution; 12.2 Zipfian Distribution; 12.3 Gaussian, Normal, or Bell Curve; 12.4 Poisson Distribution; 12.5 Logistic or "S" Distribution; 12.6 Pareto Distribution; 12.7 Distribution Discovery; 12.8 References; Chapter 13. Market-Basket Analysis; 13.1 Simple Example of a Market Basket; 13.2 Relational Division; 13.3 Romney's Division; 13.4 How to Use Relational Divisions; Chapter 14. Decision, Classification, and Regression Trees; 14.1 Casual Caldistics
14.2 Decision and Correlation Trees14.3 Entropy; 14.4 Other Algorithms and Software; Chapter 15. Computer-Intensive Analysis; 15.1 Bootstraps; 15.2 Subgroups; 15.3 Bayesian Analysis; 15.4 Clustering; Chapter 16. Relationship Analytics; 16.1 Adjacency List Model for General Graphs; 16.2 Covering Paths Model for General Graphs; 16.3 Conclusion and Solution; 16.4 Further Reading; Chapter 17. Database Architectures; 17.1 Parallelism; 17.2 Hashing; 17.3 Bit Vector Indexes; 17.4 Streaming Databases; 17.5 Further Reading; Chapter 18. MDX from a SQL Viewpoint; 18.1 MDX SELECT Statement
18.2 Hierarchical Navigation
Altri titoli varianti Joe Celko's Analytics & OLAP in SQL
Analytics and OLAP in SQL
Record Nr. UNINA-9910784650703321
Celko Joe  
San Francisco, Calif., : Morgan Kaufmann, c2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui