Matches in SemOpenAlex for { <https://semopenalex.org/work/W3144778742> ?p ?o ?g. }
- W3144778742 endingPage "665" @default.
- W3144778742 startingPage "641" @default.
- W3144778742 abstract "Abstract Micro-architectural behavior of traditional disk-based online transaction processing (OLTP) systems has been investigated extensively over the past couple of decades. Results show that traditional OLTP systems mostly under-utilize the available micro-architectural resources. In-memory OLTP systems, on the other hand, process all the data in main-memory and, therefore, can omit the buffer pool. Furthermore, they usually adopt more lightweight concurrency control mechanisms, cache-conscious data structures, and cleaner codebases since they are usually designed from scratch. Hence, we expect significant differences in micro-architectural behavior when running OLTP on platforms optimized for in-memory processing as opposed to disk-based database systems. In particular, we expect that in-memory systems exploit micro-architectural features such as instruction and data caches significantly better than disk-based systems. This paper sheds light on the micro-architectural behavior of in-memory database systems by analyzing and contrasting it to the behavior of disk-based systems when running OLTP workloads. The results show that, despite all the design changes, in-memory OLTP exhibits very similar micro-architectural behavior to disk-based OLTP: more than half of the execution time goes to memory stalls where instruction cache misses or the long-latency data misses from the last-level cache (LLC) are the dominant factors in the overall execution time. Even though ground-up designed in-memory systems can eliminate the instruction cache misses, the reduction in instruction stalls amplifies the impact of LLC data misses. As a result, only 30% of the CPU cycles are used to retire instructions, and 70% of the CPU cycles are wasted to stalls for both traditional disk-based and new generation in-memory OLTP." @default.
- W3144778742 created "2021-04-13" @default.
- W3144778742 creator A5003350392 @default.
- W3144778742 creator A5034234312 @default.
- W3144778742 creator A5046034599 @default.
- W3144778742 creator A5061990490 @default.
- W3144778742 creator A5070907021 @default.
- W3144778742 date "2021-03-31" @default.
- W3144778742 modified "2023-10-10" @default.
- W3144778742 title "Micro-architectural analysis of in-memory OLTP: Revisited" @default.
- W3144778742 cites W1955594754 @default.
- W3144778742 cites W1963674762 @default.
- W3144778742 cites W1982752205 @default.
- W3144778742 cites W2008441771 @default.
- W3144778742 cites W2013062050 @default.
- W3144778742 cites W2014977566 @default.
- W3144778742 cites W2020129682 @default.
- W3144778742 cites W2050078636 @default.
- W3144778742 cites W2054075931 @default.
- W3144778742 cites W2067354926 @default.
- W3144778742 cites W2106771621 @default.
- W3144778742 cites W2126603366 @default.
- W3144778742 cites W2135232880 @default.
- W3144778742 cites W2141710443 @default.
- W3144778742 cites W2165663045 @default.
- W3144778742 cites W2170952599 @default.
- W3144778742 cites W2272535669 @default.
- W3144778742 cites W2290349115 @default.
- W3144778742 cites W2435606122 @default.
- W3144778742 cites W2495124393 @default.
- W3144778742 cites W2561036834 @default.
- W3144778742 cites W2610776462 @default.
- W3144778742 cites W2612080955 @default.
- W3144778742 cites W2612473142 @default.
- W3144778742 cites W2763683179 @default.
- W3144778742 cites W2889144945 @default.
- W3144778742 cites W2903881938 @default.
- W3144778742 cites W2907714110 @default.
- W3144778742 cites W2908321983 @default.
- W3144778742 cites W2949157610 @default.
- W3144778742 cites W2951202371 @default.
- W3144778742 cites W2962771342 @default.
- W3144778742 cites W2996353500 @default.
- W3144778742 cites W2997451313 @default.
- W3144778742 cites W3011145936 @default.
- W3144778742 cites W3103567827 @default.
- W3144778742 cites W4230886184 @default.
- W3144778742 cites W4238420657 @default.
- W3144778742 cites W4239323686 @default.
- W3144778742 cites W4256143806 @default.
- W3144778742 doi "https://doi.org/10.1007/s00778-021-00663-8" @default.
- W3144778742 hasPublicationYear "2021" @default.
- W3144778742 type Work @default.
- W3144778742 sameAs 3144778742 @default.
- W3144778742 citedByCount "1" @default.
- W3144778742 countsByYear W31447787422022 @default.
- W3144778742 crossrefType "journal-article" @default.
- W3144778742 hasAuthorship W3144778742A5003350392 @default.
- W3144778742 hasAuthorship W3144778742A5034234312 @default.
- W3144778742 hasAuthorship W3144778742A5046034599 @default.
- W3144778742 hasAuthorship W3144778742A5061990490 @default.
- W3144778742 hasAuthorship W3144778742A5070907021 @default.
- W3144778742 hasBestOaLocation W31447787421 @default.
- W3144778742 hasConcept C111919701 @default.
- W3144778742 hasConcept C115537543 @default.
- W3144778742 hasConcept C135572916 @default.
- W3144778742 hasConcept C149635348 @default.
- W3144778742 hasConcept C173608175 @default.
- W3144778742 hasConcept C191087605 @default.
- W3144778742 hasConcept C201932085 @default.
- W3144778742 hasConcept C41008148 @default.
- W3144778742 hasConcept C72108876 @default.
- W3144778742 hasConcept C75949130 @default.
- W3144778742 hasConcept C77088390 @default.
- W3144778742 hasConceptScore W3144778742C111919701 @default.
- W3144778742 hasConceptScore W3144778742C115537543 @default.
- W3144778742 hasConceptScore W3144778742C135572916 @default.
- W3144778742 hasConceptScore W3144778742C149635348 @default.
- W3144778742 hasConceptScore W3144778742C173608175 @default.
- W3144778742 hasConceptScore W3144778742C191087605 @default.
- W3144778742 hasConceptScore W3144778742C201932085 @default.
- W3144778742 hasConceptScore W3144778742C41008148 @default.
- W3144778742 hasConceptScore W3144778742C72108876 @default.
- W3144778742 hasConceptScore W3144778742C75949130 @default.
- W3144778742 hasConceptScore W3144778742C77088390 @default.
- W3144778742 hasIssue "4" @default.
- W3144778742 hasLocation W31447787421 @default.
- W3144778742 hasLocation W31447787422 @default.
- W3144778742 hasOpenAccess W3144778742 @default.
- W3144778742 hasPrimaryLocation W31447787421 @default.
- W3144778742 hasRelatedWork W1483843129 @default.
- W3144778742 hasRelatedWork W1488820732 @default.
- W3144778742 hasRelatedWork W2025089946 @default.
- W3144778742 hasRelatedWork W2354954952 @default.
- W3144778742 hasRelatedWork W2359159405 @default.
- W3144778742 hasRelatedWork W2373858521 @default.
- W3144778742 hasRelatedWork W2950632735 @default.
- W3144778742 hasRelatedWork W3037902925 @default.