{"repo":"gregrahn/join-order-benchmark","free":true,"listed":false,"github":"https://github.com/gregrahn/join-order-benchmark","clone":"git clone https://github.com/gregrahn/join-order-benchmark.git","description":"Join Order Benchmark (JOB)","language":null,"stars":366,"topics":["sql","benchmark","database"],"license":null,"category":"databases-storage","readme_excerpt":"Join Order Benchmark This package contains the Join Order Benchmark (JOB) queries from: \"How Good Are Query Optimizers, Really?\" by Viktor Leis, Andrey Gubichev, Atans Mirchev, Peter Boncz, Alfons Kemper, Thomas Neumann PVLDB Volume 9, No. 3, 2015 http://www.vldb.org/pvldb/vol9/p204-leis.pdf This repository is not maintained by the original authors of the Join Order Benchmark. The purpose is to ease the distribution of Join Order Benchmark queries (e.g., as a git submodule). Please be aware that the queries assume the data set from the original paper (see below for the CWI link). The queries might yield unexpected results when used on the \"Frozen Data Set\" generated by the step-by-step instructions below. IMDB Data Set The CSV files used in the paper, which are from May 2013, can be found at http://event.cwi.nl/da/job/imdb.tgz The license and links to the current version IMDB data set can be found at http://www.imdb.com/interfaces Step-by-step instructions 1. download gz files (unpacking not necessary) 2. download and unpack imdbpy and the imdbpy2sql.py script 3. create PostgreSQL database (e.g., name imdbload): 4. transform gz files to relational schema (takes a while) Now you should have a PostgreSQL database named imdbload with the imdb data. Note that this database has some secondary indexes (but not on all foreign key attributes). You can export all tables to CSV: To import the CSV files to another database, create all tables (see schema.sql and optionally fkindexes.sql ","default_branch":null,"files":null,"tree":[],"storefront":"/r/gregrahn","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gregrahn/join-order-benchmark/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}