Introduction. Zachary G. Ives University of Pennsylvania CIS 650 – Implementing Data Management Systems September 4, 2008. Welcome to CIS 650, Database and Information Systems!. Instructor: Zachary Ives, zives@cis 576 Levine Hall North Office hours: Wednesdays, 2PM
Zachary G. Ives
University of Pennsylvania
CIS 650 – Implementing Data Management Systems
September 4, 2008
Instructor: Zachary Ives, zives@cis
Home page: www.cis.upenn.edu/~zives/cis650/
Discussion group: email@example.com
Texts and readings:
Summaries/commentary on papers (20%)
“Midterm report” (25%)
Project (50%) – team or individual:
Participation, discussion, intangibles (5%)
Not how to build an Oracle-driven Web site…
… nor even how to build Oracle…
More than just tables!
General and universal means of encoding everything!
Additional integrity constraints
A secondary concept: views
What is special about relational query languages that makes them amenable to scalability?
How do we optimize and execute queries or ensure ACID?
How do we handle heterogeneity in data and meaning?
Data streams and sensor data
How do we process infinite amounts of data?
Cloud computing, Web search
How do we partition computation along 1000s of machines and achieve reliable execution?
What’s the best way of finding data?
Red = logical
Blue = physical
Web Server /
UI / etc
SELECT * FROM STUDENT, Takes, COURSE
WHERE STUDENT.sid = Takes.sID
AND Takes.cID = cid