T-SQL: A Lightweight Implementation to Enable Built-in Temporal Support in MVCC-based RDBMSs
| Autor: | Haixiang Li, Anqun Pan, Wei Lu, Xiaoyong Du, Zongyan He, Zhao Zhanhao, Hongyao Zhao |
|---|---|
| Rok vydání: | 2021 |
| Předmět: |
SQL
Database Computer science InformationSystems_DATABASEMANAGEMENT computer.software_genre Temporal expressions Computer Science Applications Temporal database Concurrency control Computational Theory and Mathematics Relational database management system Overhead (computing) computer Historical record Information Systems computer.programming_language |
| Zdroj: | IEEE Transactions on Knowledge and Data Engineering. :1-1 |
| ISSN: | 2326-3865 1041-4347 |
| DOI: | 10.1109/tkde.2021.3081717 |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|