Stats Benchmark

Descripción

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…

Descripción de Zenodo, abreviada.

Archivos (6)

• DUCKDBstats.duckdb618 MB
• SQLschema-duckdb.sql5,2 kB
• ZIPqueries.zip57 kB
• ZIPcsv.zip123 MB
• PGstats_dump.pg124 MB
• SQLschema-postgres.sql5,8 kB

DataHunter no guarda ni aloja estos archivos: cada enlace lleva a la fuente original. Revisa allí la licencia antes de usar los datos.