This week’s topics
Data Storage Architectures and Database Management
- Relational databases (RDBMS)
- NoSQL databases
- Cloud storage infrastructures
- Data warehouses
- Data lakes
- Relational vs. Non-Relational Databases
- What is a Data Warehouse?
- Data Lakehouses Explained
What you will be able to do
- 1.2 Analyse the different ways in which data is stored and processed for use in an organisation.
Activity
Start with this week’s 3 videos, then: Seminar, guided reading and a short written task: analyse the different ways in which data is stored and processed for use in an organisation.
Study materials
Videos
- Relational vs. Non-Relational Databases · YouTube · IBM Technology · 8 min · for registered students
- What is a Data Warehouse? · YouTube · IBM Technology · 8 min · for registered students
- Data Lakehouses Explained · YouTube · IBM Technology · 9 min · for registered students
- 03 - Database Storage Models & Data Layout (CMU Advanced Databases / Spring 2023) · YouTube · CMU Database Group · 78 min · for registered students
Further resources
- Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
- MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
- Foundations of Information Systems, ch. 3: Database Management Systems · PDF · OpenStax, textbook chapter; pp. 91–124 · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
