{"id":"https://openalex.org/W1969460277","doi":"https://doi.org/10.14778/1453856.1453975","title":"Rewriting procedures for batched bindings","display_name":"Rewriting procedures for batched bindings","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W1969460277","doi":"https://doi.org/10.14778/1453856.1453975","mag":"1969460277"},"language":"en","primary_location":{"id":"doi:10.14778/1453856.1453975","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453975","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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/A5081474412","display_name":"Ravindra Guravannavar","orcid":null},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Ravindra Guravannavar","raw_affiliation_strings":["Indian Institute of Technology, Bombay"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology, Bombay","institution_ids":["https://openalex.org/I162827531"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081847962","display_name":"S. Sudarshan","orcid":"https://orcid.org/0000-0002-6230-2288"},"institutions":[{"id":"https://openalex.org/I162827531","display_name":"Indian Institute of Technology Bombay","ror":"https://ror.org/02qyf5152","country_code":"IN","type":"education","lineage":["https://openalex.org/I162827531"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"S. Sudarshan","raw_affiliation_strings":["Indian Institute of Technology, Bombay"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology, Bombay","institution_ids":["https://openalex.org/I162827531"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I162827531"],"apc_list":null,"apc_paid":null,"fwci":2.6384,"has_fulltext":false,"cited_by_count":48,"citation_normalized_percentile":{"value":0.90276513,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"1","issue":"1","first_page":"1107","last_page":"1123"},"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.9994999766349792,"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.9994999766349792,"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/T10126","display_name":"Logic, programming, and type systems","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9955000281333923,"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.8700040578842163},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.7883362770080566},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.7293533682823181},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.4881952404975891},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.466383695602417},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.46181002259254456},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4523341655731201},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.45058342814445496},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4334528148174286},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.43270519375801086},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.42807090282440186},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.40548551082611084},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3338159918785095},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.24190208315849304},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.19413480162620544}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8700040578842163},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.7883362770080566},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7293533682823181},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.4881952404975891},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.466383695602417},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.46181002259254456},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4523341655731201},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.45058342814445496},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4334528148174286},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43270519375801086},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.42807090282440186},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40548551082611084},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3338159918785095},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24190208315849304},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.19413480162620544},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/1453856.1453975","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453975","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1529063404","https://openalex.org/W1825341804","https://openalex.org/W2008116177","https://openalex.org/W2075827270","https://openalex.org/W2086779607","https://openalex.org/W2109221906","https://openalex.org/W2114067856","https://openalex.org/W2134179408","https://openalex.org/W2139508393","https://openalex.org/W2165674271","https://openalex.org/W3207229557"],"related_works":["https://openalex.org/W319014924","https://openalex.org/W2406556739","https://openalex.org/W2970853428","https://openalex.org/W2554271401","https://openalex.org/W4244527061","https://openalex.org/W2152149667","https://openalex.org/W1966669067","https://openalex.org/W2185619733","https://openalex.org/W1003283331","https://openalex.org/W2353434938"],"abstract_inverted_index":{"Queries,":[0],"or":[1,21,215],"calls":[2,133],"to":[3,47,77,92,122,130,134,141,151,203,244,259],"stored":[4,149,179],"procedures/user-defined":[5],"functions":[6],"are":[7,232],"often":[8],"invoked":[9,32,171],"multiple":[10,132],"times,":[11],"either":[12],"from":[13,22,174,250],"within":[14],"a":[15,37,83,102,135,138,142,148,153,159,165,178,188,192,225],"loop":[16],"in":[17,42,55,206],"an":[18,27,235],"application":[19,76],"program,":[20],"the":[23,31,56,75,90,95,124,196,220,241],"where/select":[24],"clause":[25],"of":[26,59,85,98,155,158,177,191,195,213,227,262],"outer":[28],"query.":[29,197],"When":[30],"query/procedure/function":[33],"involves":[34],"database":[35,230],"access,":[36],"naive":[38],"implementation":[39],"can":[40,119,200],"result":[41],"very":[43],"poor":[44],"performance,":[45],"due":[46,243,258],"random":[48],"I/O.":[49],"Query":[50],"decorrelation":[51],"addresses":[52],"this":[53,113],"problem":[54,68],"special":[57],"case":[58],"nested":[60],"sub-queries,":[61],"but":[62],"is":[63,69,107],"not":[64],"applicable":[65],"otherwise.":[66],"This":[67],"traditionally":[70],"addressed":[71],"by":[72,81,88,137,185],"manually":[73],"rewriting":[74,89,106,222],"make":[78],"it":[79],"set-oriented,":[80],"creating":[82],"batch":[84,96,154],"parameters,":[86],"and":[87,109],"query/procedure":[91],"work":[93],"on":[94],"instead":[97,157],"one":[99,186],"parameter":[100],"at":[101],"time.":[103],"Such":[104],"manual":[105],"time-consuming":[108],"error":[110],"prone.":[111],"In":[112],"paper,":[114],"we":[115],"propose":[116],"techniques":[117,199,223],"that":[118],"be":[120,182,201],"used":[121],"do":[123],"following,":[125],"(a)":[126],"Automatically":[127],"rewrite":[128],"programs":[129],"replace":[131],"query":[136,166],"batched":[139,193],"call":[140],"correspondingly":[143],"rewritten":[144],"query,":[145],"(b)":[146],"Rewrite":[147],"procedure/function":[150],"accept":[152],"bindings,":[156],"single":[160],"binding.":[161],"Thereby,":[162],"for":[163,224],"example,":[164],"which":[167,253],"would":[168,181],"have":[169,218],"been":[170],"many":[172],"times":[173],"different":[175],"invocations":[176,190,261],"procedure":[180],"automatically":[183],"replaced":[184],"(or":[187],"few)":[189],"version":[194],"Our":[198],"applied":[202],"code":[204],"written":[205],"any":[207],"language,":[208],"such":[209],"as":[210],"procedural":[211],"versions":[212],"SQL,":[214],"Java.":[216],"We":[217,239],"implemented":[219],"proposed":[221],"subset":[226],"Java,":[228],"where":[229],"operations":[231],"performed":[233],"using":[234],"API":[236],"over":[237],"JDBC.":[238],"demonstrate":[240],"benefits":[242],"our":[245],"rewrites":[246],"with":[247],"three":[248],"cases":[249],"real-world":[251],"applications,":[252],"faced":[254],"significant":[255],"performance":[256],"problems":[257],"repeated":[260],"queries/procedures.":[263]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":8},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":6}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}