Incremental Relational Lenses

07/05/2018
by   Rudi Horn, et al.
0

Lenses are a popular approach to bidirectional transformations, a generalisation of the view update problem in databases, in which we wish to make changes to source tables to effect a desired change on a view. However, perhaps surprisingly, lenses have seldom actually been used to implement updatable views in databases. Bohannon, Pierce and Vaughan proposed an approach to updatable views called relational lenses, but to the best of our knowledge this proposal has not been implemented or evaluated to date. We propose incremental relational lenses, that equip relational lenses with change-propagating semantics that map small changes to the view to (potentially) small changes to the source tables. We also present a language-integrated implementation of relational lenses and a detailed experimental evaluation, showing orders of magnitude improvement over the non-incremental approach. Our work shows that relational lenses can be used to support expressive and efficient view updates at the language level, without relying on updatable view support from the underlying database.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
10/27/2022

Re-looking at the View Update Problem

Relational databases have always had a means for creating a pseudo-table...
research
03/04/2020

Language-Integrated Updatable Views (Extended version)

Relational lenses are a modern approach to the view update problem in re...
research
03/15/2023

F-IVM: Analytics over Relational Databases under Updates

This article describes F-IVM, a unified approach for maintaining analyti...
research
11/14/2019

Programmable View Update Strategies on Relations

View update is an important mechanism that allows updates on a view by t...
research
05/21/2012

The View-Update Problem for Indefinite Databases

This paper introduces and studies a declarative framework for updating v...
research
05/11/2010

Scalable Probabilistic Databases with Factor Graphs and MCMC

Probabilistic databases play a crucial role in the management and unders...
research
11/10/2017

Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example

While many applications export data in hierarchical formats like XML and...

Please sign up or login with your details

Forgot password? Click here to reset