Matches in SemOpenAlex for { <https://semopenalex.org/work/W3163263123> ?p ?o ?g. }
Showing items 1 to 96 of
96
with 100 items per page.
- W3163263123 endingPage "1" @default.
- W3163263123 startingPage "1" @default.
- W3163263123 abstract "The adoption of temporal expressions into SQL:2011 has continuously driven the extensions of temporal support in relational database systems (a.b.a. RDBMSs). In this paper, we present T-SQL, a lightweight yet efficient built-in temporal implementation in RDBMSs. T-SQL completely relies on multi-version concurrency control (MVCC) which is widely adopted in RDMBSs to manage temporal data. For temporal data, current records are maintained in legacy databases, and historical records, i.e., previoius versions of current records (if any), which used to be periodically reclaimed are separately maintained in KV stores. To enable temporal query processing under SQL:2011, we extend the query engine in legacy RDBMSs to support query processing over either historical records or current records or both. Further, regarding temporal data are ever-increasing, we propose various optimizations to reduce the storage overhead of KV stores while keeping efficient query performance. We elaborate on a publicly available implementation, on how to integrate T-SQL into both centralized and distributed RDBMSs. We conduct extensive experiments on both YCSB and TPC-series benchmarks by comparing T-SQL with other temporal database systems. The results show that T-SQL is both lightweight and efficient." @default.
- W3163263123 created "2021-05-24" @default.
- W3163263123 creator A5001037413 @default.
- W3163263123 creator A5005529387 @default.
- W3163263123 creator A5008721449 @default.
- W3163263123 creator A5030757374 @default.
- W3163263123 creator A5051686057 @default.
- W3163263123 creator A5066862989 @default.
- W3163263123 creator A5070589472 @default.
- W3163263123 date "2021-01-01" @default.
- W3163263123 modified "2023-09-26" @default.
- W3163263123 title "T-SQL: A Lightweight Implementation to Enable Built-in Temporal Support in MVCC-based RDBMSs" @default.
- W3163263123 cites W1502318375 @default.
- W3163263123 cites W1592532873 @default.
- W3163263123 cites W1594809416 @default.
- W3163263123 cites W1971864291 @default.
- W3163263123 cites W1978006057 @default.
- W3163263123 cites W1985229168 @default.
- W3163263123 cites W2000616942 @default.
- W3163263123 cites W2025315843 @default.
- W3163263123 cites W2064311651 @default.
- W3163263123 cites W2068739275 @default.
- W3163263123 cites W2083150957 @default.
- W3163263123 cites W2098489450 @default.
- W3163263123 cites W2116470353 @default.
- W3163263123 cites W2117917070 @default.
- W3163263123 cites W2133384222 @default.
- W3163263123 cites W2139285682 @default.
- W3163263123 cites W2147270837 @default.
- W3163263123 cites W2149833616 @default.
- W3163263123 cites W2167350691 @default.
- W3163263123 cites W2169057819 @default.
- W3163263123 cites W2764131694 @default.
- W3163263123 cites W2797419690 @default.
- W3163263123 cites W2798441769 @default.
- W3163263123 cites W2889275874 @default.
- W3163263123 cites W2970727055 @default.
- W3163263123 cites W3021797001 @default.
- W3163263123 cites W4234497300 @default.
- W3163263123 cites W4245278602 @default.
- W3163263123 doi "https://doi.org/10.1109/tkde.2021.3081717" @default.
- W3163263123 hasPublicationYear "2021" @default.
- W3163263123 type Work @default.
- W3163263123 sameAs 3163263123 @default.
- W3163263123 citedByCount "1" @default.
- W3163263123 countsByYear W31632631232023 @default.
- W3163263123 crossrefType "journal-article" @default.
- W3163263123 hasAuthorship W3163263123A5001037413 @default.
- W3163263123 hasAuthorship W3163263123A5005529387 @default.
- W3163263123 hasAuthorship W3163263123A5008721449 @default.
- W3163263123 hasAuthorship W3163263123A5030757374 @default.
- W3163263123 hasAuthorship W3163263123A5051686057 @default.
- W3163263123 hasAuthorship W3163263123A5066862989 @default.
- W3163263123 hasAuthorship W3163263123A5070589472 @default.
- W3163263123 hasConcept C154420247 @default.
- W3163263123 hasConcept C164120249 @default.
- W3163263123 hasConcept C194222762 @default.
- W3163263123 hasConcept C199360897 @default.
- W3163263123 hasConcept C23123220 @default.
- W3163263123 hasConcept C2779960059 @default.
- W3163263123 hasConcept C41008148 @default.
- W3163263123 hasConcept C510870499 @default.
- W3163263123 hasConcept C77088390 @default.
- W3163263123 hasConcept C77277458 @default.
- W3163263123 hasConcept C97854310 @default.
- W3163263123 hasConceptScore W3163263123C154420247 @default.
- W3163263123 hasConceptScore W3163263123C164120249 @default.
- W3163263123 hasConceptScore W3163263123C194222762 @default.
- W3163263123 hasConceptScore W3163263123C199360897 @default.
- W3163263123 hasConceptScore W3163263123C23123220 @default.
- W3163263123 hasConceptScore W3163263123C2779960059 @default.
- W3163263123 hasConceptScore W3163263123C41008148 @default.
- W3163263123 hasConceptScore W3163263123C510870499 @default.
- W3163263123 hasConceptScore W3163263123C77088390 @default.
- W3163263123 hasConceptScore W3163263123C77277458 @default.
- W3163263123 hasConceptScore W3163263123C97854310 @default.
- W3163263123 hasFunder F4320321001 @default.
- W3163263123 hasLocation W31632631231 @default.
- W3163263123 hasOpenAccess W3163263123 @default.
- W3163263123 hasPrimaryLocation W31632631231 @default.
- W3163263123 hasRelatedWork W1505413869 @default.
- W3163263123 hasRelatedWork W1538798823 @default.
- W3163263123 hasRelatedWork W1598481744 @default.
- W3163263123 hasRelatedWork W1725587203 @default.
- W3163263123 hasRelatedWork W1964555030 @default.
- W3163263123 hasRelatedWork W2356335648 @default.
- W3163263123 hasRelatedWork W2367232817 @default.
- W3163263123 hasRelatedWork W2368836186 @default.
- W3163263123 hasRelatedWork W2463360381 @default.
- W3163263123 hasRelatedWork W2096082947 @default.
- W3163263123 isParatext "false" @default.
- W3163263123 isRetracted "false" @default.
- W3163263123 magId "3163263123" @default.
- W3163263123 workType "article" @default.