<node id="681776">
  <nid>681776</nid>
  <type>event</type>
  <uid>
    <user id="27707"><![CDATA[27707]]></user>
  </uid>
  <created>1744647814</created>
  <changed>1744647844</changed>
  <title><![CDATA[PhD Defense by Jiashen Cao]]></title>
  <body><![CDATA[<p><strong>Title</strong>: Enhance Database Query Performance through Software Optimization and Hardware Adaptation</p><p><strong>Time</strong>: 3pm Friday 4/25</p><p><strong>Location</strong>: Klaus 2100</p><p><strong>Online</strong>: <a href="https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDU3YzMwNDctY2FkOS00ZDUyLTlhODEtZWUzNjQ3ZjU5MjM3%40thread.v2/0?context=%7b%22Tid%22%3a%22482198bb-ae7b-4b25-8b7a-6d7f32faa083%22%2c%22Oid%22%3a%224ee47df9-81fa-4703-8979-0e914d8e4b7d%22%7d" title="https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDU3YzMwNDctY2FkOS00ZDUyLTlhODEtZWUzNjQ3ZjU5MjM3%40thread.v2/0?context=%7b%22Tid%22%3a%22482198bb-ae7b-4b25-8b7a-6d7f32faa083%22%2c%22Oid%22%3a%224ee47df9-81fa-4703-8979-0e914d8e4b7d%22%7d">Microsoft Teams</a></p><p><a href="https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDU3YzMwNDctY2FkOS00ZDUyLTlhODEtZWUzNjQ3ZjU5MjM3%40thread.v2/0?context=%7b%22Tid%22%3a%22482198bb-ae7b-4b25-8b7a-6d7f32faa083%22%2c%22Oid%22%3a%224ee47df9-81fa-4703-8979-0e914d8e4b7d%22%7d" target="_blank"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGAAAABgCAYAAADimHc4AAAAAXNSR0IArs4c6QAACnVJREFUeAHtXXtsHEcZ/2Z27fP5dbbPbVNoKyFUBbWFQhLzbJVatNCHUkLch5pQFUVVlMAfVAGhEp8lE9shRUIIIQpKBRWJ46CmiVMQ5I+WtFVatSVNoGlBBDUKSUMdiJ3g9+P2dvhmz3c+Nrd3s7uzc+tmVzrd7M433/fN77f7zet2DiA6IgQiBCIEIgQuVwTIYq141w8ufgoyxmoTyK0A7MOEwYd4XRiB9wHIvyiww6DpB3q+1/znMNdx0RGQ2jZyH2RYLwO2VARYAuQEaCTVuyX5rIi8aplFQ0Cq578fYcQYAMY+6wkkQl4nTF/b29V0ylP5gAotCgK6tl1caZqZfQh+0hcOhIxQqnX0bGl+2ZceiYVDT8A8+M8j+FVS6k1IGkm4IywkhJqA+bBzxPedb2cOnwQMR21hCEfU7luYzudjvr+wU6xCGMos3cXyFF8LLQFWb8drgysCIuq2bIjIBiijB6jbn2rsavpTIFA6a8NT9/SrXzt2MzGN+0zG7iCEXAcMkkBghDF2hhLyPKP6s4P9y94q50Uo2wA+yDIN41g552XkU11f5mawtvqRNz9K0uYPEeg15ewjMftZFf3ugV+vOOkkG84QhCNcJ4elX3dha/W6I3eROfOoCPjcTy7H5Xk5J79DSUB2esHJZbnXRW1Z4Jvm73AEnnDjAZcnWM6JhFASwOd23FTSn2x5W1bYMdkeBqB5scXLESzP9djLh5KA3MSa3dkgzkVsWTHf5Z1v99V6ErDtsF8PJQF2J4M8ZwQpKHHw3o5ozC+hxsrieri+QrlQEpCdUi50M8g0GyqlnXc1S+W7zbPrCyUBfD7fbcW8y5e2xfv53nVfWtKuL5QDsYmx9//EGGm/1H3nK9jnxvWXGMRiDYCTbc6Cthxr4cZ2rfCUD7IwdBRe8pW2Bm0FGsL5BNDYvgIfhZIcJCM9A5OT5wGnroXKWEK4alZSmI9wZR42faEk4Cfblx7BO+VdT/XGm3V2dlyoKF8tKzsKxukFIWWiQjZ9Vghas+7Fa2ZnsYvE2G2o52pRXUHKvXvyXFH1jKWBmWNgpt/DUAMQr03ClUtugOrq2rx8xpjNp0smcKmyZD5m4pN1Br+kYTKvL2+WZsHPvIWWHpJpKG9BcoKQKqBaErSamzDUAEyMD8E/T74Mc3NTeUtCMRuXKEXWifnEWl6xhIRdH83e+dAiQbdSFQR0oFXXWjZN04D/nPubuP3sgsxakQJ8VlNETlTGrg87AVbYES0fKjlCG/P+TE8JhurskmSH6GoYn1LG9mh/3pCPBNdjn6LmjbC0+ObDN09FeTjKHZnMXC7p/J1dlHe9HsynlLHBHnVWXD6Hl+d67JKh7AXZnZRynv1ZSpuXxXg+n88oeQgXT1z0bxe85uV4+WLrAh94AnhXk2j0/r5U6+dEw84CdAupA7vbDjJKV7l9Eqw7H8vx8gvaFlKhHAkvuFc+pWnV72D4aUXJJuw08jv0HBA6RAkckv3TRA4iTikvl7kiRu7peEHeOLs8XtIlfr/v9oosq8paE3b9BOx66hZIJKqlA8kVjo7NwcOPvhKIbtlK53szfNG9y49u1wRQfLb5J4gjKL1B+CpL5we+EZYFVFB6XD8BQTniVe+X7t6Wb8M+duOqvJqGxiX5tJcEn86YmZ2D0dEJuDAyij/78X9gj2iOEfY2JfQZ7SsrfrT3AZJZ9AT4h6W4Bhy1QrwmZn0a6mvh9Okh3yTgunA1KlluMnO5OXjkrvufYbe7JmBsIo0LVsWdzl1tbKgCXgH7wRvZUsf4OOoO4VFXF4eWZAJG8EmQd7DbMs+9+W3XBGz61utlfej/5a3QZOsppdMmrFt/uGzZsAokEvWSCQDAJ+GBqBEWZLwmJr/rTRj5eESAIAHFQqpgUUcx3iZEBDjCoyYjIkANzo5WIgIcoVGTERGgBmdHKxEBjtCoyYgIUIOzo5WIAEdo1GREBKjB2dFKRIAjNGoyIgLU4OxoJSLAERo1GREBanB2tBIR4AiNmoyIADU4O1qJCHCERk1GRIAanB2tRAQ4QqMmIyJADc6OViICHKFRkxERoAZnRyuuf5biqKkgI5NhkMngG3QFh2H8/3lB1mWdDISARza8clmDKlx5QoajECSMViCCZyMCAsFVWOl7EQHCWAUhSI5GBASBq6DOKgq/4QSU3LBIUFdFxMzMTEXsyjCKP3U8tre/7QTF35G/JENhJXSk08PKzDK+MYXMg5CfcXU0FsO3twlckKlbhS6TzcHU+DsqTFk2DNu4xo9hvPtf3d+/4mmug+7f3X42FtNuxidhD56HPhzxsDM7cxZGhw/htjUL29K42SXLC3iG4ekl+UtMIfhp3MRyI35bbz1ZAzFOAkoK7R5yiUYXF25Z+Z2/Gsb0DS6KlBTVq+L5fF2vyaeDSGSkEICgE7JxcFdb/tFV2guimn5CGjj4ClRNTXa3FEKotXGTNN1FFM3M+n19ah783W2/KlSvlABdjx8tNO4lzcHmd359/ZWg4yZ91dV10Ji4BjRtYVYFH28vqkuWmZqaLplfKhO9mcBXq9cfGGjbYZdb8NqeE8B5csmyXVexqa34ZkigxOP+EXK9Z8ScnJrx5DPeDAd1nW7cu3PFmWJOeVJaTJHItb07V50hmvYXEVmvMvzu51tXyjxQ5RvYDf089hb/gPrLxiL+PjB+BvFhXTU48Om7ncDnPip9ArhBDCHP4dcynpZ5ENwrVK+qgVh1Pe4pJ7ta5OnBPZ95Df29Z+3a483TdPpeZpJPIjH8bXDc8IrFsHU9jeenMP33OKv57cDAJy6K1E9+sCxjdcOGF1szmnkK30SvLyPqKjte2wxNzde5KiMkjLtsJWuT127eTLw3AiUMKQ1B3I8dO9qHqaY9VcIn11l8DFDfcJXrciIFsO+yIyjwuX3lBHCjuGPCNoylEzzt5+DA18QTkLzieqtH5EdX0bKEjMdp/KdF8yRdVB6Ccn6neoY3YW/oydx5GL+xIf1Gb1frz4P0rWIE8Eqles8fxE1J7gyygl51IzCHe1KtK/FJlbFRiqMbFQlBOW/ipHY9dosEN/zMlVLwjaFH12KPBg0+r0lFCejsrBvSCH0YSSjbt1YAu2XC6sMzWNO9pfEfKmxWlABewa2dLQdxt/8HseKGigqXtIHhhhH6dYz7L5SUk5hZcQJ4XbamWnHUSNbhkyBnztcLQGgb4d/Ul2rh0/LKjoo2wvZapnpG7sRpl524q9QV9rwgzxEEXFojD+KdfyhIO8V0h4oA7mBf3+TVU2x6N24q3l7MYenXCBzDGZk1fanm09J1CygMHQHc527GaLrvwmM4r7IFiZD7FyLzoGDFh7GX833tC8lfdLdXrv0JJQG5G+eJJ843jBv0MdzbazMO2nBrYv8HVngKJwSfrNNJ7+OPt8jcBM6Tc6EmIFej7h9fbDImzA5sHzpwm68v8p2mcnlC37yBBfgjjqj6q5qTg93f9D8NImRXQGhREFBYj+3bLyQmM+zLOD9/E15fyj/4b3jz06DMwHFrBv8Ibgwb1bfxc5xQdhynh1/r7Kz/d6GeKB0hECEQIRAhAP8Df5YlCtXXo4oAAAAASUVORK5CYII=" width="160" height="160"></a></p><p><a href="https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDU3YzMwNDctY2FkOS00ZDUyLTlhODEtZWUzNjQ3ZjU5MjM3%40thread.v2/0?context=%7b%22Tid%22%3a%22482198bb-ae7b-4b25-8b7a-6d7f32faa083%22%2c%22Oid%22%3a%224ee47df9-81fa-4703-8979-0e914d8e4b7d%22%7d" target="_blank">Join conversation</a></p><p>teams.microsoft.com</p><p>&nbsp;</p><p>&nbsp;</p><p><strong>Jiashen Cao</strong></p><p>Ph.D. Candidate</p><p>School of Computer Science</p><p>College of Computing</p><p>Georgia Institute of Technology</p><p>&nbsp;</p><p><strong>Committee</strong></p><p>Dr. Joy Arulraj (co-advisor), School of Computer Science, Georgia Institute of Technology</p><p>Dr. Hyesoon Kim (co-advisor), School of Computer Science, Georgia Institute of Technology</p><p>Dr. Divya Mahajan, School of Electrical and Computer Engineering and Computer Science, Georgia Institute of Technology</p><p>Dr. Kexin Rong, School of Computer Science, Georgia Institute of Technology</p><p>Dr. Rathijit Sen, Microsoft Gray System Lab</p><p>Dr. Tarique Siddiqui, Microsoft Research</p><p>&nbsp;</p><p><strong>Abstract</strong></p><p>Modern database systems incorporate machine learning (ML) algorithms within queries to deliver richer insights and support complex business logic. However, the inclusion of these compute-intensive algorithms introduces new performance bottlenecks. My thesis focuses on addressing these challenges through a combination of software-level optimizations and hardware-aware adaptations. In my talk, I will highlight two projects.</p><p>&nbsp;</p><p>The first project, Aero, introduces an enhanced adaptive query execution framework to produce better query plans and more efficient GPU resource management. Traditional databases rely on static, ahead-of-time query optimization, which struggles to optimize ML queries due to the difficulty of collecting accurate statistics beforehand. Moreover, optimal hardware utilization often requires dynamic, runtime decisions, which is impossible in the static optimization setting. Aero addresses both of these challenges in a unified framework and achieves significant performance improvements over prior approaches.</p><p>&nbsp;</p><p>The second project shifts focus toward supporting large language model (LLM) analytics within database systems. Specifically, we target scenarios where LLMs are too large to fit entirely in GPU memory. In such cases, prior offloading-based approaches suffer from CPU-GPU bandwidth limitations, which become the new bottleneck. To overcome this, we propose a GPU-centric buffering strategy paired with an LLM-aware buffer replacement policy significantly, improving both performance and buffer hit rates.</p>]]></body>
  <field_summary_sentence>
    <item>
      <value><![CDATA[Enhance Database Query Performance through Software Optimization and Hardware Adaptation]]></value>
    </item>
  </field_summary_sentence>
  <field_summary>
    <item>
      <value><![CDATA[<p>Enhance Database Query Performance through Software Optimization and Hardware Adaptation</p>]]></value>
    </item>
  </field_summary>
  <field_time>
    <item>
      <value><![CDATA[2025-04-25T15:00:00-04:00]]></value>
      <value2><![CDATA[2025-04-25T17:00:00-04:00]]></value2>
      <rrule><![CDATA[]]></rrule>
      <timezone><![CDATA[America/New_York]]></timezone>
    </item>
  </field_time>
  <field_fee>
    <item>
      <value><![CDATA[]]></value>
    </item>
  </field_fee>
  <field_extras>
      </field_extras>
  <field_audience>
          <item>
        <value><![CDATA[Public]]></value>
      </item>
      </field_audience>
  <field_media>
      </field_media>
  <field_contact>
    <item>
      <value><![CDATA[]]></value>
    </item>
  </field_contact>
  <field_location>
    <item>
      <value><![CDATA[Klaus 2100]]></value>
    </item>
  </field_location>
  <field_sidebar>
    <item>
      <value><![CDATA[]]></value>
    </item>
  </field_sidebar>
  <field_phone>
    <item>
      <value><![CDATA[]]></value>
    </item>
  </field_phone>
  <field_url>
    <item>
      <url><![CDATA[]]></url>
      <title><![CDATA[]]></title>
            <attributes><![CDATA[]]></attributes>
    </item>
  </field_url>
  <field_email>
    <item>
      <email><![CDATA[]]></email>
    </item>
  </field_email>
  <field_boilerplate>
    <item>
      <nid><![CDATA[]]></nid>
    </item>
  </field_boilerplate>
  <links_related>
      </links_related>
  <files>
      </files>
  <og_groups>
          <item>221981</item>
      </og_groups>
  <og_groups_both>
          <item><![CDATA[Graduate Studies]]></item>
      </og_groups_both>
  <field_categories>
          <item>
        <tid>1788</tid>
        <value><![CDATA[Other/Miscellaneous]]></value>
      </item>
      </field_categories>
  <field_keywords>
          <item>
        <tid>100811</tid>
        <value><![CDATA[Phd Defense]]></value>
      </item>
      </field_keywords>
  <field_userdata><![CDATA[]]></field_userdata>
</node>
