relational_algebra外文电子书籍.pdfVIP

Querying the Database • Goal: specify what we want from our database UIUC-employee ( SSN, name, address, salary) IRS-IL (SSN, city, year-of-filed-return) • Find all the employees who earn more than $50,000 and pay taxes in Champaign-Urbana. 1 Querying the Database • Could write in C++/Java, but bad idea • Instead use high-level query languages – Theoretical: Relational Algebra, Datalog – Practical: SQL – Relational algebra: a basic set of operat