Database modeling and design logical design
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you mo...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Amsterdam ; Boston :
Morgan Kaufmann Publishers
c2011.
|
| Edición: | 5th ed |
| Colección: | Morgan Kaufmann series in data management systems.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627987906719 |
Tabla de Contenidos:
- 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
