Useful Links
1. Introduction to Databases and DBMS
2. Data Models
3. The Relational Model
4. Database Design
5. SQL (Structured Query Language)
6. Storage and File Structure
7. Query Processing and Optimization
8. Transaction Management
9. Recovery Systems
10. Database Security
11. Distributed Database Systems
12. NoSQL Database Systems
13. Data Warehousing and OLAP
14. Emerging Database Technologies
  1. Computer Science
  2. Databases

Database Management Systems

1. Introduction to Databases and DBMS
2. Data Models
3. The Relational Model
4. Database Design
5. SQL (Structured Query Language)
6. Storage and File Structure
7. Query Processing and Optimization
8. Transaction Management
9. Recovery Systems
10. Database Security
11. Distributed Database Systems
12. NoSQL Database Systems
13. Data Warehousing and OLAP
14. Emerging Database Technologies
  1. Recovery Systems
    1. Failure Types
      1. Transaction Failures
        1. Logical Errors
          1. System Errors
          2. System Crashes
            1. Software Failures
              1. Hardware Failures
              2. Disk Failures
                1. Media Failures
                  1. Head Crashes
                2. Storage Types
                  1. Volatile Storage
                    1. Non-Volatile Storage
                      1. Stable Storage
                      2. Recovery Concepts
                        1. Data Recovery
                          1. Transaction Recovery
                            1. System Recovery
                            2. Log-Based Recovery
                              1. Write-Ahead Logging
                                1. Log Structure
                                  1. Log Records
                                    1. Log Sequence Numbers
                                    2. Recovery Algorithms
                                      1. Deferred Update Recovery
                                        1. Immediate Update Recovery
                                        2. Checkpointing
                                          1. Checkpoint Types
                                            1. Checkpoint Frequency
                                              1. Recovery with Checkpoints
                                            2. Shadow Paging
                                              1. Shadow Page Table
                                                1. Page Allocation
                                                  1. Recovery Process
                                                  2. Advanced Recovery Techniques
                                                    1. ARIES Recovery Algorithm
                                                      1. Analysis Phase
                                                        1. Redo Phase
                                                          1. Undo Phase
                                                          2. Fuzzy Checkpointing
                                                            1. Media Recovery
                                                            2. Backup and Restore
                                                              1. Backup Strategies
                                                                1. Full Backup
                                                                  1. Incremental Backup
                                                                    1. Differential Backup
                                                                    2. Remote Backup Systems
                                                                      1. Point-in-Time Recovery

                                                                    Previous

                                                                    8. Transaction Management

                                                                    Go to top

                                                                    Next

                                                                    10. Database Security

                                                                    © 2025 Useful Links. All rights reserved.

                                                                    About•Bluesky•X.com