Dataset Overview

The OnTime flight performance dataset is a comprehensive record of airline traffic data sourced from the United States Bureau of Transportation Statistics (BTS). It tracks the performance of domestic reporting carriers and is widely recognized as a standard benchmark for evaluating the efficiency of analytical (OLAP) database systems. The full dataset covers domestic flight records from 1987 to 2022. For efficiency, we only used the records from 2020 to 2022. Check the dataset source page here.

Total node count: 379

Total edge count: 17,412,876

Dataset Download

You may download this dataset directly from the BTS. You may select years and months by changing the contents in the two curly braces in the command below:

wget --no-check-certificate --continue https://transtats.bts.gov/PREZIP/On_Time_Reporting_Carrier_On_Time_Performance_1987_present_{1987..2022}_{1..12}.zip

Or you can click the button below and download the extracted and selected csv files from our repository:

Benchmark Workloads

Select a platform below to view the specific data loading commands and queries used to benchmark performance.

Runtime Results

* The unit of all results shown below are in seconds (s)

* MEMORY_LIMIT means the query exceeded the 28 GiB memory limit; TIMEOUT means the query ran for more than two hours without finishing; SKIPPED means the database platform does not support certain features required by the query; POOL LIMIT means the intermediate results generated by the query exceeded the engine-configured memory pool limit; FAILED means the system reported another error.

Memory Results

* The unit of all memory results shown below is megabytes (MB)

* TigerGraph: the sum over the GPEs of each GPE’s peak vertex-accumulator memory for the whole query, from the query profile; not process memory.

* MEMORY_LIMIT means the query exceeded the 28 GiB memory limit; TIMEOUT means the query ran for more than two hours without finishing; SKIPPED means the database platform does not support certain features required by the query; POOL LIMIT means the intermediate results generated by the query exceeded the engine-configured memory pool limit; FAILED means the system reported another error.