{"id":"https://openalex.org/W2767894601","doi":"https://doi.org/10.1145/3132847.3132954","title":"Understanding Database Performance Inefficiencies in Real-world Web Applications","display_name":"Understanding Database Performance Inefficiencies in Real-world Web Applications","publication_year":2017,"publication_date":"2017-11-06","ids":{"openalex":"https://openalex.org/W2767894601","doi":"https://doi.org/10.1145/3132847.3132954","mag":"2767894601"},"language":"en","primary_location":{"id":"doi:10.1145/3132847.3132954","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3132847.3132954","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3132954&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM on Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dl.acm.org/ft_gateway.cfm?id=3132954&type=pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101807460","display_name":"Cong Yan","orcid":"https://orcid.org/0009-0001-3596-4083"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Cong Yan","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059427197","display_name":"Alvin Cheung","orcid":"https://orcid.org/0000-0001-6261-6263"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alvin Cheung","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103066770","display_name":"Junwen Yang","orcid":"https://orcid.org/0000-0003-0481-6982"},"institutions":[{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Junwen Yang","raw_affiliation_strings":["University of Chicago, Chicago , IL, USA"],"affiliations":[{"raw_affiliation_string":"University of Chicago, Chicago , IL, USA","institution_ids":["https://openalex.org/I40347166"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061448314","display_name":"Shan Lu","orcid":"https://orcid.org/0000-0002-0757-4600"},"institutions":[{"id":"https://openalex.org/I39422238","display_name":"University of Illinois Chicago","ror":"https://ror.org/02mpq6x41","country_code":"US","type":"education","lineage":["https://openalex.org/I39422238"]},{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shan Lu","raw_affiliation_strings":["University of Chicago, Chicago, IL, USA"],"affiliations":[{"raw_affiliation_string":"University of Chicago, Chicago, IL, USA","institution_ids":["https://openalex.org/I40347166","https://openalex.org/I39422238"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5101807460"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":3.7274,"has_fulltext":true,"cited_by_count":50,"citation_normalized_percentile":{"value":0.94133745,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1299","last_page":"1308"},"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.9991000294685364,"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.9991000294685364,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9990000128746033,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9988999962806702,"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.8388960361480713},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6452406644821167},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5867834687232971},{"id":"https://openalex.org/keywords/frame","display_name":"Frame (networking)","score":0.5340743064880371},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.47306978702545166},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.42634817957878113},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.426086962223053},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.4158393442630768},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.34120792150497437},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09177473187446594}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8388960361480713},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6452406644821167},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5867834687232971},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.5340743064880371},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.47306978702545166},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.42634817957878113},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.426086962223053},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4158393442630768},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.34120792150497437},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09177473187446594},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3132847.3132954","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3132847.3132954","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3132954&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM on Conference on Information and Knowledge Management","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3132847.3132954","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3132847.3132954","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3132954&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM on Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1459233587","display_name":null,"funder_award_id":"IIS-1651489","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1515542360","display_name":null,"funder_award_id":"CNS-1563788","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1952784096","display_name":"CAREER: Generating Application-Specific Database Management Systems","funder_award_id":"1651489","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2205687661","display_name":null,"funder_award_id":"IIS-1546083,IIS-1651489,CNS-1563788","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2986590756","display_name":"BIGDATA: Collaborative Research: F: Holistic Optimization of Data-Driven Applications","funder_award_id":"1546543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3785592558","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4161253729","display_name":"CSR: Medium:Collaborative Research:Holistic, Cross-Site, Hybrid System Anomaly Debugging for Large Scale Hosting Infrastructures","funder_award_id":"1514256","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G442592535","display_name":null,"funder_award_id":"IIS-1546543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4451656","display_name":"BIGDATA: Collaborative Research: F: Holistic Optimization of Data-Driven Applications","funder_award_id":"1546083","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4713059963","display_name":null,"funder_award_id":"FA8750","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4779814752","display_name":null,"funder_award_id":"CNS-1514256","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5334950495","display_name":null,"funder_award_id":"CCF-1514189","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5974677782","display_name":null,"funder_award_id":"DE-SC0016260","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G6947076996","display_name":null,"funder_award_id":"FA8750-16-2-003","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G7722544557","display_name":"NeTS: Medium: Collaborative Research: Language and Hardware Primitives for Programming the Data Plane in High Speed Networks","funder_award_id":"1563788","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8046783532","display_name":"CAREER: Combating Performance Bugs in Software Systems","funder_award_id":"1514189","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8429701143","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306084","display_name":"U.S. Department of Energy","ror":"https://ror.org/01bj3aw27"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2767894601.pdf","grobid_xml":"https://content.openalex.org/works/W2767894601.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W1969548135","https://openalex.org/W1970165929","https://openalex.org/W2062666593","https://openalex.org/W2069171862","https://openalex.org/W2073987830","https://openalex.org/W2089347259","https://openalex.org/W2100099053","https://openalex.org/W2143279993","https://openalex.org/W2148167495","https://openalex.org/W2236986911","https://openalex.org/W2340417905","https://openalex.org/W2346151344","https://openalex.org/W2399620389","https://openalex.org/W2441695939","https://openalex.org/W3100791781"],"related_works":["https://openalex.org/W325713583","https://openalex.org/W2512945146","https://openalex.org/W2483382562","https://openalex.org/W2101197724","https://openalex.org/W2626533837","https://openalex.org/W2027048017","https://openalex.org/W2762065037","https://openalex.org/W2044272255","https://openalex.org/W289370537","https://openalex.org/W2355364777"],"abstract_inverted_index":{"Many":[0],"modern":[1],"database-backed":[2],"web":[3],"applications":[4,41],"are":[5,80,153],"built":[6,42],"upon":[7],"Object":[8],"Relational":[9],"Mapping":[10],"(ORM)":[11],"frameworks.":[12],"While":[13],"such":[14,26],"frame-":[15],"works":[16],"ease":[17],"application":[18,84,151],"development":[19],"by":[20],"abstracting":[21],"persistent":[22],"data":[23],"as":[24,113],"objects,":[25],"convenience":[27],"comes":[28],"with":[29,53],"a":[30,67,114],"performance":[31,60,111],"cost.":[32],"In":[33],"this":[34],"paper,":[35],"we":[36],"studied":[37],"27":[38],"real-world":[39],"open-source":[40],"on":[43,49],"top":[44],"of":[45,69,141],"the":[46,54,58,83,109,127,139],"popular":[47],"Ruby":[48],"Rails":[50],"ORM":[51,146],"framework,":[52],"goal":[55],"to":[56,77,91,103,124,132,138,148],"understand":[57],"database-related":[59],"inefficiencies":[61,70],"in":[62,82],"these":[63,97,105],"applications.":[64],"We":[65,86],"discovered":[66],"number":[68],"rang-":[71],"ing":[72],"from":[73],"physical":[74],"design":[75,140],"issues":[76,98,106],"how":[78,95],"queries":[79],"expressed":[81],"code.":[85],"applied":[87],"static":[88],"program":[89],"analysis":[90],"identify":[92],"and":[93,107,126,145],"measure":[94],"prevalent":[96],"are,":[99],"then":[100],"suggested":[101],"techniques":[102,117],"alleviate":[104],"measured":[108],"potential":[110],"gain":[112],"result.":[115],"These":[116],"significantly":[118],"reduce":[119],"database":[120,143,150],"query":[121],"time":[122,130],"(up":[123,131],"91%)":[125],"webpage":[128],"response":[129],"98%).":[133],"Our":[134],"study":[135],"provides":[136],"guidance":[137],"future":[142],"engines":[144],"frameworks":[147],"support":[149],"that":[152],"performant":[154],"yet":[155],"without":[156],"sacrificing":[157],"programmability.":[158]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}