firststeps
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
firststeps [2009/12/13 14:30] 78.237.168.112 |
firststeps [2010/01/05 14:08] 132.168.74.230 |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| - | ===== Connecting ===== | + | * First of all you need to [[how_to:dbconnection|get a connection on the MSI db]] (Mass Spectrometer Identification database)\\ |
| - | + | * [[how to:createProject|Create an hEIDI project]]\\ | |
| - | First of all, we need to get a connection on a Mass Spectrometer Identification database (MSI db). | + | * [[how_to:opensession|Open a working session on the MSI db]]\\ |
| - | In the Service window, select the database server hosting the MSI DB and enter connection properties in approprated field. | + | |
| - | + | ||
| - | {{:connect.png|}} | + | |
| - | + | ||
| - | **Connection to a postgres server** | + | |
| - | + | ||
| - | ===== hEIDI Projects ===== | + | |
| - | + | ||
| - | It is possible to create hEIDI projects in order to organise data. For now, data consist of SQL queries... | + | |
| - | To create a Project, click right in the ''Project'' window or choose ''File > New Project'' menu and only specify the project name in the wizard. | + | |
| - | + | ||
| - | + | ||
| - | ===== SQL Queries ===== | + | |
| - | + | ||
| - | Once the connection is successful, the first simple feature is to explore the database or create SQL queries. Information on MSI database and its model is available [[http://biodev.extra.cea.fr/docs/irma/doku.php?id=msidb| here ]]. | + | |
| - | + | ||
| - | You can create new SQL files from hEIDI project (''File > New File'' menu then choose ''Empty File'' or directly ''New Empty File'' from hEIDI Project window) . It is also possible to select a Table under database connection and choose ''Veiw Data''. | + | |
| - | + | ||
| - | {{:sql_comment.png|}} | + | |
| - | + | ||
| - | ** SQL queries sample ** | + | |
| - | + | ||
| - | + | ||
| - | ===== Open MSI Session ===== | + | |
| - | + | ||
| - | To open a working session on the MS identification database, select the connection in ''Service Window'' and open menu ''MS Identification > Open session''. | + | |
| + | * [[how to:writeSqlQueries|Write some SQL queries to explore the database ]]\\ | ||
firststeps.txt · Last modified: 2010/01/05 15:40 by 132.168.73.247
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
