0
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 1 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 2 "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 3
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 4 <html lang="en">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 5 <head>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 6 <meta name="generator" content=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 7 "HTML Tidy for Mac OS X (vers 1st December 2004), see www.w3.org">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 8 <meta http-equiv="Content-Type" content=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 9 "text/html; charset=us-ascii">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 10
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 11 <title>Querying the contents of a repository (LTPDA Toolbox)</title>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 12 <link rel="stylesheet" href="docstyle.css" type="text/css">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 13 <meta name="generator" content="DocBook XSL Stylesheets V1.52.2">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 14 <meta name="description" content=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 15 "Presents an overview of the features, system requirements, and starting the toolbox.">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 16 </head>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 17
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 18 <body>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 19 <a name="top_of_page" id="top_of_page"></a>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 20
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 21 <p style="font-size:1px;"> </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 22
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 23 <table class="nav" summary="Navigation aid" border="0" width=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 24 "100%" cellpadding="0" cellspacing="0">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 25 <tr>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 26 <td valign="baseline"><b>LTPDA Toolbox</b></td><td><a href="../helptoc.html">contents</a></td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 27
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 28 <td valign="baseline" align="right"><a href=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 29 "repo_gui_submit.html"><img src="b_prev.gif" border="0" align=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 30 "bottom" alt="Submitting objects to a repository"></a> <a href=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 31 "repo_gui_hlq.html"><img src="b_next.gif" border="0" align=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 32 "bottom" alt="Performing High-Level Queries"></a></td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 33 </tr>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 34 </table>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 35
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 36 <h1 class="title"><a name="f3-12899" id="f3-12899"></a>Querying the contents of a repository</h1>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 37 <hr>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 38
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 39 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 40 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 41 Querying an LTPDA repository is done using standard SQL statements. The repository GUI
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 42 presents the user with the possibility to graphically build SQL statements which avoids
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 43 learning SQL syntax. Currently, the SQL statements that can be built in this way are
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 44 restricted to queries on a single database table. High-level queries, searching more database tables at once, are implemented in the following panel.
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 45 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 46 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 47 The repository GUI has a query panel which looks like the figure below:
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 48 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 49 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 50 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 51 <img src="images/repo_gui_query_1.png" alt="Repo GUI Query">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 52 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 53 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 54 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 55 In this figure, you see that the user has built a query to select all objects
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 56 submitted on the 24th February 2008. The results will contain the object id,
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 57 the submitted date, the experiment title, the experiment description, and the analysis
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 58 description. The results will be sorted in descending order of the object id.
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 59 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 60 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 61 Executing the query (click the 'Execute query' button) produces the results table
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 62 shown below.
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 63 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 64 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 65 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 66 <img src="images/repo_gui_query_2.png" alt="Repo GUI Query Results">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 67 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 68 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 69 <p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 70 The query string that is actually executed is presented in the text edit
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 71 box above the 'Execute query' button. This query string can be edited to allow for finer
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 72 control over the query. This is meant for users who already have a working knowledge of MySQL
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 73 SQL syntax.
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 74 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 75
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 76
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 77 </p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 78
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 79 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 80 <br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 81 <table class="nav" summary="Navigation aid" border="0" width=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 82 "100%" cellpadding="0" cellspacing="0">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 83 <tr valign="top">
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 84 <td align="left" width="20"><a href="repo_gui_submit.html"><img src=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 85 "b_prev.gif" border="0" align="bottom" alt=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 86 "Submitting objects to a repository"></a> </td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 87
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 88 <td align="left">Submitting objects to a repository</td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 89
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 90 <td> </td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 91
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 92 <td align="right">Performing High-Level Queries</td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 93
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 94 <td align="right" width="20"><a href=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 95 "repo_gui_hlq.html"><img src="b_next.gif" border="0" align=
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 96 "bottom" alt="Performing High-Level Queries"></a></td>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 97 </tr>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 98 </table><br>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 99
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 100 <p class="copy">©LTP Team</p>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 101 </body>
Daniele Nicolodi <nicolodi@science.unitn.it>
parents:
diff
changeset
+ − 102 </html>