Peter Geoghegan on "Query Evaluation Techniques for Large Databases"

Mar 30, 2017 · San Francisco, United States of America

Mini

Matt Adereth on TBD

Matt's Bio

soon ...


Main Talk

Peter Geoghegan on "Query Evaluation Techniques for Large Databases"

Peter tells us:  This talk takes some artistic license with the established PWL format. Rather than being a discussion of one particular paper, the talk is intended as a guided tour of the development of various widely implemented relational database join algorithms, with a particular focus on the pressures that shaped their development. Framing the discussion this way is not intended as a history lesson, so much as a vehicle for explaining the practical relevance of each algorithm under discussion, possible future developments, and the fundamental nature of how relational databases implement joins.

That being said, the talk is essentially an exploration of the paper "Query Evaluation Techniques for Large Databases", by Goetz Graefe.

The talk will make quite a few small detours, generally influenced by related papers, but without veering too far from Graefe's central arguments.

Familiarity with working with systems like PostgreSQL, SQL Server, or Oracle will give a good grounding for understanding the material in the talk. Reading over and working through the "Using EXPLAIN" [1] section of the PostgreSQL documentation may be a useful refresher on the topics the talks considers.

[1] https://www.postgresql.org/docs/current/static/using-explain.html


Peter's Bio
Peter has been involved in PostgreSQL development since 2011 as both a reviewer and feature implementer, and is a PostgreSQL Major Contributor.

His development projects tend to be centered on improving PostgreSQL's performance in various ways, including adding support for group commit, as well as a succession of improvements to the PostgreSQL sort code down through the years. Peter is also the primary author of PostgreSQL 9.5's "UPSERT" feature.

Event organizers
  • Papers we love too

    San Francisco chapter of http://www.meetup.com/papers-we-love  What was the last paper within the realm of computing you read? What did it inspire you to build or tinker with? Come share the ideas in an awesome academic/research publication with fellow engineers, programmers, and paper-readers. Lead a session and show off code that you wrote that implements these ideas or just give us the low...

    Recent Events
    More

Are you organizing Peter Geoghegan on "Query Evaluation Techniques for Large Databases"?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews

Featured Events