Stats Benchmark

Описание

General This is a re-distribution of the Stats dataset and workload, adapted for different database systems. The original dataset was uploaded by Stack Exchange, Inc. to archive.org and licensed under CC-BY-SA 4.0 terms. Our dump is based on the distribution from the CTU Relational Dataset Repository , but re-packaged for PostgreSQL and DuckDB. The benchmark queries were first presented by Han et al. in their paper "Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation" (Proc. VLDB, Vol. 15, Issue 4) (DOI 10.14778/3503585.3503586 ). We extracted the queries from the official Github Repo of the publication and provide the as individual SQL files. Import for PostgreSQL The PostgreSQL dump was created using PostgreSQL 16, so it should work on all Postgres version starting from PG 16. To load the dump, first create a new Postgres database. Afterwards, run pg restore on the dump: $ createdb stats $ pg restore -n public -O -d stats stats dump.pg If you do not have the pg hint plan extension available on your server, you might see a couple of warnings during the import. These are safe to ignore. For reference, we also provide the raw schema for Postgres. Similarly, a…

Описание из Zenodo, сокращённое.

Файлы (6)

• DUCKDBstats.duckdb618 МБ
• SQLschema-duckdb.sql5,2 кБ
• ZIPqueries.zip57 кБ
• ZIPcsv.zip123 МБ
• PGstats_dump.pg124 МБ
• SQLschema-postgres.sql5,8 кБ

DataHunter не хранит и не раздаёт эти файлы: каждая ссылка ведёт к первоисточнику. Перед использованием проверьте там лицензию.