Tag: database

SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner

Filed in Episodes by on June 19, 2018 0 Comments
SE-Radio Episode 328: Bruce Momjian on the Postgres Query Planner

Bruce Momjian, a longtime Postgres developer, educator and consultant joins Robert Blumen for a discussion of the SQL query planner in the Postgres relational database. Topics covered include what is a query? How queries are evaluated by the server; the phases of query evaluation; SQL as a declarative language; why declarative query evaluation is simpler […]

Continue Reading »

SE-Radio Episode 252: Christopher Meiklejohn on CRDTs

Filed in Episodes by on March 15, 2016 4 Comments
SE-Radio Episode 252: Christopher Meiklejohn on CRDTs

Robert Blumen talks to Christopher Meiklejohn about conflict-free replicated data types (CRDTs). The discussion covers forms of consistency in distributed systems; conflicts and conflict resolution algorithms; consistency and concurrency; the discovery of CRDTs; state-based and operations-based CRDTs; examples of some well-known CRDTs, including counters and sets; time and space complexity; uses of CRDTs in chat […]

Continue Reading »

SE-Radio Episode 243: RethinkDB with Slava Akhmechet

Filed in Episodes by on December 2, 2015 5 Comments
SE-Radio Episode 243: RethinkDB with Slava Akhmechet

Slava Akhmechet and Jeff Meyerson discuss RethinkDB, an open source database for the real-time Web. RethinkDB pushes data to the application rather than requiring the application to poll the database for updates. The discussion begins with the question of why databases need to be rethought–why is it better to build JSON-pushing into the database layer […]

Continue Reading »

SE-Radio Episode 233: Fangjin Yang on OLAP and the Druid Real-Time Analytical Data Store

Filed in Episodes by on July 28, 2015 2 Comments
SE-Radio Episode 233: Fangjin Yang on OLAP and the Druid Real-Time Analytical Data Store

Fangjin Yang, creator of the Druid real-time analytical database, talks with Robert Blumen. They discuss the OLAP (online analytical processing) domain, OLAP concepts (hypercube, dimension, metric, and pivot), types of OLAP queries (roll-up, drill-down, and slicing and dicing), use cases for OLAP by organizations, the OLAP store’s position in the enterprise workflow, what “real time” […]

Continue Reading »

Episode 220: Jon Gifford on Logging and Logging Infrastructure

Filed in Episodes by on February 18, 2015 3 Comments
Episode 220: Jon Gifford on Logging and Logging Infrastructure

Robert Blumen talks to Jon Gifford of Loggly about logging and logging infrastructure. Topics include logging defined, purposes of logging, uses of logging in understanding the run-time behavior of programs, who produces logs, who consumes logs and for what reasons, software as the consumer of logs, log formats (structured versus free form), log meta-data, logging […]

Continue Reading »