You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Julian Hyde <jh...@apache.org> on 2020/05/10 02:54:00 UTC

Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

Calcite is being used in a research project that accelerates queries using FPGAs (The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS, by Lekshmi B. G., Andreas Becher, Klaus Meyer-Wegener, https://arxiv.org/pdf/2005.01511.pdf <https://arxiv.org/pdf/2005.01511.pdf>.)

"Hardware acceleration of database query processing can be done with the help of FPGAs. In particular, they are partially reconfigurable at runtime, which allows for the runtime adaption of the hardware to a variety of queries. .... This paper presents optimizations based on query sequences, which reduces the impact of the reconfigurations."

"We have implemented a ReProVide prototype, which is demonstrated at the 2020 EDBT conference [5]. The host is running Apache Calcite [6] as a DBMS. It has been extended with optimization rules to push down available operators to RPU based on cost.”

Always good to hear about Calcite being used in research.

Julian


Re: Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

Posted by Haisheng Yuan <hy...@apache.org>.
Glad to hear that.
More paper are on the way.

Haisheng

On 2020/05/10 02:54:00, Julian Hyde <jh...@apache.org> wrote: 
> Calcite is being used in a research project that accelerates queries using FPGAs (The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS, by Lekshmi B. G., Andreas Becher, Klaus Meyer-Wegener, https://arxiv.org/pdf/2005.01511.pdf <https://arxiv.org/pdf/2005.01511.pdf>.)
> 
> "Hardware acceleration of database query processing can be done with the help of FPGAs. In particular, they are partially reconfigurable at runtime, which allows for the runtime adaption of the hardware to a variety of queries. .... This paper presents optimizations based on query sequences, which reduces the impact of the reconfigurations."
> 
> "We have implemented a ReProVide prototype, which is demonstrated at the 2020 EDBT conference [5]. The host is running Apache Calcite [6] as a DBMS. It has been extended with optimization rules to push down available operators to RPU based on cost.”
> 
> Always good to hear about Calcite being used in research.
> 
> Julian
> 
> 

Re: Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

Posted by Danny Chan <da...@apache.org>.
Exciting, glad to hear that Lekshmi !

Lekshmi <le...@gmail.com>于2020年5月11日 周一上午3:07写道:

> Hello all,
>     This happened because of the support provided by this group. I'm always
> grateful to this community.
> You could also find another paper and the video which demonstrates the
> prototype we developed using Apache Calcite(accepted and published in
> EDBT2020.)
> https://openproceedings.org/2020/conf/edbt/paper_330.pdf
>
> https://openproceedings.org/2020/conf/edbt/videos/demo-session2a/4_LekshmiAndreasKlausStefanJuergen.mp4
>
> More papers are on the way...
>
> Thanks and Regards
>
> Lekshmi B.G
> Email: lekshmibg09@gmail.com
>
>
>
>
> On Sun, May 10, 2020 at 4:54 AM Julian Hyde <jh...@apache.org> wrote:
>
> > Calcite is being used in a research project that accelerates queries
> using
> > FPGAs (The ReProVide Query-Sequence Optimization in a
> Hardware-Accelerated
> > DBMS, by Lekshmi B. G., Andreas Becher, Klaus Meyer-Wegener,
> > https://arxiv.org/pdf/2005.01511.pdf <
> https://arxiv.org/pdf/2005.01511.pdf
> > >.)
> >
> > "Hardware acceleration of database query processing can be done with the
> > help of FPGAs. In particular, they are partially reconfigurable at
> runtime,
> > which allows for the runtime adaption of the hardware to a variety of
> > queries. .... This paper presents optimizations based on query sequences,
> > which reduces the impact of the reconfigurations."
> >
> > "We have implemented a ReProVide prototype, which is demonstrated at the
> > 2020 EDBT conference [5]. The host is running Apache Calcite [6] as a
> DBMS.
> > It has been extended with optimization rules to push down available
> > operators to RPU based on cost.”
> >
> > Always good to hear about Calcite being used in research.
> >
> > Julian
> >
> >
>

Re: Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

Posted by Lekshmi <le...@gmail.com>.
Hello all,
    This happened because of the support provided by this group. I'm always
grateful to this community.
You could also find another paper and the video which demonstrates the
prototype we developed using Apache Calcite(accepted and published in
EDBT2020.)
https://openproceedings.org/2020/conf/edbt/paper_330.pdf
https://openproceedings.org/2020/conf/edbt/videos/demo-session2a/4_LekshmiAndreasKlausStefanJuergen.mp4

More papers are on the way...

Thanks and Regards

Lekshmi B.G
Email: lekshmibg09@gmail.com




On Sun, May 10, 2020 at 4:54 AM Julian Hyde <jh...@apache.org> wrote:

> Calcite is being used in a research project that accelerates queries using
> FPGAs (The ReProVide Query-Sequence Optimization in a Hardware-Accelerated
> DBMS, by Lekshmi B. G., Andreas Becher, Klaus Meyer-Wegener,
> https://arxiv.org/pdf/2005.01511.pdf <https://arxiv.org/pdf/2005.01511.pdf
> >.)
>
> "Hardware acceleration of database query processing can be done with the
> help of FPGAs. In particular, they are partially reconfigurable at runtime,
> which allows for the runtime adaption of the hardware to a variety of
> queries. .... This paper presents optimizations based on query sequences,
> which reduces the impact of the reconfigurations."
>
> "We have implemented a ReProVide prototype, which is demonstrated at the
> 2020 EDBT conference [5]. The host is running Apache Calcite [6] as a DBMS.
> It has been extended with optimization rules to push down available
> operators to RPU based on cost.”
>
> Always good to hear about Calcite being used in research.
>
> Julian
>
>