Reading Notes: SIGMOD 2019 Revenge of the Interpolation Search

Overview

Recently I spent some time on a paper of SIGMOD 2019. It is a paper that optimizing an old algorithm based on model architecture of computer. We can learn some methods of programming skills to optimize algorithms.

The paper is:

Van Sandt, Peter, Yannis Chronis, and Jignesh M. Patel. “Efficiently Searching In-Memory Sorted Arrays: Revenge of the Interpolation Search?.” Proceedings of the 2019 International Conference on Management of Data. 2019.

Continue reading

三国赵云传数据+Postgres解析一篇SIGMOD2019论文的agg递归CTE

标题党实锤了。这也是我博客中第一篇用中文写的技术文章。坚持用英文写博客,并不是崇洋媚外,只是为了跟各国同事之间交流技术方便一些。那么这次为啥选择母语,因为原始论文里的例子一点也不好玩,我选择三国赵云传的一个数据来作例子,那不妨就写得幽默一代呢,放飞自我放飞的根本一些。

论文是这篇:  RaSQL: Greater Power and Performance for Big Data Analytics with Recursive-aggregate-SQL on Spark, SIGMOD 19.

Continue reading