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.
- 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.
Data structuring and enhancement:
Software/programming languages used:
SQL Server, Oracle