136x Filetype PPTX File size 1.17 MB Source: thodrek.github.io
Lecture 18 Today’s Lecture 1. The Relational Model & Relational Algebra 2. Relational Algebra Pt. II 2 Lecture 18 > Section 1 1. The Relational Model & Relational Algebra 3 Lecture 18 > Section 1 What you will learn about in this section 1. The Relational Model 2. Relational Algebra: Basic Operators 3. Execution 4. ACTIVITY: From SQL to RA & Back 4 Lecture 18 > Section 1 > The Relational Model Motivation The Relational model is precise, The Relational model is precise, implementable, and we can implementable, and we can operate on it (query/update, etc.) operate on it (query/update, etc.) Database maps internally into this Database maps internally into this procedural language. procedural language. Lecture 18 > Section 1 > The Relational Model A Little History Won • Relational model due to Edgar “Ted” Codd, Won Turing a mathematician at IBM in 1970 Turing award • A Relational Model of Data for Large Shared D award 1981 ata Banks 1981 ". Communications of the ACM 13 (6): 377–387 • IBM didn’t want to use relational model (take money from their Information Management System)
no reviews yet
Please Login to review.