Cover -- Introduction to Database Systems -- Copyright -- Contents -- Preface -- Database System -- Need of Database System -- Advantages of Database System -- Developments in Database System -- Application Areas of Database System -- Cost and Risk of Database System -- People Who Interact with Databases -- DBMS Architecture and Data Independence -- Database Models -- Database Schema versus Database Instance -- DBMS Languages -- Component Modules of DBMS -- Centralized and Client/Server Database Systems -- Classification of DBMSs -- Database Design Process -- Summary -- Key Terms -- Exercises -- Conceptual Modeling -- Concepts of Entity-Relationship Model -- Entity-Relationship Diagram -- Enhanced E-R Model -- Alternative Notations for E-R Diagrams -- Unified Modeling Language -- Summary -- Key Terms -- Exercises -- The Relational Model -- Relational Model Concepts -- Relational Database Schema -- Relational Database Instance -- Keys -- Data Integrity -- Constraint Violation while Updating Data -- Mapping E-R Model to Relational Model -- Summary -- Key Terms -- Exercises -- Relational Algebra and Calculus -- Relational Algebra -- Relational Calculus -- Expressive Power of Relational Algebra and Relational Calculus -- Summary -- Key Terms -- Exercises -- Structured Query Language -- Basic Features of SQL -- Data Definition -- Data Manipulation Language -- Complex Queries in SQL -- Additional Features of SQL -- Accessing Databases from Applications -- Summary -- Key Terms -- Exercises -- Relational Database Design -- Features of Good Relational Design -- Decomposition -- Functional Dependencies -- Normal Forms -- Insufficiency of Normal Forms -- Comparison of BCNF and 3NF -- Higher Normal Forms -- Denormalization -- Summary -- Key Terms -- Exercises -- Data Storage and Indexing -- Hierarchy of Storage Devices.

Redundant Arrays of Independent Disks -- New Storage Systems -- Accessing Data from Disk -- Placing File Records on Disk Blocks -- Organization of Records in Files -- Indexing -- Summary -- Key Terms -- Exercises -- Queryp Rocessing and Optimization -- Query Processing Steps -- External Sort-Merge Algorithm -- Algorithms for Relational Algebra Operations -- Expressions Containing Multiple Operations -- Query Optimization -- Query Optimization in Oracle -- Summary -- Key Terms -- Exercises -- Introduction to Transaction Processing -- Desirable Properties of a Transaction -- States of a Transaction -- Concurrent Execution of Transactions -- Transaction Schedules -- SQL Transaction Statements -- Summary -- Key Terms -- Exercises -- Concurrency Control Tenchniques -- Locking -- Lock-Based Techniques -- Specialized Locking Techniques -- Performance of Locking -- Timestamp-Based Technique -- Optimistic Technique -- Multiversion Technique -- Dealing with Deadlock -- Summary -- Key Terms -- Exercises -- Database Recovery System -- Types of Failures -- Caching of Disk Pages -- Recovery Related Steps During Normal Execution -- Recovery Techniques -- Recovery for Concurrent Transactions -- ARIES Recovery Algorithm -- Recovery from Catastrophic Failures -- Summary -- Key Terms -- Exercises -- Database Security -- Security Issues -- Role of DBA in Database Security -- Authorization -- Authentication -- Access Control -- Encryption -- Statistical Database -- Summary -- Key Terms -- Exercises -- Databasesy Stem Architectures -- Overview of Parallel DBMS -- Distributed DBMS -- Client/Server Systems -- Summary -- Key Terms -- Exercises -- Data Warehousing, Olap, and Data Mining -- Data Warehousing -- Online Analytical Processing -- Data Mining Technology -- Summary -- Key Terms -- Exercises -- Information Retrieval -- Information Retrieval Systems.

Indexing of Text Documents -- Web Search Engines -- Summary -- Key Terms -- Exercises -- Object-Based Databases -- Need for Object-Based Databases -- Object Relational Database Systems -- Object-Oriented Database Management Systems -- OODBMS versus ORDBMS -- Summary -- Key Terms -- Exercises -- XML -- Structured, Semi-Structured, and Unstructured Data -- Overview of XML -- Structure of XML Data -- DTD and XML Schema -- Querying XML Data -- Approaches to Store XML Data -- Uses of XML -- Summary -- Key Terms -- Exercises -- Leading Database Systems -- Postgre SQL -- Oracle -- Microsoft SQL Server -- IBM DB2 Universal Database -- Summary -- Key Terms -- Exercises -- Hospital Management System -- Aim -- Description -- Tables Description -- E-R Diagram -- Relational Database Schema for Case Study -- Implementation in SQL Server -- Railway Reservation -- Aim -- Description -- List of Assumptions -- E-R Diagram -- Description of Tables and Procedures -- Relational Database Schema for Case Study -- Microsoft Access as Database Management System -- Components of Access -- Starting Access -- Working with Tables -- Working with Queries -- Working with Forms -- Working with Reports -- SQL Extensions for Data Analysis -- Extensions to GROUP bY Clause -- New Analytic Functions -- Top-N Queries -- Windowing in SQL:1999 -- Abbreviations, Acronyms, and Symbols -- E. F. Codd's Rules -- Glossary -- Index.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2018. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.