Changes between Version 17 and Version 18 of Tutorials/a0Basic/Tutorial3
- Timestamp:
- Nov 23, 2007, 5:28:44 AM (17 years ago)
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)]] 2 2 [wiki:Tutorial Back] 3 3 = Analyzing Results = … … 6 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 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. 7 7 8 ''Note: Currently all databases share the same credentials .''8 ''Note: Currently all databases share the same credentials'' - '''Username and Password: orbit''' 9 9 10 '''Username and Password: orbit''' 11 12 == Using MySQL Client == 10 [[BR]] 11 == 1. Using MySQL Client == 13 12 14 13 The 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: … … 33 32 }}} 34 33 35 == Using Perl scripts == 34 [[BR]] 35 == 2. Using Perl scripts == 36 36 37 37 Sample Perl script that gets data from the database: … … 84 84 85 85 A 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 == 87 89 88 90 Microsoft Excel can be used to analyze an experiment as shown below. … … 92 94 The user could import MySQL database to Microsoft Excel and use chart and other tools to analyze the measurements. 93 95 94 == Using Matlab == 96 [[BR]] 97 == 4. Using Matlab == 95 98 96 99 Matlab 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.
