Simple queries
MaxHalford opened this issue · 5 comments
Hello @gregrahn,
I was wondering if a "light" version of the JOB benchmark might be available. By this I mean queries that only use simple predicates such as a =
between two attributes. I'm writing a cardinality estimation method and for the while I don't want to handle complex predicates such as LIKE
.
Is something like this available? I thought I read about it in some paper but I seem to have forgotten...
@MaxHalford -
The closest thing that comes to my mind is the Picasso Database Query Optimizer Visualizer.
Yes I'm aware of Picasso, but I don't think it's what I'm looking for. I was just wondering if the guys who created JOB thought of making a benchmark with trivial queries that only include =
queries.
Not sure about that. Sorry.
Okay I found it. JOB-light is mentioned in at sub-section 4.5 of this paper. I'm contacting Viktor Leis to see if he can share the queries.
Cool - thanks for the reference.