Creating the BioMart Database Schema
BioMart uses a separate database schema to the main PRIDE database schema. The BioMart schema follows the BioMart guidelines to create a query-optimised 'inverse star' schema. This schema is created and populated by an SQL script that selects public data from the main PRIDE schema.
To allow this script to work, the BioMart schema should be located on the same database server as the main PRIDE schema. Configuration for MySQL is currently available.
For the PRIDE BioMart installation at the EBI, we are currently making use of two BioMart database schemata that are swapped each week (or immediately following a large submission of public data to PRIDE). This helps to ensure that the BioMart service is down for a very short time (perhaps a minute) between updates. It is recommended that a similar mechanism is adopted elsewhere.
A complete SQL script is available to create and populate these schemata. (The scripts begin with
Before use you will need to use a text editor with a global search and replace function to insert the correct names for your main pride schema and the biomart schema as follows:
You must run this script under a MySQL login account that has (as a minimum) SELECT privileges on the main PRIDE schema and SELECT, INSERT, DELETE, CREATE, DROP, REFERENCES and INDEX privileges on the BioMart schema.
You should then be able to run this script using the MySQL command line client or a GUI client that allows you to run SQL scripts. This may take a few minutes or even longer depending on the size of your main PRIDE database.
At the end of this process you should check that you have created and populated the BioMart tables as defined in the script in your BioMart schema. Note that some tables may not be populated depending on the data in your main PRIDE schema.
Installing the MartView Web Application and MartEditor Tool
The process of installing MartView and MartEditor is documented in detail at http://www.biomart.org/install.html. MartView is the BioMart web application and web service. MartEditor is also required to allow you to load and configure the user interface from the PRIDE BioMart scripts.
It is recommended that as a minimum you read the entire 'Quick Install Guide' that is available from this page and follow the instructions to install the Perl modules from CPAN and the MartView and MartEditor software from CVS.
Once you have completed the installation of MartView and MartEditor, return to this page to continue the installation of the PRIDE BioMart system.
Configuring the MartView Web Application
Configuring the PRIDE BioMart interface with the MartEditor tool
Following the instructions in the BioMart 'Quick Install Guide', start the MartView application. This is a Java application, so please check that you have a correctly configured Java virtual machine installed. You will need to enter your BioMart database connection details to allow this to work, as illustrated in the example dialogue box below.
Once you have successfully connected to the BioMart using the MartEditor tool, you next need to install the interface definition. This is in the form of two XML files:
On the MartEditor tool, select the menu "File"..."Upload All". Accept the warning message by clicking on "Yes".
Now browse to the interface_definition_xml folder, hold the CTRL (PC) or Apple (Mac) key and select both the pride_template.template.xml file and the pride.xml file. Click on "Open". It will take a few seconds for the user interface definition to be loaded into your BioMart Database.
You must now select the menu "File"..."Update All". Wait a few seconds while this update completes.
Now the default user interface definition has been loaded and updated, you must now edit this definition to tailor it to your local installation.
Select the menu "File"..."Import". A window will appear with a 'tree' view of the definition on the left and detailed configuration displayed on the right. There are several points in this definition that are specific to the EBI installation of BioMart that you must modify. These are detailed below.
Save your changes by selecting the menu item "File"..."Export".
Of course if you are familiar with defining BioMart interfaces, you may wish to modify the BioMart interface more extensively. To assist you with this, you may wish to examine the most recent PRIDE BioMart database schema diagram, which can be found in your code download folder:
As described in the BioMart 'Quick Install Guide', it is necessary to create a MartRegistry.xml file that defines the connection to the BioMart database. Your mart registry file should be based upon the following, replacing all the items in square brackets with the correct configuration for your BioMart database:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE MartRegistry> <MartRegistry> <MartDBLocation databaseType="mysql" host="[MYSQL_SERVER]" port="[MYSQL_SERVER_PORT_NUMBER]" database="[PRIDE_BIOMART_SCHEMA_NAME]" schema="[PRIDE_BIOMART_SCHEMA_NAME]" name="pride" displayName="PRIDE BioMart" user="[DATABASE_USERNAME]" password="[DATABASE_PASSWORD]" visible="1" default="1" includeDatasets="" martUser="" /> </MartRegistry>
You are now ready to run your PRIDE BioMart by following the instructions in the BioMart 'Quick Install Guide'.
Note that your PRIDE BioMart will have the default BioMart look and feel. If you wish to 're-skin' your BioMart to look like the EBI PRIDE BioMart (or a modified version of this) you will need to add / replace the configuration for the MartView with the files listed below and included in the PRIDE BioMart download. (It is recommended that you back up any configuration files that you are replacing). The paths of the files in the download package are the same as the paths of the files in the MartView folder.