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.