intro - Introduction YiChen ArizonaStateUniversity

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

View Full Document Right Arrow Icon
Introduction Yi Chen Arizona State University CSE 412/598: Database Management Systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
CSE 412 2 Welcome to CSE 412/598, CBS598   Database Management Systems ! Instructor:  Yi Chen,  yi@asu.edu BY 562 Office hours:   Tues 2:40–3:30pm, 5-6pm  (or by appointment) TAs:  TBA Texts and readings: Required:  Fundamentals of Database Systems , R. Elmasri and S. B.  Navathe, Addison Wesley, 5th Ed., 2007. Optional: Understanding Relational Database Query Languages , S. W.  Dietrich, Prentice Hall, 2001. Prerequisites:  CSE310
Background image of page 2
CSE 412 3 Why This Course? (I)  Every company has data, and needs  databases  How to manage databases and make the  most/best use of data?  How to store data?  How to query data?   How to update data (of multiple fragments, by  multiple users)?  How to make the data online accessible? Amazon, Orbitz, priceline, online banking,…. .
Background image of page 3

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

View Full DocumentRight Arrow Icon
CSE 412 4 Why This Course? (II)  Most CS courses concentrate on code  Our interest is managing and representing  data … we know about files for storing data and  programs to manipulate it, why do we need  anything else???  
Background image of page 4
CSE 412 5 Example: Your PDA/Cell Phone Who Phone Email Office Mike 6-2789 mike 576 Brickyard Dr. Smith 6-1234 drsmith 499 Brickyard Jane 543-2198 jane 1220 Univ. Dr. Contacts Suppose you represented this in plain text,  How would you  query/search it? (1) Find people whose office is in Brickyard (*)? What’s my friend Jane’s phone number? Now suppose it was formatted like a “table”,  What might you do  with it?  What if the data is huge and can not fit in memory? How to write  a program to process it efficiently? (2)
Background image of page 5

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

View Full DocumentRight Arrow Icon
CSE 412 6 Example (cont) Event Day When Who Where Lunch 10/24 1pm Mike Bamboo club Advice10/25 9am Dr. Smith Brickyard Biking 10/26 9am Jane Downtown Dinner 10/26 6PM Jane Food Court Calendar Who Phone Email Office Mike 6-2789 mike 576 Brickyard Dr. Smith 6-1234 drsmith 499 Brickyard Jane 543-2198 jane 1220 Univ. Dr. Contacts
Background image of page 6
CSE 412 7 Example (cont) What if you and your secretary update your calendar at  the same time? (4) What if Jane changes her name to Jenny, and after you  have updated her entries in Calendar, the computer is  down, and you are yet to update the Contact? (4) Are you able to find the contact info of Jenny?
Background image of page 7

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

View Full DocumentRight Arrow Icon
CSE 412 8 What If We Want to Include Contact Info on Our  Calendar? Do we also want to keep e-mail addresses, telephone  numbers etc.? Should we expand the number of columns in our table? (3)
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 30

intro - Introduction YiChen ArizonaStateUniversity

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

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