{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,3]],"date-time":"2026-10-03T17:15:10Z","timestamp":1791047710202,"version":"4.1.0"},"publisher-location":"New York, NY, USA","reference-count":31,"publisher":"ACM","license":[{"start":{"date-parts":[[2017,11,6]],"date-time":"2017-11-06T00:00:00Z","timestamp":1509926400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/100000001","name":"National Science Foundation","doi-asserted-by":"publisher","award":["IIS-1546083,IIS-1651489,CNS-1563788"],"award-info":[{"award-number":["IIS-1546083,IIS-1651489,CNS-1563788"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100000185","name":"Defense Advanced Research Projects Agency","doi-asserted-by":"publisher","award":["FA8750-16-2-0032"],"award-info":[{"award-number":["FA8750-16-2-0032"]}],"id":[{"id":"10.13039\/100000185","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100000015","name":"U.S. Department of Energy","doi-asserted-by":"publisher","award":["DE-SC0016260"],"award-info":[{"award-number":["DE-SC0016260"]}],"id":[{"id":"10.13039\/100000015","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2017,11,6]]},"DOI":"10.1145\/3132847.3132954","type":"proceedings-article","created":{"date-parts":[[2017,11,6]],"date-time":"2017-11-06T13:30:29Z","timestamp":1509975029000},"page":"1299-1308","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":50,"title":["Understanding Database Performance Inefficiencies in Real-world Web Applications"],"prefix":"10.1145","author":[{"given":"Cong","family":"Yan","sequence":"first","affiliation":[{"name":"University of Washington, Seattle, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Alvin","family":"Cheung","sequence":"additional","affiliation":[{"name":"University of Washington, Seattle, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Junwen","family":"Yang","sequence":"additional","affiliation":[{"name":"University of Chicago, Chicago , IL, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Shan","family":"Lu","sequence":"additional","affiliation":[{"name":"University of Chicago, Chicago, IL, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2017,11,6]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"Active record. https:\/\/github.com\/rails\/rails\/tree\/master\/activerecord.  Active record. https:\/\/github.com\/rails\/rails\/tree\/master\/activerecord."},{"key":"e_1_3_2_1_2_1","unstructured":"Common length of a comment. https:\/\/www.reddit.com\/r\/dataisbeautiful\/comments\/2mkp6u\/comment_length_by_subreddit_oc\/.  Common length of a comment. https:\/\/www.reddit.com\/r\/dataisbeautiful\/comments\/2mkp6u\/comment_length_by_subreddit_oc\/."},{"key":"e_1_3_2_1_3_1","unstructured":"diaspora. https:\/\/diasporafoundation.org\/.  diaspora. https:\/\/diasporafoundation.org\/."},{"key":"e_1_3_2_1_4_1","unstructured":"Discussion on blog length. https:\/\/www.snapagency.com\/blog\/whatll-best-length-blog-article-2015-seo\/.  Discussion on blog length. https:\/\/www.snapagency.com\/blog\/whatll-best-length-blog-article-2015-seo\/."},{"key":"e_1_3_2_1_5_1","unstructured":"Django. https:\/\/www.djangoproject.com\/.  Django. https:\/\/www.djangoproject.com\/."},{"key":"e_1_3_2_1_6_1","unstructured":"Enterprise javabeans. https:\/\/jcp.org\/en\/jsr\/detail?id=220.  Enterprise javabeans. https:\/\/jcp.org\/en\/jsr\/detail?id=220."},{"key":"e_1_3_2_1_7_1","unstructured":"filter validation and association. http:\/\/guides.rubyonrails.org.  filter validation and association. http:\/\/guides.rubyonrails.org."},{"key":"e_1_3_2_1_8_1","unstructured":"gitlab. https:\/\/github.com\/gitlabhq\/gitlabhq.  gitlab. https:\/\/github.com\/gitlabhq\/gitlabhq."},{"key":"e_1_3_2_1_9_1","unstructured":"gitlab forum. https:\/\/gitlab.com\/gitlab-org\/gitlab-ce\/issues.  gitlab forum. https:\/\/gitlab.com\/gitlab-org\/gitlab-ce\/issues."},{"key":"e_1_3_2_1_10_1","unstructured":"Hibernate. http:\/\/hibernate.org\/.  Hibernate. http:\/\/hibernate.org\/."},{"key":"e_1_3_2_1_11_1","unstructured":"kandan:web. http:\/\/getkandan.com\/.  kandan:web. http:\/\/getkandan.com\/."},{"key":"e_1_3_2_1_12_1","unstructured":"lobsters. https:\/\/github.com\/jcs\/lobsters.  lobsters. https:\/\/github.com\/jcs\/lobsters."},{"key":"e_1_3_2_1_13_1","unstructured":"publify. https:\/\/github.com\/publify\/publify.  publify. https:\/\/github.com\/publify\/publify."},{"key":"e_1_3_2_1_14_1","unstructured":"redmine. https:\/\/github.com\/redmine\/redmine.  redmine. https:\/\/github.com\/redmine\/redmine."},{"key":"e_1_3_2_1_15_1","unstructured":"Ruby on rails. http:\/\/rubyonrails.org\/.  Ruby on rails. http:\/\/rubyonrails.org\/."},{"key":"e_1_3_2_1_16_1","unstructured":"sugar. https:\/\/github.com\/elektronaut\/sugar.  sugar. https:\/\/github.com\/elektronaut\/sugar."},{"key":"e_1_3_2_1_17_1","unstructured":"Update query cache. http:\/\/instantbadger.blogspot.com\/2009\/12\/memcached-cache-invalidation-made-easy.html.  Update query cache. http:\/\/instantbadger.blogspot.com\/2009\/12\/memcached-cache-invalidation-made-easy.html."},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2016.2553039"},{"key":"e_1_3_2_1_20_1","volume-title":"CIDR","author":"Cheung A.","year":"2013","unstructured":"A. Cheung , O. Arden , S. Madden , A. Solar-Lezama , and A. Myers . Statusquo: Making familiar abstractions perform using program analysis . In CIDR , 2013 . A. Cheung, O. Arden, S. Madden, A. Solar-Lezama, and A. Myers. Statusquo: Making familiar abstractions perform using program analysis. In CIDR, 2013."},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2593672"},{"issue":"1","key":"e_1_3_2_1_22_1","first-page":"48","article-title":"Using program analysis to improve database applications","volume":"37","author":"Cheung A.","year":"2014","unstructured":"A. Cheung , S. Madden , A. Solar-Lezama , O. Arden , and A. C. Myers . Using program analysis to improve database applications . IEEE Data Engineering Bulletin , 37 ( 1 ): 48 -- 59 , 2014 . A. Cheung, S. Madden, A. Solar-Lezama, O. Arden, and A. C. Myers. Using program analysis to improve database applications. IEEE Data Engineering Bulletin, 37(1):48--59, 2014.","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491956.2462180"},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882926"},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/582353.582400"},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/2168651.2168654"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066201"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/2987550.2987567"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2014.2334302"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1109\/CONIELECOMP.2006.6"},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.14778\/2876473.2876479"}],"event":{"name":"CIKM '17: ACM Conference on Information and Knowledge Management","location":"Singapore Singapore","acronym":"CIKM '17","sponsor":["SIGWEB ACM Special Interest Group on Hypertext, Hypermedia, and Web","SIGIR ACM Special Interest Group on Information Retrieval"]},"container-title":["Proceedings of the 2017 ACM on Conference on Information and Knowledge Management"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3132847.3132954","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3132847.3132954","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3132847.3132954","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T02:13:46Z","timestamp":1750212826000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3132847.3132954"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,11,6]]},"references-count":31,"alternative-id":["10.1145\/3132847.3132954","10.1145\/3132847"],"URL":"https:\/\/doi.org\/10.1145\/3132847.3132954","relation":{},"subject":[],"published":{"date-parts":[[2017,11,6]]},"assertion":[{"value":"2017-11-06","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}