Lecture 6: Tuple Relational Calculus

Title slideAnother lecture, another language. This one is the Tuple Relational Calculus for specifying queries that describe information to be extracted from the linked tables of a relational database. There’s a separation of roles here: the tuple relational calculus is good for succinctly stating what we want to find out; while relational algebra from the last lecture describes how to combine and sift tables to extract that information from the data. We distinguish what information we want from how to compute it.

There were also announcements about the IT Careers Fair and the Careers in Computer Games evening next week; as well as the story of Facebook Graph Search as an example of the power of database query languages.

Link: Slides for Lecture 6

Homework

Read This

Inside Google Spanner, the Largest Single Database on Earth.
Cade Metz. Wired, 26 November 2012.

Do This

Tuple-relational calculus can be quite tricky to understand, and it’s not always obvious to follow what a query means. So, homework this time is to read the lecture slides again, going through the examples to see how each query works. If you are stuck, say so and ask on Piazza.

References

Mark Zuckerberg announcing Facebook Graph SearchA timeline of Facebook Graph Search.

From 2013
To 2015

More search, less graph.

Those Example Graph Searches

Build your own with http://graph.tips

How it’s Done

Read the technical paper by the computer scientists who built this.

Unicorn: A System for Searching the Social Graph
Presented at the 39th International Conference on Very Large Data Bases, VLDB 2013