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.
Database modeling and design [[electronic resource] ] : logical design / / Toby Teorey ... [et al.]
| Database modeling and design [[electronic resource] ] : logical design / / Toby Teorey ... [et al.] |
| Edizione | [5th ed.] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann Publishers, c2011 |
| Descrizione fisica | 1 online resource (347 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) | TeoreyToby J |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
Relational databases
Database design |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-00618-9
9786613006189 0-12-382021-9 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Database Modeling and Design; Copyright; Dedication; Contents; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; About the Authors; Chapter 1: Introduction; Data and Database Management; Database Life Cycle; Conceptual Data Modeling; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 2: The Entity-Relationship Model; Fundamental ER Constructs; Advanced ER Constructs; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 3: The Unified Modeling Language; Class Diagrams
Activity DiagramsSummary; Tips and Insights for Database Professionals; Literature Summary; Chapter 4: Requirements Analysis and Conceptual Data Modeling; Introduction; Requirements Analysis; Conceptual Data Modeling; View Integration; Entity Clustering for ER Models; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 5: Transforming the Conceptual Data Model to SQL; Transformation Rules and SQL Constructs; Transformation Steps; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 6: Normalization; Fundamentals of Normalization The Design of Normalized Tables: A Simple ExampleNormalization of Candidate Tables Derived from ER Diagrams; Determining the Minimum Set of 3NF Tables; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 7: An Example of Logical Database Design; Requirements Specification; Logical Design; Summary; Tips and Insights for Database Professionals; Chapter 8: Object-Relational Design; Object Orientation; Object-Oriented Databases; Object-Relational Databases; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 9: XML and Web Databases XMLXML Design; Web-Based Applications; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 10: Business Intelligence; Data Warehousing; Online Analytical Processing; Data Mining; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 11: CASE Tools for Logical Database Design; Introduction to the CASE Tools; Key Capabilities to Watch for; The Basics; Generating a Database from a Design; Database Support; Collaborative Support; Distributed Development; Application Life Cycle Tooling Integration; Design Compliance Checking; Reporting Modeling a Data WarehouseSemistructured Data-XML; Summary; Tips and Insights for Database Professionals; Literature Summary; Appendix: The Basics of SQL; SQL Names and Operators; Data Definition Language; Data Manipulation Language; References; References; Exercises; ER and UML Conceptual Data Modeling; Conceptual Data Modeling and Integration; Transformation of the Conceptual Model to SQL; Normalization and Minimum Set of Tables; Logical Database Design (Generic Problem); OLAP; Solutions to Selected Exercises; Glossary; Index; Bonus Chapter Opener Chapter 3: Query Optimization and Plan Selection |
| Record Nr. | UNINA-9910458966903321 |
| Amsterdam ; ; Boston, : Morgan Kaufmann Publishers, c2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database modeling and design [[electronic resource] ] : logical design / / Toby Teorey ... [et al.]
| Database modeling and design [[electronic resource] ] : logical design / / Toby Teorey ... [et al.] |
| Edizione | [5th ed.] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann Publishers, c2011 |
| Descrizione fisica | 1 online resource (347 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) | TeoreyToby J |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
Relational databases
Database design |
| ISBN |
1-283-00618-9
9786613006189 0-12-382021-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Database Modeling and Design; Copyright; Dedication; Contents; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; About the Authors; Chapter 1: Introduction; Data and Database Management; Database Life Cycle; Conceptual Data Modeling; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 2: The Entity-Relationship Model; Fundamental ER Constructs; Advanced ER Constructs; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 3: The Unified Modeling Language; Class Diagrams
Activity DiagramsSummary; Tips and Insights for Database Professionals; Literature Summary; Chapter 4: Requirements Analysis and Conceptual Data Modeling; Introduction; Requirements Analysis; Conceptual Data Modeling; View Integration; Entity Clustering for ER Models; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 5: Transforming the Conceptual Data Model to SQL; Transformation Rules and SQL Constructs; Transformation Steps; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 6: Normalization; Fundamentals of Normalization The Design of Normalized Tables: A Simple ExampleNormalization of Candidate Tables Derived from ER Diagrams; Determining the Minimum Set of 3NF Tables; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 7: An Example of Logical Database Design; Requirements Specification; Logical Design; Summary; Tips and Insights for Database Professionals; Chapter 8: Object-Relational Design; Object Orientation; Object-Oriented Databases; Object-Relational Databases; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 9: XML and Web Databases XMLXML Design; Web-Based Applications; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 10: Business Intelligence; Data Warehousing; Online Analytical Processing; Data Mining; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 11: CASE Tools for Logical Database Design; Introduction to the CASE Tools; Key Capabilities to Watch for; The Basics; Generating a Database from a Design; Database Support; Collaborative Support; Distributed Development; Application Life Cycle Tooling Integration; Design Compliance Checking; Reporting Modeling a Data WarehouseSemistructured Data-XML; Summary; Tips and Insights for Database Professionals; Literature Summary; Appendix: The Basics of SQL; SQL Names and Operators; Data Definition Language; Data Manipulation Language; References; References; Exercises; ER and UML Conceptual Data Modeling; Conceptual Data Modeling and Integration; Transformation of the Conceptual Model to SQL; Normalization and Minimum Set of Tables; Logical Database Design (Generic Problem); OLAP; Solutions to Selected Exercises; Glossary; Index; Bonus Chapter Opener Chapter 3: Query Optimization and Plan Selection |
| Record Nr. | UNINA-9910791783203321 |
| Amsterdam ; ; Boston, : Morgan Kaufmann Publishers, c2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau
| Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau |
| Autore | Lightstone Sam |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 |
| Descrizione fisica | 1 online resource (449 p.) |
| Disciplina | 005.74 |
| Altri autori (Persone) |
TeoreyToby J
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico | Database design |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-04654-X
9786611046545 0-08-055231-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Physical Database Design; Copyright Page; Contents; Preface; Organization; Usage Examples; Literature Summaries and Bibliography; Feedback and Errata; Acknowledgments; Chapter 1. Introduction to Physical Database Design; 1.1 Motivation-The Growth of Data and Increasing Relevance of Physical Database Design; 1.2 Database Life Cycle; 1.3 Elements of Physical Design: Indexing, Partitioning, and Clustering; 1.4 Why Physical Design Is Hard; 1.5 Literature Summary; Chapter 2. Basic Indexing Methods; 2.1 B+tree Index; 2.2 Composite Index Search; 2.3 Bitmap Indexing
2.4 Record Identifiers 2.5 Summary; 2.6 Literature Summary; Chapter 3. Query Optimization and Plan Selection; 3.1 Query Processing and Optimization; 3.2 Useful Optimization Features in Database Systems; 3.3 Query Cost Evaluation-An Example; 3.4 Query Execution Plan Development; 3.5 Selectivity Factors, Table Size, and Query Cost Estimation; 3.6 Summary; 3.7 Literature Summary; Chapter 4. Selecting Indexes; 4.1 Indexing Concepts and Terminology; 4.2 Indexing Rules of Thumb; 4.3 Index Selection Decisions; 4.4 Join Index Selection; 4.5 Summary; 4.6 Literature Summary Chapter 5. Selecting Materialized Views 5.1 Simple View Materialization; 5.2 Exploiting Commonality; 5.3 Exploiting Grouping and Generalization; 5.4 Resource Considerations; 5.5 Examples: The Good, the Bad, and the Ugly; 5.6 Usage Syntax and Examples; 5.7 Summary; 5.8 Literature Review; Chapter 6. Shared-nothing Partitioning; 6.1 Understanding Shared-nothing Partitioning; 6.2 More Key Concepts and Terms; 6.3 Hash Partitioning; 6.4 Pros and Cons of Shared Nothing; 6.5 Use in OLTP Systems; 6.6 Design Challenges: Skew and Join Collocation 6.7 Database Design Tips for Reducing Cross-node Data Shipping 6.8 Topology Design; 6.9 Where the Money Goes; 6.10 Grid Computing; 6.11 Summary; 6.12 Literature Summary; Chapter 7. Range Partitioning; 7.1 Range Partitioning Basics; 7.2 List Partitioning; 7.3 Syntax Examples; 7.4 Administration and Fast Roll-in and Roll-out; 7.5 Increased Addressability; 7.6 Partition Elimination; 7.7 Indexing Range Partitioned Data; 7.8 Range Partitioning and Clustering Indexes; 7.9 The Full Gestalt: Composite Range and Hash Partitioning with Multidimensional Clustering; 7.10 Summary; 7.11 Literature Summary Chapter 8. Multidimensional Clustering 8.1 Understanding MDC; 8.2 Performance Benefits of MDC; 8.3 Not Just Query Performance: Designing for Roll-in and Roll-out; 8.4 Examples of Queries Benefiting from MDC; 8.5 Storage Considerations; 8.6 Designing MDC Tables; 8.7 Summary; 8.8 Literature Summary; Chapter 9. The Interdependence Problem; 9.1 Strong and Weak Dependency Analysis; 9.2 Pain-first Waterfall Strategy; 9.3 Impact-.rst Waterfall Strategy; 9.4 Greedy Algorithm for Change Management; 9.5 The Popular Strategy (the Chicken Soup Algorithm); 9.6 Summary; 9.7 Literature Summary Chapter 10. Counting and Data Sampling in Physical Design Exploration |
| Record Nr. | UNINA-9910458663703321 |
Lightstone Sam
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau
| Physical database design [[electronic resource] ] : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau |
| Autore | Lightstone Sam |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 |
| Descrizione fisica | 1 online resource (449 p.) |
| Disciplina | 005.74 |
| Altri autori (Persone) |
TeoreyToby J
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico | Database design |
| ISBN |
1-281-04654-X
9786611046545 0-08-055231-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Physical Database Design; Copyright Page; Contents; Preface; Organization; Usage Examples; Literature Summaries and Bibliography; Feedback and Errata; Acknowledgments; Chapter 1. Introduction to Physical Database Design; 1.1 Motivation-The Growth of Data and Increasing Relevance of Physical Database Design; 1.2 Database Life Cycle; 1.3 Elements of Physical Design: Indexing, Partitioning, and Clustering; 1.4 Why Physical Design Is Hard; 1.5 Literature Summary; Chapter 2. Basic Indexing Methods; 2.1 B+tree Index; 2.2 Composite Index Search; 2.3 Bitmap Indexing
2.4 Record Identifiers 2.5 Summary; 2.6 Literature Summary; Chapter 3. Query Optimization and Plan Selection; 3.1 Query Processing and Optimization; 3.2 Useful Optimization Features in Database Systems; 3.3 Query Cost Evaluation-An Example; 3.4 Query Execution Plan Development; 3.5 Selectivity Factors, Table Size, and Query Cost Estimation; 3.6 Summary; 3.7 Literature Summary; Chapter 4. Selecting Indexes; 4.1 Indexing Concepts and Terminology; 4.2 Indexing Rules of Thumb; 4.3 Index Selection Decisions; 4.4 Join Index Selection; 4.5 Summary; 4.6 Literature Summary Chapter 5. Selecting Materialized Views 5.1 Simple View Materialization; 5.2 Exploiting Commonality; 5.3 Exploiting Grouping and Generalization; 5.4 Resource Considerations; 5.5 Examples: The Good, the Bad, and the Ugly; 5.6 Usage Syntax and Examples; 5.7 Summary; 5.8 Literature Review; Chapter 6. Shared-nothing Partitioning; 6.1 Understanding Shared-nothing Partitioning; 6.2 More Key Concepts and Terms; 6.3 Hash Partitioning; 6.4 Pros and Cons of Shared Nothing; 6.5 Use in OLTP Systems; 6.6 Design Challenges: Skew and Join Collocation 6.7 Database Design Tips for Reducing Cross-node Data Shipping 6.8 Topology Design; 6.9 Where the Money Goes; 6.10 Grid Computing; 6.11 Summary; 6.12 Literature Summary; Chapter 7. Range Partitioning; 7.1 Range Partitioning Basics; 7.2 List Partitioning; 7.3 Syntax Examples; 7.4 Administration and Fast Roll-in and Roll-out; 7.5 Increased Addressability; 7.6 Partition Elimination; 7.7 Indexing Range Partitioned Data; 7.8 Range Partitioning and Clustering Indexes; 7.9 The Full Gestalt: Composite Range and Hash Partitioning with Multidimensional Clustering; 7.10 Summary; 7.11 Literature Summary Chapter 8. Multidimensional Clustering 8.1 Understanding MDC; 8.2 Performance Benefits of MDC; 8.3 Not Just Query Performance: Designing for Roll-in and Roll-out; 8.4 Examples of Queries Benefiting from MDC; 8.5 Storage Considerations; 8.6 Designing MDC Tables; 8.7 Summary; 8.8 Literature Summary; Chapter 9. The Interdependence Problem; 9.1 Strong and Weak Dependency Analysis; 9.2 Pain-first Waterfall Strategy; 9.3 Impact-.rst Waterfall Strategy; 9.4 Greedy Algorithm for Change Management; 9.5 The Popular Strategy (the Chicken Soup Algorithm); 9.6 Summary; 9.7 Literature Summary Chapter 10. Counting and Data Sampling in Physical Design Exploration |
| Record Nr. | UNINA-9910784649703321 |
|
Lightstone Sam
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data
| Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data |
| Autore | Teorey Toby J |
| Pubbl/distr/stampa | [Place of publication not identified], : ACM, 1981 |
| Descrizione fisica | 1 online resource (237 pages) |
| Collana | ACM Conferences |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti |
Proceedings of the 1981 Association for Computing Machinery Special Interest Group on Management of Data International Conference on Management of Data
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data |
| Record Nr. | UNINA-9910375990003321 |
|
Teorey Toby J
|
||
| [Place of publication not identified], : ACM, 1981 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP
| Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP |
| Autore | Song Il-Yeol |
| Pubbl/distr/stampa | [Place of publication not identified], : ACM, 1998 |
| Descrizione fisica | 1 online resource (79 pages) |
| Collana | ACM Conferences |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti | Proceedings of the 1st Association for Computing Machinery International Workshop on Data Warehousing and Online Analytical Processing technology |
| Record Nr. | UNINA-9910376342103321 |
|
Song Il-Yeol
|
||
| [Place of publication not identified], : ACM, 1998 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP
| Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP |
| Autore | Song Il-Yeol |
| Pubbl/distr/stampa | [Place of publication not identified], : ACM, 1999 |
| Descrizione fisica | 1 online resource (108 pages) |
| Collana | ACM Conferences |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti | Proceedings of the 2nd Association for Computing Machinery International Workshop on Data Warehousing and Online Analytical Processing technology |
| Record Nr. | UNINA-9910376217703321 |
|
Song Il-Yeol
|
||
| [Place of publication not identified], : ACM, 1999 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||