Senior Research Scientist

Rick Cole

About

Rick Cole is a Research Scientist at Tableau Software where his focus is on the intersection of database query processing and visual analysis, or how to see and understand queries. Rick earned his PhD and MS degrees from the University of Colorado at Boulder, where he was a member of the Volcano project for research into efficient, extensible tools for query processing. His research explored the optimization of dynamic query evaluation plans for robust query performance. He has more than 35 publications and patents in query processing.

Rick has over 30 years of experience in databases, query processing, and query optimization. Before joining Tableau, Rick co-founded Bright Vine, a data integration startup for cooperative analytics in diverse big data ecosystems. Previously he was at ParAccel, where he led development of a new query optimization framework and query optimizers, as well as a new extensibility framework for ParAccel’s massively parallel, columnar data engine. Prior to ParAccel, he was a technical leader at IBM, Informix Software, and Red Brick Systems.

Focus

Databases
Query Processing
Query Optimization
Visual Analysis for Queries

Helping people see and understand queries.

Papers

Learning to Optimize Federated Queries

Liqi Xu, Richard L. Cole, Daniel Ting

To appear in aiDM'19, July 5, 2019, Amsterdam, Netherlands

PDF

The mixed workload CH-benCHmark

Richard L. Cole, Florian Funke, Leo Giakoumakis, Wey Guy, Alfons Kemper, Stefan Krompass, Harumi Kuno, Raghunath Nambiar, Thomas Neumann, Meikel Poess, Kai-Uwe Sattler, Michael Seibold, Eric Simon, and Florian Waas.

In Proceedings of the Fourth International Workshop on Testing Database Systems (DBTest '11).

PDF

Partial Join Order Optimization in the ParAccel Analytic Database

Yijou Chen, Richard L. Cole, William J. McKenna, Sergei Perfilov, Aman Sinha, and Eugene Szedenits, Jr.

In Proceedings of the 2009 ACM SIGMOD International Conference on Management of data (SIGMOD '09).

PDF

Aggregate Maintenance for Data Warehousing in Informix Red Brick Vista

Craig J. Bunker, Latha S. Colby, Richard L. Cole, William J. McKenna, Gopal Mulagund, and David Wilhite.

In Proceedings of the 27th International Conference on Very Large Data Bases (VLDB '01).

PDF

A Decision Theoretic Cost Model for Dynamic Plans

Richard L. Cole.

In IEEE Bulletin of the Technical Committee on Data Engineering, Vol. 23, No. 2, June 2000.

PDF

Redbrick Vista: Aggregate Computation and Management

Latha S. Colby, Richard L. Cole, Edward Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, Lee Schumacher, and David Wilhite.

In Proceedings of the Fourteenth International Conference on Data Engineering (ICDE '98).

PDF

Fast Algorithms for Universal Quantification in Large Databases

Goetz Graefe and Richard L. Cole.

In ACM Transactions on Database Systems, 20, 2 (June 1995).

PDF

Optimization of Dynamic Query Evaluation Plans

Richard L. Cole and Goetz Graefe.

In Proceedings of the 1994 ACM SIGMOD international conference on Management of data (SIGMOD '94).

PDF

Query Processing in the IBM Application System/400

Richard L. Cole, Mark J. Anderson, and Robert J. Bestgen.

In IEEE Bulletin of the Technical Committee on Data Engineering, Vol. 16, No. 4, December 1993.

PDF