Meeting note (Sep 21)

[wukefe]

Done

1. Found a bug in GCC compiler optimization (-O3)
2. Changed the compiler from gcc-5 to gcc-7
3. Completed query 4 and 6

To-do

1. To work on query 9 (with total 6 joins)
2. To complete all queries by the end of this month
3. To start writing paper at the beginning of October

Answer the following questions.

1. What is the problem?

• Lack of a programming interface for UDFs
• Database optimizations lag off compiler optimizations

2. Why is it important?

• Performance is the king
• Productivity

3. Why is it hard?

• Hard to utilize modern hardware
• E.g. MonetDB backend

4. Why hasn't it been solved already?

• DB researchers think high-level impl. could hurt the holistic performance
• Low-level efficient impl. is preferred

5. What is your solution?

• Array programming + compiler optimizations

6. Why is it a favorite?

• A fit combination of array programming and column-based DB