public function paramEvaluationAction()
{
$db = $this->container->getDBUtils();
$this->buildFilters(array('minexecs' => array('default' => null, 'type' => 'inputNumber', 'label' => 'Minimum executions:', 'parseFunction' => function () {
return 0;
}, 'filterGroup' => 'basic')));
$whereClause = $this->filters->getWhereClause();
$model_html = '';
$model_info = $db->get_rows("SELECT id_learner, model, algorithm, dataslice FROM aloja_ml.learners");
foreach ($model_info as $row) {
$model_html = $model_html . "<li><b>" . $row['id_learner'] . "</b> => " . $row['algorithm'] . " : " . $row['model'] . " : " . $row['dataslice'] . "</li>";
}
$categories = '';
$series = '';
try {
$paramEval = isset($_GET['parameval']) && Utils::get_GET_string('parameval') != '' ? Utils::get_GET_string('parameval') : 'maps';
$minExecs = isset($_GET['minexecs']) ? Utils::get_GET_int('minexecs') : -1;
$this->filters->changeCurrentChoice('minexecs', $minExecs == -1 ? null : $minExecs);
$shortAliasParamEval = array('maps' => 'e', 'comp' => 'e', 'id_cluster' => 'c', 'net' => 'e', 'disk' => 'e', 'replication' => 'e', 'iofilebuf' => 'e', 'blk_size' => 'e', 'iosf' => 'e', 'vm_size' => 'c', 'vm_cores' => 'c', 'vm_ram' => 'c', 'datanodes' => 'c', 'hadoop_version' => 'e', 'type' => 'c');
$minExecsFilter = "";
if ($minExecs > 0) {
$minExecsFilter = "HAVING COUNT(*) > {$minExecs}";
}
$filter_execs = DBUtils::getFilterExecs();
$options = $this->filters->getFiltersArray()[$paramEval]['choices'];
$benchOptions = "SELECT DISTINCT e.bench FROM aloja2.execs e JOIN aloja2.clusters c USING (id_cluster) LEFT JOIN aloja_ml.predictions p USING (id_exec) WHERE 1 {$filter_execs} {$whereClause} GROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench order by {$shortAliasParamEval[$paramEval]}.{$paramEval}";
$params = $this->filters->getFiltersSelectedChoices(array('prediction_model', 'upred', 'uobsr'));
$whereClauseML = str_replace("exe_time", "pred_time", $whereClause);
$whereClauseML = str_replace("start_time", "creation_time", $whereClauseML);
$query = "SELECT COUNT(*) AS count, {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench, avg(e.exe_time) avg_exe_time, min(e.exe_time) min_exe_time\n\t\t\t\t\t FROM aloja2.execs AS e JOIN aloja2.clusters AS c USING (id_cluster)\n\t\t\t\t\t LEFT JOIN aloja_ml.predictions AS p USING (id_exec)\n\t\t\t\t\t WHERE 1 {$filter_execs} {$whereClause}\n\t\t\t\t\t GROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench {$minExecsFilter} ORDER BY e.bench, {$shortAliasParamEval[$paramEval]}.{$paramEval}";
$queryPredictions = "\n\t\t\t\t\tSELECT COUNT(*) AS count, {$shortAliasParamEval[$paramEval]}.{$paramEval}, CONCAT('pred_',e.bench) as bench,\n\t\t\t\t\t\tavg(e.pred_time) as avg_exe_time, min(e.pred_time) as min_exe_time\n\t\t\t\t\t\tFROM aloja_ml.predictions AS e\n\t\t\t\t\t\tJOIN clusters c USING (id_cluster)\n\t\t\t\t\t\tWHERE 1 {$filter_execs} " . str_replace("p.", "e.", $whereClauseML) . " AND e.id_learner = '" . $params['prediction_model'] . "'\n\t\t\t\t\t\tGROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench {$minExecsFilter} ORDER BY e.bench, {$shortAliasParamEval[$paramEval]}.{$paramEval}";
// get the result rows
if ($params['uobsr'] == 1 && $params['upred'] == 1) {
$query = "({$query}) UNION ({$queryPredictions})";
$benchOptions = "SELECT DISTINCT e.bench FROM aloja2.execs e JOIN aloja2.clusters c USING (id_cluster) LEFT JOIN aloja_ml.predictions p USING (id_exec) WHERE 1 {$filter_execs} {$whereClause} GROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench\n\t\t\t\t\t\t\t\t UNION\n\t\t\t\t\t\t\t\t (SELECT DISTINCT CONCAT('pred_', e.bench) as bench FROM aloja_ml.predictions AS e\n\t\t\t\t\t\t\t\t JOIN clusters c USING (id_cluster)\n\t\t\t\t\t\t\t\t WHERE 1 {$filter_execs} " . str_replace("p.", "e.", $whereClauseML) . " AND e.id_learner = '" . $params['prediction_model'] . "'\n\t\t\t\t\t\t\t\t GROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench {$minExecsFilter})\n\t\t\t\t\t\t\t\t ORDER BY bench";
$optionsPredictions = "SELECT DISTINCT {$shortAliasParamEval[$paramEval]}.{$paramEval} FROM aloja_ml.predictions AS e JOIN clusters c USING (id_cluster) WHERE 1 {$filter_execs} " . str_replace("p.", "e.", $whereClauseML) . " AND e.id_learner = '" . $params['prediction_model'] . "' ORDER BY {$shortAliasParamEval[$paramEval]}.{$paramEval}";
$optionsPredictions = $db->get_rows($optionsPredictions);
foreach ($optionsPredictions as $predOption) {
$options[] = $predOption[$paramEval];
}
} else {
if ($params['uobsr'] == 0 && $params['upred'] == 1) {
$query = $queryPredictions;
$benchOptions = "SELECT DISTINCT CONCAT('pred_', e.bench) as bench FROM aloja_ml.predictions AS e\n \t\t\t\t\t\t\t\t JOIN clusters c USING (id_cluster)\n\t\t\t\t\t\t\t\t WHERE 1 {$filter_execs} " . str_replace("p.", "e.", $whereClauseML) . " AND e.id_learner = '" . $params['prediction_model'] . "'\n\t\t\t\t\t\t\t\t GROUP BY {$shortAliasParamEval[$paramEval]}.{$paramEval}, e.bench {$minExecsFilter} ORDER BY e.bench, {$shortAliasParamEval[$paramEval]}.{$paramEval}";
$options = array();
$optionsPredictions = "SELECT DISTINCT {$shortAliasParamEval[$paramEval]}.{$paramEval} FROM aloja_ml.predictions AS e JOIN clusters c USING (id_cluster) WHERE 1 {$filter_execs} " . str_replace("p.", "e.", $whereClauseML) . " AND e.id_learner = '" . $params['prediction_model'] . "' ORDER BY {$shortAliasParamEval[$paramEval]}.{$paramEval}";
$optionsPredictions = $db->get_rows($optionsPredictions);
foreach ($optionsPredictions as $predOption) {
$options[] = $predOption[$paramEval];
}
} else {
if ($params['uobsr'] == 0 && $params['upred'] == 0) {
$this->container->getTwig()->addGlobal('message', "Warning: No data selected (Predictions|Observations) from the ML Filters. Adding the Observed executions to the figure by default.\n");
}
}
}
$rows = $db->get_rows($query);
$benchOptions = $db->get_rows($benchOptions);
if (!$rows) {
throw new \Exception("No results for query!");
}
$paramOptions = array();
foreach ($options as $option) {
if ($paramEval == 'id_cluster') {
$paramOptions[] = Utils::getClusterName($option, $db);
} else {
if ($paramEval == 'comp') {
$paramOptions[] = Utils::getCompressionName($option);
} else {
if ($paramEval == 'net') {
$paramOptions[] = Utils::getNetworkName($option);
} else {
if ($paramEval == 'disk') {
$paramOptions[] = Utils::getDisksName($option);
} else {
if ($paramEval == 'vm_ram') {
$paramOptions[] = Utils::getBeautyRam($option);
} else {
$paramOptions[] = $option;
}
}
}
}
}
}
$categories = '';
$arrayBenchs = array();
foreach ($paramOptions as $param) {
$categories .= "'{$param}" . Utils::getParamevalUnit($paramEval) . "',";
foreach ($benchOptions as $bench) {
$arrayBenchs[$bench['bench']][$param] = null;
}
}
$series = array();
foreach ($rows as $row) {
if ($paramEval == 'comp') {
$row[$paramEval] = Utils::getCompressionName($row['comp']);
} else {
if ($paramEval == 'id_cluster') {
$row[$paramEval] = Utils::getClusterName($row[$paramEval], $db);
} else {
if ($paramEval == 'net') {
$row[$paramEval] = Utils::getNetworkName($row['net']);
} else {
if ($paramEval == 'disk') {
$row[$paramEval] = Utils::getDisksName($row['disk']);
} else {
if ($paramEval == 'vm_ram') {
$row[$paramEval] = Utils::getBeautyRam($row['vm_ram']);
}
}
}
}
}
$arrayBenchs[strtolower($row['bench'])][$row[$paramEval]]['y'] = round((int) $row['avg_exe_time'], 2);
$arrayBenchs[strtolower($row['bench'])][$row[$paramEval]]['count'] = (int) $row['count'];
}
foreach ($arrayBenchs as $key => $arrayBench) {
$series[] = array('name' => $key, 'data' => array_values($arrayBench));
}
$series = json_encode($series);
} catch (\Exception $e) {
$this->container->getTwig()->addGlobal('message', $e->getMessage() . "\n");
}
return $this->render('configEvaluationViews/parameval.html.twig', array('title' => 'Improvement of Hadoop Execution by SW and HW Configurations', 'minexecs' => $minExecs, 'categories' => $categories, 'series' => $series, 'paramEval' => $paramEval, 'models' => $model_html));
}
public function paramEvaluationAction()
{
$db = $this->container->getDBUtils();
$preset = null;
if (sizeof($_GET) <= 1) {
$preset = Utils::setDefaultPreset($db, 'Parameter Evaluation');
}
$selPreset = isset($_GET['presets']) ? $_GET['presets'] : "none";
$rows = '';
$categories = '';
$series = '';
try {
$where_configs = '';
$concat_config = "";
if (!isset($_GET['benchs'])) {
$_GET['benchs'] = array('wordcount', 'terasort', 'sort');
}
$datefrom = Utils::read_params('datefrom', $where_configs);
$dateto = Utils::read_params('dateto', $where_configs);
$benchs = Utils::read_params('benchs', $where_configs);
$nets = Utils::read_params('nets', $where_configs);
$disks = Utils::read_params('disks', $where_configs);
$blk_sizes = Utils::read_params('blk_sizes', $where_configs);
$comps = Utils::read_params('comps', $where_configs);
$id_clusters = Utils::read_params('id_clusters', $where_configs);
$mapss = Utils::read_params('mapss', $where_configs);
$replications = Utils::read_params('replications', $where_configs);
$iosfs = Utils::read_params('iosfs', $where_configs);
$iofilebufs = Utils::read_params('iofilebufs', $where_configs);
$money = Utils::read_params('money', $where_configs);
$datanodes = Utils::read_params('datanodess', $where_configs, false);
$benchtype = Utils::read_params('bench_types', $where_configs);
$vm_sizes = Utils::read_params('vm_sizes', $where_configs, false);
$vm_coress = Utils::read_params('vm_coress', $where_configs, false);
$vm_RAMs = Utils::read_params('vm_RAMs', $where_configs, false);
$hadoop_versions = Utils::read_params('hadoop_versions', $where_configs, false);
$types = Utils::read_params('types', $where_configs, false);
$valid = Utils::read_params('valids', $where_configs);
$filters = Utils::read_params('filters', $where_configs, false);
$allunchecked = isset($_GET['allunchecked']) ? $_GET['allunchecked'] : '';
$minexetime = Utils::read_params('minexetime', $where_configs, false);
$maxexetime = Utils::read_params('maxexetime', $where_configs, false);
$provider = Utils::read_params('providers', $where_configs, false);
$vm_OS = Utils::read_params('vm_OSs', $where_configs, false);
$paramEval = isset($_GET['parameval']) && $_GET['parameval'] != '' ? $_GET['parameval'] : 'maps';
$minExecs = isset($_GET['minexecs']) ? $_GET['minexecs'] : -1;
$minExecsFilter = "";
if ($minExecs > 0) {
$minExecsFilter = "HAVING COUNT(*) > {$minExecs}";
}
$filter_execs = DBUtils::getFilterExecs();
$options = Utils::getFilterOptions($db);
$paramOptions = array();
foreach ($options[$paramEval] as $option) {
if ($paramEval == 'id_cluster') {
$paramOptions[] = $option['name'];
} else {
if ($paramEval == 'comp') {
$paramOptions[] = Utils::getCompressionName($option[$paramEval]);
} else {
if ($paramEval == 'net') {
$paramOptions[] = Utils::getNetworkName($option[$paramEval]);
} else {
if ($paramEval == 'disk') {
$paramOptions[] = Utils::getDisksName($option[$paramEval]);
} else {
if ($paramEval == 'vm_ram') {
$paramOptions[] = Utils::getBeautyRam($option['vm_RAM']);
} else {
$paramOptions[] = $option[$paramEval];
}
}
}
}
}
}
// if($paramEval == 'maps')
// $paramOptions = array(4,6,8,10,12,16,24,32);
// else if($paramEval == 'comp')
// $paramOptions = array('None','ZLIB','BZIP2','Snappy');
// else if($paramEval == 'id_cluster')
// $paramOptions = array('rl-06');
// else if($paramEval == 'net')
// $paramOptions = array('Ethernet','Infiniband');
// else if($paramEval == 'disk')
// $paramOptions = array('Hard-disk drive','1 HDFS remote(s)/tmp local','2 HDFS remote(s)/tmp local','3 HDFS remote(s)/tmp local','1 HDFS remote(s)', '2 HDFS remote(s)', '3 HDFS remote(s)', 'SSD');
// else if($paramEval == 'replication')
// $paramOptions = array(1,2,3);
// else if($paramEval == 'iofilebuf')
// $paramOptions = array(1,4,16,32,64,128,256);
// else if($paramEval == 'blk_size')
// $paramOptions = array(32,64,128,256);
// else if($paramEval == 'iosf')
// $paramOptions = array(5,10,20,50);
$benchOptions = $db->get_rows("SELECT DISTINCT bench FROM execs e JOIN clusters c USING (id_cluster) WHERE 1 {$filter_execs} {$where_configs} GROUP BY {$paramEval}, bench order by {$paramEval}");
// get the result rows
$query = "SELECT count(*) as count, {$paramEval}, e.id_exec, exec as conf, bench, " . "exe_time, avg(exe_time) avg_exe_time, min(exe_time) min_exe_time " . "from execs e JOIN clusters c USING (id_cluster) WHERE 1 {$filter_execs} {$where_configs}" . "GROUP BY {$paramEval}, bench {$minExecsFilter} order by bench,{$paramEval}";
$rows = $db->get_rows($query);
if (!$rows) {
throw new \Exception("No results for query!");
}
$categories = '';
$arrayBenchs = array();
foreach ($paramOptions as $param) {
$categories .= "'{$param}" . Utils::getParamevalUnit($paramEval) . "',";
foreach ($benchOptions as $bench) {
$arrayBenchs[$bench['bench']][$param] = null;
}
}
$series = array();
$bench = '';
foreach ($rows as $row) {
if ($paramEval == 'comp') {
$row[$paramEval] = Utils::getCompressionName($row['comp']);
} else {
if ($paramEval == 'id_cluster') {
$row[$paramEval] = Utils::getClusterName($row[$paramEval], $db);
} else {
if ($paramEval == 'net') {
$row[$paramEval] = Utils::getNetworkName($row['net']);
} else {
if ($paramEval == 'disk') {
$row[$paramEval] = Utils::getDisksName($row['disk']);
} else {
if ($paramEval == 'vm_ram') {
$row[$paramEval] = Utils::getBeautyRam($row['vm_ram']);
}
}
}
}
}
$arrayBenchs[strtolower($row['bench'])][$row[$paramEval]]['y'] = round((int) $row['avg_exe_time'], 2);
$arrayBenchs[strtolower($row['bench'])][$row[$paramEval]]['count'] = (int) $row['count'];
}
foreach ($arrayBenchs as $key => $arrayBench) {
$series[] = array('name' => $key, 'data' => array_values($arrayBench));
}
$series = json_encode($series);
} catch (\Exception $e) {
$this->container->getTwig()->addGlobal('message', $e->getMessage() . "\n");
}
echo $this->container->getTwig()->render('parameval/parameval.html.twig', array('selected' => 'Parameter Evaluation', 'title' => 'Improvement of Hadoop Execution by SW and HW Configurations', 'categories' => $categories, 'series' => $series, 'datefrom' => $datefrom, 'dateto' => $dateto, 'benchs' => $benchs, 'nets' => $nets, 'disks' => $disks, 'blk_sizes' => $blk_sizes, 'comps' => $comps, 'id_clusters' => $id_clusters, 'mapss' => $mapss, 'replications' => $replications, 'iosfs' => $iosfs, 'iofilebufs' => $iofilebufs, 'money' => $money, 'datanodess' => $datanodes, 'bench_types' => $benchtype, 'vm_sizes' => $vm_sizes, 'vm_coress' => $vm_coress, 'vm_RAMs' => $vm_RAMs, 'vm_OS' => $vm_OS, 'hadoop_versions' => $hadoop_versions, 'types' => $types, 'providers' => $provider, 'filters' => $filters, 'allunchecked' => $allunchecked, 'minexetime' => $minexetime, 'maxexetime' => $maxexetime, 'preset' => $preset, 'selPreset' => $selPreset, 'paramEval' => $paramEval, 'options' => $options));
}
