{"id":"https://openalex.org/W4313492100","doi":"https://doi.org/10.1145/3570991.3571069","title":"TSAPI: Enhancing Existing OLTP Databases with Temporal Query Capabilities for Analytics","display_name":"TSAPI: Enhancing Existing OLTP Databases with Temporal Query Capabilities for Analytics","publication_year":2023,"publication_date":"2023-01-04","ids":{"openalex":"https://openalex.org/W4313492100","doi":"https://doi.org/10.1145/3570991.3571069"},"language":"en","primary_location":{"id":"doi:10.1145/3570991.3571069","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3570991.3571069","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 6th Joint International Conference on Data Science & Management of Data (10th ACM IKDD CODS and 28th COMAD)","raw_type":"proceedings-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/A5044389696","display_name":"Chandrashekar Ramanathan","orcid":"https://orcid.org/0000-0002-3330-8365"},"institutions":[{"id":"https://openalex.org/I181514455","display_name":"International Institute of Information Technology Bangalore","ror":"https://ror.org/05h9eqy10","country_code":"IN","type":"education","lineage":["https://openalex.org/I181514455"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Chandrashekar Ramanathan","raw_affiliation_strings":["MINRO Center, International Institute of Information Technology Bangalore, India"],"affiliations":[{"raw_affiliation_string":"MINRO Center, International Institute of Information Technology Bangalore, India","institution_ids":["https://openalex.org/I181514455"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035477598","display_name":"Apurva Kulkarni","orcid":"https://orcid.org/0000-0002-9215-2049"},"institutions":[{"id":"https://openalex.org/I181514455","display_name":"International Institute of Information Technology Bangalore","ror":"https://ror.org/05h9eqy10","country_code":"IN","type":"education","lineage":["https://openalex.org/I181514455"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Apurva Kulkarni","raw_affiliation_strings":["MINRO Center, International Institute of Information Technology Bangalore, India"],"affiliations":[{"raw_affiliation_string":"MINRO Center, International Institute of Information Technology Bangalore, India","institution_ids":["https://openalex.org/I181514455"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5044389696"],"corresponding_institution_ids":["https://openalex.org/I181514455"],"apc_list":null,"apc_paid":null,"fwci":0.5798,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.69735475,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"268","last_page":"271"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12720","display_name":"Multimedia Communication and Technology","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T12720","display_name":"Multimedia Communication and Technology","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9934999942779541,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.988099992275238,"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/online-transaction-processing","display_name":"Online transaction processing","score":0.8596535325050354},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8019223213195801},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.7330817580223083},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.621766984462738},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5355429649353027},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4071948230266571},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.3894227147102356},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3571378290653229},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.2515527009963989}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.8596535325050354},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8019223213195801},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.7330817580223083},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.621766984462738},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5355429649353027},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4071948230266571},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3894227147102356},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3571378290653229},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.2515527009963989}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3570991.3571069","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3570991.3571069","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 6th Joint International Conference on Data Science & Management of Data (10th ACM IKDD CODS and 28th COMAD)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6499999761581421}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W2060371982","https://openalex.org/W2541815069","https://openalex.org/W2554803459","https://openalex.org/W2963654186"],"related_works":["https://openalex.org/W2980304303","https://openalex.org/W3115756817","https://openalex.org/W4213297968","https://openalex.org/W2084266952","https://openalex.org/W289877171","https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W834810655"],"abstract_inverted_index":{"Time":[0],"is":[1,14,225,228,294,321],"an":[2],"essential":[3],"aspect":[4],"of":[5,16,121,217,223,276],"real":[6],"world":[7],"applications.":[8,219,235,289],"A":[9],"Temporal":[10],"Query":[11],"in":[12,208,273,284,311],"SQL":[13,159,255,286,292,317],"composed":[15],"special":[17,29],"database":[18,123,234,268,326],"operators":[19,22,30,143,177],"called":[20,156],"temporal":[21,122,141,175,262,300,308],"(e.g.,":[23],"AS-OF,":[24],"WHEN,":[25],"etc.).":[26],"These":[27],"are":[28,99,264,302],"that":[31,54,88,118,226,280],"help":[32],"applications":[33,168,242],"perform":[34],"time-based":[35],"analytics":[36,73,80],"on":[37,204,323,328],"databases.":[38],"Conventional":[39],"OLTP":[40,86,94,131],"(Online":[41,67],"Transaction":[42],"Processing)":[43,69],"databases":[44,70,95,98,133,247],"implemented":[45,327],"using":[46,144,173,304],"traditional":[47],"RDBMS":[48],"deal":[49],"only":[50,76],"with":[51,199,231,253],"current":[52],"data,":[53],"is,":[55],"the":[56,63,119,136,179,196,215,218,239,259,274,288,298,316],"data":[57,78,90,172,184,203,309],"reflects":[58],"modelled":[59],"reality":[60],"\u201cas-of-now.\u201d":[61,92],"On":[62,258],"other":[64,237,260],"hand,":[65,261],"OLAP":[66,97],"Analytical":[68],"intended":[71],"for":[72,79,101,161,250,287,307],"necessarily":[74],"incorporate":[75],"historical":[77,106,140,171,202],"and":[81,96,108,151,193,206,243,256,270,297],"do":[82,110],"not":[83,111],"cater":[84],"to":[85,134,138,181],"requirements":[87,216],"demands":[89],"values":[91],"Consequently,":[93],"used":[100],"orthogonal":[102],"purposes":[103],"(transaction-processing":[104],"vs":[105],"analytics)":[107],"generally":[109],"co-exist.":[112],"In":[113,236],"this":[114,165],"paper,":[115],"we":[116],"demonstrate":[117],"principles":[120],"design":[124],"can":[125,169,281],"be":[126,282],"integrated":[127],"seamlessly":[128],"into":[129,266],"existing":[130,232,240,267],"relational":[132,233,246],"give":[135],"ability":[137],"run":[139],"query":[142,176,278],"(a)":[145],"a":[146,153,209,312,324],"Java-based":[147],"static":[148,188],"interactive":[149,189],"tool":[150,190],"(b)":[152],"dynamic":[154],"API":[155],"TSAPI":[157,224],"(Temporal":[158],"API)":[160],"application":[162,271],"development.":[163],"Using":[164],"proposed":[166],"approach,":[167],"access":[170],"powerful":[174],"without":[178],"need":[180],"implement":[182],"expensive":[183],"warehousing":[185],"infrastructure.":[186],"The":[187,290,319],"also":[191],"automates":[192],"abstracts":[194],"out":[195],"complexities":[197],"associated":[198],"maintaining":[200],"\u201cin-place\u201d":[201],"entities":[205],"attributes":[207],"selective":[210],"manner":[211],"exactly":[212],"as":[213],"per":[214],"Another":[220],"unique":[221],"feature":[222],"it":[227],"backward":[229],"compatible":[230],"words,":[238],"client":[241],"their":[244],"underlying":[245],"remain":[248],"unaltered":[249],"regular":[251],"use":[252],"standard":[254,285],"JDBC.":[257],"aspects":[263],"injected":[265],"schema":[269],"code":[272],"form":[275],"new":[277,299],"keywords":[279,306],"embedded":[283],"conventional":[291],"language":[293],"supported":[295],"as-is":[296],"functionalities":[301],"offered":[303],"additional":[305],"operations":[310],"syntax":[313],"just":[314],"like":[315],"language.":[318],"demonstration":[320],"done":[322],"synthetic":[325],"MySQL.":[329]},"counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}