Principles of Database Management

Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data

This comprehensive textbook teaches the fundamentals of database design, modeling, systems, data storage, and the evolving world of data warehousing, governance and more. Written by experienced educators and experts in big data, analytics, data quality, and data integration, it provides an up-to-date approach to database management. This full-color, illustrated text has a balanced theory-practice focus, covering essential topics, from established database technologies to recent trends, like Big Data, NoSQL, and more. Fundamental concepts are supported by real-world examples, query and code walkthroughs, and figures, making it perfect for introductory courses for advanced undergraduates and graduate students in information systems or computer science. These examples are further supported by an online playground with multiple learning environments, including MySQL; MongoDB; Neo4j Cypher; and tree structure visualization. This combined learning approach connects key concepts throughout the text to the important, practical tools to get started in database management.

Table of Contents

Part I Databases and Database Design
Chapter 1 Fundamental Concepts Of Database Management
Chapter 2 Architecture And Categorization Of Dbmss
Chapter 3 Conceptual Data Modeling Using The (E)Er Model And Uml Class Diagram
Chapter 4 Organizational Aspects Of Data Management

Part II Types of Database Systems
Chapter 5 Legacy Databases
Chapter 6 Relational Databases: The Relational Model
Chapter 7 Relational Databases: Structured Query Language (Sql)
Chapter 8 Object-Oriented Databases And Object Persistence
Chapter 9 Extended Relational Databases
Chapter 10 Xml Databases
Chapter 11 Nosql Databases

Part III Physical Data Storage, Transaction Management, and Database Access
Chapter 12 Physical File Organization And Indexing
Chapter 13 Physical Database Organization
Chapter 14 Basics Of Transaction Management
Chapter 15 Accessing Databases And Database Apis
Chapter 16 Data Distribution And Distributed Transaction Management

Part IV Data Warehousing, Data Governance, and (Big) Data Analytics
Chapter 17 Data Warehousing And Business Intelligence
Chapter 18 Data Integration, Data Quality, And Data Governance
Chapter 19 Big Data
Chapter 20 Analytics