CIS 450/550: Database & Information Systems (Fall 2020)
Instructor:
|
Prof. Susan Davidson, susan@cis.upenn.edu Office hours: Tuesday 4-5 Location: Zoom |
Lecture Coordinates:
| Time | Place |
|---|---|
| MW 12:00-1:20 | Zoom |
Recitation Coordinates (optional, starting 9/10-11) one of the following:
| Section | Time | Place |
|---|---|---|
| 403 | Thu, 5:00-6:30 PM | Online TBD |
| 404 | Fri, 12:00-1:30 PM | Online TBD |
Course Description:
Structured information is the lifeblood of commerce, government, and science today. This course provides an introduction to the broad field of information management systems, covering a range of topics relating to structured data, from data modeling to logical foundations and popular languages, to system implementations. We will study the theory of relational data design; the basics of query languages; efficient storage of data, execution of queries and query optimization; transactions and updates; and "big data" and NoSQL systems.
Topics Covered:
Database design using ER modeling, relational algebra, SQL, views, relational design theory, indexing, transactions, query optimization, data import and munging, client-side & server-side Web development, NoSQL systems (MongoDB, Neo4j) and Map/Reduce.
Textbook:
Ramakrishnan and Gehrke, Database Management Systems, 3rd ed, McGraw-Hill
Workload:
Six homeworks, weekly on-line quizzes and group exercises, two midterms, and a group project. Weekly recitations are optional but strongly recommended; students will work in groups on the exercises which will prepare them to do the homeworks.
Grading: TDB
Late Policy:
Late homeworks (up to 3 days) will be given half credit; after 3 days they will not be accepted. You are allowed three "free" late homeworks (no credit lost). No late quizzes or group exercises will be accepted.