Greenplum is an established large scale data-warehouse system with both enterprise and open-source deployments. The massively parallel processing (MPP) architecture of Greenplum splits the data into disjoint parts that are stored across individual worker segments. The increased amount of data these systems have to process magnifies optimization mistakes and stresses the importance of query optimization more than ever. Furthermore, there is growing need for optimizers to be highly extensible and modular to ensure that optimizer can keep up with the growing diversity of complex workloads. This talk will focus on Orca – a modular optimizer built for Greenplum and the results of our recent research and development efforts.

This talk is part of the Vaccination Database (Booster) Tech Talk Seminar Series.

Bio:
Venkatesh (Venky) Raghavan is Senior Manager of Product for Greenplum at VMware. Venky's team works on the query optimization, federated query processing as well as machine learning components of Greenplum. Venky started his carrier at Greenplum part of the team that built the cascade based query optimizer named Orca. Prior to joining Greenplum, Venky earned his Ph.D in Computer Sc. from Worcester Polytechnic Institute.

More Info: https://db.cs.cmu.edu/seminar2022-booster#db4