CompSci 316 (Fall 2013):
Introduction to Database Systems

Course Information   Lecture Notes   Assignments   Tentative Syllabus   Programming Notes   Homework/Project Submission   Sakai (Grades & Solutions)   Piazza (Q&A)
Getting Started with Windows Azure (Linux) Virtual Machine   Getting Started with Gradiance   PostgreSQL Notes   Using ra   JDBC Notes   Tomcat Notes   Django Notes   PHP Notes   XML Notes

Using RA


RA is a simple relational algebra interpreter. It has already been installed for you, and it is set up to connect to the local PostgreSQL server. So just log in and type ra at the shell prompt.

For details on how to use RA, please refer to the public RA homepage, but ignore the parts about getting RA and SQLite being the default---your installation is set up differently.

To create/restore the db-beers database in PostgreSQL (the SQLite version of which was used as a running example on the RA homepage), run "/opt/dbcourse/examples/db-beers/setup.sh" from the shell.

Last updated Wed Sep 11 10:18:07 EDT 2013