FE-Logo
  • Introduction to Database Management System
    • Overview of Database Management Systems
    • Database Systems versus File Systems
    • History of Database Systems
    • View of Data
    • Extending Database Capabilities
    • Types of Databases and Database Applications
    • Advantages of Database Systems
    • Functions of a DBMS
    • Role of the Database Administrator
    • Database Users
    • Data Models
    • Components of Database Management system
    • Transaction
    • Database Management System Languages
    • The two tier architecture
    • Three-layer architecture
    • Entity-Relationship Model
    • Database design and ER Diagrams
    • Entity Types, Attributes and Keys
    • Relationships and Relationship sets
    • Types of Entity
    • Constraints
    • Keys
    • Entity-Relationship Diagram
    • Hierarchical Data Model
    • Network Data Model
    • Design Issues
    • Extended E-R Features
    • Alternative E-R Notations
    • The Unified Modeling Language

  • Relational Model
    • Relational Model Terminology
    • Mathematical Definition of Relation
    • Database Relations
    • Structure of Relational Databases
    • Database Schema
    • Keys
    • Schema Diagram
    • The Relational Algebra
    • Composition of Relational Operations
    • The Union Operation
    • The Set Difference Operation
    • The Rename Operation
    • Formal Definition of the Relational Algebra
    • Additional Operations
    • Extended Relational-Algebra Operations
    • Outer Join
    • Null Values
    • Modification of the Database
    • Views

  • Storage and File organization
    • Physical Storage Media
    • RAID
    • Tertiary Storage
    • Storage Access
    • File Organization
    • Variable-Length Records
    • Organization of Records in Files
    • Indexing structures for files
    • Secondary Indexes
    • Clustering File Organization
    • Data-Dictionary Storage
    • Hashing
    • B+Tree

  • QBE
    • Query-by-Example
    • Queries on One Relation
    • Queries on Several Relations
    • The Condition Box
    • The Result Relation
    • Ordering of the Display of Tuples
    • Aggregate Operations
    • Normalization
    • Functional Dependency
    • The Process of Normalization
    • First Normal Form (1NF)
    • Boyce.Codd Normal Form (BCNF)
    • Fourth Normal Form (4NF)
    • Fifth Normal Form (5NF)
    • Algorithm for Functional Dependencies

  • SQL
    • Objectives of SQL
    • History of SQL
    • Importance of SQL
    • SQL Statement
    • Use of DISTINCT
    • Search Condition
    • Pattern Matching
    • NULL Search Condition
    • SELECT Statement
    • SELECT Statement - Grouping
    • Subqueries
    • Join
    • Integrity Enhancement Feature
    • Data Definition
    • View
    • Transactions
    • Data-Definition Language
    • Schema Definition in SQL
    • Dynamic SQL
    • Trigger
    • cursor

  • Concurrency Control
    • Lock-Based Protocols
    • Granting of Locks
    • Two-Phase Locking Protocol
    • Implementation of Locking
    • Graph-Based Protocols
    • Timestamp-Based Protocols
    • Validation-Based Protocols
    • Deadlock Handling
    • Timeout-Based Schemes for Deadlock Prevention
    • Deadlock Detection
    • Recovery from Deadlock
    • Need for Concurrency Control
    • Schedule
    • Timestamping
    • Optimistic Techniques
    • Granularity of Data Items
    • Database Recovery
    • Checkpoint
    • Recovery Techniques

  • Recovery System
    • Failure Classification
    • Storage Types
    • Data Access
    • Log-Based Recovery
    • Deferred Database Modification
    • Immediate Database Modification
    • Checkpoints
    • Shadow Paging
    • Recovery with Concurrent Transactions
    • Buffer Management
    • Failure with Loss of Nonvolatile Storage
    • ARIES
    • Data Structures
    • Recovery Algorithm of ARIES
    • key features of ARIES
    • Remote Backup Systems

  • Distributed Databases
    • HomogeneousandHeterogeneousDatabases
    • Distributed Data Storage
    • Transparency
    • Distributed Transactions
    • Commit Protocols
    • Three-Phase Commit
    • ConcurrencyControl inDistributedDatabases
    • Local wait-for graphs
    • Heterogeneous Distributed Databases
    • Directory Systems

  • Parallel Databases
    • I/O Parallelism
    • Handling of Skew
    • Interquery Parallelism
    • Intraquery Parallelism
    • Intraoperation Parallelism
    • Parallel Join
    • Cost of Parallel Evaluation of Operations

Branch : Computer Science and Engineering | Subject : Database Management Systems
Distributed Databases
  • HomogeneousandHeterogeneousDatabases

    Read topic
  • Distributed Data Storage

    Read topic
  • Transparency

    Read topic
  • Distributed Transactions

    Read topic
  • Commit Protocols

    Read topic
  • Three-Phase Commit

    Read topic
  • ConcurrencyControl inDistributedDatabases

    Read topic
  • Local wait-for graphs

    Read topic
  • Heterogeneous Distributed Databases

    Read topic
  • Directory Systems

    Read topic