What was the first recognisable relational database system?
IBM SABRE reservation system
Who defined the rules for relational databases?
Edgar F. Codd
Who introduced the ER model?
Peter Chen
What is SQL?
The standard query language for relational databases
Name two early relational databases
System R and Ingres
Which company created DB2?
IBM
Name three major commercial databases
Oracle, SQL Server, IBM DB2
What is a commercial database license?
A paid license with vendor support
Name three popular open-source databases
MySQL, PostgreSQL, SQLite
What does open-source licensing allow?
Viewing, modifying, and distributing source code
Who created SQLite?
Dwayne Richard Hipp
What organisation ranks database popularity?
DB-Engines
Name two factors used in DB-Engines rankings
Search engine mentions, job postings, Stack Overflow activity
Which database ranked highest in 2021 popularity?
Oracle
What percentage of popularity did open-source databases reach in 2023?
0.5529999999999999
What is a cloud database?
A database hosted on a cloud platform
Give two advantages of cloud databases
Scalability, global access, backups, disaster recovery
What percentage of databases are expected to be cloud-based by 2025?
0.8
Name two cloud database services
Amazon DynamoDB, Azure SQL Database
Why are cloud databases growing in popularity?
SaaS adoption and scalability needs
What decade saw cloud databases become popular?
2010s
Which open-source database uses GPL v2 license?
MySQL
Which open-source database uses public domain license?
SQLite
Which open-source database uses PostgreSQL license?
PostgreSQL
