lecture-02-intro-relational-model

Lecture-02-intro-rel - The Relational Model T M Murali T M Murali CS4604 The Relational Model Course Outline I Weeks 1–5 13 Query/Manipulation

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The Relational Model T. M. Murali August 25, 2010 T. M. Murali August 25, 2010 CS4604: The Relational Model Course Outline I Weeks 1–5 , 13: Query/Manipulation Languages I The relational model I Relational Algebra I SQL I Data definition I Programming with SQL I Weeks 6–8: Data Modelling I Weeks 9–13: Relational Design I Week 14–15: Students’ choice T. M. Murali August 25, 2010 CS4604: The Relational Model What is a Data Model? I Data model: notation for describing data or information. T. M. Murali August 25, 2010 CS4604: The Relational Model What is a Data Model? I Data model: notation for describing data or information. I Structure of the data: models in databases are conceptual as opposed to physical. I Operations on the data: databases data models allow limited set of queries and modifications. I Constraints on the data: database data models support specifications of constraints on the data. T. M. Murali August 25, 2010 CS4604: The Relational Model What is a Data Model? I Data model: notation for describing data or information. I Structure of the data: models in databases are conceptual as opposed to physical. I Operations on the data: databases data models allow limited set of queries and modifications. I Constraints on the data: database data models support specifications of constraints on the data. I Examples of Data Models: 1. Relational data model. 2. Semi-structured data model (e.g., XML). 3. Object-relational models. T. M. Murali August 25, 2010 CS4604: The Relational Model The Relational Model CoursesTaken Student Course Grade Hermione Grainger Potions A- Draco Malfoy Potions B Harry Potter Potions A Ron Weasley Potions C I Structure: Table (like an array of structs) I Operations: Relational algebra (selection, projection, conditions, etc.) I Constraints: E.g., grades can be from a fixed list. T. M. Murali August 25, 2010 CS4604: The Relational Model T. M. Murali August 25, 2010 CS4604: The Relational Model The Semi-structured Model <CoursesTaken> <Student>Hermione Grainger</Student> <Course>Potions</Course> <Grade>A-</Grade> <Student>Draco Malfoy</Student> <Course>Potions</Course> <Grade>B</Grade> ... </CoursesTaken> I Structure: Trees or graphs, tags define role played by different pieces of data. I Operations: Follow paths in the implied tree from one element to another. I Constraints: Can express limitations on data types. T. M. Murali August 25, 2010 CS4604: The Relational Model Comparison of Models I Flexibility: T. M. Murali August 25, 2010 CS4604: The Relational Model Comparison of Models I Flexibility: XML models can represent graphs. T. M. Murali August 25, 2010 CS4604: The Relational Model Comparison of Models I Flexibility: XML models can represent graphs....
View Full Document

This note was uploaded on 12/24/2011 for the course CS 4604 taught by Professor Cmmalik during the Fall '08 term at Virginia Tech.

Page1 / 31

Lecture-02-intro-rel - The Relational Model T M Murali T M Murali CS4604 The Relational Model Course Outline I Weeks 1–5 13 Query/Manipulation

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online