Changes between Version 12 and Version 13 of Tutorials/a0Basic/Tutorial3
- Timestamp:
- Jan 18, 2006, 8:58:46 PM (19 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Tutorials/a0Basic/Tutorial3
v12 v13 4 4 It 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. 5 5 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 any of the following approaches.''' 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 8 ''Note: Currently all databases share the same credentials.'' 9 10 '''Username and Password: orbit''' 7 11 8 12 == Using MySQL Client == … … 24 28 Standard 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 29 26 At 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:30 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 31 {{{ 28 32 INFO init: Experiment ID: sb5_2006_01_17_11_45_23 … … 90 94 == Using Matlab == 91 95 92 Matlab is another tool can be used. Sample Matlab code is shown below96 Matlab is another tool can be used. It should be noted that the 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. 93 97 {{{ 94 98 function nsf(dbServer, dbUser, dbPW, database);