Changes between Version 58 and Version 59 of DatabaseBasedAnalysis
- Timestamp:
- 08/05/18 20:48:34 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis
v58 v59 31 31 === mysql === 32 32 33 The mysql 33 The mysql-client is the classical way to connect to the database and get data. Data is retrieved from a MySQl database always as pure ascii. {{{mysql}}} can print the ascii table to the console either as a nicely formatted text or as a machine readable ascii table. 34 34 35 35 === rootifysql === … … 49 49 To get a fast glimpse on the accessible databases and the contents of the tables, you can log-in to !PhpMyAdmin at http://iph-pc45.ethz.ch/phpmyadmin 50 50 51 == The Analy is ==51 == The Analysis == 52 52 53 53 Generally speaking, it makes sens to get familiar with the available columns in the table and their meaning. Right now, the best is to guess from the column name (see !PhPMyAdmin). More details will follow soon. … … 287 287 Let's assume the output file is ''crab-data-only.root'' ({{{rootifysql --out=crab-data-only.root}}}). Requesting the data and writing the file took me about 60s. 288 288 289 To run an analysis on the data you can use the following root macro "''analysis.C''". It produces a theta-square plot. Its execution took about 5s ({{{root analysis.C++}}}). The {{{++}}} behind the macro name forces root to compile the macro before execution (might not be necessary anymore with root 6) to increase performance.289 To run an analysis on the data you can use the following root macro "''analysis.C''". It produces a theta-square plot. Its execution took about five seconds ({{{root analysis.C++}}}). The {{{++}}} behind the macro name forces root to compile the macro before execution (might not be necessary anymore with root 6) to increase performance. 290 290 291 291 {{{#!cpp