Tag: SQL

SE-Radio Episode 344: Pat Helland on Web Scale

Filed in Episodes by on October 31, 2018 0 Comments
SE-Radio Episode 344: Pat Helland on Web Scale

Pat Helland talks about building systems at web scale that are prepared to handle failure. Pat has been working on databases, transactions and distributed systems since 1978.  Host Edaena Salinas spoke with Helland about the components of a system including physical hardware and data centers; the role of humans in a production system;  automation by […]

Continue Reading »

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 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 194: Michael Hunger on Graph Databases

Filed in Episodes by on May 22, 2013 4 Comments
Episode 194: Michael Hunger on Graph Databases

Recording Venue: Skype Guest: Michael Hunger Michael Hunger of Neo Technology, and a developer on the Neo4J database, joins Robert to discuss graph databases. Graph databases fall within the larger category of NoSQL databases but they are not primarily a solution to problems of scale. They differentiate themselves from RDBMS in offering a data model built […]

Continue Reading »

Episode 186: Martin Fowler and Pramod Sadalage on Agile Database Development

Filed in Episodes by on June 1, 2012 13 Comments
Episode 186: Martin Fowler and Pramod Sadalage on Agile Database Development

Recording Venue: Skype Guest: Martin Fowler and Pramod Sadalage In this episode, we talk with Pramod Sadalage and Martin Fowler about database evolution and agile database development. We discuss the basic challenges for working with a database in an agile development culture and how to include database design and most of all, database evolution, in […]

Continue Reading »