Xin (Shin) Zhang

Senior Principal Software Engineer at Pivotal

About

Shin is currently a senior principal software engineer at Pivotal Data team. Shin is a committer of GPORCA (a standalone query optimizer), GPDB (an MPP database solution), Gemfire (an in-memory data grid), and Greenplum connector (a protocol to transfer data between Gemfire and Greenplum clusters). He is also a contributor on HAWQ (a SQL solution on top of Hadoop using GPORCA). In past decade, Shin was also a seasoned former Microsoft SQL Server engineer focused on product quality of query optimizer (QO) and released column store indexing, star join optimization, and other performance features in SQL Server releases from 2005 to 2016 CTP.

Xin (Shin) Zhang has presented the following presentations

    Xin (Shin) Zhang The internals of GPORCA optimizer at PGConf Local: Seattle [PgConf.US]
    An Open Source query optimizer

    presented by Xin (Shin) Zhang

    The latest OSS release of Greenplum Database (GPDB) 5.0 can switch between the planner optimizer and a standalone MPP (massively parallel processing) query optimizer called GPORCA. This query optimizer is also used in Apache HAWQ (a SQL solution on top of Hadoop). The talk will describe the architecture of GPORCA, how to develop new rules, and best practices for testing and debugging. At the en...

    more

    dev