This week’s topics
Database Administration and Enterprise Resilience
- Automated backup and disaster recovery
- High availability failover
- Continuous performance monitoring
- Compliance audit procedures
- #22 - Database Crash Recovery ✸ ClickHouse Database Talk (CMU Intro to Database Systems)
- Disaster Recovery vs. Backup: What's the difference?
What you will be able to do
- 1.3 Critically evaluate different database management systems available in relation to open source and vendor-specific platforms.
- 3.4 Test the system for functionality and performance
- 3.5 Evaluate security risks to the database.
Activity
Start with this week’s 2 videos, then: Seminar, guided reading and a short written task: critically evaluate different database management systems available in relation to open source and vendor-specific platforms.
Study materials
Videos
- #22 - Database Crash Recovery ✸ ClickHouse Database Talk (CMU Intro to Database Systems) · YouTube · CMU Database Group · 78 min · for registered students
- Disaster Recovery vs. Backup: What's the difference? · YouTube · IBM Technology · 10 min · for registered students
- #21 - Database Recovery with ARIES (CMU Intro to Database Systems) · YouTube · CMU Database Group · 73 min · for registered students
- F2023 #20 - Database Recovery (CMU Intro to Database Systems) · YouTube · CMU Database Group · 84 min · for registered students
- 20 - Database Recovery (CMU Intro to Database Systems / Fall 2021) · YouTube · CMU Database Group · 72 min · for registered students
- 21 - ARIES Database Recovery (CMU Databases Systems / Fall 2019) · YouTube · CMU Database Group · 78 min · for registered students
- CMU Advanced Database Systems - 12 Recovery Protocols (Spring 2019) · YouTube · CMU Database Group · 73 min · for registered students
- Lecture #13 - Logging & Recovery (Physical Logging) [CMU Database Systems Spring 2016] · YouTube · CMU Database Group · 76 min · for registered students
- CMU Database Systems - 21 Database Recovery (Fall 2018) · YouTube · CMU Database Group · 77 min · for registered students
Further resources
- NIST SP 800-34 Rev. 1, ch. 3: Information System Contingency Planning Process · PDF · NIST, textbook chapter; pp. 13–33 · for registered students
- MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
- The rise of crypto-ransomware in a changing cybercrime landscape: taxonomising countermea… · PDF · Reading, article · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
