Joint Systems Design and Implementation / Intel Science & Technology Center / Database Seminar
— 1:00pm
Location:
Panther Hollow Room - 4th Floor
-
Robert Mehrabian Collaborative Innovation Center
Speaker:
JIAQI YAN
,
Software Engineer
https://www.linkedin.com/in/jiaqiy
For partitioned tables, maintaining good clustering properties for frequently accessed dimensions is critical for partition pruning performance. Naive methods of clustering maintenance could be expensive, especially when the clustering dimensions are different from the dimensions with which the data is loaded. On the other hand, approximate clustering is cheaper to maintain while still resulting in good pruning performance. In this talk, I will present Snowflake's clustering capabilities, including our algorithm for incremental maintenance of approximate clustering of partitioned tables, as well as our infrastructure to perform such maintenance automatically. I will also cover some real-world problems we run into and our solutions.
—
Jiaqi Yan is a Software Engineer at Snow ake Computing. His work focused on Snow ake Databases' Query Engine. Before Snow ake, he worked on Oracle's
Optimizer team where he was a core developer for Oracle's In-memory Columnar Database product. Jiaqi graduated with a B.S.E. from Duke University
Faculty Host: Andy Pavlo
Event Website:
http://db.cs.cmu.edu/events/jiaqi-yan-snowflake-computing
For More Information:
dvanaken@cs.cmu.edu