{"id":"https://openalex.org/W2214154610","doi":"https://doi.org/10.1145/2835043.2835047","title":"Data Provenance for Historical Queries in Relational Database","display_name":"Data Provenance for Historical Queries in Relational Database","publication_year":2015,"publication_date":"2015-10-29","ids":{"openalex":"https://openalex.org/W2214154610","doi":"https://doi.org/10.1145/2835043.2835047","mag":"2214154610"},"language":"en","primary_location":{"id":"doi:10.1145/2835043.2835047","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2835043.2835047","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th Annual ACM India Conference","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/A5043267583","display_name":"Asma Rani","orcid":null},"institutions":[{"id":"https://openalex.org/I74796645","display_name":"Birla Institute of Technology and Science, Pilani","ror":"https://ror.org/001p3jz28","country_code":"IN","type":"education","lineage":["https://openalex.org/I74796645"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Asma Rani","raw_affiliation_strings":["Lecturer, Birla Institute of Technology & Science, Pilani, India, +919468646534"],"affiliations":[{"raw_affiliation_string":"Lecturer, Birla Institute of Technology & Science, Pilani, India, +919468646534","institution_ids":["https://openalex.org/I74796645"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053105431","display_name":"Navneet Goyal","orcid":"https://orcid.org/0000-0002-0006-8211"},"institutions":[{"id":"https://openalex.org/I74796645","display_name":"Birla Institute of Technology and Science, Pilani","ror":"https://ror.org/001p3jz28","country_code":"IN","type":"education","lineage":["https://openalex.org/I74796645"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Navneet Goyal","raw_affiliation_strings":["Professor, Birla Institute of Technology & Science, Pilani, India, +919929095379"],"affiliations":[{"raw_affiliation_string":"Professor, Birla Institute of Technology & Science, Pilani, India, +919929095379","institution_ids":["https://openalex.org/I74796645"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113594786","display_name":"Shashi K. Gadia","orcid":null},"institutions":[{"id":"https://openalex.org/I173911158","display_name":"Iowa State University","ror":"https://ror.org/04rswrd78","country_code":"US","type":"education","lineage":["https://openalex.org/I173911158"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shashi K. Gadia","raw_affiliation_strings":["Associate Professor, Iowa State University, United States, (515) 294-2253"],"affiliations":[{"raw_affiliation_string":"Associate Professor, Iowa State University, United States, (515) 294-2253","institution_ids":["https://openalex.org/I173911158"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5043267583"],"corresponding_institution_ids":["https://openalex.org/I74796645"],"apc_list":null,"apc_paid":null,"fwci":4.015,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.94684735,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"117","last_page":"122"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9980999827384949,"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/T11937","display_name":"Research Data Management Practices","score":0.9945999979972839,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.8303853273391724},{"id":"https://openalex.org/keywords/provenance","display_name":"Provenance","score":0.802910566329956},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5963132977485657},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5912722945213318},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5885963439941406}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8303853273391724},{"id":"https://openalex.org/C2780049196","wikidata":"https://www.wikidata.org/wiki/Q23582628","display_name":"Provenance","level":2,"score":0.802910566329956},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5963132977485657},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5912722945213318},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5885963439941406},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C5900021","wikidata":"https://www.wikidata.org/wiki/Q163082","display_name":"Petrology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2835043.2835047","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2835043.2835047","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th Annual ACM India Conference","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","score":0.49000000953674316,"display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W1486776102","https://openalex.org/W1543225912","https://openalex.org/W1552694902","https://openalex.org/W1582521812","https://openalex.org/W1968875243","https://openalex.org/W1983178058","https://openalex.org/W1994326726","https://openalex.org/W2006211529","https://openalex.org/W2020391739","https://openalex.org/W2072269087","https://openalex.org/W2077336685","https://openalex.org/W2096219859","https://openalex.org/W2101235780","https://openalex.org/W2119325664","https://openalex.org/W2125332694","https://openalex.org/W2142026796","https://openalex.org/W2159255950","https://openalex.org/W2163032274","https://openalex.org/W2165766811","https://openalex.org/W2219503726","https://openalex.org/W2272348617","https://openalex.org/W2293299776","https://openalex.org/W2397562051","https://openalex.org/W2508427801","https://openalex.org/W2620387101"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2354627941","https://openalex.org/W2347483153","https://openalex.org/W2353379336","https://openalex.org/W2379683085","https://openalex.org/W2363868702","https://openalex.org/W2374448931","https://openalex.org/W2376723740","https://openalex.org/W2370535391"],"abstract_inverted_index":{"Capturing,":[0],"modeling,":[1],"and":[2,53,80,86,106,111,121,150,201],"querying":[3,87,151,203],"data":[4],"provenance":[5,29,55,72,88,97,113,152,165,205],"in":[6,12,89],"databases":[7],"has":[8],"gained":[9],"considerable":[10],"importance":[11],"the":[13,66,70,119,189],"last":[14],"decade.":[15],"All":[16,92],"kinds":[17],"of":[18,23,35,69,124,147,157,186,191,204],"applications":[19],"developed":[20],"on":[21,65],"top":[22],"databases,":[24],"now":[25],"a":[26,47,136],"days":[27],"collect":[28],"for":[30,57,84,99,104,114,140,153,166,199],"various":[31],"purposes":[32],"like":[33,74],"trustworthiness":[34],"data,":[36],"update":[37],"management,":[38],"quality":[39],"measurement":[40],"etc.":[41],"For":[42],"these":[43,93,125],"purposes,":[44],"there":[45],"is":[46,128,145,197],"need":[48],"to":[49,179],"efficiently":[50,148],"capture,":[51],"store,":[52],"query":[54,112],"information":[56],"current":[58],"as":[59,61],"well":[60],"historical":[62,115,158,181],"queries":[63,116,182],"executed":[64],"database.":[67],"Most":[68],"existing":[71],"models":[73,94,127],"DBNotes,":[75],"MONDRIAN,":[76],"Perm,":[77],"Orchestra,":[78],"TRIO,":[79],"GProM":[81],"are":[82],"suitable":[83],"capturing":[85,149],"relational":[90],"databases.":[91],"can":[95,109],"capture":[96,110],"only":[98],"currently":[100],"executing":[101],"queries,":[102,154],"except":[103],"TRIO":[105],"GProM,":[107],"which":[108,144],"also.":[117],"But,":[118],"time":[120],"space":[122],"complexity":[123],"two":[126],"very":[129],"high.":[130],"In":[131,168],"this":[132],"paper,":[133],"we":[134,171],"propose":[135],"framework,":[137],"Data":[138],"Provenance":[139],"Historical":[141],"Queries":[142],"(DPHQ),":[143],"capable":[146],"including":[155],"that":[156],"queries.":[159],"The":[160],"proposed":[161],"model":[162],"also":[163],"supports":[164],"updates.":[167],"our":[169],"model,":[170],"have":[172],"used":[173,198],"Zero":[174],"Information":[175],"Loss":[176],"Database":[177],"[2]":[178],"execute":[180],"at":[183],"any":[184],"point":[185],"time,":[187],"using":[188],"concept":[190],"nested":[192],"relations.":[193],"A":[194],"graph":[195],"database":[196],"storing":[200],"subsequent":[202],"information.":[206]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}