Artwork

Вміст надано JACK WAUDBY. Весь вміст подкастів, включаючи епізоди, графіку та описи подкастів, завантажується та надається безпосередньо компанією JACK WAUDBY або його партнером по платформі подкастів. Якщо ви вважаєте, що хтось використовує ваш захищений авторським правом твір без вашого дозволу, ви можете виконати процедуру, описану тут https://uk.player.fm/legal.
Player FM - додаток Podcast
Переходьте в офлайн за допомогою програми Player FM !

Felix S Campbell | Efficient Answering of Historical What-if Queries | #2

19:21
 
Поширити
 

Архівні серії ("Канал неактуальний" status)

When? This feed was archived on October 13, 2022 19:36 (1+ y ago). Last successful fetch was on August 21, 2022 08:18 (1+ y ago)

Why? Канал неактуальний status. Нашим серверам не вдалося отримати доступ до каналу подкасту протягом тривалого періоду часу.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 337873978 series 3383877
Вміст надано JACK WAUDBY. Весь вміст подкастів, включаючи епізоди, графіку та описи подкастів, завантажується та надається безпосередньо компанією JACK WAUDBY або його партнером по платформі подкастів. Якщо ви вважаєте, що хтось використовує ваш захищений авторським правом твір без вашого дозволу, ви можете виконати процедуру, описану тут https://uk.player.fm/legal.

Summary:

In this interview Felix discusses "historical what-if queries", a novel type of what-if analysis that determines the effect of a hypothetical change to the transactional history of a database. For example, “how would revenue be affected if we would have charged an additional $6 for shipping?” In his research Felix has developed efficient techniques for answering these historical what-if queries, i.e., determining how a modified history affects the current database state. During the show, Felix talks about reenactment, a replay technique for transactional histories, and how he and his co-authors optimize this process using program and data slicing techniques to determine which updates and what data can be excluded from reenactment without affecting the result.

Questions:

0:42: Can you start off by explaining what are historical what-if queries?

1:56: What is the naive approach to answering these types of questions?

2:47: What are the problems with this naive approach and why is your solution better?

3:45: Tell us about reenactment, how does that work?

4:48: In your paper you mention two additional techniques, data slicing and program slicing, can you tell us more about these?

6:44: How does reenactment, data slicing and program slicing, compare to other techniques in the literature? Where does it improve on the pitfalls of those?

8:00: Are there any commercial DBMSs that provide similar functionality out of the box?

8:57: How did you go about evaluation your solution?

10:40: What are the parameters you varied in your evaluation?

14:11: Where do you see this research being most useful? Who can use this?

15:17: Are the code/toolkit publicly available?

16:15: What is the most interesting aspect of working on what-if queries and more generally in the area of data provenance?

17:36: What do you have planned for future research?


Links:

Contact Info:


Our GDPR privacy policy was updated on August 8, 2022. Visit acast.com/privacy for more information.

  continue reading

11 епізодів

Artwork
iconПоширити
 

Архівні серії ("Канал неактуальний" status)

When? This feed was archived on October 13, 2022 19:36 (1+ y ago). Last successful fetch was on August 21, 2022 08:18 (1+ y ago)

Why? Канал неактуальний status. Нашим серверам не вдалося отримати доступ до каналу подкасту протягом тривалого періоду часу.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 337873978 series 3383877
Вміст надано JACK WAUDBY. Весь вміст подкастів, включаючи епізоди, графіку та описи подкастів, завантажується та надається безпосередньо компанією JACK WAUDBY або його партнером по платформі подкастів. Якщо ви вважаєте, що хтось використовує ваш захищений авторським правом твір без вашого дозволу, ви можете виконати процедуру, описану тут https://uk.player.fm/legal.

Summary:

In this interview Felix discusses "historical what-if queries", a novel type of what-if analysis that determines the effect of a hypothetical change to the transactional history of a database. For example, “how would revenue be affected if we would have charged an additional $6 for shipping?” In his research Felix has developed efficient techniques for answering these historical what-if queries, i.e., determining how a modified history affects the current database state. During the show, Felix talks about reenactment, a replay technique for transactional histories, and how he and his co-authors optimize this process using program and data slicing techniques to determine which updates and what data can be excluded from reenactment without affecting the result.

Questions:

0:42: Can you start off by explaining what are historical what-if queries?

1:56: What is the naive approach to answering these types of questions?

2:47: What are the problems with this naive approach and why is your solution better?

3:45: Tell us about reenactment, how does that work?

4:48: In your paper you mention two additional techniques, data slicing and program slicing, can you tell us more about these?

6:44: How does reenactment, data slicing and program slicing, compare to other techniques in the literature? Where does it improve on the pitfalls of those?

8:00: Are there any commercial DBMSs that provide similar functionality out of the box?

8:57: How did you go about evaluation your solution?

10:40: What are the parameters you varied in your evaluation?

14:11: Where do you see this research being most useful? Who can use this?

15:17: Are the code/toolkit publicly available?

16:15: What is the most interesting aspect of working on what-if queries and more generally in the area of data provenance?

17:36: What do you have planned for future research?


Links:

Contact Info:


Our GDPR privacy policy was updated on August 8, 2022. Visit acast.com/privacy for more information.

  continue reading

11 епізодів

Усі епізоди

×
 
Loading …

Ласкаво просимо до Player FM!

Player FM сканує Інтернет для отримання високоякісних подкастів, щоб ви могли насолоджуватися ними зараз. Це найкращий додаток для подкастів, який працює на Android, iPhone і веб-сторінці. Реєстрація для синхронізації підписок між пристроями.

 

Короткий довідник