{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,17]],"date-time":"2026-03-17T18:32:11Z","timestamp":1773772331517,"version":"3.50.1"},"reference-count":31,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2019,8]]},"abstract":"<jats:p>Driven by the recent adoption of temporal expressions into SQL:2011, extensions of temporal support in conventional database management systems (a.b.a. DBMSs) have re-emerged as a research hotspot. In this paper, we present a lightweight yet efficient built-in temporal implementation in Tencent's distributed database management system, namely TDSQL. The novelty of TDSQL's temporal implementation includes: (1) a new temporal data model with the extension of SQL:2011, (2) a built-in temporal implementation with various optimizations, which are also applicable to other DBMSs, and (3) a low-storage-consumption in which only data changes are maintained. For the repeatability purpose, we elaborate the integration of our proposed techniques into MySQL. We conduct extensive experiments on both real-life dataset and synthetic TPC benchmarks by comparing TD-SQL with other temporal databases. The results show that TDSQL is lightweight and efficient.<\/jats:p>","DOI":"10.14778\/3352063.3352122","type":"journal-article","created":{"date-parts":[[2019,9,18]],"date-time":"2019-09-18T18:36:11Z","timestamp":1568831771000},"page":"2035-2046","source":"Crossref","is-referenced-by-count":17,"title":["A lightweight and efficient temporal database management system in TDSQL"],"prefix":"10.14778","volume":"12","author":[{"given":"Wei","family":"Lu","sequence":"first","affiliation":[{"name":"Renmin University of China, Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhanhao","family":"Zhao","sequence":"additional","affiliation":[{"name":"Renmin University of China, Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xiaoyu","family":"Wang","sequence":"additional","affiliation":[{"name":"Tencent Inc., China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Haixiang","family":"Li","sequence":"additional","affiliation":[{"name":"Tencent Inc., China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhenmiao","family":"Zhang","sequence":"additional","affiliation":[{"name":"Renmin University of China, Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhiyu","family":"Shui","sequence":"additional","affiliation":[{"name":"Renmin University of China, Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sheng","family":"Ye","sequence":"additional","affiliation":[{"name":"Tencent Inc., China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Anqun","family":"Pan","sequence":"additional","affiliation":[{"name":"Tencent Inc., China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xiaoyong","family":"Du","sequence":"additional","affiliation":[{"name":"Renmin University of China, Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2019,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"DB2. https:\/\/www.ibm.com\/analytics\/us\/en\/db2.  DB2. https:\/\/www.ibm.com\/analytics\/us\/en\/db2."},{"key":"e_1_2_1_2_1","unstructured":"Mariadb. https:\/\/mariadb.com\/kb\/en\/library\/system-versioned-tables\/.  Mariadb. https:\/\/mariadb.com\/kb\/en\/library\/system-versioned-tables\/."},{"key":"e_1_2_1_3_1","unstructured":"Oracle. https:\/\/www.oracle.com.  Oracle. https:\/\/www.oracle.com."},{"key":"e_1_2_1_4_1","unstructured":"PostgreSQL. https:\/\/www.postgresql.org.  PostgreSQL. https:\/\/www.postgresql.org."},{"key":"e_1_2_1_5_1","unstructured":"SQL Server. https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/temporal-tables.  SQL Server. https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/tables\/temporal-tables."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2452376.2452443"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223785"},{"key":"e_1_2_1_8_1","first-page":"437","volume-title":"Temporal Data Model and Query Language Concepts","author":"B\u00f6hlen M.","year":"2003"},{"key":"e_1_2_1_9_1","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"crossref","first-page":"96","DOI":"10.1007\/3-540-45393-8_8","volume-title":"ER","author":"Chen C. X.","year":"2000"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/210197.210200"},{"key":"e_1_2_1_11_1","first-page":"383","volume-title":"The TSQL2 Temporal Query Language","author":"Clifford J.","year":"1995"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.5555\/645475.654165"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/50202.50233"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/181550.181560"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/140979.140996"},{"key":"e_1_2_1_16_1","first-page":"367","volume-title":"Temporal Databases","author":"Jensen C. S.","year":"1997"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.755613"},{"key":"e_1_2_1_18_1","first-page":"451","volume-title":"VLDB","author":"Jiang L.","year":"2000"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113307"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-04936-6_2"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2380776.2380786"},{"key":"e_1_2_1_22_1","first-page":"235","volume-title":"Workshops in Computing","author":"Kumar A.","year":"1995"},{"key":"e_1_2_1_23_1","volume-title":"World Wide Web","author":"Li H.","year":"2018"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.162"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.599935"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367523"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223844"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/320473.320476"},{"key":"e_1_2_1_29_1","first-page":"431","volume-title":"PVLDB","author":"Tao Y.","year":"2001"},{"key":"e_1_2_1_30_1","first-page":"790","volume-title":"VLDB","author":"Tao Y.","year":"2003"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-005-0161-9"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3352063.3352122","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:41:31Z","timestamp":1672224091000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3352063.3352122"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,8]]},"references-count":31,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2019,8]]}},"alternative-id":["10.14778\/3352063.3352122"],"URL":"https:\/\/doi.org\/10.14778\/3352063.3352122","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2019,8]]}}}