Database Management Systems (DBMS) Ebook, notes and presentations covering full semester syllabus
The topics covered in the e-books are:
UNIT I INTRODUCTION AND CONCEPTUAL MODELING: Introduction to File and Database systems- Database system structure Data Models Introduction to Network and Hierarchical Models ER model Relational Model Relational Algebra and Calculus.
UNIT II RELATIONAL MODEL: SQL Data definition- Queries in SQL- Updates- Views Integrity and Security Relational Database design Functional dependencies and Normalization for Relational Databases (up to BCNF).
UNIT III DATA STORAGE AND QUERY PROCESSING: Record storage and Primary file organization- Secondary storage Devices- Operations on Files- Heap File- Sorted Files- Hashing Techniques Index Structure for files Different types of Indexes- B-Tree - B+Tree Query Processing.
UNIT IV TRANSACTION MANAGEMENT: Transaction Processing Introduction- Need for Concurrency control- Desirable properties of Transaction- Schedule and Recoverability- Serializability and Schedules Concurrency Control Types of Locks- Two Phases locking- Deadlock- Time stamp based concurrency control Recovery Techniques Concepts- Immediate Update- Deferred Update - Shadow Paging.
UNIT V CURRENT TRENDS: Object Oriented Databases Need for Complex Data types- OO data Model- Nested relations- Complex Types- Inheritance Reference Types - Distributed databases- Homogenous and Heterogenous- Distributed data Storage XML Structure of XML- Data- XML Document- Schema- Querying and Transformation. Data Mining and Data Warehousing.