Database modeling and design [[electronic resource] ] : logical design / / Toby Teorey ... [et al.]

• Pubblicazione: Amsterdam ; ; Boston, : Morgan Kaufmann Publishers, c2011
• Edizione: 5th ed.
• Descrizione fisica: 1 online resource (347 p.)
• Disciplina: 005.75/6
• Soggetto topico: Relational databases; Database design
• Soggetto genere / forma: Electronic books.
• Altri autori: TeoreyToby J
• Note generali: Rev. ed. of: Database modeling & design / Tobey Teorey, Sam Lightstone, Tom Nadeau. 4th ed. 2005.
• Nota di bibliografia: Includes bibliographical references and index.
• 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
• Sommario/riassunto: 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 model and design your database application in consideration of new technology or new business needs? In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with d
• Titolo autorizzato: Database modeling and design
• ISBN: 1-283-00618-9; 9786613006189; 0-12-382021-9
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910458966903321
• Lo trovi qui: Univ. Federico II
• Serie: Morgan Kaufmann series in data management systems.