Changes between Version 58 and Version 59 of DatabaseBasedAnalysis


Ignore:
Timestamp:
08/05/18 20:48:34 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBasedAnalysis

    v58 v59  
    3131=== mysql ===
    3232
    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.
     33The 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.
    3434
    3535=== rootifysql ===
     
    4949To 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
    5050
    51 == The Analyis ==
     51== The Analysis ==
    5252
    5353Generally 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.
     
    287287Let'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.
    288288
    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.
     289To 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.
    290290
    291291{{{#!cpp