Froid and the relational database query quandry with Dr. Karthik Ramachandra
676
16.1
Microsoft Research324 тыс
Следующее
24.04.19 – 4 3212:22Популярные
55 дней – 4963:07:51
14.12.22 – 1 15034:02Опубликовано 24 апреля 2019, 21:15
Episode 73 | April 24, 2019
In the world of relational databases, structured query language, or SQL, has long been King of the Queries, primarily because of its ubiquity and unparalleled performance. But many users prefer a mix of imperative programming, along with declarative SQL, because its user-defined functions (or UDFs) allow for good software engineering practices like modularity, readability and re-usability. Sadly, these benefits have traditionally come with a huge performance penalty, rendering them impractical in most situations. That bothered Dr. Karthik Ramachandra, a Senior Applied Scientist at Microsoft Research India, so he’s spent a great deal of his career working on improving an imperative complement to SQL in database systems.
Today, Dr. Ramachandra gives us an overview of the historic trade-offs between declarative and imperative programming paradigms, tells us some fantastic stories, including The Tale of Two Engineers and The UDF Story, Parts 1 and 2, and introduces us to Froid – that’s F-R-O-I-D, not the Austrian psychoanalyst – which is an extensible, language-agnostic framework for optimizing imperative functions in databases, offering the benefits of UDFs without sacrificing performance.
See more at microsoft.com/en-us/research/b...
In the world of relational databases, structured query language, or SQL, has long been King of the Queries, primarily because of its ubiquity and unparalleled performance. But many users prefer a mix of imperative programming, along with declarative SQL, because its user-defined functions (or UDFs) allow for good software engineering practices like modularity, readability and re-usability. Sadly, these benefits have traditionally come with a huge performance penalty, rendering them impractical in most situations. That bothered Dr. Karthik Ramachandra, a Senior Applied Scientist at Microsoft Research India, so he’s spent a great deal of his career working on improving an imperative complement to SQL in database systems.
Today, Dr. Ramachandra gives us an overview of the historic trade-offs between declarative and imperative programming paradigms, tells us some fantastic stories, including The Tale of Two Engineers and The UDF Story, Parts 1 and 2, and introduces us to Froid – that’s F-R-O-I-D, not the Austrian psychoanalyst – which is an extensible, language-agnostic framework for optimizing imperative functions in databases, offering the benefits of UDFs without sacrificing performance.
See more at microsoft.com/en-us/research/b...
Свежие видео
9 дней – 2 803 1150:57
11 дней – 7 9690:56
16 дней – 2 9101:18
19 дней – 2 4777:58
22 дня – 309 29811:10
23 дня – 2 8350:20Случайные видео
122 дня – 7 1070:07
308 дней – 16 2430:26
25.08.22 – 297 29311:58
19.07.22 – 10 6905:44
11.08.19 – 80 5001:24
15.08.09 – 207 8506:00
2 дня – 00:00
3 дня – 1 84152:20
3 дня – 8 81459:11
3 дня – 37 90620:39
5 дней – 4 159 9471:44
6 дней – 82 36220:58
8 дней – 505 6692:21:54
