TitleBodyTechnical Expertise RequiredCostAdditional Information

MySQL is a relational database system (RDBMS) that runs as a server providing multi-user access to several databases. All major programming languages include libraries to access MySQL. It comes with a command line tool, with many third party graphical user interfaces also available. Although not considered a full enterprise RDBMS like Oracle or PostgreSQL, it supports most RDBMS technologies like foreign keys, triggers, views, indexing, and backup. MySQL is easy to use, sufficient for most environmental data management applications and the choice of many web server hosting companies.

MySQL is included in several third party installation bundles, providing easy installation and configuration for the most popular combinations of programs for web development. E.g. LAMP, WAMP etc. which combine Apache webserver, MySQL and PHP for Linux and Windows respectively.

Basic programming skillsFree
  • Wikipedia: http://en.wikipedia.org/wiki/MySQL
  • MySQL tutorial: http://www.mysqltutorial.org/
  • MySQL documentation: http://dev.mysql.com/doc/index.html
MySQL Workbench

MySQL Workbench is an open source, visual based tool for MySQL database design, creation and administration. It is separate from, but connects to MySQL, which is database software built on a version of Structured Query Language or SQL (see MySQL tool description in the DataONEpedia).

SQL Development
Create and manage connections to database servers.
Enables the user to configure connection parameters.
Capability to execute SQL queries on the database connections using the built-in SQL Editor.
Data Modeling
Enables you to create models of your database schema graphically.
Forward engineer, or turn diagrams into MySQL databases.
Reverse engineer, or download existing MySQL databases and represent them as diagrams.
Edit Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views.
Database Administration
Enables you to create and administer server instances.
Manage users and user permissions.
Basic programming skillsFree
SQL Server

The SQL Server is a relational model database server produced by Microsoft that provides a high performance database platform that’s reliable, scalable, and easy to manage. Its primary query languages are T-SQL and ANSI SQL. There are several Editions of the Server available, which differ depending on the services they provide.

Basic programming skillsCost-basis
  • Microsoft SQL Server : http://msdn.microsoft.com/en-us/sqlserver/default.aspx
  • SQL Server Worldwide Users Group: http://www.sswug.org/
  • http://en.wikipedia.org/wiki/Microsoft_SQL_Server
  • SQL Server Central: http://www.sqlservercentral.com/
  • SQL Server Customer Advisory Team: http://sqlcat.com/
  • Pro SQL Server 2008 XML - Michael Coles - 2008
  • Expert SQL Server 2008 Development - Alastair Aitchison, Adam Machanic - 2009