ln01 - CIS 550 Databases Val Tannen Fall 2010 Lecture Notes...

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

View Full Document Right Arrow Icon
CIS 550 – Databases Fall 2010 Val Tannen Lecture Notes 01 September 27, 2010 Slides courtesy of Susan Davidson, Zachary Ives & Raghu Ramakrishnan
Background image of page 1

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

View Full DocumentRight Arrow Icon
CIS 550 Fall 2010 Lecture Notes 01 09/27 2 Why This Course? Most CS courses concentrate on code – our interest is managing and representing data Warning: this course doesn’t focus on teaching advanced SQL or how to be an Oracle DBA (though it will get you started) … So what in the world are we studying for 14 weeks???
Background image of page 2
CIS 550 Fall 2010 Lecture Notes 01 09/27 3 From the Wikipedia entry for “database” on 8/19/2005 (check it out today!) A database is a collection of data elements (facts) stored in a computer in a systematic way, such that a computer program can consult it to answer questions. The answers to those questions become information that can be used to make decisions that may not be made with the data elements alone. The computer program used to manage and query a database is known as a database management system (DBMS). Facts may be structured in a number of ways, known as database models . For instance, one database model is to associate each fact with a record representing an entity (such as a person), and to arrange these entities into trees or hierarchies -- the hierarchical database model . Another model is to arrange facts into sets of values which satisfy logical predicates -- the relational database model .
Background image of page 3

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

View Full DocumentRight Arrow Icon
CIS 550 Fall 2010 Lecture Notes 01 09/27 4 Wikipedia entry for “database”, cont. Database management systems range from the extremely simple to the highly complex. Differences among DBMSes include whether they are capable of ensuring the integrity of the data; whether they may be used by many users at once; and what sorts of conclusions they can be programmed to compute from a set of data. The Frst database management systems were developed in the 1960s . A pioneer in the Feld was Charles Bachman . Two key data models arose at this time: the network model (developed by CODASYL ) followed by the hierarchical model (as implemented in IMS ). These were later usurped by the relational model, which was contemporary with the so-called ±at model designed for very small tasks. Another contemporary of the relational model is the object-oriented database ( OODB ).
Background image of page 4
CIS 550 Fall 2010 Lecture Notes 01 09/27 5 Example: To-Do List Buy school supplies due 9/7 Go to orientation on 9/7 Exercise every M/W/F Buy Philly postcards How does this differ from plain text? What might you do with it that you couldn’t (easily) as plain text?
Background image of page 5

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

View Full DocumentRight Arrow Icon
Lecture Notes 01 09/27 6 Example: Your PDA/Cell Phone Event Day When Who Where Lunch 10/24 1pm Zack Cavanaugh’s Advice 10/25 9am Dr. Smith 599 Levine Biking 10/26 9am Jane Pottruck Dinner 10/26 6PM Jane Food Court Calendar Who Phone Email Office Zack 6-2789 zives 576 Levine N Dr. Smith 6-1234 drsmith 599 Levine Jane 543-2198 jane 2220 Walnut St. Contacts
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 02/22/2011.

Page1 / 99

ln01 - CIS 550 Databases Val Tannen Fall 2010 Lecture Notes...

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

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