Mass Spectrometry Identification Database

Mass Spectrometry Identification Database or MSI db, are database containing validated identification data. They are populated using IRMa application and then can be exploited using generic database exploration software or the hEIDI (h Exploitation et Intégration des Données d'Identification) application developed at EDyP laboratory

Database supported for exporting validated identification data is Postgresql 8.x, 9.x (test done on 8.1, 8.4, 9.1). Executables can be downloaded from Postgres downloads page

• Execute PostgreSQL 8.1.msi
• Follow instructions
• Note : master password needs to be set at this stage

Under user « postgres » :

• Connect to database (dble_click)
• Create new user « example » with permission to login and create a database
• Disconnect from database (R-click)
• Reconnect under « example » username (cf. above)

• Select database Uppsala and click the button « execute arbitraty sql queries »
• In query window select file/open
• Select the file MSIDBModel (previously named ExportDBModel) included in the IRMa installation folder
• All the queries necessary to create the MSidb are now open

• Execute the queries
• The database gets populated with all the tables IRMa needs to store identifications data

• msimodel18
• model version D.1
• model version D.2
• model version D.3 - model description
• model version D.4 - model description
• model version E.1
• model version E.2