Relational databases versus relational models
- đ¤ Speaker: Alex Gurney, WebFlow
- đ Date & Time: Friday 11 February 2022, 14:00 - 15:00
- đ Venue: FW26
Abstract
THIS TALK WILL BE IN SS03 , NOT FW26
The propaganda has it that relational algebra is the foundation of relational databases: we can understand SQL queries in terms of relational join, projection, and other operators. When cornered, some may admit that odd features of SQL are hard to model, like NUL Ls, SELECT DISTINCT , and aggregations. I argue that the position is even worse, and that relational models have no story for the core use cases of relational databases, where we care about transactional semantics, locking, and predictability of performance. I will give examples of problems encountered in large-scale production settings that were beyond the reach of current theory, relational or otherwise.
Series This talk is part of the Logic and Semantics Seminar (Computer Laboratory) series.
Included in Lists
- All Talks (aka the CURE list)
- bld31
- Cambridge talks
- Computing and Mathematics
- Department of Computer Science and Technology talks and seminars
- FW26
- Interested Talks
- Logic and Semantics Seminar (Computer Laboratory)
- Martin's interesting talks
- School of Technology
- tcw57âs list
- Trust & Technology Initiative - interesting events
- yk373's list
- yk449
Note: Ex-directory lists are not shown.
![[Talks.cam]](/static/images/talkslogosmall.gif)

Alex Gurney, WebFlow
Friday 11 February 2022, 14:00-15:00