How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder
推荐理由
I'd suggest watching this video to get a flavor of how much leverage using the database can give you
说明
这是2017年由Devoxx发布的一部演讲,主题归在Databases & storage。它讲的是sql query optimization这一支里的具体问题,而不是把整个领域扫一遍。适合已经能看懂基本术语、想继续往下走的人。内容上可以概括成:Lukas Eder's Devoxx talk on how modern cost-based SQL optimizers rewrite and plan queries in ways developers would not expect. It argues that declarative SQL, used well, can run complex queries very fast.这些读者给出的理由,核心是:HN commenters recommend it to developers unfamiliar with how much leverage and intelligence there is in a SQL database.讲法不绑某一条新闻,过几年仍然可以当材料看。从2019年到2023年,有3位不同的读者在3个不同月份把它推荐出来,其中明确叫别人去看的有0次。适合一次性看完。讲者把一个判断讲透,演示是在给这个判断配例子。如果已经会了基本定义,就把注意力放在它怎么把sql query optimization变成能跟着复述的例子。
视频信息
- 频道
- Devoxx
- 时长
- 50 分 31 秒
- 发布年份
- 2017
同主题更多
- "Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson
- The Value of Values with Rich Hickey
- AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)
- "Turning the database inside out with Apache Samza" by Martin Kleppmann
- Conflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016
- 01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)