Dataset Overview
The Yelp Open Dataset is a comprehensive record of business and user interactions sourced from the Yelp platform. 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. Check the dataset source page here.
Total node count: 10,038,716 on Neo4j and TigerGraph, 9,129,801 on others
Total edge count: 31,078,664 on Neo4j, 30,169,749 on others
Dataset Download
You may download this dataset directly from the Yelp's website. Simply go to here and scroll down to the "Download" section, and click on the "Download JSON" button.
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.
| Workload | Query ID | PuppyGraph | Neo4j | TigerGraph | GraphFrames |
|---|---|---|---|---|---|
| Neighborhood | Q1 | 1.729 | 1.992 | 10.379 | 43.433 |
| Q2 | 5.380 | 3.352 | 10.588 | 13.042 | |
| Q3 | POOL LIMIT | 80.588 | 30.139 | 51.824 | |
| Q4 | 13.068 | 2.676 | 15.455 | 11.589 | |
| Path | Q5 | 11.251 | 1.943 | 0.186 | 313.180 |
| Q6 | 3.085 | 4.689 | 34.903 | 24.611 | |
| Q7 | MEMORY_LIMIT | 1.753 | 7.545 | 39.140 | |
| Q8 | MEMORY_LIMIT | 1.758 | 13.518 | 97.703 | |
| Q9 | 58.155 | 833.095 | 24.884 | 334.552 | |
| Pattern | Q10 | 77.313 | 2.645 | 11.956 | 19.102 |
| Q11 | 98.031 | 7.745 | 47.114 | 324.207 | |
| Q12 | 205.953 | 14.054 | 12.081 | 4.231 | |
| Q13 | MEMORY_LIMIT | 2.683 | 20.127 | 24.035 | |
| Q14 | 54.818 | 2.244 | 13.502 | 5.251 | |
| Q15 | 221.502 | 7.516 | 14.301 | 12.267 | |
| Aggregation | Q16 | 18.838 | 2.621 | 7.695 | 3.822 |
| Q17 | 35.939 | 9.178 | 27.859 | 275.772 | |
| Q18 | 386.060 | 12.387 | 43.084 | 207.367 | |
| Q19 | 4.774 | 13.184 | 24.849 | 1703.458 | |
| Q20 | 17.695 | 4787.915 | 7.296 | 88.418 | |
| Q21 | 180.633 | TIMEOUT | 23.171 | 30.006 | |
| Q22 | 46.384 | 19.547 | 5.137 | 13.292 | |
| Q23 | 8.456 | 16.425 | 5.398 | 8.359 | |
| Q24 | 3.522 | 3.765 | 24.812 | 8.163 | |
| Analytics | Q25 | 4.273 | 2.780 | 0.633 | 40.004 |
| Q26 | 138.028 | 17.299 | 16.932 | 122.097 | |
| Q27 | 93.486 | 3.328 | 11.993 | 63.445 | |
| Q28 | NOT SUPPORTED | 3.889 | 13.599 | 163.207 | |
| Q29 | 555.497 | 43.325 | 243.632 | 173.537 | |
| Hybrid | Q30 | 95.588 | 72.664 | 22.171 | 7.587 |
| Q31 | 3.069 | 7.990 | 18.903 | 51.274 | |
| Q32 | 2.022 | 2.810 | 9.536 | 56.830 | |
| Others | Q33 | NOT SUPPORTED | 2.035 | 3.401 | 54.655 |
| Q34 | NOT SUPPORTED | 3.132 | NOT SUPPORTED | 13.913 | |
| Q35 | NOT SUPPORTED | 1.816 | 3.514 | 5.310 | |
| Q36 | 2.174 | 3.063 | 7.447 | 1.180 | |
| Q37 | NOT SUPPORTED | 1.860 | 0.169 | 0.644 | |
| Q38 | NOT SUPPORTED | 1.926 | 0.169 | 0.428 | |
| Q39 | 2.273 | 1.889 | 20.538 | 1.241 | |
| Q40 | 13.333 | TIMEOUT | 50.943 | 5.427 |
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.
| Workload | Query ID | PuppyGraph | Neo4j | TigerGraph | GraphFrames |
|---|---|---|---|---|---|
| Neighborhood | Q1 | 135.018 | 0.000 | 29.000 | 71.303 |
| Q2 | 1178.000 | 63.492 | 28.000 | 218.431 | |
| Q3 | POOL LIMIT | 1087.834 | 50.000 | 285.868 | |
| Q4 | 1028.000 | 22.915 | 28.000 | 355.008 | |
| Path | Q5 | 15.250 | 0.085 | 7.000 | 0.066 |
| Q6 | 1061.000 | 3.780 | 199.000 | 207.684 | |
| Q7 | MEMORY_LIMIT | 0.005 | 28.000 | 142.672 | |
| Q8 | MEMORY_LIMIT | 0.215 | 32.000 | 142.672 | |
| Q9 | 2535.000 | 0.936 | 74.000 | 7314.930 | |
| Pattern | Q10 | 15247.000 | 1.701 | 29.000 | 222.560 |
| Q11 | 502.512 | 546.573 | 78.000 | 2692.743 | |
| Q12 | 454.651 | 143.753 | 74.000 | 282.329 | |
| Q13 | MEMORY_LIMIT | 1.696 | 28.000 | 471.400 | |
| Q14 | 56.090 | 0.039 | 32.000 | 210.043 | |
| Q15 | 126.536 | 403.563 | 183.000 | 209.846 | |
| Aggregation | Q16 | 107.712 | 2.868 | 29.000 | 206.045 |
| Q17 | 0.000 | 15.071 | 231.000 | 142.606 | |
| Q18 | 663.454 | 0.000 | 4837.000 | 289.407 | |
| Q19 | 1217.000 | 0.026 | 377.000 | 289.669 | |
| Q20 | 688.961 | 34.761 | 46.000 | 1276.379 | |
| Q21 | 11364.000 | TIMEOUT | 71.000 | 1276.379 | |
| Q22 | 1828.000 | 14.810 | 15.000 | 421.790 | |
| Q23 | 1182.000 | 10.591 | 14.000 | 421.790 | |
| Q24 | 2075.000 | 6.591 | 205.000 | 203.751 | |
| Analytics | Q25 | 1068.000 | 138.141 | 79.000 | 203.424 |
| Q26 | 27.056 | 138.141 | 940.000 | 150.995 | |
| Q27 | 74.036 | 129.994 | 274.000 | 208.142 | |
| Q28 | NOT SUPPORTED | 129.994 | 370.000 | 138.936 | |
| Q29 | 130.326 | 130.028 | 930.000 | 138.936 | |
| Hybrid | Q30 | 6384.000 | 968.581 | 50.000 | 285.868 |
| Q31 | 794.147 | 290.561 | 27.000 | 210.043 | |
| Q32 | 310.995 | 80.993 | 183.000 | 352.715 | |
| Others | Q33 | NOT SUPPORTED | 3.409 | 11.000 | 281.289 |
| Q34 | NOT SUPPORTED | 19.093 | NOT SUPPORTED | 352.715 | |
| Q35 | NOT SUPPORTED | 0.212 | 11.000 | 274.997 | |
| Q36 | 89.834 | 21.533 | 27.000 | 68.157 | |
| Q37 | NOT SUPPORTED | 0.026 | 10.000 | 67.174 | |
| Q38 | NOT SUPPORTED | 1.121 | 10.000 | 0.000 | |
| Q39 | 645.233 | 0.000 | 205.000 | 0.000 | |
| Q40 | 6993.000 | TIMEOUT | 205.000 | 75.497 |