Biography

Wan Shen Lim is a PhD student in the Computer Science Department of the School of Computer Science at Carnegie Mellon University. His research interest is in database management systems. He is advised by Professor Andy Pavlo. Wan graduated from Carnegie Mellon University in May 2020 with a Bachelor of Science (University Honors) in Computer Science with an Algorithms and Complexity Concentration, a Computer Systems Concentration, and a Minor in Mathematical Sciences. He is a member of the Carnegie Mellon Database Group, Parallel Data Lab, and SNAP Lab.

Contact

• Email: [email protected]
• Office: GHC 9023
• GitHub: lmwnshn
• LinkedIn: lmwnshn

Teaching

• 15-445 Database Systems (Fall 2019).
• 15-150 Principles of Functional Programming (Spring 2018, Fall 2018).
• 15-122 Principles of Imperative Programming (Fall 2017).

Service

• Curriculum Review Committee (Spring 2020, Fall 2020, Spring 2021).
• Dean's Undergraduate Student Advisory Council (Fall 2019, Spring 2020).

Publications

2021. MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems. Lin Ma, William Zhang, Jie Jiao, Wuwen Wang, Matthew Butrovich, Wan Shen Lim, Prashanth Menon, Andrew Pavlo. SIGMOD 2021.
2021. Filter Representation in Vectorized Query Execution. Amadou Ngom, Prashanth Menon, Matthew Butrovich, Lin Ma, Wan Shen Lim, Todd C. Mowry, Andrew Pavlo. DAMON 2021.
2021. Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems. Ling Zhang, Matthew Butrovich, Tianyu Li, Yash Nannapanei, Andrew Pavlo, John Rollinson, Huanchen Zhang, Ambarish Balakumar, Daniel Biales, Ziqi Dong, Emmanuel Eppinger, Jordi Gonzalez, Wan Shen Lim, Jianqiao Liu, Lin Ma, Prashanth Menon, Soumil Mukherjee, Tanuj Nayak, Amadou Ngom, Jeff Niu, Deepayan Patra, Poojita Raj, Stephanie Wang, Wuwen Wang, Yao Yu, William Zhang. CIDR 2021.
2020. Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats. Tianyu Li, Matthew Butrovich, Amadou Ngom, Wan Shen Lim, Wes McKinney, Andrew Pavlo. PVLDB 2020.
2019. On Supporting Efficient Snapshot Isolation for Hybrid Workloads with Multi-Versioned Indexes. Yihan Sun, Guy Blelloch, Wan Shen Lim, Andrew Pavlo. PVLDB 2019.

Honors and Awards

2020. Carnegie Mellon University. Senior Leadership Recognition.
2018. Carnegie Mellon University. Summer Undergraduate Research Fellowship. Research with Carnegie Mellon Database Group / Professor Andy Pavlo.
2016. Ministry of Education, Brunei. Full ride scholarship to Carnegie Mellon University, USA. Approximately 150 scholarship recipients nationwide.
2015. BruCERT ITPSS Cyber Battle (national cybersecurity CTF). First place.
2014. Shing-Tung Yau High School Mathematics Awards. Semi-Finalist.
2014. Singapore Science and Engineering Fair. Gold award.
2014. singpath (national high school coding competition). First place.
2010. Ministry of Education, Brunei. Full ride scholarship to NUS High School, Singapore. Three recipients nationwide.

Work History

• 2019-08 to 2019-12.
  Teaching Assistant at Carnegie Mellon University, USA.
• 2019-05 to 2019-08.
  SDE Intern at Amazon.com Services, Inc. on the AWS Aurora (Engine) team.
• 2018-08 to 2018-12.
  SCS Gateskeeper (Microsoft Lounge) at Carnegie Mellon University, USA.
• 2017-08 to 2017-12, 2018-01 to 2018-05, 2018-08 to 2018-12.
  Teaching Assistant at Carnegie Mellon University, USA.
• 2016-08 to 2017-05.
  Desk Services Attendant (Housing) at Carnegie Mellon University, USA.
• 2015-01 to 2016-04.
  Law Firm Attachment at Rudi Lee, Annie Kon & Associates, Brunei.
• 2013-06 to 2014-06.
  R&D Project Intern at Solar Energy Research Institute of Singapore, Singapore.

Education History

• 2020 (current). Carnegie Mellon University, Pittsburgh, USA.
• 2016 to 2020. Carnegie Mellon University, Pittsburgh, USA.
• 2010 to 2014. NUS High School, Singapore.
• 2008 to 2009. Sultan Omar Ali Saifuddien College, Brunei.
• 2001 to 2007. Saint Andrew's School, Brunei.
• 2000 to 2000. PDS School, Brunei.