Matches in SemOpenAlex for { <https://semopenalex.org/work/W3086717878> ?p ?o ?g. }
Showing items 1 to 92 of
92
with 100 items per page.
- W3086717878 endingPage "3203" @default.
- W3086717878 startingPage "3195" @default.
- W3086717878 abstract "Database systems based on ARIES [11] protocol rely on Write Ahead Logging (WAL) to recover the database in the event of a crash. WAL protocol requires changes to the database are recorded to the transaction log before updating the underlying database page. WAL also mandates that the log record corresponding to the change is persisted to disk before the updated page. While WAL allows updates to the databases using in-place updates or using shadow paging, database systems that perform in-place updates typically latch the page exclusively for the entire duration of log generation and the change on the page. The exclusive latch on the page prevents other threads from modifying the page at the same time, reducing the concurrency, and negatively impacting the throughput of the system. While approaches like Segment-Based recovery [16] attempt to solve the contention by pushing the burden of synchronization to the application along with a proposal for recovering parts of pages, this paper takes a different approach by providing a mechanism to support concurrent updates to certain kinds of pages under a shared latch using lock-free algorithms. The pages are recovered using existing ARIES protocol with a few modifications. This approach significantly boosts the throughput of an ARIES based database system, without any application changes. The paper describes in detail the challenges of implementing the mechanism and how the ARIES concepts like page LSN, logging and checkpoint are handled to support concurrent updates on space maintenance pages in Microsoft SQL Server. The paper also presents the experimental results showcasing the impact of the work." @default.
- W3086717878 created "2020-09-21" @default.
- W3086717878 creator A5072691393 @default.
- W3086717878 creator A5082786431 @default.
- W3086717878 creator A5083145336 @default.
- W3086717878 date "2020-08-01" @default.
- W3086717878 modified "2023-09-27" @default.
- W3086717878 title "Concurrent updates to pages with fixed-size rows using lock-free algorithms" @default.
- W3086717878 cites W2007044900 @default.
- W3086717878 cites W2031844067 @default.
- W3086717878 cites W2104954161 @default.
- W3086717878 cites W2116436709 @default.
- W3086717878 cites W2948526913 @default.
- W3086717878 cites W2999454777 @default.
- W3086717878 cites W4241687679 @default.
- W3086717878 doi "https://doi.org/10.14778/3415478.3415544" @default.
- W3086717878 hasPublicationYear "2020" @default.
- W3086717878 type Work @default.
- W3086717878 sameAs 3086717878 @default.
- W3086717878 citedByCount "1" @default.
- W3086717878 countsByYear W30867178782022 @default.
- W3086717878 crossrefType "journal-article" @default.
- W3086717878 hasAuthorship W3086717878A5072691393 @default.
- W3086717878 hasAuthorship W3086717878A5082786431 @default.
- W3086717878 hasAuthorship W3086717878A5083145336 @default.
- W3086717878 hasConcept C111919701 @default.
- W3086717878 hasConcept C127413603 @default.
- W3086717878 hasConcept C135598885 @default.
- W3086717878 hasConcept C136085584 @default.
- W3086717878 hasConcept C142724271 @default.
- W3086717878 hasConcept C157764524 @default.
- W3086717878 hasConcept C173608175 @default.
- W3086717878 hasConcept C174220543 @default.
- W3086717878 hasConcept C174839445 @default.
- W3086717878 hasConcept C176649486 @default.
- W3086717878 hasConcept C188873839 @default.
- W3086717878 hasConcept C193702766 @default.
- W3086717878 hasConcept C204787440 @default.
- W3086717878 hasConcept C2780385302 @default.
- W3086717878 hasConcept C33925742 @default.
- W3086717878 hasConcept C41008148 @default.
- W3086717878 hasConcept C555944384 @default.
- W3086717878 hasConcept C71924100 @default.
- W3086717878 hasConcept C75949130 @default.
- W3086717878 hasConcept C76399640 @default.
- W3086717878 hasConcept C77088390 @default.
- W3086717878 hasConcept C78519656 @default.
- W3086717878 hasConcept C84511453 @default.
- W3086717878 hasConceptScore W3086717878C111919701 @default.
- W3086717878 hasConceptScore W3086717878C127413603 @default.
- W3086717878 hasConceptScore W3086717878C135598885 @default.
- W3086717878 hasConceptScore W3086717878C136085584 @default.
- W3086717878 hasConceptScore W3086717878C142724271 @default.
- W3086717878 hasConceptScore W3086717878C157764524 @default.
- W3086717878 hasConceptScore W3086717878C173608175 @default.
- W3086717878 hasConceptScore W3086717878C174220543 @default.
- W3086717878 hasConceptScore W3086717878C174839445 @default.
- W3086717878 hasConceptScore W3086717878C176649486 @default.
- W3086717878 hasConceptScore W3086717878C188873839 @default.
- W3086717878 hasConceptScore W3086717878C193702766 @default.
- W3086717878 hasConceptScore W3086717878C204787440 @default.
- W3086717878 hasConceptScore W3086717878C2780385302 @default.
- W3086717878 hasConceptScore W3086717878C33925742 @default.
- W3086717878 hasConceptScore W3086717878C41008148 @default.
- W3086717878 hasConceptScore W3086717878C555944384 @default.
- W3086717878 hasConceptScore W3086717878C71924100 @default.
- W3086717878 hasConceptScore W3086717878C75949130 @default.
- W3086717878 hasConceptScore W3086717878C76399640 @default.
- W3086717878 hasConceptScore W3086717878C77088390 @default.
- W3086717878 hasConceptScore W3086717878C78519656 @default.
- W3086717878 hasConceptScore W3086717878C84511453 @default.
- W3086717878 hasIssue "12" @default.
- W3086717878 hasLocation W30867178781 @default.
- W3086717878 hasOpenAccess W3086717878 @default.
- W3086717878 hasPrimaryLocation W30867178781 @default.
- W3086717878 hasRelatedWork W1981207589 @default.
- W3086717878 hasRelatedWork W2005109102 @default.
- W3086717878 hasRelatedWork W2109396167 @default.
- W3086717878 hasRelatedWork W2176888493 @default.
- W3086717878 hasRelatedWork W2371976517 @default.
- W3086717878 hasRelatedWork W2383574505 @default.
- W3086717878 hasRelatedWork W3086717878 @default.
- W3086717878 hasRelatedWork W32928112 @default.
- W3086717878 hasRelatedWork W2184111589 @default.
- W3086717878 hasRelatedWork W429603606 @default.
- W3086717878 hasVolume "13" @default.
- W3086717878 isParatext "false" @default.
- W3086717878 isRetracted "false" @default.
- W3086717878 magId "3086717878" @default.
- W3086717878 workType "article" @default.