LA Open Source Data Infrastructure Meetup | Wednesday June 12th, 2024
Details
Are you interested in learning more about open-source data technologies? ✅
Do you want to network with local and international tech professionals in a fun, relaxed environment? ✅
🤩 Then join us for an evening full of inspiring conversations and exciting talks by an awesome speaker!
Date: Wednesday, June 12th, 2024
Location: 720 Lincoln Blvd, Venice, CA 90291
Agenda:
- 5 - 5:30 Welcome: Networking & snacks
- 5:30 - 5:35 Kickoff: Welcome Aiven
- 5:35 - 6:15 Query Optimizations in TiDB with Ahmad Ghazal
- 6:15 - 8:00 Food & Networking
* Please note that this is an alcohol-free event. Light bites will be provided.
* By attending this event, you agree to abide by our community code of conduct.
Query Optimizations in TiDB with Ahmad Ghazal
The database query optimizer is a major component of database management systems. Its main task is to determine the most efficient execution plan for a given query. In the first half of this talk, we provide a high-level description of query optimizers in general and go over their logical and physical optimization phases. The logical optimization phase includes query rewriting and join re-ordering. The physical optimization phase focuses on finding the best table access methods and the best join and aggregation execution algorithms. These optimizations conclude with building an execution plan that can be used to produce the query result.
The second half of this talk covers the TiDB query optimizer. TiDB is an open-source, distributed SQL database designed to support hybrid transactional and analytical processing (HTAP) workloads, ensuring strong consistency, high availability, and horizontal scalability. The scale and complexity of these hybrid workloads present unique challenges for the TiDB query optimizer. In this talk, we will demonstrate how the TiDB optimizer addresses these challenges by (1) being aware of the distributed framework, (2) selecting the optimal storage engine for data access, and (3) providing tools to manage query execution plans and index recommendations