Zechao Shang


		Zechao Shang pronunciation Say 'ch' as in 'child' instead of 'chaos' and you are pretty close. What does it mean? Glad you asked. Shang means business, which is a very rare surname, as ancient Chinese governments despised commerce. Ze represents my genealogy order: I'm actually the 26th generation of Shang, if my ancestors' data management ability is as good as mine and their data is accurate. Chao is the name given by my mom, which means superior. She wanted me to be an outstanding boy from the Shang family. I hope I did not let her down. first name plus last name dot gmail dot com

Interests		I am a Senior Software Engineer at Snowflake and an Adjunct Assistant Professor at the University of Chicago. I build efficient and scalable database management systems. At Snowflake I work on a secret project :) My last research work focuses on exploiting the value from fast-changing data. I worked on distributed machine learning/graph analytics systems, with a focus on how weak concurrency affects computation quality. My dissertation is on efficient graph computing.

Projects		CrocodileDB I lead CrocodileDB, a next-generation database that helps users ingest and process the fast-changing data. CrocodileDB avoids the trap of unnecessary resource consumption and expedites result delivery. It integrates workload prioritization, execution policies, query scheduling, and data loading. SoCC 2021 Version Reconciliation for Collaborative Databases (under shepherding) Nalin Ranjan, Zechao Shang, Sanjay Krishnan, Aaron J. Elmore SIGMOD 2021 Combining Sampling and Aggregation (Nearly) Optimally Xi Liang, Stavros Sintos, Zechao Shang, Sanjay Krishnan SIGMOD 2021 Resource-efficient Shared Query Execution via Exploiting Time Slackness Dixin Tang, Zechao Shang, Aaron J. Elmore, and Sanjay Krishnan CIDR 2020 CrocodileDB: Efficient Database Execution through Intelligent Deferment Zechao Shang, Xi Liang, Dixin Tang, Cong Ding, Aaron J. Elmore, Sanjay Krishnan, Michael J. Franklin VLDB 2019 Intermittent Query Processing Dixin Tang, Zechao Shang, Aaron J. Elmore, Sanjay Krishnan, Michael J. Franklin VLDB 2018 (Demo) CYADB: a Database that Covers Your Ask Zechao Shang, Will Brackenbury, Aaron J. Elmore, Michael J. Franklin SIGMOD 2020 Fast and Reliable Missing Data Contingency Analysis with Predicate-Constraints Xi Liang, Zechao Shang, Sanjay Krishnan, Aaron J. Elmore, Michael J. Franklin SIGMOD 2020 Thrifty Query Execution via Incrementability Dixin Tang, Zechao Shang, Aaron J. Elmore, Sanjay Krishnan, Michael J. Franklin Asynchronous Optimization I extended transaction processing theory to study how large-scale optimization behaves in the asynchronous environment, especially when/how asynchronization endangers convergence. SIGMOD 2018 RushMon: Real-time Isolation Anomalies Monitoring Zechao Shang, Aaron J. Elmore, Jeffrey Xu Yu CIDR 2017 My Weak Consistency is Strong: When Bad Things Do Not Come in Threes Zechao Shang, Jeffrey Xu Yu SIGOPS Operating Systems Review Artificial Intelligence in Resource-Constrained and Shared Environments Sanjay Krishnan, Aaron J. Elmore, Michael J. Franklin, John Paparrizos, Zechao Shang, Adam Dziedzic, Rui Liu Graphs Systems My dissertation focuses on efficient and scalable graph computing systems that preserve the correctness when necessary, and strike at the balance between performance and accuracy when approximations are preferred. I also designed graph analytical algorithms. ICDE 2019 TuFast: A Lightweight Parallelization Library for Graph Analytics Zechao Shang, Jeffrey Xu Yu, Zhiwei Zhang ICDE 2019 Keyword-Centric Community Search Zhiwei Zhang, Xin Huang, Jianliang Xu, Byron Choi, Zechao Shang SIGMOD 2016 Graph Analytics Through Fine-Grained Parallelism Zechao Shang, Feifei Li, Jeffrey Xu Yu, Zhiwei Zhang, Hong Cheng Frontiers of Computer Science Handling Query Skew in Large Indexes: a View Based Approach Weihuang Huang, Jeffrey Xu Yu, Zechao Shang TKDE To Meet or Not to Meet: Finding the Shortest Paths in Road Networks Weihuang Huang, Yikai Zhang, Zechao Shang, Jeffrey Xu Yu ADC 2016 A Sketch-First Approach for Finding TSP Weihuang Huang, Jeffrey Xu Yu, Zechao Shang VLDB 2015 Auto-Approximation of Graph Computing Zechao Shang, Jeffrey Xu Yu SIGMOD 2015 Divide & Conquer: I/O Efficient Depth-First Search Zhiwei Zhang, Jeffrey Xu Yu, Lu Qin, Zechao Shang ICDE 2013 Catch the Wind: Graph Workload Balancing on Cloud Zechao Shang, Jeffrey Xu Yu VLDB 2012 K-reach: Who is in Your Small World Invited to VLDBJ: Bests of VLDB 2012 James Cheng, Zechao Shang, Hong Cheng, Haixun Wang, Jeffrey Xu Yu CIKM 2012 Measuring Robustness of Complex Networks Under MVC Attack Ronghua Li, Jeffrey Xu Yu, Xin Huang, Hong Cheng, Zechao Shang

Employment		University of Chicago Adjunct Assistant Professor 2021-

		Snowflake Inc. Senior Software Engineer 2021-

		University of Chicago Postdoctoral Scholar Advisor: Michael J. Franklin and Aaron J. Elmore 2016-2020

		Chinese University of Hong Kong, Hong Kong Postdoctoral Fellow Advisor: Jeffrey Xu Yu 2015-2016

Education		Chinese University of Hong Kong, Hong Kong Ph.D., Systems Engineering and Engineering Management Advisor: Jeffrey Xu Yu 2011-2015

		Zhejiang University, China B.E., Computer Science 2006-2010
		Last Update: Sept 16, 2021