← Back to Datasets

Yelp Open Dataset

Exploring business-consumer interactions through graph topology

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.

Yelp Dataset Download

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