Changes between Version 17 and Version 18 of Tutorials/a0Basic/Tutorial3


Ignore:
Timestamp:
Nov 23, 2007, 5:28:44 AM (17 years ago)
Author:
thierry
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Tutorials/a0Basic/Tutorial3

    v17 v18  
    1 [[TOC(heading=Tutorial TOC, Tutorial, Tutorial/Testbed, Tutorial/HowtoWriteScripts, Tutorial/HelloWorld,  Tutorial/CollectMeasurements, Tutorial/AnalyzeResults, depth=2)]]
     1[[TOC(heading=Tutorial TOC, Tutorial, Tutorial/AnalyzeResults, depth=2)]]
    22[wiki:Tutorial Back]
    33= Analyzing Results =
     
    66A 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 is blocked by the firewall.  We are working on a system to safely and securely export databases to experimenters.  Until then, please use any of the following approaches to retreive your data.
    77
    8 ''Note:  Currently all databases share the same credentials.''
     8''Note:  Currently all databases share the same credentials'' - '''Username and Password: orbit'''
    99
    10 '''Username and Password: orbit'''
    11 
    12 == Using MySQL Client ==
     10[[BR]]
     11== 1. Using MySQL Client ==
    1312
    1413The 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:
     
    3332}}}
    3433
    35 == Using Perl scripts ==
     34[[BR]]
     35== 2. Using Perl scripts ==
    3636
    3737Sample Perl script that gets data from the database:
     
    8484
    8585A more specific Perl script for OTG/OTR application can be found [wiki:Documentation/OTG/Measurement/DatabaseProcess here]
    86 == Using Microsoft Excel ==
     86
     87[[BR]]
     88== 3. Using Microsoft Excel ==
    8789
    8890Microsoft Excel can be used to analyze an experiment as shown below.
     
    9294The user could import MySQL database to Microsoft Excel and use chart and other tools to analyze the measurements.
    9395
    94 == Using Matlab ==
     96[[BR]]
     97== 4. Using Matlab ==
    9598
    9699Matlab is another tool can be used.  It should be noted that this assumes you have [http://www.die.net/doc/linux/man/man1/mysqldump.1.html exported] the database off of ORBIT and imported to your own MySQL server.