Modern Database Management, Global Edition

Höfundar: Jeff Hoffer; Ramesh Venkataraman; Heikki Topi; Hillol Bala (Útgáfa: 14)
Modern Database Management, Global Edition

Kaup valmöguleikar

Modern Database Management offers a comprehensive introduction to the latest in database development. Using sound pedagogy, the authors present topics critical to the practical success of database professionals. Focused on the most important aspects of database development according to leading practitioners, the text serves as a practical guide to the field. The 14th Edition, Global Edition, has been thoroughly updated to reflect major trends, including new coverage of the full data to analysis process, data management infrastructure developments, SQL analytical capabilities, new cloud-based solutions, AI and more.

Nánar um bókina

Útgefandi
Pearson International Content
ISBN
9781292750699
Print ISBN
9781292750705
Format
ePub
Útgáfa
14
Höfundar
Jeff Hoffer; Ramesh Venkataraman; Heikki Topi; Hillol Bala
Tungumál
English
Útgefið
2025-08-25
Prent takmörkun á líftíma
100
Prent takmörkun
2
Afritunar takmörkun
2

Kaflar

  • Cover
  • Cover
  • Front Matter
  • Title page
  • Copyright
  • Dedication
  • Preface
  • What’s New in This Edition?
  • Acknowledgments
  • Acknowledgments for the Global Edition
  • Videos and Interactive Resources
  • Part I: The Context of Database Management
  • Part I: The Context of Database Management
  • Chapter 1: The Database Environment and Development Process
  • Learning Objectives
  • Data Matter!
  • Introduction
  • Basic Concepts and Definitions
  • Traditional File Processing Systems
  • The Database Approach
  • Integrated Data Management Framework
  • Components of the Database Environment
  • The Database Development Process
  • Evolution of Database Systems
  • The Range of Database Applications
  • Developing a Database Application for Pine Valley Furniture Company
  • State of AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Part II: Database Analysis and Logical Design
  • Part II: Database Analysis and Logical Design
  • Chapter 2: Modeling Data in the Organization
  • Learning Objectives
  • Introduction
  • The E-R Model: An Overview
  • Modeling the Rules of the Organization
  • Modeling Entities and Attributes
  • Modeling Relationships
  • E-R Modeling Example: Pine Valley Furniture Company
  • Database Processing at Pine Valley Furniture
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Chapter 3: The Enhanced E-R Model
  • Learning Objectives
  • Introduction
  • Representing Supertypes and Subtypes
  • Specifying Constraints in Supertype/Subtype Relationships
  • EER Modeling Example: Pine Valley Furniture Company
  • Entity Clustering
  • Packaged Data Models
  • Alternative Data Models for Data Analytics
  • State of AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Chapter 4: Logical Database Design and the Relational Model
  • Learning Objectives
  • Introduction
  • The Relational Data Model
  • Integrity Constraints
  • Transforming EER Diagrams into Relations
  • Introduction to Normalization
  • Normalization Example: Pine Valley Furniture Company
  • Merging Relations
  • A Final Step for Defining Relational Keys
  • State of AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Part III: Database Implementation and Use
  • Part III: Database Implementation and Use
  • Chapter 5: Introduction to SQL
  • Learning Objectives
  • Introduction
  • Origins of the SQL Standard
  • The SQL Environment
  • Defining a Database in SQL
  • Inserting, Updating, and Deleting Data
  • Internal Schema Definition in RDBMSs
  • Processing Single Tables
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Chapter 6: Advanced SQL
  • Learning Objectives
  • Introduction
  • Processing Multiple Tables
  • Tips for Developing Queries
  • Using and Defining Views
  • Triggers and Routines
  • Data Dictionary Facilities
  • Enhancements and Extensions to SQL Over Time
  • State of AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Chapter 7: Databases in Applications
  • Learning Objectives
  • Location, Location, Location!
  • Introduction
  • Client/Server Architectures
  • Databases in Three-Tier Applications
  • Key Considerations in Three-Tier Applications
  • Transaction Integrity
  • Controlling Concurrent Access
  • Managing Data Security in an Application Context
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Chapter 8: Physical Database Design and Database Infrastructure
  • Learning Objectives
  • Introduction
  • The Physical Database Design Process
  • Designing Fields
  • Denormalizing and Partitioning Data
  • Designing Physical Database Files
  • Using and Selecting Indexes
  • Data Dictionaries and Repositories
  • Database Software Data Security Features
  • Database Backup and Recovery
  • Cloud-Based Database Infrastructure
  • Check Your Understanding
  • Summary
  • Chapter Review
  • Case: Forondo Artist Management Excellence Inc.
  • References
  • Further Reading
  • Web Resources
  • Part IV: Advanced Database Topics
  • Part IV: Advanced Database Topics
  • Chapter 9: Beyond Relational: Big Data, NoSQL, and Cloud Databases
  • Learning Objectives
  • Introduction
  • Moving Beyond Transactional Databases
  • Big Data
  • State of AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • References
  • Further Reading
  • Web Resources
  • Chapter 10: Modern Data Platforms: Integration, Warehousing, and Virtualization
  • Learning Objectives
  • Introduction
  • Data Integration: Key to Modern Data Platforms
  • Data Consolidation Mechanism: ETL
  • An Overview of Data Transformation
  • Data Consolidation: Master Data Management (MDM)
  • Data Consolidation: Data Warehousing
  • Data Warehouse Architectures
  • Some Characteristics of Data Warehouse Data
  • Data Warehousing: The Derived Data Layer
  • The Future of Data Warehousing: Integration with Other Forms of Data Management and Analytics
  • Data Federation: Data Virtualization
  • The Future of Data Virtualization: Data Fabric, Data Lakehouse, and Integration with AI
  • Check Your Understanding
  • Summary
  • Chapter Review
  • References
  • Further Reading
  • Web Resources
  • Chapter 11: Analytics: From Data to Insights
  • Learning Objectives
  • Introduction
  • Analytics
  • The Analytics Process
  • Operational Analytics and the End-to-End Analytics Process
  • Impact of Big Data and Analytics
  • Check Your Understanding
  • Summary
  • Chapter Review
  • References
  • Further Reading
  • Chapter 12: Data and Database Administration with Focus on Data Quality
  • Learning Objectives
  • Introduction
  • Overview of Data and Database Administration
  • The Open Source Movement and Database Management
  • Data Governance
  • Managing Data Quality
  • Data Availability
  • Master Data Management
  • Check Your Understanding
  • Summary
  • Chapter Review
  • References
  • Further Reading
  • Web Resources
  • Chapter 13: Object-Oriented Data Modeling
  • Learning Objectives
  • Introduction
  • Unified Modeling Language
  • Object-Oriented Data Modeling
  • Business Rules
  • Object Modeling Example: Pine Valley Furniture Company
  • Check Your Understanding
  • Summary
  • Chapter Review
  • References
  • Further Reading
  • Web Resources
  • Appendix A: Data Modeling Tools and Notation
  • Comparing E-R Modeling Conventions
  • Comparison of Tool Interfaces and E-R Diagrams
  • Appendix B: Advanced Normal Forms
  • Boyce-Codd Normal Form
  • Fourth Normal Form
  • Higher Normal Forms
  • Appendix Review
  • References
  • Web Resource
  • Appendix C: Data Structures
  • Pointers
  • Data Structure Building Blocks
  • Linear Data Structures
  • Hazards of Chain Structures
  • Trees
  • Reference
  • Glossary