Changes between Version 10 and Version 11 of Tutorials/a0Basic/Tutorial3


Ignore:
Timestamp:
Jan 17, 2006, 5:39:12 PM (19 years ago)
Author:
faiyaz
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Tutorials/a0Basic/Tutorial3

    v10 v11  
    44It is important to understand how measurements were collected and organized to be able to interpret them. The [wiki:OML ORBIT Measurement Framework] provides tools to insert points to tap available information and to effectively collect that information in a timely manner. And after the experiment is done, the user would get access to the exprimenet database generated. In general, the results of the experiment is in one [http://www.mysql.com MySQL] database. Different participating nodes populate different tables of this database. Usually, user would like to post-process or visualize those raw measurements for further analysis.
    55
    6 A number of different tools are available to interpret experimental results.  The choice of tools depends upon availability and the nature of the measurements. '''Excel and Matlab connections from your local laptop to our database server may be blocked by the firewall. Hence, until we are working on figuring out a proxy service to expose these databases based on user credentials, please use the Perl script approach.'''
     6A number of different tools are available to interpret experimental results.  The choice of tools depends upon availability and the nature of the measurements. '''Excel and Matlab connections from your local laptop to our database server may be blocked by the firewall. Hence, until we are working on figuring out a proxy service to expose these databases based on user credentials, please use any of the following approaches.'''
    77
     8== MySQL Client ==
     9
     10The easiest way to access your data is by manipulating the database directly with the MySQL Client.  From gateway.orbit-lab.org (or any of the consoles), you may access your database by issuing the following commands from the command line:
     11
     12{{{
     13$ mysql -h idb1 -u orbit -p
     14Enter password:
     15Welcome to the MySQL monitor.  Commands end with ; or \g.
     16Your MySQL connection id is 153 to server version: 4.1.15-Debian_1-log
     17
     18Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
     19
     20mysql> use   <DB NAME>;
     21
     22}}}
     23
     24Standard MySQL queries can then be made to manipulate your data.  A brief tutorial on how to use MySQL can be found [http://dev.mysql.com/doc/refman/4.1/en/index.html here].
     25
     26At the moment, all experiment databases share the same user and password;  "orbit".  The database name is your experiment ID and is displayed by the nodehandler in the first few lines of your experiment run.  It will look something like this:
     27{{{
     28 INFO init: Experiment ID: sb5_2006_01_17_11_45_23
     29}}}
    830
    931== Using Perl scripts ==