Skip to content

Latest commit

 

History

History
141 lines (105 loc) · 4.06 KB

README.md

File metadata and controls

141 lines (105 loc) · 4.06 KB
Raw

Repository for Hanfeng's Thesis

This repository is created for showing details of experiments in the thesis, including source code, data, and intermediate results. They are placed under the folder exp. We also provide a google sheet containg the summary of our intermeidate results.

Setup

Machines

Item sable-intel sable-tigger
CPU E7-4850 @ 2.00 GHz i7-8700K @ 3.70 GHz
L1 Cache 32 KB 32 KB
L2 Cache 256 KB 256 KB
L3 Cache 24 MB 12 MB
Threads per Core 2 2
Cores per Socket 10 6
Sockets 4 1
Total Threads 80 12
Thread Scales T1/2/4/8/16/32/64 T1/2//4/8/16
RAM Size 128 GB 32 GB
GPU (No GPU) GeForce GTX 1080 Ti
Operation System Ubuntu 18.04.04 LTS Ubuntu 18.04.04 LTS

Software

  • MonetDB v11.35.9 (Nov2019-SP1)
  • MATLAB version R2019a
  • GCC v8.1.0 (-O3, -march=native)
  • NVIDIA PGI compiler 19.10-0 (-O4)

Methodology

  • In terms of execution time, we only consider the time once data resides in main memory.
  • We consider performance variance by running each test 15 times, measuring the average execution time over the last 10 runs.

1. Experiments: Database Queries

Benchmarks

  • 22 TPC-H benchmarks

Results

  • sable-intel (Summary sheet)
    • HorsePower
      • Path: exp/tpch/fastgen
      • Log: log/run4
    • MonetDB
      • Path: exp/monetdb
      • Log: log/run5
  • sable-tigger (Summary sheet)
    • HorsePower
      • Path: exp/tpch/fastgen
      • Log: log/run5
    • MonetDB
      • Path: exp/monetdb
      • Log: log/run6
  • analysis (Summary sheet)
    • HorsePower
      • Path: exp/tpch/new-analysis
      • Log: log/run2

2. Experiments: Array Programs

Benchmarks

  • Black-Scholes
  • Morgan

Results (Summary sheet)

  • Black-Scholes
    • HorsePower
      • Path: exp/morgan/hir/gencode
      • Log: log/run1
    • MATLAB
      • Path: exp/morgan/matlab
      • Log: log/run1
  • Morgan
    • HorsePower
      • Path: exp/bs/hir/gencode
      • Log: log/run1
    • MATLAB
      • Path: exp/morgan/matlab
      • Log: log/run4

3. Experiments: Queries and UDFs

Benchmarks

  • udf-froid
  • udf-bs

Results (Summary sheet)

  • udf-froid: queries derived from TPC-H queries on the Froid paper
    • HorsePower
      • Path: exp/udf/froid/hir
      • Log: log/sf8
    • MonetDB
      • Path: exp/udf/froid/monetdb
      • Log: log/sf8
  • udf-bs: queries derived from the Black-Scholes code
    • HorsePower
      • Path: exp/udf/bs/hir
      • Log: log
    • MonetDB
      • Path: exp/udf/bs/monetdb
      • Log: log/log-t*

4. Experiments: GPU Benchmarks

Benchmarks

  • Black-Scholes
  • Morgan

Results (Summary sheet)

  • Black-Scholes
    • HorsePower
      • Path: exp/morgan/gpu
      • Log: log/run1
  • Morgan
    • HorsePower
      • Path: exp/bs/gpu
      • Log: log/run2