| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910823297803321 |
|
|
Autore |
Ślipiński Stanisław Adam |
|
|
Titolo |
Australian longhorn beetles (Coleoptera, Cerambycidae) . Volume 2 Subfamily Cerambycinae / / Adam Ślipiński & Hermes E. Escalona |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Victoria, Australia : , : CSIRO Publishing, , 2016 |
|
©2016 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-4863-0460-5 |
1-4863-0459-1 |
|
|
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (640 pages) : color illustrations, photographs |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Beetles - Australia |
Cerambycidae - Australia |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references and index. |
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Record Nr. |
UNINA9910808119903321 |
|
|
Autore |
Linoff Gordon S. |
|
|
Titolo |
Data analysis using SQL and Excel / / Gordon S. Linoff |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Indianapolis, Indiana : , : Wiley, , 2016 |
|
©2016 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-119-02144-8 |
1-119-18341-3 |
1-119-02145-6 |
|
|
|
|
|
|
|
|
Edizione |
[Second edition.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (795 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
Querying (Computer science) |
Data mining |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Data Analysis Using SQL and Excel®; About the Author; Credits; Acknowledgments; Contents at a Glance; Contents; Foreword; Introduction; Chapter 1 A Data Miner Looks at SQL; Databases, SQL, and Big Data; What Is Big Data?; Relational Databases; Hadoop and Hive; NoSQL and Other Types of Databases; SQL; Picturing the Structure of the Data; What Is a Data Model?; What Is a Table?; Allowing NULL Values; Column Types; What Is an Entity-Relationship Diagram?; The Zip Code Tables; Subscription Dataset; Purchases Dataset; Tips on Naming Things; Picturing Data Analysis Using Dataflows |
What Is a Dataflow? READ: Reading a Database Table; OUTPUT: Outputting a Table (or Chart); SELECT: Selecting Various Columns in the Table; FILTER: Filtering Rows Based on a Condition; APPEND: Appending New Calculated Columns; UNION: Combining Multiple Datasets into One; AGGREGATE: Aggregating Values; LOOKUP: Looking Up Values in One Table in Another; CROSS JOIN: Generating the Cartesian Product of Two Tables; JOIN: Combining Two Tables Using a Key Column; SORT: Ordering the Results of a Dataset; Dataflows, SQL, and Relational Algebra; SQL Queries; What to Do, Not How to Do It |
The SELECT Statement A Basic SQL Query; A Basic Summary SQL Query; |
|
|
|
|
|
|
|
|
|
|
What It Means to Join Tables; Cross-Joins: The Most General Joins; Lookup: A Useful Join; Equijoins; Nonequijoins; Outer Joins; Other Important Capabilities in SQL; UNION ALL; CASE; IN; Window Functions; Subqueries and Common Table Expressions Are Our Friends; Subqueries for Naming Variables; Subqueries for Handling Summaries; Subqueries and IN; Rewriting the "IN" as a JOIN; Correlated Subqueries; NOT IN Operator; EXISTS and NOT EXISTS Operators; Subqueries for UNION ALL; Lessons Learned |
Chapter 2 What's in a Table? Getting Started with Data Exploration What Is Data Exploration?; Excel for Charting; A Basic Chart: Column Charts; Inserting the Data; Creating the Column Chart; Formatting the Column Chart; Bar Charts in Cells; Character-Based Bar Charts; Conditional Formatting-Based Bar Charts; Useful Variations on the Column Chart; A New Query; Side-by-Side Columns; Stacked Columns; Stacked and Normalized Columns; Number of Orders and Revenue; Other Types of Charts; Line Charts; Area Charts; X-Y Charts (Scatter Plots); Sparklines; What Values Are in the Columns?; Histograms |
Histograms of Counts Cumulative Histograms of Counts; Histograms (Frequencies) for Numeric Values; Ranges Based on the Number of Digits, Using Numeric Techniques; Ranges Based on the Number of Digits, Using String Techniques; More Refined Ranges: First Digit Plus Number of Digits; Breaking Numeric Values into Equal-Sized Groups; More Values to Explore-Min, Max, and Mode; Minimum and Maximum Values; The Most Common Value (Mode); Calculating Mode Using Basic SQL; Calculating Mode Using Window Functions; Exploring String Values; Histogram of Length; Strings Starting or Ending with Spaces |
Handling Upper- and Lowercase |
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
Record Nr. |
UNINA9911019297903321 |
|
|
Titolo |
Dynamics of environmental bioprocesses : modelling and simulation / / Jonathan B. Snape ... [et al.] |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Weinheim ; ; New York, : VCH, c1995 |
|
|
|
|
|
|
|
ISBN |
|
9786611758646 |
9781281758644 |
1281758647 |
9783527615391 |
3527615393 |
9783527615384 |
3527615385 |
|
|
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (524 p.) |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
628.168015118 |
628.5/01/5118 |
628.5015118 |
|
|
|
|
|
|
|
|
Soggetti |
|
Bioremediation - Mathematical models |
Water - Pollution - Mathematical models |
Bioremediation - Computer simulation |
Water - Pollution - Computer simulation |
|
|
|
|
|
|
|
|
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 |
|
Dynamics of Environmental Bioprocesses; Preface; Organisation of the Book; ISIM Simulation Software; Acknowledgements; Table of Contents; Nomenclature for Chapters 1 and 2; 1 Modelling Principles; 1.1 The Role of Modelling in Environmental Technology; 1.2 General Aspects of the Modelling Approach; 1.3 Model Classification; 1.3.1 Deterministic Models; 1.3.2 Stochastic Models; 1.3.3 Steady-State Models; 1.3.4 Dynamic Models; 1.4 General Modelling Procedure; 1.5 Simulation Tools; 1.6 ISIM; 1.7 Introductory ISIM Example: WASTE; 1.8 Formulation of Dynamic Balance Equations |
1.8.1 Mass Balance Procedures1.8.1.1 Case A . Continuous Stirred-Tank Reactor; 1.8.1.2 Case B . Tubular Reactor; 1.8.1.3 Case C . River |
|
|
|
|
|
|
|
|
|
|
|
with Eddy Current; 1.8.1.4 Rate of Accumulation Term; 1.8.1.5 Convective Flow Terms; 1.8.1.6 Production Rate; 1.8.1.7 Diffusion of Components; 1.8.1.8 Interphase Transport; 1.8.1.9 Case A . Waste Holding Tank: Total and Component Mass Balance Example; 1.8.1.10 Case B . The Plug-Flow Tubular Reactor; 1.8.1.11 Case C . Biological Hazard Room; 1.8.1.12 Case D . Lake Pollution Problem; 1.8.2 Energy Balancing |
1.8.2.1 Case A . Determining Heat Transfer Area or Cooling Water Temperature1.8.2.2 Case B . Heating of a Filling Tank; 1.9 Chemical and Biological Reaction Systems; 1.9.1 Modes of Reactor Operation; 1.9.1.1 Batch Reactors; 1.9.1.2 Semi-Continuous or Fed-Batch Operation; 1.9.1.3 Continuous Operation; 1.9.2 Reaction Kinetics; 1.9.2.1 Chemical Kinetics; 1.9.2.2 Biological Reaction Kinetics; 1.9.2.3 Simple Microbial Growth Kinetics; 1.9.2.4 Substrate Uptake Kinetics; 1.9.2.5 Substrate Inhibition of Growth; 1.9.2.6 Additional Forms of Inhibition; 1.9.2.7 Other Expressions for Specific Growth Rate |
1.9.2.8 Multiple-Substrate Kinetics1.9.2.9 Structured Kinetic Models; 1.9.2.10 Interacting Micro-Organisms; 1.10 Modelling of Bioreactor Systems; 1.10.1 Stirred Tank Reactors; 1.10.2 Modelling Tubular Plug-Flow Reactor Behaviour; 1.10.2.1 Steady-State Balancing; 1.10.2.2 Unsteady-State Balancing; 1.11 Mass Transfer Theory; 1.11.1 Phase Equilibria; 1.11.2 Interphase Mass Transfer; 1.11.2.1 Case A . Steady-State Tubular and Column Modelling; 1.11.3 Case Studies; 1.11.3.1 Case A . Aeration of a Tank of Water; 1.11.3.2 Case B . Biological Oxidation in an Aerated Tank |
1.11.3.3 Case C . Determination of Biological Oxygen Uptake Rates by a Dynamic Method1.11.4 Gas-Liquid Phase Transfer Across a Free Surface; 1.12 Diffusion and Biological Reaction in Solid Phase Biosystems; 1.12.1 External Mass Transfer; 1.12.2 Finite Difference Model for Internal Transfer; 1.12.3 Case Studies for Diffusion with Biological Reaction; 1.12.3.1 Case A . Estimation of Oxygen Diffusion Effects in a Biofilm; 1.12.3.2 Case B . Biofilm Nitrification; 1.13 Process Control; 1.14 Optimisation. Parameter Estimation and Sensitivity Analysis |
1.14.1 Case A . Estimation of Bioreaction Kinetic Parameters for Batch Degradation Using ESL and SIMUSOLV |
|
|
|
|
|
|
Sommario/riassunto |
|
Dynamic environmental processes are complex; the easiest and most effective way to understanding them lies through the disciplines of dynamic modelling and computer simulation.The prerequisite modelling fundamentals are presented in the first chapter in a manner comprehensible to students as well as to practising scientists and engineers. The second chapter describes the many environmental processes that lend themselves to modelling, for example pollution and wastewater treatment. The third part of the book provides 65 simulation examples both on the page and on an accompanying diskett |
|
|
|
|
|
|
|
| |