MySQL

Purpose: 

A software application that enables relational databases to be created, managed and queried. The database management system enables multiple users to access a database through an appropriate interface. As an open source tool, MySQL underpins a number of free software projects, such as WordPress, phpBB and other software built on a LAMP infrastructure. Although widely used, there are a number of performance issues that limit its use in some environments. For example, it is unable to use multiple CPU cores to process a single query, potentially limiting its use as a data warehouse.

Features: 
  • X/Open XA distributed transaction processing (DTP) support
  • Connector/ODBC enables connection to a MySQL server using the Open Database Connectivity (ODBC) API
  • Connector/NET enables developers to create .NET applications that use data stored in a MySQL database
A&H use case 1 description: 
The Winsor & Newton Colourman's Manuscript Archive used a MySQL database to store nearly 17,000 pages of information regarding paint-making recipes. PHP scripts were utilised to publish content using dynamically generated HTML.
A&H use case 2 description: 
The Mapping performance culture project has used MySQL to create a database of theatrical performances in Nottingham between 1857 and 1867. The database includes information on the play that was performance, the location, dates of the performance and a list of actors that appeared in it.
A&H use case 3 description: 
The Plebeian Lives and the Making of Modern London project is using MySQL to create a database of information on the lives of ordinary people in eighteenth-century London, focusing on poor relief, criminal justice, and medical care.
Publisher: 
Sun Microsystems
Creator: 
MySQL AB
Data structuring and enhancement: 
Specifications: 
Software/programming languages used: 
Alternate tool(s): 

SQL Server, Oracle