Author: harry

Databases

harry

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

ECS613U/ECS716P - Advanced Database Systems

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.

Software

harry

The School uses a lot of open source software and some proprietory software. All of it comes with licensing restrictions, ranging from highly restrictive (e.g. Matlab, MS Office) through the GPL to the very open (e.g. various BSD licensed programs).

The School has MS Office in its teaching laboratories, but we also install Libre Office, which is free to download and cross-platform.

The College also licenses proprietory software which we are able to use, e.g. Endnote.

As much as possible, we purchase “concurrent licences” – these allow a specified number of people to use the software simultaneously, but are much cheaper than a site license (everyone in EECS could use it) and more convenient than individual licenses (particular named people can use it).

 

You will find bellow more information for a number of the software available in  EECS Desktops and/or Servers:

MATLAB

Oxygen XML Editor

LaTeX

LabView

 

 

 

EECS Username

harry

You might not know this, but as an EECS member (Staff/PhD) you have a second account which you will use only for services in EECS.

QMUL username

As a member of Queen Mary University, you will have a username allocated to you. Staff, research and PHD students will have a username of the format abc123@qmul.ac.uk. While undergraduate and masters students will have the format ab12345@qmul.ac.uk.

You will use that username to access your Email, WiFi (Eduroam), the Library and other QMUL services.

EECS username

As a member of EECS, you will be provided by the School with a second account (EECS username). You will use it to access Desktops, Servers, VPN, File shares, Printing and other EECS Services.

  • Staff/Guests/Research: the EECS username is usually a combination of the first and last name, for e.g. for Jane Doe it would be something like janed or jane or jdoe.

Visitors

EECS Visitors usually do not have a QMUL username but they can request an ‘EECS guest account’ from the EECS Reception (CS300) in order to access services provided by EECS.

 

Forgot my password!

Here’s what you can do in case you forgot your password:

http://support.eecs.qmul.ac.uk/faq/reset-eecs-password/

Labview

harry

The University has National Instruments Academic Suite site license for staff and students. This license provides use of Student edition of LabView which you can use for instrument control, data acquisition and monitoring.

Installation

Before installation please make sure that you have a valid National Instruments account.

You can obtain the software in the following ways:

  • Download LabVIEW Student Edition Software Suite from here
  • Download LabVIEW and Toolkits individually from here
  • Search for the products and download individually from here

During the installation please use the following student install serial number:

Please note that the above serial number is valid only for one year.

LaTeX

harry

The LaTeX command typesets a file of text using the TeX program and the LaTeX Macro package for TeX. To be more specific, it processes an input file containing the text of a document with interspersed commands that describe how the text should be formatted. It produces two files as output, a Device Independent (DVI) file that contains commands that can be translated into commands for a variety of output devices, and a `transcript’ or `log file’ that contains summary information and diagnostic messages for any errors discovered in the input file.

For a description of what goes on inside TeX, you should consult The TeXbook by Donald E. Knuth, ISBN 0-201-13448-9, published jointly by the American Mathematical Society and Addison-Wesley Publishing Company. Some documentation can be found in TEX_DISK:[TEX.DOC…].

For a description of LaTeX, you should consult “A Document Preparation System: LaTeX” by Leslie Lamport, ISBN 0-201-15790-X, published jointly by the American Mathematical Society and Addison-Wesley Publishing Company. Some documentation can be found in TEX_DISK:[TEX.DOC…].

Parameters

input-file, …

The input file specification indicates the file to be formatted; TeX uses TEX as a default file extension. If you omit the input file entirely, TeX accepts input from the terminal. You specify command options using the conventional VAX/VMS arrangement — options begin with a slash mark (/), and are placed following the command name or following the input file specification.

Output files are always created in the current directory; the DVI file has the file type DVI, and the log file has the file type LIS. When you fail to specify an input file name, TeX bases the output names on the file specification associated with the logical name TEX_OUTPUT.

MATLAB

harry

The University has Matlab Total Academic Headcount License (TAH) for researchers and staff. This license provides unlimited use of Matlab and the following toolboxes for research and teaching:

Simulink Bioinformatics Toolbox
Communications System Toolbox Computer Vision System Toolbox
Control System Toolbox Curve Fitting Toolbox
DSP System Toolbox Data Acquisition Toolbox
Database Toolbox Datafeed Toolbox
Econometrics Toolbox Embedded Coder
Filter Design HDL Coder Financial Instruments Toolbox
Financial Toolbox Fuzzy Logic Toolbox
Global Optimization Toolbox Image Acquisition Toolbox
Image Processing Toolbox Instrument Control Toolbox
MATLAB Builder EX MATLAB Builder JA
MATLAB Builder NE MATLAB Coder
MATLAB Compiler MATLAB Report Generator
Mapping Toolbox Model Predictive Control Toolbox
Neural Network Toolbox OPC Toolbox
Optimization Toolbox Parallel Computing Toolbox
Partial Differential Equation Toolbox RF Toolbox
Robust Control Toolbox Signal Processing Toolbox
SimMechanics Simscape
Simulink 3D Animation Simulink Coder
Simulink Control Design Simulink Design Optimization
Spreadsheet Link EX Stateflow
Statistics Toolbox Symbolic Math Toolbox
System Identification Toolbox Trading Toolbox
Wavelet Toolbox xPC Target

Using Matlab in the School

The School Matlab concurrent license server serves the TAH license to managed PCs connected to the EECS networks. Additionally, Matlab is available on the general purpose Linux login servers, amd the EECS computing clusters.

Offsite Use by Researchers

The Matlab TAH license also allows PhD students and staff to register for a designated computer license, which allows usage when not on the campus network, making it possible to use Matlab at conference or for field work. For more information about registering for a designated computer license, please email its-helpdesk@qmul.ac.uk

Taught Students

Taught students can use Matlab in the labs, but the installation on equipment NOT owned by the College is NOT allowed at this time.

oXygen XML Editor

harry

The latest version of oXygen XML Editor can be downloaded from here.

Please use the following license key for the use of your home assignments and enter the below 9 lines of text  when prompted to “Use a license key” during installation:

------START-LICENSE-KEY------
Registration_Name=Tim Kay
Company=Queen Mary University of London
Category=Academic-Site
Component=XML-Editor, XSLT-Debugger, Saxon-SA
Version=20
Number_of_Licenses=1
Date=10-15-2018
Maintenance=698
SGN=MC0CFQCHkh9aTv+F9o3N+On2jwKAFI/jpAIUPLNVVXd+Is/AwXGrK0aiMxB8fQw\=
-------END-LICENSE-KEY-------