Matches in SemOpenAlex for { <https://semopenalex.org/work/W2754332001> ?p ?o ?g. }
Showing items 1 to 97 of
97
with 100 items per page.
- W2754332001 abstract "Efficient transaction management is a delicate task. As systems face transactions of inherently different types, ranging from point updates to long-running analytical queries, it is hard to satisfy their requirements with a single execution engine. Unfortunately, most systems rely on such a design that implements its parallelism using multi-version concurrency control. While MVCC parallelizes short-running OLTP transactions well, it struggles in the presence of mixed workloads containing long-running OLAP queries, as scans have to work their way through vast amounts of versioned data. To overcome this problem, we reintroduce the concept of hybrid processing and combine it with state-of-the-art MVCC: OLAP queries are outsourced to run on separate virtual snapshots while OLTP transactions run on the most recent version of the database. Inside both execution engines, we still apply MVCC. The most significant challenge of a hybrid approach is to generate the snapshots at a high frequency. Previous approaches heavily suffered from the high cost of snapshot creation. In our approach termed AnKer, we follow the current trend of co-designing underlying system components and the DBMS, to overcome the restrictions of the OS by introducing a custom system call vm_snapshot. It allows fine-granular snapshot creation that is orders of magnitudes faster than state-of-the-art approaches. Our experimental evaluation on an HTAP workload based on TPC-C transactions and OLAP queries show that our snapshotting mechanism is more than a factor of 100x faster than fork-based snapshotting and that the latency of OLAP queries is up to a factor of 4x lower than MVCC in a single execution engine. Besides, our approach enables a higher OLTP throughput than all state-of-the-art methods." @default.
- W2754332001 created "2017-09-25" @default.
- W2754332001 creator A5005397258 @default.
- W2754332001 creator A5061361602 @default.
- W2754332001 creator A5091334588 @default.
- W2754332001 date "2018-05-27" @default.
- W2754332001 modified "2023-10-11" @default.
- W2754332001 title "Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting" @default.
- W2754332001 cites W1968658954 @default.
- W2754332001 cites W1969877208 @default.
- W2754332001 cites W2004736736 @default.
- W2754332001 cites W2011395086 @default.
- W2754332001 cites W2014977566 @default.
- W2754332001 cites W2020129682 @default.
- W2754332001 cites W2054644843 @default.
- W2754332001 cites W2102729946 @default.
- W2754332001 cites W2139285682 @default.
- W2754332001 cites W2141710443 @default.
- W2754332001 cites W2394555589 @default.
- W2754332001 cites W2415432569 @default.
- W2754332001 cites W2423891596 @default.
- W2754332001 cites W2479391614 @default.
- W2754332001 cites W2571118757 @default.
- W2754332001 cites W2604961016 @default.
- W2754332001 cites W2908464978 @default.
- W2754332001 cites W3123420770 @default.
- W2754332001 doi "https://doi.org/10.1145/3183713.3196904" @default.
- W2754332001 hasPublicationYear "2018" @default.
- W2754332001 type Work @default.
- W2754332001 sameAs 2754332001 @default.
- W2754332001 citedByCount "15" @default.
- W2754332001 countsByYear W27543320012018 @default.
- W2754332001 countsByYear W27543320012019 @default.
- W2754332001 countsByYear W27543320012020 @default.
- W2754332001 countsByYear W27543320012021 @default.
- W2754332001 countsByYear W27543320012022 @default.
- W2754332001 crossrefType "proceedings-article" @default.
- W2754332001 hasAuthorship W2754332001A5005397258 @default.
- W2754332001 hasAuthorship W2754332001A5061361602 @default.
- W2754332001 hasAuthorship W2754332001A5091334588 @default.
- W2754332001 hasBestOaLocation W27543320011 @default.
- W2754332001 hasConcept C111919701 @default.
- W2754332001 hasConcept C120314980 @default.
- W2754332001 hasConcept C135572916 @default.
- W2754332001 hasConcept C173608175 @default.
- W2754332001 hasConcept C174220543 @default.
- W2754332001 hasConcept C191087605 @default.
- W2754332001 hasConcept C201932085 @default.
- W2754332001 hasConcept C2778476105 @default.
- W2754332001 hasConcept C41008148 @default.
- W2754332001 hasConcept C55282118 @default.
- W2754332001 hasConcept C72108876 @default.
- W2754332001 hasConcept C75949130 @default.
- W2754332001 hasConcept C77088390 @default.
- W2754332001 hasConcept C84511453 @default.
- W2754332001 hasConceptScore W2754332001C111919701 @default.
- W2754332001 hasConceptScore W2754332001C120314980 @default.
- W2754332001 hasConceptScore W2754332001C135572916 @default.
- W2754332001 hasConceptScore W2754332001C173608175 @default.
- W2754332001 hasConceptScore W2754332001C174220543 @default.
- W2754332001 hasConceptScore W2754332001C191087605 @default.
- W2754332001 hasConceptScore W2754332001C201932085 @default.
- W2754332001 hasConceptScore W2754332001C2778476105 @default.
- W2754332001 hasConceptScore W2754332001C41008148 @default.
- W2754332001 hasConceptScore W2754332001C55282118 @default.
- W2754332001 hasConceptScore W2754332001C72108876 @default.
- W2754332001 hasConceptScore W2754332001C75949130 @default.
- W2754332001 hasConceptScore W2754332001C77088390 @default.
- W2754332001 hasConceptScore W2754332001C84511453 @default.
- W2754332001 hasLocation W27543320011 @default.
- W2754332001 hasLocation W27543320012 @default.
- W2754332001 hasOpenAccess W2754332001 @default.
- W2754332001 hasPrimaryLocation W27543320011 @default.
- W2754332001 hasRelatedWork W1985229168 @default.
- W2754332001 hasRelatedWork W2011395086 @default.
- W2754332001 hasRelatedWork W2014977566 @default.
- W2754332001 hasRelatedWork W2020129682 @default.
- W2754332001 hasRelatedWork W2102729946 @default.
- W2754332001 hasRelatedWork W2188262136 @default.
- W2754332001 hasRelatedWork W2394555589 @default.
- W2754332001 hasRelatedWork W2399004477 @default.
- W2754332001 hasRelatedWork W2400366270 @default.
- W2754332001 hasRelatedWork W2613970404 @default.
- W2754332001 hasRelatedWork W2753767407 @default.
- W2754332001 hasRelatedWork W2767559763 @default.
- W2754332001 hasRelatedWork W2800321615 @default.
- W2754332001 hasRelatedWork W2804682780 @default.
- W2754332001 hasRelatedWork W2942351344 @default.
- W2754332001 hasRelatedWork W2951310630 @default.
- W2754332001 hasRelatedWork W2961730385 @default.
- W2754332001 hasRelatedWork W2982604121 @default.
- W2754332001 hasRelatedWork W30166824 @default.
- W2754332001 hasRelatedWork W3136342420 @default.
- W2754332001 isParatext "false" @default.
- W2754332001 isRetracted "false" @default.
- W2754332001 magId "2754332001" @default.
- W2754332001 workType "article" @default.