Tag: SQL
Episode 397: Pat Helland on Data Management with Microservices
Pat Helland, who has been working on building data management systems since 1978, talks to host Akshay Manchale about Data Management at scale with Microservices. Pat talks about trends in storage and computing, state management, immutable data storage, and idempotent computation. He also talks about various ways to look at data — “inside” vs. “outside,” “prescriptive” […]
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 […]
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 […]
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” […]
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 […]
SE Radio Alerts
