search

Sable / HorsePower

Optimizing database queries with array programming
18 stars 6 forks source link

Meeting note (Sep 21) #10

Open wukefe opened 7 years ago

wukefe commented 7 years ago

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