# for g++-5
sudo apt-get update
sudo apt-get install -y software-properties-common
sudo add-apt-repository -y ppa:ubuntu-toolchain-r/test

# common
sudo apt-get update
sudo apt-get install -y build-essential cmake git g++-5 libjemalloc-dev libnuma-dev
# for Silo
sudo apt-get install -y libdb6.0++-dev
# for FOEDUS/MOCC
sudo apt-get install -y libgoogle-perftools-dev papi-tools

# for experiments
sudo apt-get install -y psmisc python3

# for analysis
sudo apt-get install -y python3-pip
sudo apt-get install -y texlive-generic-recommended texlive-latex-recommended texlive-latex-extra texlive-fonts-recommended texlive-fonts-extra dvipng
pip3 install --user 'pandas>=0.20,<0.21' 'pandasql>=0.7,<0.8' 'matplotlib>=1.5,<2.0'

# for non-interactive experiment execution
echo "`whoami` ALL=(ALL:ALL) NOPASSWD:ALL" | sudo tee -a /etc/sudoers

# for third-party engines
echo "`whoami` - memlock unlimited" | sudo tee -a /etc/security/limits.conf
echo "`whoami` - nofile 655360" | sudo tee -a /etc/security/limits.conf
echo "`whoami` - nproc 655360" | sudo tee -a /etc/security/limits.conf
echo "`whoami` - rtprio 99" | sudo tee -a /etc/security/limits.conf

sudo groupadd hugeshm
sudo usermod -a -G hugeshm `whoami`

sudo reboot

git clone --recursive https://github.com/efficient/cicada-exp-sigmod2017.git

cd cicada-exp-sigmod2017
./build_cicada.sh
./build_ermia.sh
./build_foedus.sh
./build_silo.sh

EXPNAME=MYEXP
./run_exp.py exp_data_$EXPNAME run

cd result_analysis
./analyze.sh ../exp_data_$EXPNAME

Figure 3
 (a) output_macrobench_tpcc-full_warehouse_1.pdf
 (b) output_macrobench_tpcc-full_warehouse_4.pdf
 (c) output_macrobench_tpcc-full_fixed_ratio.pdf

Figure 4
 (a) output_macrobench_tpcc-full_warehouse_1_siu.pdf
 (b) output_macrobench_tpcc-full_warehouse_4_siu.pdf
 (c) output_macrobench_tpcc-full_fixed_ratio_siu.pdf

Figure 5
 (a) output_macrobench_tpcc_warehouse_1.pdf
 (b) output_macrobench_tpcc_warehouse_4.pdf
 (c) output_macrobench_tpcc_fixed_ratio.pdf

Figure 6
 (a) output_macrobench_ycsb_record_100_req_16_read_0_50_zipf_0_99.pdf
 (b) output_macrobench_ycsb_record_100_req_16_read_0_50_thread_28.pdf
 (c) output_macrobench_ycsb_record_100_req_16_read_0_95_thread_28.pdf

Figure 7
 output_macrobench_ycsb_record_100_req_1_read_0_95_zipf_0_99.pdf

Figure 8
 output_inlining_ycsb_req_16_read_0_95_zipf_0_00_thread_28.pdf

Table 2
 output_query.txt: "factor-ycsb-contended-tx"

Figure 9
 output_gc_tpcc-full.pdf

Figure 10
 output_backoff_tpcc-full_warehouse_4.pdf
 output_backoff_tpcc_warehouse_4.pdf
 output_backoff_ycsb_req_1_read_0_50_zipf_0_99.pdf

Figure 11
 output_macrobench_ycsb_record_100_req_1_read_0_50_zipf_0_99.pdf
 output_macrobench_ycsb_record_100_req_1_read_0_50_thread_28.pdf
 output_macrobench_ycsb_record_100_req_1_read_0_95_thread_28.pdf

    Copyright 2014, 2015, 2016, 2017 Carnegie Mellon University

    Licensed under the Apache License, Version 2.0 (the "License");
    you may not use this file except in compliance with the License.
    You may obtain a copy of the License at

        http://www.apache.org/licenses/LICENSE-2.0

    Unless required by applicable law or agreed to in writing, software
    distributed under the License is distributed on an "AS IS" BASIS,
    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    See the License for the specific language governing permissions and