Jignesh Patel
Professor of Computer Science · Carnegie Mellon University
Jignesh Patel is a Professor of Computer Science at Carnegie Mellon University, known for work on query processing and column-oriented database systems.
- lectures
- 10
- series
- 1
- hours
- 13
Start here
Series and courses
CMU 15-445/645: Intro to Database Systems
In these lectures
- Query optimization transforms a high-level declarative SQL query into an efficient physical execution plan to minimize I/O and CPU costs.Query Planning & Optimization
- Conflict serializability permits safe interleavings by ensuring the final schedule is equivalent to some serial schedule.Two-Phase Locking Concurrency Control
- External merge sort uses divide-and-conquer and multi-way merging to sort files larger than available memory.Sorting & Aggregation Algorithms
Draws on
People cited in the lectures, at the moment of the citation.
- Jim GrayTuring Award winner who helped invent two-phase locking.
- S R SelingerAuthor of the seminal paper on System R query optimization.
- Pat SelingerAuthor of the System R query optimization paper.
- Goetz GraefeInvented top-down optimization while an assistant professor with student Bill McKenna as part of the Volcano project.
- Bill McKennaStudent of Goetz Graefe who worked on the Volcano project.
- Paul LarsonResearcher at Microsoft, author on the Hekaton paper.
About
Jignesh Patel is a Professor of Computer Science at Carnegie Mellon University, known for work on query processing and column-oriented database systems. His CMU 15-445/645 lectures derive external merge sort, two-phase locking, multi-version concurrency control and ARIES recovery at the introductory level.
Taught with
Same subject, Computer Systems & Software
Connections
16Their places, courses, books and lectures.


