Databases

We currently provide three Database Management Systems (DBMSs) for student use. All three DBMS run on a single server, dbprojects.eecs.qmul.ac.uk, and can be accessed using command-line clients (e.g. sqlplus/mysql/psql) or JDBC clients from various machines within the college.

To create an account on any of the school database servers please follow the setup links below.

Name Version Details Setup Required for
Mysql 5.5 www.mysql.org https://webprojects.eecs.qmul.ac.uk/info/details.php ECS417U
Oracle 11G R2 www.oracle.com https://webprojects.eecs.qmul.ac.uk/info/details.php ECS613U ECS716P
Postgres 8.4.20 www.postgresql.org https://webprojects.eecs.qmul.ac.uk/info/details.php ECS519U ECS740P

The following modules make use of the above Databases, for more info check the lecture notes and the instructions on your webprojects page.

This course uses a PHP enabled web server: http://webprojects.eecs.qmul.ac.uk/ This provides the full LAMP stack, including MySQL and optionally Postgres or Oracle. To set up an account go to https://webprojects.eecs.qmul.ac.uk/info/details.php

Students on this course will require an account on the postgres database server. To set this up go to https://webprojects.eecs.qmul.ac.uk/info/details.php
Students on this course will require Oracle accounts. To set this up go to https://webprojects.eecs.qmul.ac.uk/info/details.php
There is a Twitter database (1% feed) available for project work. Raise a Helpdesk Ticket if you want to use it. More documentation will follow on the IMC wiki.
hird year and other project-based courses can take advantage of any of this infrastructure. If you need anything other than that provided through https://webprojects.eecs.qmul.ac.uk/info/details.php please raise a Raise a Helpdesk Ticket as early as possible in your project and we will do our best to assist.