{"id":"https://openalex.org/W4391307286","doi":"https://doi.org/10.1109/smc53992.2023.10394026","title":"An Offline Profile-Guided Optimization Strategy for Function Reordering on Relational Databases","display_name":"An Offline Profile-Guided Optimization Strategy for Function Reordering on Relational Databases","publication_year":2023,"publication_date":"2023-10-01","ids":{"openalex":"https://openalex.org/W4391307286","doi":"https://doi.org/10.1109/smc53992.2023.10394026"},"language":"en","primary_location":{"id":"doi:10.1109/smc53992.2023.10394026","is_oa":false,"landing_page_url":"https://doi.org/10.1109/smc53992.2023.10394026","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Conference on Systems, Man, and Cybernetics (SMC)","raw_type":"proceedings-article"},"type":"conference-paper","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":null,"display_name":"Weibin Chen","orcid":null},"institutions":[{"id":"https://openalex.org/I4210116924","display_name":"Chinese University of Hong Kong, Shenzhen","ror":"https://ror.org/02d5ks197","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633","https://openalex.org/I180726961","https://openalex.org/I4210116924"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Weibin Chen","raw_affiliation_strings":["School of Science and Engineering, The Chinese University of Hong Kong (Shenzhen),Shenzhen,China","School of Science and Engineering, The Chinese University of Hong Kong (Shenzhen), Shenzhen, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Science and Engineering, The Chinese University of Hong Kong (Shenzhen),Shenzhen,China","institution_ids":["https://openalex.org/I4210116924"]},{"raw_affiliation_string":"School of Science and Engineering, The Chinese University of Hong Kong (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I4210116924"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5043627040","display_name":"Yeh\u2010Ching Chung","orcid":"https://orcid.org/0000-0002-8704-9821"},"institutions":[{"id":"https://openalex.org/I4210116924","display_name":"Chinese University of Hong Kong, Shenzhen","ror":"https://ror.org/02d5ks197","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633","https://openalex.org/I180726961","https://openalex.org/I4210116924"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yeh-Ching Chung","raw_affiliation_strings":["School of Data Science, The Chinese University of Hong Kong (Shenzhen),Shenzhen,China","School of Data Science, The Chinese University of Hong Kong (Shenzhen), Shenzhen, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Data Science, The Chinese University of Hong Kong (Shenzhen),Shenzhen,China","institution_ids":["https://openalex.org/I4210116924"]},{"raw_affiliation_string":"School of Data Science, The Chinese University of Hong Kong (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I4210116924"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210116924"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"967","last_page":"972"},"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.944599986076355,"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.944599986076355,"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.7483801245689392},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.68131422996521},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.5477749705314636},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4608016312122345},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.32320380210876465}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7483801245689392},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.68131422996521},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.5477749705314636},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4608016312122345},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.32320380210876465},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/smc53992.2023.10394026","is_oa":false,"landing_page_url":"https://doi.org/10.1109/smc53992.2023.10394026","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Conference on Systems, Man, and Cybernetics (SMC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W2008158664","https://openalex.org/W2010595692","https://openalex.org/W2087928503","https://openalex.org/W2097175800","https://openalex.org/W2102099561","https://openalex.org/W2168503413","https://openalex.org/W2785369612","https://openalex.org/W2911038074","https://openalex.org/W2944240329","https://openalex.org/W2952416601","https://openalex.org/W2962717918","https://openalex.org/W3098844916","https://openalex.org/W4234573405","https://openalex.org/W4248045917","https://openalex.org/W4251155448","https://openalex.org/W4252045756","https://openalex.org/W4309344900"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2350741829","https://openalex.org/W2530322880","https://openalex.org/W1596801655","https://openalex.org/W2359140296"],"abstract_inverted_index":{"Profile-guided":[0],"optimization":[1],"(PGO)":[2],"is":[3,21],"an":[4,47,75],"advanced":[5],"technique":[6],"used":[7],"to":[8,22,32,57,79,86],"improve":[9],"the":[10,17,26,38,64,97,128,133,143,150,157,166],"performance":[11,35,98,129,167,176],"of":[12,142,152,160,168],"Relational":[13],"Databases":[14],"(RDBs).":[15],"However,":[16],"most":[18],"common":[19],"strategy":[20,50,56],"perform":[23],"profiling":[24,49,162],"on":[25,74,112],"production":[27,65,171],"environment,":[28],"which":[29],"can":[30],"lead":[31],"instability":[33],"and":[34,83,107,125,155,178],"loss":[36],"for":[37,121,164],"Database":[39],"System.":[40],"To":[41,91],"address":[42],"this":[43,72],"issue,":[44],"we":[45,95],"propose":[46],"offline":[48,76,161],"that":[51,127,141],"uses":[52],"a":[53,59,103,108,113],"query":[54,61,105,110,123,135,145],"reduction":[55],"obtain":[58],"reduced":[60,104,134],"set":[62,106,111,136],"from":[63],"environment's":[66],"log":[67],"file.":[68],"We":[69,116],"then":[70],"run":[71],"sample":[73],"test":[77],"environment":[78],"collect":[80],"profile":[81],"data":[82],"use":[84],"it":[85],"conduct":[87],"function":[88,118],"reorder":[89],"optimization.":[90],"evaluate":[92],"our":[93,153],"approach,":[94],"compared":[96],"improvements":[99],"achieved":[100,131],"by":[101,132],"running":[102],"full":[109,144],"MYSQL":[114],"database.":[115],"generated":[117],"call":[119],"graphs":[120],"both":[122],"sets":[124],"observed":[126],"improvement":[130],"was":[137],"slightly":[138],"lower":[139],"than":[140],"set.":[146],"These":[147],"results":[148],"demonstrate":[149],"effectiveness":[151],"approach":[154],"highlight":[156],"potential":[158],"benefits":[159],"strategies":[163],"improving":[165],"RDBs":[169],"in":[170],"environments,":[172],"while":[173],"also":[174],"avoiding":[175],"losses":[177],"increasing":[179],"stability.":[180]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}