A SQL query walks up to two tables in a bar and asks:
“Mind if I join you?”
A SQL query walks up to two tables in a bar and asks:
“Mind
if I join you?”
Who we are
Dr. Jacek Kopecký
(unit coordinator)
Dr. Penny Ross
(lecturer)
Mark Venn
(tutor)
DBPRIN
Unit Specification
Materials:
Moodle
Books
Schedule
| # | Lecture | Seminar | |
|---|---|---|---|
| 1 | Introduction | ERD | |
| 2 | History: how did we get DBMS? | ||
| 3 | EERD | Attributes, keys | |
| 4 | Data Dictionary | ||
| 5 | Normalization 1 | EERD | |
| 6 | Normalization 2 | ||
| 7 | Reading week, guest lecture? | --- | |
| 8 | Physical Architecture | Quiz | |
| 9 | Physical Design | ||
| 10 | SQL & Relational Algebra | Physical design, indices | |
| 11 | Algebra & Optimization | ||
| 12 | Coursework Feedback | --- | |
| 13 | Performance Optimization | Relational algebra | |
| 14 | Security | ||
| 15 | Databases on the Web | Security | |
| 16 | DB on the Web: Client Technologies | ||
| 17 | DB on the Web: Server Technologies | Databases on the Web | |
| 18 | Legal, Ethical & Professional Issues | ||
| 19 | Reading week, guest lecture? | --- | |
| 20 | Transactions | Professional & ethical issues | |
| 21 | Concurrency, Deadlocks & Recovery | ||
| 22 | Stored Procedures & Triggers | Transactions & Concurrency | |
| 23 | Linked Data, Semantic DBs | ||
| 24 | Teaser: Distributed Databases | --- | |
Assessment
Interlude
What do you like?
Who has Databases?
A Look at Scale
SELECT *
FROM Candidate c
JOIN Interview i
ON i.caID = c.caID
WHERE date = CURDATE();
Two-tier Architecture
SQL
Three-tier Architecture
HTTP
Net
image of Tesla Model S interior from http://www.teslamotors.com/models
Picture of ATMs from https://sacredspaces2004.wordpress.com/2012/11/06/sacred-spaces-355-at-the-atm/
Picture of tesco scan-as-you-go scanner from http://mobile.pistonheads.com/gassing/topic.asp?h=0&f=192&t=1330248&nmt=Tescos+scan+as+you+shop
Picture of parcel scanner from http://www.dpd.com.pl/EN/subpage.asp?ID_kat=4&ID=50&Mark=11&Go=47&CATID=53