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
• Languages: English, Malay, *

Teaching

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

Service

• Member, Curriculum Review Committee (Spring 2020, Fall 2020, Spring 2021, Fall 2021, Spring 2022, Fall 2022, Spring 2023).
• Member, Introductory Course Committee (Spring 2022).
• Member, Open House Committee (Spring 2022).
• Member, Dean's Undergraduate Student Advisory Council (Fall 2019, Spring 2020).

• Mentor, (Student-Run) Mentorship Program (Spring 2022).
• Mentor, (Student-Run) Graduate Application Support Program (Fall 2020).
• Mentor, (Student-Run) TartanHacks (Spring 2017).

Publications

2023. Database Gyms.
      Wan Shen Lim, Matthew Butrovich, William Zhang, Andrew Crotty, Lin Ma, Peijing Xu, Johannes Gehrke, Andrew Pavlo.
      CIDR 2023. PDF


2022. Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems. Matthew Butrovich, Wan Shen Lim, Lin Ma, John Rollinson, William Zhang, Yu Xia, Andrew Pavlo. SIGMOD 2022. PDF


2021. Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation.
      Andrew Pavlo, Matthew Butrovich, Lin Ma, Wan Shen Lim, Prashanth Menon, Dana Van Aken, William Zhang.
      PVLDB 2021. PDF


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. PDF


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. PDF


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. PDF


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. PDF


2019. On Supporting Efficient Snapshot Isolation for Hybrid Workloads with Multi-Versioned Indexes.
      Yihan Sun, Guy Blelloch, Wan Shen Lim, Andrew Pavlo.
      PVLDB 2019. PDF

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.
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

• 2023-01 to 2023-05.
  Teaching Assistant (15-721) at Carnegie Mellon University, USA.
• 2022-08 to 2022-12.
  Teaching Assistant (15-445) at Carnegie Mellon University, USA.
• 2019-08 to 2019-12.
  Teaching Assistant (15-445) 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.
• 2018-08 to 2018-12.
  Teaching Assistant (15-150) at Carnegie Mellon University, USA.
• 2018-01 to 2018-05.
  Teaching Assistant (15-150) at Carnegie Mellon University, USA.
• 2017-08 to 2017-12.
  Teaching Assistant (15-122) 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 (PhD CS), Pittsburgh, USA.
• 2016 to 2020. Carnegie Mellon University (BSc CS), Pittsburgh, USA.
• 2010 to 2014. NUS High School (Diploma), Singapore.
• 2008 to 2009. Sultan Omar Ali Saifuddien College, Brunei.
• 2001 to 2007. Saint Andrew's School, Brunei.
• 2000 to 2000. PDS School, Brunei.