{"id":"https://openalex.org/W3163263123","doi":"https://doi.org/10.1109/tkde.2021.3081717","title":"T-SQL: A Lightweight Implementation to Enable Built-in Temporal Support in MVCC-based RDBMSs","display_name":"T-SQL: A Lightweight Implementation to Enable Built-in Temporal Support in MVCC-based RDBMSs","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3163263123","doi":"https://doi.org/10.1109/tkde.2021.3081717","mag":"3163263123"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2021.3081717","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2021.3081717","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5066862989","display_name":"Zhanhao Zhao","orcid":"https://orcid.org/0000-0002-4044-7742"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhanhao Zhao","raw_affiliation_strings":["School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: zhanhaozhao@ruc.edu.cn)","[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: zhanhaozhao@ruc.edu.cn)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: zhanhaozhao@ruc.edu.cn)","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: zhanhaozhao@ruc.edu.cn)]","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005529387","display_name":"Wei L\u00fc","orcid":"https://orcid.org/0000-0001-6769-2695"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Lu","raw_affiliation_strings":["Computer Science, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: lu-wei@ruc.edu.cn)","[Computer Science, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: lu-wei@ruc.edu.cn)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: lu-wei@ruc.edu.cn)","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"[Computer Science, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: lu-wei@ruc.edu.cn)]","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051686057","display_name":"Hongyao Zhao","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hongyao Zhao","raw_affiliation_strings":["School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hongyaozhao@ruc.edu.cn)","[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hongyaozhao@ruc.edu.cn)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hongyaozhao@ruc.edu.cn)","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hongyaozhao@ruc.edu.cn)]","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111733992","display_name":"Zongyan He","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zongyan He","raw_affiliation_strings":["School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hzy9819@ruc.edu.cn)","[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hzy9819@ruc.edu.cn)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hzy9819@ruc.edu.cn)","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: hzy9819@ruc.edu.cn)]","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101608037","display_name":"Haixiang Li","orcid":"https://orcid.org/0009-0004-7562-339X"},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haixiang Li","raw_affiliation_strings":["TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: blueseali@tencent.com)","[TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: blueseali@tencent.com)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: blueseali@tencent.com)","institution_ids":["https://openalex.org/I2250653659"]},{"raw_affiliation_string":"[TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: blueseali@tencent.com)]","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001037413","display_name":"Anqun Pan","orcid":"https://orcid.org/0000-0002-6756-149X"},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Anqun Pan","raw_affiliation_strings":["TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: aaronpan@tencent.com)","[TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: aaronpan@tencent.com)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: aaronpan@tencent.com)","institution_ids":["https://openalex.org/I2250653659"]},{"raw_affiliation_string":"[TEG, Tencent, 508929 Shenzhen, Guangdong, China, (e-mail: aaronpan@tencent.com)]","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008721449","display_name":"Xiaoyong Du","orcid":"https://orcid.org/0000-0002-5757-9135"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoyong Du","raw_affiliation_strings":["School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: duyong@ruc.edu.cn)","[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: duyong@ruc.edu.cn)]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: duyong@ruc.edu.cn)","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"[School of Information, Renmin University of China, 12471 Beijing, Beijing, China, (e-mail: duyong@ruc.edu.cn)]","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.443,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.82542704,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"1"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9402040243148804},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7400203943252563},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5453680157661438},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5318719148635864},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5187323689460754},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.5135117173194885},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5065778493881226},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.23260128498077393},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.13558220863342285},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.07948705554008484},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07317087054252625}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9402040243148804},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7400203943252563},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5453680157661438},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5318719148635864},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5187323689460754},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.5135117173194885},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5065778493881226},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.23260128498077393},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.13558220863342285},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07948705554008484},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07317087054252625}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2021.3081717","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2021.3081717","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G695185130","display_name":null,"funder_award_id":"61972403, 61732014 and U1711261","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W1502318375","https://openalex.org/W1553193704","https://openalex.org/W1557868286","https://openalex.org/W1592532873","https://openalex.org/W1594809416","https://openalex.org/W1598754936","https://openalex.org/W1845494277","https://openalex.org/W1971864291","https://openalex.org/W1978006057","https://openalex.org/W1985229168","https://openalex.org/W2000616942","https://openalex.org/W2025315843","https://openalex.org/W2064311651","https://openalex.org/W2068739275","https://openalex.org/W2083150957","https://openalex.org/W2098489450","https://openalex.org/W2116470353","https://openalex.org/W2117917070","https://openalex.org/W2133384222","https://openalex.org/W2139285682","https://openalex.org/W2143241596","https://openalex.org/W2147270837","https://openalex.org/W2149833616","https://openalex.org/W2167350691","https://openalex.org/W2169057819","https://openalex.org/W2764131694","https://openalex.org/W2797419690","https://openalex.org/W2798441769","https://openalex.org/W2889275874","https://openalex.org/W2951100380","https://openalex.org/W2970727055","https://openalex.org/W3021797001","https://openalex.org/W4234497300","https://openalex.org/W4245278602","https://openalex.org/W6633080275","https://openalex.org/W6633341335","https://openalex.org/W6635734788","https://openalex.org/W6638819420","https://openalex.org/W6681188343","https://openalex.org/W6764309174"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W2614112517","https://openalex.org/W2108932068","https://openalex.org/W1980548249","https://openalex.org/W2340883001","https://openalex.org/W1488984669","https://openalex.org/W2512678083","https://openalex.org/W2038123353","https://openalex.org/W4388053677","https://openalex.org/W4223894417"],"abstract_inverted_index":{"The":[0,174],"adoption":[1],"of":[2,12,70,130],"temporal":[3,13,32,52,55,89,117,171],"expressions":[4],"into":[5,150],"SQL:2011":[6],"has":[7],"continuously":[8],"driven":[9],"the":[10,96,127],"extensions":[11],"support":[14,103],"in":[15,34,48,61,84,99],"relational":[16],"database":[17,172],"systems":[18],"(a.b.a.":[19],"RDBMSs).":[20],"In":[21],"this":[22],"paper,":[23],"we":[24,94,121],"present":[25],"T-SQL,":[26],"a":[27,141],"lightweight":[28,181],"yet":[29],"efficient":[30,135],"built-in":[31],"implementation":[33],"RDBMSs.":[35,155],"T-SQL":[36,149,168,178],"completely":[37],"relies":[38],"on":[39,140,145,160],"multi-version":[40],"concurrency":[41],"control":[42],"(MVCC)":[43],"which":[44,75],"is":[45,179],"widely":[46],"adopted":[47],"RDMBSs":[49],"to":[50,77,102,125,147],"manage":[51],"data.":[53],"For":[54],"data,":[56],"current":[57,71,111],"records":[58,72,109,112],"are":[59,81,119],"maintained":[60,83],"legacy":[62,100],"databases,":[63],"and":[64,153,163,182],"historical":[65,108],"records,":[66],"i.e.,":[67],"previoius":[68],"versions":[69],"(if":[73],"any),":[74],"used":[76],"be":[78],"periodically":[79],"reclaimed":[80],"separately":[82],"KV":[85,131],"stores.":[86],"To":[87],"enable":[88],"query":[90,97,104,136],"processing":[91,105],"under":[92],"SQL:2011,":[93],"extend":[95],"engine":[98],"RDBMSs":[101],"over":[106],"either":[107],"or":[110,113],"both.":[114],"Further,":[115],"regarding":[116],"data":[118],"ever-increasing,":[120],"propose":[122],"various":[123],"optimizations":[124],"reduce":[126],"storage":[128],"overhead":[129],"stores":[132],"while":[133],"keeping":[134],"performance.":[137],"We":[138,156],"elaborate":[139],"publicly":[142],"available":[143],"implementation,":[144],"how":[146],"integrate":[148],"both":[151,161,180],"centralized":[152],"distributed":[154],"conduct":[157],"extensive":[158],"experiments":[159],"YCSB":[162],"TPC-series":[164],"benchmarks":[165],"by":[166],"comparing":[167],"with":[169],"other":[170],"systems.":[173],"results":[175],"show":[176],"that":[177],"efficient.":[183]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":8}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}