This preview shows pages 1–12. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full 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. Semistructured data model (e.g., XML). 3. Objectrelational 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 Semistructured 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.
 Fall '08
 CMMALIK

Click to edit the document details