DoC Computing Support Group


Differences between revisions 1 and 2
Revision 1 as of 2008-09-12 23:26:42
Size: 1120
Editor: dwm
Comment:
Revision 2 as of 2008-09-15 16:24:17
Size: 1120
Editor: dwm
Comment:
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
  * ~+`db-research.doc.ic.ac.uk`+~, running PostgreSQL 8.3, dedicated for DoC research group activities.   * ~+`db-research.doc.ic.ac.uk`+~, running PostgreSQL 7.4, dedicated for DoC research group activities.

Database Services

Relational Database Management Systems (RDBMS) provide you the ability to store large amounts of relational (tabular) records in many interlinked tables. A query language called SQL (the Structured Query Language) is used to create tables, insert/update records, and perform complex queries on the data.

In DoC, we support the following RDBMS implementations:

  • PostgreSQL, a high-quality open-source RDBMS, originally created as a reimplementation of Ingres;

  • Microsoft SQL Server, Microsoft's flagship SQL server implementation, which is remarkably similar to the old Unix RDBMS, Sybase.

Current PostgreSQL services offered include:

  • db.doc.ic.ac.uk, running PostgreSQL 7.3, intended for general teaching and educational use;

  • db-research.doc.ic.ac.uk, running PostgreSQL 7.4, dedicated for DoC research group activities.

Current Microsoft SQL services offered include:

  • db-ms.doc.ic.ac.uk, running SQL Server 2003, intended for general teaching and educational use.

 
 

services/databases (last edited 2009-06-18 16:06:52 by dcw)