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
Joe Celko's sql for smarties : advanced sql programming / / Joe Celko
Joe Celko's sql for smarties : advanced sql programming / / Joe Celko
Autore Celko Joe
Edizione [Fifth edition.]
Pubbl/distr/stampa Waltham, Massachusetts : , : Morgan Kaufmann, , 2015
Descrizione fisica 1 online resource (853 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann Series in Data Management Systems
Soggetto topico SQL (Computer program language)
ISBN 0-12-800830-X
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Joe Celko's sql for Smarties: Advanced sql Programming; Copyright; Dedication; Contents; Introduction to the Fifth Edition; What is New in this Edition; Corrections and Additions; Part 1: Data Declaration Features; Chapter 1: Databases Versus File Systems; 1.1. The Schema Statement; 1.2. Tables as Entities; 1.3. Tables as Relationships; 1.3.1. E-R Diagrams; 1.4. Rows Versus Records; 1.5. Columns Versus Fields; Chapter 2: Transactions and Concurrency Control; 2.1. Sessions; 2.2. Transactions and ACID ; 2.3. Concurrency Control; 2.3.1. The Transaction Phenomena
2.4. The Isolation Levels2.5. Pessimistic Concurrency Control; 2.6. Snapshot Isolation Optimistic Concurrency; 2.7. Logical Concurrency Control; 2.8. Cap Theorem; 2.9. Base; 2.10. Server-Side Consistency; 2.11. Error Handling; 2.12. Deadlock and Livelocks; Chapter 3: Tables; 3.1. Create Table Statements; 3.1.1. Base Tables; 3.1.2. [ Global | Local ] Temporary Tables; 3.2. Column Definitions; 3.2.1. DEFAULT Clause; 3.2.2. NOT NULL Constraint; 3.2.3. CHECK () Constraint; 3.2.4. UNIQUE and PRIMARY KEY Constraints; 3.2.5. REFERENCES Clause; 3.2.6. Referential Actions
3.2.6.1. Nested UNIQUE Constraints3.2.6.2. Overlapping Keys; 3.3. Computed Columns; 3.4. [ NOT ] DEFERRABLE Constraints; 3.5. CREATE DOMAIN and CREATE SEQUENCE ; 3.5.1. CREATE DOMAIN ; 3.5.2. CREATE SEQUENCE ; 3.5.2.1. Using the SEQUENCE ; 3.6. Character Set Related Constructs; 3.6.1. CREATE CHARACTER SET ; 3.6.2. CREATE COLLATION ; 3.6.3. CREATE TRANSLATION ; Chapter 4: Keys, Locators, and Generated Values; 4.1. Key Types; 4.1.1. Natural Keys; 4.1.2. Artificial Keys; 4.1.3. Exposed Physical Locators; 4.2. Practical Hints for Denormalization; 4.2.1. Row Sorting; Chapter 5: Normalization
5.1. Functional and Multivalued Dependencies5.2. First Normal Form (1NF); 5.2.1. Note on Repeating Groups; 5.2.1.1. Repeating Columns; 5.2.1.2. Parsing a List in a String; 5.3. Second Normal Form (2NF); 5.4. Third Normal Form (3NF); 5.5. Elementary Key Normal Form (EKNF); 5.6. Boyce-Codd Normal Form (BCNF); 5.7. Fourth Normal Form (4NF); 5.8. Fifth Normal Form (5NF); 5.9. Domain-Key Normal Form (DKNF); 5.10. Practical Hints for Normalization; 5.11. Non-Normal Form Redundancy; 5.11.1. Aggregation Level Redundancy; 5.11.2. Entire Table Redundancy; 5.11.3. Access Path Redundancy
5.11.4. Attribute SplittingChapter 6: VIEWs, Derived, and Other Virtual Tables; 6.1. VIEWs in Queries; 6.2. Updatable and Read-Only VIEWs; 6.3. Types of VIEWs; 6.3.1. Single-Table Projection and Restriction; 6.3.2. Calculated Columns; 6.3.3. Translated Columns; 6.3.4. Grouped VIEWs; 6.3.5. UNION-ed VIEWs; 6.3.6. JOINs in VIEWs; 6.3.7. Nested VIEWs; 6.4. How VIEWs are Handled in the Database Engine; 6.4.1. View Column List; 6.4.2. VIEW Materialization; 6.4.3. In-Line Text Expansion; 6.4.4. Pointer Structures; 6.4.5. Indexing and Views; 6.5. WITH CHECK OPTION Clause
6.5.1. WITH CHECK OPTION as CHECK() clause
Record Nr. UNINA-9910788810103321
Celko Joe  
Waltham, Massachusetts : , : Morgan Kaufmann, , 2015
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's sql for smarties : advanced sql programming / / Joe Celko
Joe Celko's sql for smarties : advanced sql programming / / Joe Celko
Autore Celko Joe
Edizione [Fifth edition.]
Pubbl/distr/stampa Waltham, Massachusetts : , : Morgan Kaufmann, , 2015
Descrizione fisica 1 online resource (853 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann Series in Data Management Systems
Soggetto topico SQL (Computer program language)
ISBN 0-12-800830-X
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Joe Celko's sql for Smarties: Advanced sql Programming; Copyright; Dedication; Contents; Introduction to the Fifth Edition; What is New in this Edition; Corrections and Additions; Part 1: Data Declaration Features; Chapter 1: Databases Versus File Systems; 1.1. The Schema Statement; 1.2. Tables as Entities; 1.3. Tables as Relationships; 1.3.1. E-R Diagrams; 1.4. Rows Versus Records; 1.5. Columns Versus Fields; Chapter 2: Transactions and Concurrency Control; 2.1. Sessions; 2.2. Transactions and ACID ; 2.3. Concurrency Control; 2.3.1. The Transaction Phenomena
2.4. The Isolation Levels2.5. Pessimistic Concurrency Control; 2.6. Snapshot Isolation Optimistic Concurrency; 2.7. Logical Concurrency Control; 2.8. Cap Theorem; 2.9. Base; 2.10. Server-Side Consistency; 2.11. Error Handling; 2.12. Deadlock and Livelocks; Chapter 3: Tables; 3.1. Create Table Statements; 3.1.1. Base Tables; 3.1.2. [ Global | Local ] Temporary Tables; 3.2. Column Definitions; 3.2.1. DEFAULT Clause; 3.2.2. NOT NULL Constraint; 3.2.3. CHECK () Constraint; 3.2.4. UNIQUE and PRIMARY KEY Constraints; 3.2.5. REFERENCES Clause; 3.2.6. Referential Actions
3.2.6.1. Nested UNIQUE Constraints3.2.6.2. Overlapping Keys; 3.3. Computed Columns; 3.4. [ NOT ] DEFERRABLE Constraints; 3.5. CREATE DOMAIN and CREATE SEQUENCE ; 3.5.1. CREATE DOMAIN ; 3.5.2. CREATE SEQUENCE ; 3.5.2.1. Using the SEQUENCE ; 3.6. Character Set Related Constructs; 3.6.1. CREATE CHARACTER SET ; 3.6.2. CREATE COLLATION ; 3.6.3. CREATE TRANSLATION ; Chapter 4: Keys, Locators, and Generated Values; 4.1. Key Types; 4.1.1. Natural Keys; 4.1.2. Artificial Keys; 4.1.3. Exposed Physical Locators; 4.2. Practical Hints for Denormalization; 4.2.1. Row Sorting; Chapter 5: Normalization
5.1. Functional and Multivalued Dependencies5.2. First Normal Form (1NF); 5.2.1. Note on Repeating Groups; 5.2.1.1. Repeating Columns; 5.2.1.2. Parsing a List in a String; 5.3. Second Normal Form (2NF); 5.4. Third Normal Form (3NF); 5.5. Elementary Key Normal Form (EKNF); 5.6. Boyce-Codd Normal Form (BCNF); 5.7. Fourth Normal Form (4NF); 5.8. Fifth Normal Form (5NF); 5.9. Domain-Key Normal Form (DKNF); 5.10. Practical Hints for Normalization; 5.11. Non-Normal Form Redundancy; 5.11.1. Aggregation Level Redundancy; 5.11.2. Entire Table Redundancy; 5.11.3. Access Path Redundancy
5.11.4. Attribute SplittingChapter 6: VIEWs, Derived, and Other Virtual Tables; 6.1. VIEWs in Queries; 6.2. Updatable and Read-Only VIEWs; 6.3. Types of VIEWs; 6.3.1. Single-Table Projection and Restriction; 6.3.2. Calculated Columns; 6.3.3. Translated Columns; 6.3.4. Grouped VIEWs; 6.3.5. UNION-ed VIEWs; 6.3.6. JOINs in VIEWs; 6.3.7. Nested VIEWs; 6.4. How VIEWs are Handled in the Database Engine; 6.4.1. View Column List; 6.4.2. VIEW Materialization; 6.4.3. In-Line Text Expansion; 6.4.4. Pointer Structures; 6.4.5. Indexing and Views; 6.5. WITH CHECK OPTION Clause
6.5.1. WITH CHECK OPTION as CHECK() clause
Record Nr. UNINA-9910825350403321
Celko Joe  
Waltham, Massachusetts : , : Morgan Kaufmann, , 2015
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Autore Celko Joe
Edizione [4th ed.]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Elsevier, 2010
Descrizione fisica 1 online resource (817 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann series in data management systems
Soggetto topico SQL (Computer program language)
Database design
Soggetto genere / forma Electronic books.
ISBN 1-282-87957-X
9786612879579
0-12-382023-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Series page; Joe Celko's SQL for Smarties; Copyright; Dedication; Table of Contents; About the Author; Introduction to the Fourth Edition; Chapter 1. Databases versus File Systems; 1.1 Tables as Entities; 1.2 Tables as Relationships; 1.3 Rows versus Records; 1.4 Columns versus Fields; 1.5 Schema Objects; 1.6 CREATE SCHEMA Statement; Chapter 2. Transactions and Concurrency Control; 2.1 Sessions; 2.2 Transactions and ACID; 2.3 Concurrency Control; 2.4 Pessimistic Concurrency Control; 2.5 SNAPSHOT Isolation and Optimistic Concurrency; 2.6 Logical Concurrency Control
2.7 Deadlock and LivelocksChapter 3. Schema Level Objects; 3.1 CREATE SCHEMA Statement; 3.2 CREATE PROCEDURE, CREATE FUNCTION, and CREATE TRIGGER; 3.3 CREATE DOMAIN Statement; 3.4 CREATE SEQUENCE; 3.5 CREATE ASSERTION; 3.6 Character Set Related Constructs; Chapter 4. Locating Data and Special Numbers; 4.1 Exposed Physical Locators; 4.2 Generated Identifiers; 4.3 Sequence Generator Functions; 4.4 Preallocated Values; 4.5 Special Series; Chapter 5. Base Tables and Related Elements; 5.1 CREATE TABLE Statement; 5.2 Nested UNIQUE Constraints; 5.3 CREATE ASSERTION Constraints; 5.4 TEMPORARY Tables
5.5 Manipulating Tables5.6 Avoiding Attribute Splitting; 5.7 Modeling Class Hierarchies in DDL; 5.8 Exposed Physical Locators; 5.9 Auto-Incrementing Columns; 5.10 Generated Identifiers; 5.11 A Remark on Duplicate Rows; 5.12 Other Schema Objects; 5.13 Temporary Tables; 5.14 CREATE DOMAIN Statement; 5.15 CREATE TRIGGER Statement; 5.16 CREATE PROCEDURE Statement; 5.17 DECLARE CURSOR Statement; Chapter 6. Procedural, Semiprocedural, and Declarative Programming; 6.1 Basics of Software Engineering; 6.2 Cohesion; 6.3 Coupling; 6.4 The Big Leap; 6.5 Rewriting Tricks; 6.6 Functions for Predicates
6.7 Procedural versus Logical DecompositionChapter 7. Procedural Constructs; 7.1 CREATE PROCEDURE; 7.2 CREATE TRIGGER; 7.3 CURSORs; 7.4 SEQUENCEs; 7.5 Generated Columns; 7.6 Table Functions; Chapter 8. Auxiliary Tables; 8.1 The Series Table; 8.2 Lookup Auxiliary Tables; 8.3 Auxiliary Function Tables; 8.4 Global Constants Tables; 8.5 A Note on Converting Procedural Code to Tables; Chapter 9. Normalization; 9.1 Functional and Multivalued Dependencies; 9.2 First Normal Form (1NF); 9.3 Second Normal Form (2NF); 9.4 Third Normal Form (3NF); 9.5 Elementary Key Normal Form (EKNF)
9.6 Boyce-Codd Normal Form (BCNF)9.7 Fourth Normal Form (4NF); 9.8 Fifth Normal Form (5NF); 9.9 Domain-Key Normal Form (DKNF); 9.10 Practical Hints for Normalization; 9.11 Key Types; 9.12 Practical Hints for Denormalization; Chapter 10. Numeric Data Types; 10.1 Numeric Types; 10.2 Numeric Type Conversion; 10.3 Four Function Arithmetic; 10.4 Arithmetic and NULLs; 10.5 Converting Values to and from NULL; 10.6 Mathematical Functions; 10.7 Unique Value Generators; 10.8 IP Addresses; Chapter 11. Temporal Data Types; 11.1 Notes on Calendar Standards; 11.2 SQL Temporal Data Types
11.3 INTERVAL Data Types
Record Nr. UNINA-9910459503703321
Celko Joe  
Amsterdam ; ; Boston, : Elsevier, 2010
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Autore Celko Joe
Edizione [4th ed.]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Elsevier, 2010
Descrizione fisica 1 online resource (817 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann series in data management systems
Soggetto topico SQL (Computer program language)
Database design
ISBN 1-282-87957-X
9786612879579
0-12-382023-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover; Series page; Joe Celko's SQL for Smarties; Copyright; Dedication; Table of Contents; About the Author; Introduction to the Fourth Edition; Chapter 1. Databases versus File Systems; 1.1 Tables as Entities; 1.2 Tables as Relationships; 1.3 Rows versus Records; 1.4 Columns versus Fields; 1.5 Schema Objects; 1.6 CREATE SCHEMA Statement; Chapter 2. Transactions and Concurrency Control; 2.1 Sessions; 2.2 Transactions and ACID; 2.3 Concurrency Control; 2.4 Pessimistic Concurrency Control; 2.5 SNAPSHOT Isolation and Optimistic Concurrency; 2.6 Logical Concurrency Control
2.7 Deadlock and LivelocksChapter 3. Schema Level Objects; 3.1 CREATE SCHEMA Statement; 3.2 CREATE PROCEDURE, CREATE FUNCTION, and CREATE TRIGGER; 3.3 CREATE DOMAIN Statement; 3.4 CREATE SEQUENCE; 3.5 CREATE ASSERTION; 3.6 Character Set Related Constructs; Chapter 4. Locating Data and Special Numbers; 4.1 Exposed Physical Locators; 4.2 Generated Identifiers; 4.3 Sequence Generator Functions; 4.4 Preallocated Values; 4.5 Special Series; Chapter 5. Base Tables and Related Elements; 5.1 CREATE TABLE Statement; 5.2 Nested UNIQUE Constraints; 5.3 CREATE ASSERTION Constraints; 5.4 TEMPORARY Tables
5.5 Manipulating Tables5.6 Avoiding Attribute Splitting; 5.7 Modeling Class Hierarchies in DDL; 5.8 Exposed Physical Locators; 5.9 Auto-Incrementing Columns; 5.10 Generated Identifiers; 5.11 A Remark on Duplicate Rows; 5.12 Other Schema Objects; 5.13 Temporary Tables; 5.14 CREATE DOMAIN Statement; 5.15 CREATE TRIGGER Statement; 5.16 CREATE PROCEDURE Statement; 5.17 DECLARE CURSOR Statement; Chapter 6. Procedural, Semiprocedural, and Declarative Programming; 6.1 Basics of Software Engineering; 6.2 Cohesion; 6.3 Coupling; 6.4 The Big Leap; 6.5 Rewriting Tricks; 6.6 Functions for Predicates
6.7 Procedural versus Logical DecompositionChapter 7. Procedural Constructs; 7.1 CREATE PROCEDURE; 7.2 CREATE TRIGGER; 7.3 CURSORs; 7.4 SEQUENCEs; 7.5 Generated Columns; 7.6 Table Functions; Chapter 8. Auxiliary Tables; 8.1 The Series Table; 8.2 Lookup Auxiliary Tables; 8.3 Auxiliary Function Tables; 8.4 Global Constants Tables; 8.5 A Note on Converting Procedural Code to Tables; Chapter 9. Normalization; 9.1 Functional and Multivalued Dependencies; 9.2 First Normal Form (1NF); 9.3 Second Normal Form (2NF); 9.4 Third Normal Form (3NF); 9.5 Elementary Key Normal Form (EKNF)
9.6 Boyce-Codd Normal Form (BCNF)9.7 Fourth Normal Form (4NF); 9.8 Fifth Normal Form (5NF); 9.9 Domain-Key Normal Form (DKNF); 9.10 Practical Hints for Normalization; 9.11 Key Types; 9.12 Practical Hints for Denormalization; Chapter 10. Numeric Data Types; 10.1 Numeric Types; 10.2 Numeric Type Conversion; 10.3 Four Function Arithmetic; 10.4 Arithmetic and NULLs; 10.5 Converting Values to and from NULL; 10.6 Mathematical Functions; 10.7 Unique Value Generators; 10.8 IP Addresses; Chapter 11. Temporal Data Types; 11.1 Notes on Calendar Standards; 11.2 SQL Temporal Data Types
11.3 INTERVAL Data Types
Record Nr. UNINA-9910785122803321
Celko Joe  
Amsterdam ; ; Boston, : Elsevier, 2010
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Autore Celko Joe
Edizione [3rd ed.]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Morgan Kaufmann, c2005
Descrizione fisica 1 online resource (839 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann series in data management systems
Soggetto topico SQL (Computer program language)
Soggetto genere / forma Electronic books.
ISBN 1-280-63348-4
9786610633487
0-08-046004-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto front cover; copyright; table of contents; front matter; Introduction to the Third Edition; 1.1 What Changed in Ten Years; 1.2 What Is New in This Edition; 1.3 Corrections and Additions; body; 1 Database Design; 1.1 Schema and Table Creation; 1.1.1 CREATE SCHEMA Statement; 1.1.2 Manipulating Tables; 1.1.3 Column Constraints; 1.1.4 UNIQUE Constraints versus UNIQUE Indexes; 1.1.5 Nested UNIQUE Constraints; 1.1.6 Overlapping Keys; 1.1.7 CREATE ASSERTION Constraints; 1.1.8 Using VIEWs for Schema Level Constraints; 1.1.9 Using PRIMARY KEYs and ASSERTIONs for Constraints
1.1.10 Avoiding Attribute Splitting1.1.11 Modeling Class Hierarchies in DDL; 1.2 Generating Unique Sequential Numbers for Keys; 1.2.1 IDENTITY Columns; 1.2.2 ROWID and Physical Disk Addresses; 1.2.3 Sequential Numbering in Pure SQL; 1.2.4 GUIDs; 1.2.5 Sequence Generator Functions; 1.2.6 Unique Value Generators; 1.2.7 Preallocated Values; 1.2.8 Random Order Values; 1.3 A Remark on Duplicate Rows; 1.4 Other Schema Objects; 1.4.1 Schema Tables; 1.4.2 Temporary Tables; 1.4.3 CREATE DOMAIN Statement; 1.4.4 CREATE TRIGGER Statement; 1.4.5 CREATE PROCEDURE Statement; 1.4.6 DECLARE CURSOR Statement
2 Normalization2.1 Functional and Multivalued Dependencies; 2.2 First Normal Form (1NF); 2.2.1 Note on Repeated Groups; 2.3 Second Normal Form (2NF); 2.4 Third Normal Form (3NF); 2.5 Elementary Key Normal Form (EKNF); 2.6 Boyce-Codd Normal Form (BCNF); 2.7 Fourth Normal Form (4NF); 2.8 Fifth Normal Form (5NF); 2.9 Domain-Key Normal Form (DKNF); 2.10 Practical Hints for Normalization; 2.11 Key Types; 2.11.1 Natural Keys; 2.11.2 Artificial Keys; 2.11.3 Exposed Physical Locators; 2.11.4 Practical Hints for Denormalization; 2.11.5 Row Sorting; 3 Numeric Data in SQL; 3.1 Numeric Types
3.1.1 BIT, BYTE, and BOOLEAN Data Types3.2 Numeric Type Conversion; 3.2.1 Rounding and Truncating; 3.2.2 CAST() Function; 3.3 Four-Function Arithmetic; 3.4 Arithmetic and NULLs; 3.5 Converting Values to and from NULL; 3.5.1 NULLIF() Function; 3.5.2 COALESCE() Function; 3.6 Vendor Math Functions; 3.6.1 Number Theory Operators; 3.6.2 Exponential Functions; 3.6.3 Scaling Functions; 3.6.4 Converting Numbers to Words; 4 Temporal Data Types in SQL; 4.1 Notes on Calendar Standards; 4.2 SQL Temporal Data Types; 4.2.1 Tips for Handling Dates, Timestamps, and Times; 4.2.2 Date Format Standards
4.2.3 Handling Timestamps4.2.4 Handling Times; 4.3 Queries with Date Arithmetic; 4.4 The Nature of Temporal Data Models; 4.4.1 Temporal Duplicates; 4.4.2 Temporal Databases; 4.4.3 Temporal Projection and Selection; 4.4.4 Temporal Joins; 4.4.5 Modifying Valid-Time State Tables; 4.4.6 Current Modifications; 4.4.7 Sequenced Modifications; 4.4.8 Nonsequenced Modifications; 4.4.9 Transaction-Time State Tables; 4.4.10 Maintaining the Audit Log; 4.4.11 Querying the Audit Log; 4.4.12 Modifying the Audit Log; 4.4.13 Bitemporal Tables; 4.4.14 Temporal Support in Standard SQL
5 Character Data Types in SQL
Altri titoli varianti SQL for smarties
Record Nr. UNINA-9910458957603321
Celko Joe  
Amsterdam ; ; Boston, : Morgan Kaufmann, c2005
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Joe Celko's SQL for smarties [[electronic resource] ] : advanced SQL programming / / Joe Celko
Autore Celko Joe
Edizione [3rd ed.]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Morgan Kaufmann, c2005
Descrizione fisica 1 online resource (839 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann series in data management systems
Soggetto topico SQL (Computer program language)
ISBN 1-280-63348-4
9786610633487
0-08-046004-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto front cover; copyright; table of contents; front matter; Introduction to the Third Edition; 1.1 What Changed in Ten Years; 1.2 What Is New in This Edition; 1.3 Corrections and Additions; body; 1 Database Design; 1.1 Schema and Table Creation; 1.1.1 CREATE SCHEMA Statement; 1.1.2 Manipulating Tables; 1.1.3 Column Constraints; 1.1.4 UNIQUE Constraints versus UNIQUE Indexes; 1.1.5 Nested UNIQUE Constraints; 1.1.6 Overlapping Keys; 1.1.7 CREATE ASSERTION Constraints; 1.1.8 Using VIEWs for Schema Level Constraints; 1.1.9 Using PRIMARY KEYs and ASSERTIONs for Constraints
1.1.10 Avoiding Attribute Splitting1.1.11 Modeling Class Hierarchies in DDL; 1.2 Generating Unique Sequential Numbers for Keys; 1.2.1 IDENTITY Columns; 1.2.2 ROWID and Physical Disk Addresses; 1.2.3 Sequential Numbering in Pure SQL; 1.2.4 GUIDs; 1.2.5 Sequence Generator Functions; 1.2.6 Unique Value Generators; 1.2.7 Preallocated Values; 1.2.8 Random Order Values; 1.3 A Remark on Duplicate Rows; 1.4 Other Schema Objects; 1.4.1 Schema Tables; 1.4.2 Temporary Tables; 1.4.3 CREATE DOMAIN Statement; 1.4.4 CREATE TRIGGER Statement; 1.4.5 CREATE PROCEDURE Statement; 1.4.6 DECLARE CURSOR Statement
2 Normalization2.1 Functional and Multivalued Dependencies; 2.2 First Normal Form (1NF); 2.2.1 Note on Repeated Groups; 2.3 Second Normal Form (2NF); 2.4 Third Normal Form (3NF); 2.5 Elementary Key Normal Form (EKNF); 2.6 Boyce-Codd Normal Form (BCNF); 2.7 Fourth Normal Form (4NF); 2.8 Fifth Normal Form (5NF); 2.9 Domain-Key Normal Form (DKNF); 2.10 Practical Hints for Normalization; 2.11 Key Types; 2.11.1 Natural Keys; 2.11.2 Artificial Keys; 2.11.3 Exposed Physical Locators; 2.11.4 Practical Hints for Denormalization; 2.11.5 Row Sorting; 3 Numeric Data in SQL; 3.1 Numeric Types
3.1.1 BIT, BYTE, and BOOLEAN Data Types3.2 Numeric Type Conversion; 3.2.1 Rounding and Truncating; 3.2.2 CAST() Function; 3.3 Four-Function Arithmetic; 3.4 Arithmetic and NULLs; 3.5 Converting Values to and from NULL; 3.5.1 NULLIF() Function; 3.5.2 COALESCE() Function; 3.6 Vendor Math Functions; 3.6.1 Number Theory Operators; 3.6.2 Exponential Functions; 3.6.3 Scaling Functions; 3.6.4 Converting Numbers to Words; 4 Temporal Data Types in SQL; 4.1 Notes on Calendar Standards; 4.2 SQL Temporal Data Types; 4.2.1 Tips for Handling Dates, Timestamps, and Times; 4.2.2 Date Format Standards
4.2.3 Handling Timestamps4.2.4 Handling Times; 4.3 Queries with Date Arithmetic; 4.4 The Nature of Temporal Data Models; 4.4.1 Temporal Duplicates; 4.4.2 Temporal Databases; 4.4.3 Temporal Projection and Selection; 4.4.4 Temporal Joins; 4.4.5 Modifying Valid-Time State Tables; 4.4.6 Current Modifications; 4.4.7 Sequenced Modifications; 4.4.8 Nonsequenced Modifications; 4.4.9 Transaction-Time State Tables; 4.4.10 Maintaining the Audit Log; 4.4.11 Querying the Audit Log; 4.4.12 Modifying the Audit Log; 4.4.13 Bitemporal Tables; 4.4.14 Temporal Support in Standard SQL
5 Character Data Types in SQL
Altri titoli varianti SQL for smarties
Record Nr. UNINA-9910784649303321
Celko Joe  
Amsterdam ; ; Boston, : Morgan Kaufmann, c2005
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL programming style [[electronic resource] /] / Joe Celko
Joe Celko's SQL programming style [[electronic resource] /] / Joe Celko
Autore Celko Joe
Edizione [1st edition]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Elsevier, 2005
Descrizione fisica 1 online resource (236 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann Series in Data Management Systems
Soggetto topico SQL (Computer program language)
Query languages (Computer science)
Soggetto genere / forma Electronic books.
ISBN 1-281-00810-9
9786611008109
1-4237-2245-0
0-08-047883-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front cover; Title page; Copyright page; Table of contents; front matter; Introduction; 1.1 Purpose of the Book; 1.2 Acknowledgments; 1.3 Corrections, Comments, and Future Editions; First chapter; 1. Names and Data Elements; 1.1 Names; 1.1.1 Watch the Length of Names; 1.1.2 Avoid All Special Characters in Names; 1.1.3 Avoid Quoted Identifiers; 1.1.4 Enforce Capitalization Rules to Avoid Case- Sensitivity Problems; 1.2 Follow the ISO-11179 Standards Naming Conventions; 1.2.1 ISO-11179 for SQL; 1.2.2 Levels of Abstraction; 1.2.3 Avoid Descriptive Prefixes; 1.2.4 Develop Standardized Postfixes
1.2.5 Table and View Names Should Be Industry Standards, Collective, Class, or Plural Nouns1.2.6 Correlation Names Follow the Same Rules as Other Names . . . Almost; 1.2.7 Relationship Table Names Should Be Common Descriptive Terms; 1.2.8 Metadata Schema Access Objects Can Have Names That Include Structure Information; 1.3 Problems in Naming Data Elements; 1.3.1 Avoid Vague Names; 1.3.2 Avoid Names That Change from Place to Place; 1.3.3 Do Not Use Proprietary Exposed Physical Locators; 2. Fonts, Punctuation, and Spacing; 2.1 Typography and Code
2.1.1 Use Only Upper- and Lowercase Letters, Digits, and Underscores for Names2.1.2 Lowercase Scalars Such as Column Names, Parameters, and Variables; 2.1.3 Capitalize Schema Object Names; 2.1.4 Uppercase the Reserved Words; 2.1.5 Avoid the Use of CamelCase; 2.2 Word Spacing; 2.3 Follow Normal Punctuation Rules; 2.4 Use Full Reserved Words; 2.5 Avoid Proprietary Reserved Words if a Standard Keyword Is Available in Your SQL Product; 2.6 Avoid Proprietary Statements if a Standard Statement Is Available; 2.7 Rivers and Vertical Spacing; 2.8 Indentation; 2.9 Use Line Spacing to Group Statements
3. Data Declaration Language3.1 Put the Default in the Right Place; 3.2 The Default Value Should Be the Same Data Type as the Column; 3.3 Do Not Use Proprietary Data Types; 3.4 Place the PRIMARY KEY Declaration at the Start of the CREATE TABLE Statement; 3.5 Order the Columns in a Logical Sequence and Cluster Them in Logical Groups; 3.6 Indent Referential Constraints and Actions under the Data Type; 3.7 Give Constraints Names in the Production Code; 3.8 Put CHECK() Constraint Near what they Check; 3.8.1 Consider Range Constraints for Numeric Values
3.8.2 Consider LIKE and SIMILAR TO Constraints for Character Values3.8.3 Remember That Temporal Values Have Duration; 3.8.4 REAL and FLOAT Data Types Should Be Avoided; 3.9 Put Multiple Column Constraints as Near to Both Columns as Possible; 3.10 Put Table-Level CHECK() Constraints at the End of the Table Declaration; 3.11 Use CREATE ASSERTION for Multi-table Constraints; 3.12 Keep CHECK() Constraints Single Purposed; 3.13 Every Table Must Have a Key to Be a Table; 3.13.1 Auto-Numbers Are Not Relational Keys; 3.13.2 Files Are Not Tables; 3.13.3 Look for the Properties of a Good Key
3.14 Do Not Split Attributes
Altri titoli varianti SQL programming style
Record Nr. UNINA-9910458675103321
Celko Joe  
Amsterdam ; ; Boston, : Elsevier, 2005
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Joe Celko's SQL programming style [[electronic resource] /] / Joe Celko
Joe Celko's SQL programming style [[electronic resource] /] / Joe Celko
Autore Celko Joe
Edizione [1st edition]
Pubbl/distr/stampa Amsterdam ; ; Boston, : Elsevier, 2005
Descrizione fisica 1 online resource (236 p.)
Disciplina 005.13/3
Collana The Morgan Kaufmann Series in Data Management Systems
Soggetto topico SQL (Computer program language)
Query languages (Computer science)
ISBN 1-281-00810-9
9786611008109
1-4237-2245-0
0-08-047883-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front cover; Title page; Copyright page; Table of contents; front matter; Introduction; 1.1 Purpose of the Book; 1.2 Acknowledgments; 1.3 Corrections, Comments, and Future Editions; First chapter; 1. Names and Data Elements; 1.1 Names; 1.1.1 Watch the Length of Names; 1.1.2 Avoid All Special Characters in Names; 1.1.3 Avoid Quoted Identifiers; 1.1.4 Enforce Capitalization Rules to Avoid Case- Sensitivity Problems; 1.2 Follow the ISO-11179 Standards Naming Conventions; 1.2.1 ISO-11179 for SQL; 1.2.2 Levels of Abstraction; 1.2.3 Avoid Descriptive Prefixes; 1.2.4 Develop Standardized Postfixes
1.2.5 Table and View Names Should Be Industry Standards, Collective, Class, or Plural Nouns1.2.6 Correlation Names Follow the Same Rules as Other Names . . . Almost; 1.2.7 Relationship Table Names Should Be Common Descriptive Terms; 1.2.8 Metadata Schema Access Objects Can Have Names That Include Structure Information; 1.3 Problems in Naming Data Elements; 1.3.1 Avoid Vague Names; 1.3.2 Avoid Names That Change from Place to Place; 1.3.3 Do Not Use Proprietary Exposed Physical Locators; 2. Fonts, Punctuation, and Spacing; 2.1 Typography and Code
2.1.1 Use Only Upper- and Lowercase Letters, Digits, and Underscores for Names2.1.2 Lowercase Scalars Such as Column Names, Parameters, and Variables; 2.1.3 Capitalize Schema Object Names; 2.1.4 Uppercase the Reserved Words; 2.1.5 Avoid the Use of CamelCase; 2.2 Word Spacing; 2.3 Follow Normal Punctuation Rules; 2.4 Use Full Reserved Words; 2.5 Avoid Proprietary Reserved Words if a Standard Keyword Is Available in Your SQL Product; 2.6 Avoid Proprietary Statements if a Standard Statement Is Available; 2.7 Rivers and Vertical Spacing; 2.8 Indentation; 2.9 Use Line Spacing to Group Statements
3. Data Declaration Language3.1 Put the Default in the Right Place; 3.2 The Default Value Should Be the Same Data Type as the Column; 3.3 Do Not Use Proprietary Data Types; 3.4 Place the PRIMARY KEY Declaration at the Start of the CREATE TABLE Statement; 3.5 Order the Columns in a Logical Sequence and Cluster Them in Logical Groups; 3.6 Indent Referential Constraints and Actions under the Data Type; 3.7 Give Constraints Names in the Production Code; 3.8 Put CHECK() Constraint Near what they Check; 3.8.1 Consider Range Constraints for Numeric Values
3.8.2 Consider LIKE and SIMILAR TO Constraints for Character Values3.8.3 Remember That Temporal Values Have Duration; 3.8.4 REAL and FLOAT Data Types Should Be Avoided; 3.9 Put Multiple Column Constraints as Near to Both Columns as Possible; 3.10 Put Table-Level CHECK() Constraints at the End of the Table Declaration; 3.11 Use CREATE ASSERTION for Multi-table Constraints; 3.12 Keep CHECK() Constraints Single Purposed; 3.13 Every Table Must Have a Key to Be a Table; 3.13.1 Auto-Numbers Are Not Relational Keys; 3.13.2 Files Are Not Tables; 3.13.3 Look for the Properties of a Good Key
3.14 Do Not Split Attributes
Altri titoli varianti SQL programming style
Record Nr. UNINA-9910784543103321
Celko Joe  
Amsterdam ; ; Boston, : Elsevier, 2005
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui