Matches in SemOpenAlex for { <https://semopenalex.org/work/W2980897989> ?p ?o ?g. }
Showing items 1 to 79 of
79
with 100 items per page.
- W2980897989 abstract "In Teradata database, the transient journal (TJ) is a system-maintained log that provides a way to protect transactions from various system failures. Each transaction processed by the database records a before image of rows that are touched by the transaction. Then if a transaction fails for some reason, the before image of any modified rows can be retrieved from the transient journal and written over the modifications, returning the row to the same state it was in, before the transaction started. Teradata Database removes all before images from the transient journal after a transaction commits [1]. In addition, Teradata provides Load Isolation feature, a table isolation property (MVCC variant), that enables concurrent read of committed rows while the tables are being modified. To enable committed reads in concurrent sessions, rows that are being modified are logically deleted from load-isolated tables and new rows with the modified values are inserted when rows are updated. If a row is not yet committed, then the data that is read is the data that was true and final in the table prior to the subsequent data change [2].TJ maintenance is not an exception even for load-isolated tables in Teradata. TJ, though unavoidable, incurs extra costs to the system in the form of IO and CPU. Additionally the log needs to be purged periodically to cleanup records no longer needed causing additional overhead. This paper discusses an approach to avoid logging, with no compromise in data consistency, using Teradata Load Isolation, resulting in (a) significant improvement in the performance and transaction throughput, and (b) constant time (O(1)) transaction rollback, unlike the traditional approach(O(n)), where n is the number of rows." @default.
- W2980897989 created "2019-10-25" @default.
- W2980897989 creator A5007953212 @default.
- W2980897989 creator A5008217494 @default.
- W2980897989 creator A5046521793 @default.
- W2980897989 date "2019-02-01" @default.
- W2980897989 modified "2023-09-27" @default.
- W2980897989 title "Improving performance by avoiding transaction logging on Load Isolated tables in Teradata" @default.
- W2980897989 cites W2043934800 @default.
- W2980897989 cites W2101995353 @default.
- W2980897989 cites W2102729946 @default.
- W2980897989 cites W2104954161 @default.
- W2980897989 cites W2115600841 @default.
- W2980897989 cites W2118995439 @default.
- W2980897989 cites W2128841495 @default.
- W2980897989 cites W2134799464 @default.
- W2980897989 cites W2143268825 @default.
- W2980897989 cites W2145170453 @default.
- W2980897989 cites W2155070484 @default.
- W2980897989 doi "https://doi.org/10.1109/icecct.2019.8869119" @default.
- W2980897989 hasPublicationYear "2019" @default.
- W2980897989 type Work @default.
- W2980897989 sameAs 2980897989 @default.
- W2980897989 citedByCount "0" @default.
- W2980897989 crossrefType "proceedings-article" @default.
- W2980897989 hasAuthorship W2980897989A5007953212 @default.
- W2980897989 hasAuthorship W2980897989A5008217494 @default.
- W2980897989 hasAuthorship W2980897989A5046521793 @default.
- W2980897989 hasConcept C104140500 @default.
- W2980897989 hasConcept C111919701 @default.
- W2980897989 hasConcept C135598885 @default.
- W2980897989 hasConcept C154945302 @default.
- W2980897989 hasConcept C174220543 @default.
- W2980897989 hasConcept C188045909 @default.
- W2980897989 hasConcept C2212953 @default.
- W2980897989 hasConcept C2775941552 @default.
- W2980897989 hasConcept C2776436953 @default.
- W2980897989 hasConcept C2779960059 @default.
- W2980897989 hasConcept C41008148 @default.
- W2980897989 hasConcept C45235069 @default.
- W2980897989 hasConcept C72108876 @default.
- W2980897989 hasConcept C75949130 @default.
- W2980897989 hasConcept C77088390 @default.
- W2980897989 hasConcept C86803240 @default.
- W2980897989 hasConcept C89423630 @default.
- W2980897989 hasConceptScore W2980897989C104140500 @default.
- W2980897989 hasConceptScore W2980897989C111919701 @default.
- W2980897989 hasConceptScore W2980897989C135598885 @default.
- W2980897989 hasConceptScore W2980897989C154945302 @default.
- W2980897989 hasConceptScore W2980897989C174220543 @default.
- W2980897989 hasConceptScore W2980897989C188045909 @default.
- W2980897989 hasConceptScore W2980897989C2212953 @default.
- W2980897989 hasConceptScore W2980897989C2775941552 @default.
- W2980897989 hasConceptScore W2980897989C2776436953 @default.
- W2980897989 hasConceptScore W2980897989C2779960059 @default.
- W2980897989 hasConceptScore W2980897989C41008148 @default.
- W2980897989 hasConceptScore W2980897989C45235069 @default.
- W2980897989 hasConceptScore W2980897989C72108876 @default.
- W2980897989 hasConceptScore W2980897989C75949130 @default.
- W2980897989 hasConceptScore W2980897989C77088390 @default.
- W2980897989 hasConceptScore W2980897989C86803240 @default.
- W2980897989 hasConceptScore W2980897989C89423630 @default.
- W2980897989 hasLocation W29808979891 @default.
- W2980897989 hasOpenAccess W2980897989 @default.
- W2980897989 hasPrimaryLocation W29808979891 @default.
- W2980897989 hasRelatedWork W2055297179 @default.
- W2980897989 hasRelatedWork W2227450557 @default.
- W2980897989 hasRelatedWork W2337981573 @default.
- W2980897989 hasRelatedWork W2347434268 @default.
- W2980897989 hasRelatedWork W2393339731 @default.
- W2980897989 hasRelatedWork W2393779616 @default.
- W2980897989 hasRelatedWork W2913418831 @default.
- W2980897989 hasRelatedWork W2980897989 @default.
- W2980897989 hasRelatedWork W1730701659 @default.
- W2980897989 hasRelatedWork W2061097667 @default.
- W2980897989 isParatext "false" @default.
- W2980897989 isRetracted "false" @default.
- W2980897989 magId "2980897989" @default.
- W2980897989 workType "article" @default.