Polypheny-DB: Towards Bridging the Gap Between Polystores and HTAP Systems

Vogt, Marco; Hansen, Nils; Schönholz, Jan; Lengweiler, David; Geissmann, Isabel; Philipp, Sebastian; Stiemer, Alexander; Schuldt, Heiko

doi:10.1007/978-3-030-71055-2_2

Cited by 3 publications

(1 citation statement)

References 13 publications

(16 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The main competing approach for transactional isolation in polystores is Polypheny-DB [32]. In contrast to our proposal, which aims at running readonly transactions with little interference and at fine-grained conflict resolution for update transactions, Polypheny-DB assumes two-phase locking with coarse granularity, which limits concurrent updates and makes them conflict with readonly transactions.…”

Section: Discussionmentioning

confidence: 99%

Towards Generic Fine-Grained Transaction Isolation in Polystores

Faria

Pereira

Alonso

et al. 2021

Heterogeneous Data Management, Polystores, and Analytics for Healthcare

View full text Add to dashboard Cite

Transactional isolation is a challenge for polystores, as along with the limited capabilities of each datastore, we have to contend with their sheer diversity. However, transactional isolation is increasingly desirable as a variety of datastores are being sought after for roles that go beyond simple data lakes, where information is mostly static. Transactional guarantees are also relevant for reliability at scale. Finally, it would also close the gap to what is available in multi-model database systems. In this paper, we propose that transactional isolation in polystores can be achieved by leveraging the query engine, i.e., we implement some of the responsibilities of a transactional storage manager (TSM) in the query language itself. This has the key advantage of greatly simplifying design and implementation, as it doesn't need to be re-invented for each datastore, and should increase performance, by taking advantage of dynamic query optimization where available. We demonstrate the feasibility of the proposal with a simple proof-of-concept and experiment.

show abstract

Section: Discussionmentioning

confidence: 99%