01_intro

01_intro - CPS 216: Data-intensive Computing Systems...

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

View Full Document Right Arrow Icon
CPS 216: Data-intensive Computing Systems Shivnath Babu
Background image of page 1

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

View Full DocumentRight Arrow Icon
A Brief History Relational database management systems Time 1975- 1985 1985- 1995 1995- 2005 2005- 2010 2020 Let us first see what a relational database system is
Background image of page 2
Data Management Data Query Query Query User/Application D ata B ase M anagement S ystem (DBMS)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Example: At a Company ID Name DeptID Salary 10 Nemo 12 120K 20 Dory 156 79K 40 Gill 89 76K 52 Ray 34 85K ID Name 12 IT 34 Accounts 89 HR 156 Marketing Employee Department Query 1: Is there an employee named “Nemo”? Query 2: What is “Nemo’s” salary? Query 3: How many departments are there in the company? Query 4: What is the name of “Nemo’s” department? Query 5: How many employees are there in the “Accounts” department?
Background image of page 4
D ata B ase M anagement S ystem (DBMS) High-level Query Q DBMS Data Answer Translates Q into best execution plan for current conditions, runs plan
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example: Store that Sells Cars Make Model OwnerID Honda Accord 12 Toyota Camry 34 Mini Cooper 89 Honda Accord 156 ID Name Age 12 Nemo 22 34 Ray 42 89 Gill 36 156 Dory 21 Cars Owners Filter (Make = Honda and Model = Accord) Join (Cars.OwnerID = Owners.ID) Make Model OwnerID ID Name Age Honda Accord 12 12 Nemo 22 Honda Accord 156 156 Dory 21 Owners of Honda Accords who are <= 23 years old Filter (Age <= 23)
Background image of page 6
D ata B ase M anagement S ystem (DBMS) High-level Query Q DBMS Data Answer
Background image of page 7

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

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

This document was uploaded on 01/17/2012.

Page1 / 18

01_intro - CPS 216: Data-intensive Computing Systems...

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

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