CMSI 486, Fall 2012 - John David N. Dionisio, PhD

CMSI 486

Note: This page is maintained as an archival record of the course shown above, and as such, some links on this page may no longer be valid nor accessible. They are kept here as a record of the resources that were available at the time of the course offering.

Assignment 0906: 1c, 3a, 4a, 4c, 4d, 4e, 4f
Assignment 0918: 1a, 3a, 3d, 4d, 4e, 4f
- Fake data SQL script
Assignment 1011: 1a–1c, 3b–3d, 4a–4f
Assignment 1023, 1025
- Assignment 1023: 1a–1c, 3b–3d, 4a–4f
- Assignment 1025: 1a, 3d, 4a–4e
Assignment 1101, 1108, 1115, 1129: 1a–1c, 3b–3d, 4a–4f

These links take you to web sites beyond this server. The sites are in no particular order or bias, just as they came to mind.

The PostgreSQL home page: An industrial-strength, open source database management system
- Go to http://jdbc.postgresql.org to access PostgreSQL’s JDBC Driver.
The Hibernate home page: Object-relational mapping between Java and a relational database system
- The Hibernate Annotations reference will be of particular interest in this course.
Jersey will wrap our databases in a RESTful way… (see below)
…to be served up by Apache Tomcat over the web

As seminal as they get: E. F. Codd’s A Relational Model of Data for Large Data Banks, Communications of the ACM 13(6), June 1970
There is no shortage of material on SQL, so may as well start with its Wikipedia page
Not strictly database-related, but useful: Roy Fielding’s doctoral dissertation, which introduced Representational State Transfer (REST) to the world
In case you’ve never seen it, here’s RFC 2616—the HTTP/1.1 specification (note the first author)