alibaba / GraphScope

🔨 🍇 💻 🚀 GraphScope: A One-Stop Large-Scale Graph Computing System from Alibaba | 一站式图计算系统
https://graphscope.io
Apache License 2.0
3.26k stars 442 forks source link

Introduce the JOB benchmark in GIE #4014

Open BingqingLyu opened 2 months ago

BingqingLyu commented 2 months ago

Is your feature request related to a problem? Please describe.

The Join Order Benchmark (JOB) is a well-known standard for evaluating the performance of query optimizers in relational databases, focusing particularly on the effectiveness of determining optimal join orders. Integration of JOB into the GIE could provide significant insights into the optimizers' ability to handle complex join queries efficiently.

To achieve this, we need to:

  1. Preprocess the IMDB Dataset:
  1. Prepare Meta Information:
  1. Translate JOB Queries:
  1. Implement the JOB Benchmark in GIE:
  1. Test based on different backends
  1. Other related issues to be addressed https://github.com/alibaba/GraphScope/issues/4114 https://github.com/alibaba/GraphScope/issues/4039
BingqingLyu commented 2 months ago

Still some issues to be addressed.

zhanglei1949 commented 5 days ago

Job Benchmark has been introduced into Interactive via this commit: https://github.com/alibaba/GraphScope/commit/b814e5b6382d1d9a373e332451d62bd256abb8da. There are still 3 queries some supported.