Fundamentals of Database Management Systems, 3ed, An Indian Adaptation
ISBN: 9789363866027
480 pages
For more information write to us at: acadmktg@wiley.com
Description
The newly revised third edition of Fundamentals of Database Management Systems delivers an authoritative and comprehensive account of contemporary database management. This edition assists readers in understanding critical topics in the subject, including data modeling, relational database concepts, logical and physical database design, SQL, data administration, data security, NoSQL, blockchain, database in the cloud, and more. The author offers a firm grounding in the fundamentals of database while, at the same time, providing a wide-ranging survey of database subfields relevant to information systems professionals.
This Indian edition enhances the coverage with new and updated content. It introduces new sections on traditional file systems, file systems versus database systems, ARIES recovery algorithm, dirty read problem, and phantom phenomenon. The coverage of the section on the data normalization process has been enhanced by introducing new subsections on Boyce- Codd normal form (BCNF), fourth normal form, and fifth normal form. Examples, mini cases, and many end-of-chapter questions throughout the book are new or revised. It also includes multiple choice questions derived from various competitive examinations.
1. Data: The New Corporate Resource Introduction The History of Data The Origins of Data Data Through the Ages Early Data Problems Spawn Calculating Devices Swamped with Data Modern Data Storage Media Data in Today’s Information Systems Environment Using Data for Competitive Advantage Problems in Storing and Accessing Data Data as a Corporate Resource Traditional File Systems The Database Environment File Systems Versus Database Systems Summary Multiple Choice Questions Questions Exercises Minicases
2 Data Modeling Introduction Binary Relationships What Is a Binary Relationship? Cardinality Modality More About Many-to-Many Relationships Unary Relationships One-to-One Unary Relationship One-to-Many Unary Relationship Many-to-Many Unary Relationship Ternary Relationships Example: The Global Hardware Company Example: Good Reading Book Stores Example: World Music Association Example: Lakshmi Flat Rentals Summary Multiple Choice Questions Questions Exercises Minicases
3 The Database Management System Concept Introduction Data Before Database Management Records and Files Database Schemas Basic Concepts in Storing and Retrieving Data The Database Concept Data as a Manageable Resource Data Integration and Data Redundancy Multiple Relationships Data Control Issues Data Independence DBMS Approaches Summary Multiple Choice Questions Questions Exercises Minicases
4 Relational Data Retrieval: SQL Introduction Data Retrieval with the SQL SELECT Command Introduction to the SQL SELECT Command Basic Functions Built-In Functions Grouping Rows The Join Subqueries A Strategy for Writing SQL SELECT Commands Example: Good Reading Book Stores Example: World Music Association Example: Lakshmi Flat Rentals Relational Query Optimizer Relational DBMS Performance Relational Query Optimizer Concepts Summary Multiple Choice Questions Questions Exercises Minicases
5 The Relational Database Model: Introduction Introduction The Relational Database Concept Relational Terminology Primary and Candidate Keys Foreign Keys and Binary Relationships Many-to-Many Binary Relationship Data Retrieval from a Relational Database Extracting Data from a Relation The Relational Select Operator The Relational Project Operator Combination of the Relational Select and Project Operators Extracting Data Across Multiple Relations: Data Integration Example: Good Reading Book Stores Example: World Music Association Example: Lakshmi Flat Rentals Summary Multiple Choice Questions Questions Exercises Minicases
6 The Relational Database Model: Additional Concepts Introduction Relational Structures for Unary and Ternary Relationships Unary One-to-Many Relationships Unary Many-to-Many Relationships Ternary Relationships Referential Integrity The Referential Integrity Concept Three Delete Rules Summary Multiple Choice Questions Questions Exercises Minicases
7 Logical Database Design Introduction Converting E-R Diagrams into Relational Tables Introduction Converting a Simple Entity Converting Entities in Binary Relationships Converting Entities in Unary Relationships Converting Entities in Ternary Relationships Designing the Global Hardware Co. Database Designing the Good Reading Bookstores Database Designing the World Music Association Database Designing the Lakshmi Flat Rentals Database The Data Normalization Process Introduction to the Data Normalization Technique Steps in the Data Normalization Process Example: Global Hardware Co. Example: Good Reading Bookstores Example: World Music Association Example: Lakshmi Flat Rentals Testing Tables Converted from E-R Diagrams with Data Normalization Building the Data Structure with SQL Manipulating the Data with SQL Summary Multiple Choice Questions Questions Exercises Minicases
8 Physical Database Design Introduction Disk Storage The Need for Disk Storage How Rotating Disk Storage Works File Organizations and Access Methods The Goal: Locating a Record The Index Hashed Files Inputs to Physical Database Design The Tables Produced by the Logical Database Design Process Business Environment Requirements Data Characteristics Application Characteristics Operational Requirements: Data Security, Backup, and Recovery Physical Database Design Techniques Adding External Features Reorganizing Stored Data Splitting a Table into Multiple Tables Changing Attributes in a Table Adding Attributes to a Table Combining Tables Adding New Tables Example: Good Reading Book Stores Example: World Music Association Example: Lakshmi Flat Rentals Summary Multiple Choice Questions Questions Exercises Minicases
9 Object-Oriented Database Management Introduction Terminology Complex Relationships Generalization Inheritance of Attributes Operations, Inheritance of Operations, and Polymorphism Aggregation The Global Hardware Co. Class Diagram The Good Reading Bookstores Class Diagram The World Music Association Class Diagram The Lakshmi Property Rentals Class Diagram Encapsulation Abstract Data Types Object/Relational Database Summary Multiple Choice Questions Questions Exercises Minicases
10 Data Administration, Database Administration, and Data Dictionaries Introduction The Advantages of Data and Database Administration Data as a Shared Corporate Resource Efficiency in Job Specialization Operational Management of Data Managing Externally Acquired Databases Managing Data in the Decentralized Environment The Responsibilities of Data Administration Data Coordination Data Planning Data Standards Liaison to Systems Analysts and Programmers Training Arbitration of Disputes and Usage Authorization Documentation and Publicity Data’s Competitive Advantage The Responsibilities of Database Administration DBMS Performance Monitoring DBMS Troubleshooting DBMS Usage and Security Monitoring Data Dictionary Operations DBMS Data and Software Maintenance Database Design Data Dictionaries Introduction A Simple Example of Metadata Passive and Active Data Dictionaries Relational DBMS Catalogs Data Repositories Summary Multiple Choice Questions Questions Exercises Minicases
11 Database Control Issues: Security, Backup and Recovery, Concurrency Introduction Data Security The Importance of Data Security Types of Data Security Breaches Methods of Breaching Data Security Types of Data Security Measures Backup and Recovery The Importance of Backup and Recovery Backup Copies and Journals Forward Recovery Backward Recovery Duplicate or “Mirrored” Databases The Cloud ARIES Recovery Algorithm Disaster Recovery Concurrency Control The Importance of Concurrency Control The Lost Update Problem Dirty Read Problem Phantom Phenomenon Locks and Deadlock Versioning Summary Multiple Choice Questions Questions Exercises Minicases
12 The Data Warehouse Introduction The Data Warehouse Concept The Data Is Subject Oriented The Data Is Integrated The Data Is Non-Volatile
The Data Is Time Variant The Data Must Be High Quality The Data May Be Aggregated The Data Is Often Denormalized The Data Is Not Necessarily Absolutely Current Types of Data Warehouses The Enterprise Data Warehouse (EDW) The Data Mart (DM) Which to Choose: The EDW, the DM, or Both? Designing a Data Warehouse Introduction Global Hardware Co. Data Warehouse Good Reading Bookstores Data Warehouse Lakshmi Flat Rentals Data Warehouse What About a World Music Association Data Warehouse? Building a Data Warehouse Introduction Data Extraction Data Cleaning Data Transformation Data Loading Using a Data Warehouse On-Line Analytic Processing Data Mining Administering a Data Warehouse Challenges in Data Warehousing Summary Multiple Choice Questions Questions Exercises Minicases
13 NoSQL Database Management Introduction The Lead-Up to NoSQL Database Management Limitations of Relational Database Advanced Database Management System Concepts CAP Theorem Examples NoSQL Database Management Systems Key-Value Database The Key-Value Database Concept Hadoop The Hadoop Environment Document Database Column Family Database Graph Database Querying NoSQL Databases and the Rise of NewSQL NoSQL Query Languages NewSQL Summary Multiple Choice Questions Questions Exercises Minicases
14 Blockchain Introduction What Is a Blockchain? Hashing Cryptographic Hashing Cryptographic Hashing in the Blockchain Public-Key Encryption Public-Key Encryption Revisited Public-Key Encryption in the Blockchain Additional Blockchain Topics Merkle Trees Consensus Smart Contracts Summary Multiple Choice Questions Questions Exercises Minicases
15 Database in the Cloud Introduction The Cloud: What, Why, How? New Technologies Cloud Usage Models Cloud Pricing Models Advantages of the Cloud Limitations of the Cloud Data and Database in the Cloud Where Should the Data Be Stored? The Pros and Cons of Storing Data in the Cloud From Distributed Database to the Cloud Introduction to Distributed Database Distributed Database Architecture The Cloud and Distributed Database Summary Multiple Choice Questions Questions Exercises Minicases
16 Database Applications Introduction Business Intelligence and Data Analytics Data Mining Text Mining and Web Mining Artificial Intelligence Artificial Intelligence Applications Artificial Intelligence Techniques Enterprise Resource Planning (ERP) Customer Relationship Management (CRM) Supply Chain Management (SCM) Summary Multiple Choice Questions Questions Exercises Minicases
INDEX I-1 |