Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 6 Diploma in Information Technology

Database Engine Architecture and Platform Selection

IT603 · Advanced Database Management Systems — Week 3 of 16

CourseIT603
Week3 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Database Engine Architecture and Platform Selection

  1. Proprietary enterprise systems
  2. Open-source DBMS platforms
  3. Total cost of ownership
  4. Licensing and ecosystem viability
  5. #14 - Parallel Query Engine Architectures ✸ SpiralDB Database Talk (CMU Intro to Database Systems)

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.

Activity

Start with this week’s video, 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

  • #14 - Parallel Query Engine Architectures ✸ SpiralDB Database Talk (CMU Intro to Database Systems) · YouTube · CMU Database Group · 79 min · for registered students
  • #22 - Distributed Database Architectures ✸ DataStax Database Talk (CMU Intro to Database Systems) · YouTube · CMU Database Group · 83 min · for registered students
  • SpiralDB: Building a Machine-scale Database (Will Manning) · YouTube · CMU Database Group · 11 min · for registered students
  • CMU Database Systems - 14 Parallel Execution (Fall 2018) · YouTube · CMU Database Group · 40 min · for registered students
  • 13 - Parallel Query Execution (CMU Intro to Database Systems / Fall 2022) · YouTube · CMU Database Group · 64 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, 12.2: Intellectual Property · PDF · OpenStax, textbook chapter; pp. 450–459 · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Relational Theory and Normalisation
  • Week 2: Database Modelling Languages
  • Week 3: Database Engine Architecture and Platform Selection
  • Week 4: Logical Modelling and Normalisation Practice
  • Week 5: Physical Database Design and Build
  • Week 6: Advanced Querying and Data Extraction
  • Week 7: Database Access Control and Granular Security
  • Midterm: Midterm evaluation
  • Week 9: Database Threat Landscape and Risk Evaluation
  • Week 10: Database Functional and Performance Testing
  • Week 11: Database Administration and Enterprise Resilience
  • Week 12: Applying Advanced Database Management Systems in practice: …
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll