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 & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Record Nr. | UNINA-9910458109403321 |
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Record Nr. | UNINA-9910784564903321 |
|
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database modeling & design : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Altri titoli varianti | Database modeling and design |
| Record Nr. | UNINA-9910825615203321 |
|
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| 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 | ||
| ||
Physical database design : the database professional's guide to exploiting indexes, views, storage, and more / / Sam Lightstone, Toby Teorey, Tom Nadeau
| Physical database design : 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-9910808935303321 |
|
Lightstone Sam
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||