{"id":"https://openalex.org/W2066140355","doi":"https://doi.org/10.1145/1093382.1093387","title":"Self-tuning cost modeling of user-defined functions in an object-relational DBMS","display_name":"Self-tuning cost modeling of user-defined functions in an object-relational DBMS","publication_year":2005,"publication_date":"2005-09-01","ids":{"openalex":"https://openalex.org/W2066140355","doi":"https://doi.org/10.1145/1093382.1093387","mag":"2066140355"},"language":"en","primary_location":{"id":"doi:10.1145/1093382.1093387","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093387","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","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/A5100427763","display_name":"Zhen He","orcid":"https://orcid.org/0000-0003-0302-5775"},"institutions":[{"id":"https://openalex.org/I196829312","display_name":"La Trobe University","ror":"https://ror.org/01rxfrp27","country_code":"AU","type":"education","lineage":["https://openalex.org/I196829312"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Zhen He","raw_affiliation_strings":["La Trobe University, Australia"],"affiliations":[{"raw_affiliation_string":"La Trobe University, Australia","institution_ids":["https://openalex.org/I196829312"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038390659","display_name":"Byung Suk Lee","orcid":"https://orcid.org/0000-0002-6019-5247"},"institutions":[{"id":"https://openalex.org/I111236770","display_name":"University of Vermont","ror":"https://ror.org/0155zta11","country_code":"US","type":"education","lineage":["https://openalex.org/I111236770"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Byung Suk Lee","raw_affiliation_strings":["University of Vermont, Burlington VT","University of Vermont, Burlington VT#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Vermont, Burlington VT","institution_ids":["https://openalex.org/I111236770"]},{"raw_affiliation_string":"University of Vermont, Burlington VT#TAB#","institution_ids":["https://openalex.org/I111236770"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038921722","display_name":"Robert R. Snapp","orcid":null},"institutions":[{"id":"https://openalex.org/I111236770","display_name":"University of Vermont","ror":"https://ror.org/0155zta11","country_code":"US","type":"education","lineage":["https://openalex.org/I111236770"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Robert Snapp","raw_affiliation_strings":["University of Vermont, Burlington VT","University of Vermont, Burlington VT#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Vermont, Burlington VT","institution_ids":["https://openalex.org/I111236770"]},{"raw_affiliation_string":"University of Vermont, Burlington VT#TAB#","institution_ids":["https://openalex.org/I111236770"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5100427763"],"corresponding_institution_ids":["https://openalex.org/I196829312"],"apc_list":null,"apc_paid":null,"fwci":1.9456,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.86330609,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"30","issue":"3","first_page":"812","last_page":"853"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9933000206947327,"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.9296321272850037},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5411888360977173},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5029444098472595},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4920737147331238},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4873126447200775},{"id":"https://openalex.org/keywords/histogram","display_name":"Histogram","score":0.4697801470756531},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.43023547530174255},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.4270506501197815},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4135086238384247},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.226139634847641},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09083503484725952}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9296321272850037},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5411888360977173},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5029444098472595},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4920737147331238},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4873126447200775},{"id":"https://openalex.org/C53533937","wikidata":"https://www.wikidata.org/wiki/Q185020","display_name":"Histogram","level":3,"score":0.4697801470756531},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.43023547530174255},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.4270506501197815},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4135086238384247},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.226139634847641},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09083503484725952},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1093382.1093387","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093387","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.89.9970","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.89.9970","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://homepage.cs.latrobe.edu.au/zhe/publications/files/UDFCost.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4000000059604645,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W320896","https://openalex.org/W94613485","https://openalex.org/W1493664362","https://openalex.org/W1566022212","https://openalex.org/W1576347849","https://openalex.org/W1581547316","https://openalex.org/W1596332639","https://openalex.org/W1598032593","https://openalex.org/W1964374591","https://openalex.org/W1994410331","https://openalex.org/W2013589201","https://openalex.org/W2015463411","https://openalex.org/W2019762723","https://openalex.org/W2042053054","https://openalex.org/W2059507684","https://openalex.org/W2060883486","https://openalex.org/W2062072660","https://openalex.org/W2066799613","https://openalex.org/W2070074980","https://openalex.org/W2072540320","https://openalex.org/W2079656678","https://openalex.org/W2079806729","https://openalex.org/W2083479198","https://openalex.org/W2099502594","https://openalex.org/W2102166438","https://openalex.org/W2107686700","https://openalex.org/W2108908993","https://openalex.org/W2112056262","https://openalex.org/W2113124441","https://openalex.org/W2118269922","https://openalex.org/W2118314386","https://openalex.org/W2120108467","https://openalex.org/W2138793904","https://openalex.org/W2140190241","https://openalex.org/W2148258946","https://openalex.org/W2148694408","https://openalex.org/W2151135734","https://openalex.org/W2160967997","https://openalex.org/W2164219265","https://openalex.org/W2171048836","https://openalex.org/W2171744805","https://openalex.org/W2212047990","https://openalex.org/W2573031522","https://openalex.org/W2913289629","https://openalex.org/W3114265283","https://openalex.org/W4238717354","https://openalex.org/W4241435959","https://openalex.org/W4255671299","https://openalex.org/W4292023222","https://openalex.org/W4402880284","https://openalex.org/W6600011973"],"related_works":["https://openalex.org/W2107628111","https://openalex.org/W2394004323","https://openalex.org/W2398764543","https://openalex.org/W2027335291","https://openalex.org/W4210328553","https://openalex.org/W1980417906","https://openalex.org/W2007994675","https://openalex.org/W2071206959","https://openalex.org/W1892675750","https://openalex.org/W2139422440"],"abstract_inverted_index":{"Query":[0],"optimizers":[1],"in":[2,40,70,153,269],"object-relational":[3],"database":[4],"management":[5],"systems":[6],"typically":[7],"require":[8,43],"users":[9,44],"to":[10,30,45,62,150,229],"provide":[11,31,165,266],"the":[12,47,73,84,99,107,122,151,154,195,204,217,227,251],"execution":[13,54,65,155],"cost":[14,55,108,126,182],"models":[15],"of":[16,86,102,124,133,168],"user-defined":[17],"functions":[18],"(UDFs).":[19],"Despite":[20],"this":[21,161],"need,":[22],"however,":[23],"there":[24],"has":[25],"been":[26],"little":[27],"work":[28,139,143],"done":[29],"such":[32],"a":[33,49,94,131,166,213,222],"model.":[34],"The":[35,219,261],"existing":[36,247],"approaches":[37,58],"are":[38,117],"static":[39],"that":[41,135,173],"they":[42],"train":[46],"model":[48,109],"priori":[50],"with":[51,140,144,184],"pregenerated":[52],"UDF":[53,64,74,125],"data.":[56],"Static":[57],"can":[59],"not":[60,82],"adapt":[61],"changing":[63],"patterns":[66,85],"and":[67,113,148,180,250,257],"thus":[68],"degrade":[69],"accuracy":[71],"when":[72],"executions":[75],"used":[76],"for":[77,170],"generating":[78],"training":[79],"data":[80],"do":[81],"reflect":[83],"those":[87],"performed":[88,238],"during":[89],"operation.":[90],"This":[91],"article":[92],"proposes":[93],"new":[95],"approach":[96,129],"based":[97,202],"on":[98,203],"recent":[100],"trend":[101],"self-tuning":[103],"DBMS":[104],"by":[105],"which":[106,211,225],"is":[110,198,221],"maintained":[111],"dynamically":[112],"incrementally":[114],"as":[115],"UDFs":[116],"being":[118],"executed":[119],"online.":[120],"In":[121,160],"context":[123],"modeling,":[127],"our":[128,264],"faces":[130],"number":[132],"challenges,":[134,176],"is,":[136],"it":[137],"should":[138],"limited":[141,145],"memory,":[142],"computation":[146],"time,":[147],"adjust":[149],"fluctuations":[152],"costs":[156],"(e.g.,":[157],"caching":[158],"effect).":[159],"article,":[162],"we":[163,188],"first":[164],"set":[167],"guidelines":[169],"developing":[171],"techniques":[172,192,245,249,265],"meet":[174],"these":[175,243],"while":[177],"achieving":[178],"accurate":[179],"fast":[181],"prediction":[183],"small":[185],"overheads.":[186],"Then,":[187],"present":[189],"two":[190,244],"concrete":[191],"developed":[193],"under":[194],"guidelines.":[196],"One":[197],"an":[199],"instance-based":[200],"technique":[201,210,224],"conventional":[205],"k":[206],"-nearest":[207],"neighbor":[208],"(KNN)":[209],"uses":[212,226],"multidimensional":[214],"index":[215],"like":[216],"R*-tree.":[218],"other":[220],"summary-based":[223],"quadtree":[228],"store":[230],"summary":[231],"values":[232],"at":[233],"multiple":[234],"resolutions.":[235],"We":[236],"have":[237],"extensive":[239],"performance":[240,268],"evaluations":[241],"comparing":[242],"against":[246],"histogram-based":[248],"KNN":[252],"technique,":[253],"using":[254],"both":[255],"real":[256],"synthetic":[258],"UDFs/data":[259],"sets.":[260],"results":[262],"show":[263],"better":[267],"most":[270],"situations":[271],"considered.":[272]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}