| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910458636803321 |
|
|
Autore |
Celko Joe |
|
|
Titolo |
Joe Celko's analytics and OLAP in SQL [[electronic resource] /] / Joe Celko |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
San Francisco, Calif., : Morgan Kaufmann, c2006 |
|
|
|
|
|
|
|
ISBN |
|
1-281-01197-5 |
9786611011970 |
0-08-049593-1 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (205 p.) |
|
|
|
|
|
|
Collana |
|
The Morgan Kaufmann series in data management systems |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
OLAP technology |
SQL (Computer program language) |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
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 |
|
|
|
|
|
|
Sommario/riassunto |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Record Nr. |
UNINA9910454972903321 |
|
|
Autore |
Burgess Christopher |
|
|
Titolo |
Valid analytical methods and procedures [[electronic resource] /] / Christopher Burgess |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Cambridge, : Royal Society of Chemistry, 2000 |
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (98 p.) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Chemistry, Analytic - Methodology |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
Description based upon print version of record. |
|
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references and index. |
|
|
|
|
|
|
Nota di contenuto |
|
BK9780854044825-FX001; BK9780854044825-FP001; BK9780854044825-FP005; BK9780854044825-FP007; BK9780854044825-00001; BK9780854044825-00015; BK9780854044825-00083 |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
The Analytical Methods Committee of the Royal Society of Chemistry has for many years been involved in national and international efforts to establish a comprehensive framework for achieving appropriate quality in chemical measurement.This handbook attempts to select or define robust procedures that ensure the best use of resources and enable laboratories to generate consistent, reliable data. Written in concise, easy-to-read language and illustrated with worked examples, it is a guide to current best practice and establishes a control framework for the development and validation of laboratory |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
Record Nr. |
UNINA9910795052003321 |
|
|
Autore |
Krotz Larry |
|
|
Titolo |
Diagnosing the legacy : the discovery, research, and treatment of type 2 diabetes in Indigenous youth / / Larry Krotz |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Winnipeg, Manitoba, Canada : , : University of Manitoba Press, , [2018] |
|
©2018 |
|
|
|
|
|
|
|
|
|
ISBN |
|
0-88755-558-6 |
0-88755-560-8 |
|
|
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (192 pages) |
|
|
|
|
|
|
Classificazione |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Type 2 diabetes - Manitoba |
Diabetes in children - Manitoba |
Indian youth - Diseases - Manitoba |
Manitoba epidemiology |
Manitoba |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Nota di contenuto |
|
Foreword by Francis Desjarlais; Chapter 1: Early Alarm; Chapter 2: The First Patients of a New Disease; Chapter 3: Emerging Responses; Chapter 4: Island Lake; Chapter 5: Early Research, Innovations, and Strategies for Care; Chapter 6: Investigation and Hypotheses; Chapter 7: After the Deluge; Chapter 8: Revisiting Roots; Chapter 9: Food; Chapter 10: Poverty and Disease; Chapter 11: Partnerships and Participation; Chapter 12: Hopes and Dreams; Epilogue: Island Lake Encore. |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
In the late 1980s, pediatric endocrinologists at the Children's Hospital in Winnipeg began to notice a new cohort appearing in their clinics for young people with diabetes. Through dozens of interviews, Krotz shows the impact of the disease on the lives of individuals and families, especially in communities far removed from the medical personnel and facilities available in the city. |
|
|
|
|
|
|
|
| |