{"id":"https://openalex.org/W4389162357","doi":"https://doi.org/10.1145/3611643.3613893","title":"Adapting Performance Analytic Techniques in a Real-World Database-Centric System: An Industrial Experience Report","display_name":"Adapting Performance Analytic Techniques in a Real-World Database-Centric System: An Industrial Experience Report","publication_year":2023,"publication_date":"2023-11-30","ids":{"openalex":"https://openalex.org/W4389162357","doi":"https://doi.org/10.1145/3611643.3613893"},"language":"en","primary_location":{"id":"doi:10.1145/3611643.3613893","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3611643.3613893","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 31st ACM Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering","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/A5103209936","display_name":"Lizhi Liao","orcid":"https://orcid.org/0000-0001-9920-5855"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Lizhi Liao","raw_affiliation_strings":["University of Waterloo, Waterloo, Canada"],"raw_orcid":"https://orcid.org/0000-0001-9920-5855","affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100338781","display_name":"Heng Li","orcid":"https://orcid.org/0000-0001-5441-6763"},"institutions":[{"id":"https://openalex.org/I45683168","display_name":"Polytechnique Montr\u00e9al","ror":"https://ror.org/05f8d4e86","country_code":"CA","type":"education","lineage":["https://openalex.org/I45683168"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Heng Li","raw_affiliation_strings":["Polytechnique Montr\u00e9al, Montreal, Canada"],"raw_orcid":"https://orcid.org/0000-0001-5441-6763","affiliations":[{"raw_affiliation_string":"Polytechnique Montr\u00e9al, Montreal, Canada","institution_ids":["https://openalex.org/I45683168"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056378414","display_name":"Weiyi Shang","orcid":"https://orcid.org/0000-0001-6222-7444"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Weiyi Shang","raw_affiliation_strings":["University of Waterloo, Waterloo, Canada"],"raw_orcid":"https://orcid.org/0000-0001-6222-7444","affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005839180","display_name":"Catalin Sporea","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Catalin Sporea","raw_affiliation_strings":["ERA Environmental, Montreal, Canada"],"raw_orcid":"https://orcid.org/0009-0008-7853-3938","affiliations":[{"raw_affiliation_string":"ERA Environmental, Montreal, Canada","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107246964","display_name":"Andrei Toma","orcid":"https://orcid.org/0009-0009-7933-1446"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Andrei Toma","raw_affiliation_strings":["ERA Environmental, Montreal, Canada"],"raw_orcid":"https://orcid.org/0009-0009-7933-1446","affiliations":[{"raw_affiliation_string":"ERA Environmental, Montreal, Canada","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068690553","display_name":"Sarah Sajedi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sarah Sajedi","raw_affiliation_strings":["ERA Environmental, Montreal, Canada"],"raw_orcid":"https://orcid.org/0000-0002-7900-2812","affiliations":[{"raw_affiliation_string":"ERA Environmental, Montreal, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5103209936"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":0.1968,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.5359255,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1855","last_page":"1866"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":1.0,"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/T12127","display_name":"Software System Performance and Reliability","score":1.0,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T12423","display_name":"Software Reliability and Analysis Research","score":0.9860000014305115,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.8296656608581543},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6924636960029602},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.5201176404953003},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.47986429929733276},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4695371389389038},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4624270498752594},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.4593951404094696},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.45242181420326233},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4334757626056671},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.42132675647735596},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3374660015106201},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.33345258235931396},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.33180299401283264},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09806564450263977}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8296656608581543},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6924636960029602},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.5201176404953003},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.47986429929733276},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4695371389389038},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4624270498752594},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.4593951404094696},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.45242181420326233},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4334757626056671},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.42132675647735596},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3374660015106201},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.33345258235931396},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.33180299401283264},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09806564450263977},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3611643.3613893","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3611643.3613893","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 31st ACM Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:publications.polymtl.ca:57766","is_oa":false,"landing_page_url":"https://publications.polymtl.ca/57766/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401013","display_name":"PolyPublie (\u00c9cole Polytechnique de Montr\u00e9al)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I45683168","host_organization_name":"Polytechnique Montr\u00e9al","host_organization_lineage":["https://openalex.org/I45683168"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Communication de conf\u00e9rence"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5799999833106995,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W639218804","https://openalex.org/W1512098439","https://openalex.org/W1965377045","https://openalex.org/W1984135560","https://openalex.org/W2010636948","https://openalex.org/W2048430744","https://openalex.org/W2049962250","https://openalex.org/W2060328587","https://openalex.org/W2062666593","https://openalex.org/W2067258447","https://openalex.org/W2068880428","https://openalex.org/W2099870165","https://openalex.org/W2148082729","https://openalex.org/W2154941531","https://openalex.org/W2170114245","https://openalex.org/W2316057888","https://openalex.org/W2340417905","https://openalex.org/W2397554829","https://openalex.org/W2399881321","https://openalex.org/W2767894601","https://openalex.org/W2794933251","https://openalex.org/W2898912109","https://openalex.org/W2911964244","https://openalex.org/W2999302351","https://openalex.org/W2999800761","https://openalex.org/W3034645960","https://openalex.org/W3106731144","https://openalex.org/W3110783234","https://openalex.org/W3177602504","https://openalex.org/W3216303224","https://openalex.org/W4200457408","https://openalex.org/W4238623774","https://openalex.org/W4242841269","https://openalex.org/W4249332479"],"related_works":["https://openalex.org/W2129469317","https://openalex.org/W1533863182","https://openalex.org/W2188578519","https://openalex.org/W2357102580","https://openalex.org/W1588786827","https://openalex.org/W1502610062","https://openalex.org/W2015535627","https://openalex.org/W979175841","https://openalex.org/W2018151471","https://openalex.org/W2007701712"],"abstract_inverted_index":{"Database-centric":[0],"architectures":[1],"have":[2,25],"been":[3],"widely":[4],"adopted":[5],"in":[6,10,38,84,96,106,152,208],"large-scale":[7,54,154],"software":[8,40],"systems":[9,56,79,121,131],"various":[11],"domains":[12],"to":[13,53,66,76,168,231,255],"deal":[14],"with":[15,180],"the":[16,67,90,97,101,104,107,116,130,169,172,175,178,201,209,215,222,232,242,259],"ever-increasing":[17],"amount":[18],"and":[19,43,60,93,122,171,177,186,195,203,241,250,257],"complexity":[20],"of":[21,30,70,89,100,119,147,205,261],"data.":[22],"Prior":[23],"studies":[24],"proposed":[26],"a":[27,87,153],"wide":[28],"range":[29],"performance":[31,41,45,117,149,163,224,260],"analytic":[32,150],"techniques":[33,52,151],"aimed":[34],"at":[35],"assisting":[36],"developers":[37],"pinpointing":[39],"inefficiencies":[42],"diagnosing":[44],"issues.":[46],"However,":[47],"directly":[48],"applying":[49,228],"these":[50],"existing":[51],"database-centric":[55,85,155,234,262],"can":[57,245],"be":[58,126,246],"challenging":[59],"may":[61,125],"not":[62],"perform":[63],"well":[64,213],"due":[65],"unique":[68],"nature":[69],"such":[71,113,120,137],"systems.":[72,263],"In":[73,140],"particular,":[74],"compared":[75],"typical":[77],"database-based":[78],"like":[80,254],"online":[81],"shopping":[82],"systems,":[83,86],"majority":[88],"business":[91],"logic":[92],"calculations":[94,105],"reside":[95],"database":[98,108,170,176],"instead":[99],"application.":[102],"As":[103],"typically":[109],"use":[110],"domain-specific":[111],"languages":[112,136],"as":[114,138,212,214],"SQL,":[115],"issues":[118,225],"their":[123],"diagnosis":[124],"significantly":[127],"different":[128],"from":[129,157],"dominated":[132],"by":[133,227],"traditional":[134],"programming":[135],"Java.":[139],"this":[141],"paper,":[142],"we":[143,190],"share":[144],"our":[145,158,192,206,229,239],"experience":[146,244],"adapting":[148],"system":[156],"industrial":[159,210],"collaborator.":[160],"Our":[161],"adapted":[162],"analysis":[164,230],"pays":[165],"special":[166],"attention":[167],"interactions":[173],"between":[174],"application":[179],"minimal":[181],"reliance":[182],"on":[183],"expert":[184],"knowledge":[185],"manual":[187],"effort.":[188],"Moreover,":[189],"document":[191],"encountered":[193],"challenges":[194],"how":[196],"they":[197],"are":[198],"addressed":[199],"during":[200],"development":[202],"adoption":[204],"solution":[207,240],"setting":[211],"corresponding":[216],"lessons":[217],"learned.":[218],"We":[219,236],"also":[220],"discuss":[221],"real-world":[223],"detected":[226],"target":[233],"system.":[235],"anticipate":[237],"that":[238],"reported":[243],"helpful":[247],"for":[248],"practitioners":[249],"researchers":[251],"who":[252],"would":[253],"ensure":[256],"improve":[258]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}