{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,13]],"date-time":"2026-04-13T15:24:37Z","timestamp":1776093877038,"version":"3.50.1"},"reference-count":10,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2008,8]]},"abstract":"<jats:p>\n            Reading and perceiving complex SQL queries has been a time consuming task in traditional database applications for decades. When it comes to decision support systems with automatically generated and sometimes highly nested SQL queries, human understanding or tuning of these workloads becomes even more challenging. This demonstration explores visualization methods to represent queries as graphs. We developed the\n            <jats:italic>QueryScope<\/jats:italic>\n            tool to help visualize and understand critical elements of a query, thereby cutting down the learning curve. We show how the tool allows the user to drill down on particular queries or to find similarly structured queries that may exhibit similar tuning opportunities. The queries shown in the demonstration are taken from real tuning engagements.\n          <\/jats:p>","DOI":"10.14778\/1454159.1454209","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1488-1491","source":"Crossref","is-referenced-by-count":10,"title":["QueryScope"],"prefix":"10.14778","volume":"1","author":[{"given":"Ling","family":"Hu","sequence":"first","affiliation":[{"name":"Northeastern University, Boston, MA"}]},{"given":"Kenneth A.","family":"Ross","sequence":"additional","affiliation":[{"name":"Columbia University, NYC, NY"}]},{"given":"Yuan-Chi","family":"Chang","sequence":"additional","affiliation":[{"name":"IBM T.J. Watson Research Center, Hawthorne, NY"}]},{"given":"Christian A.","family":"Lang","sequence":"additional","affiliation":[{"name":"IBM T.J. Watson Research Center, Hawthorne, NY"}]},{"given":"Donghui","family":"Zhang","sequence":"additional","affiliation":[{"name":"Northeastern University, Boston, MA"}]}],"member":"320","published-online":{"date-parts":[[2008,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"R. Ahuja. Self-tuning Memory in DB2 Version 9. http:\/\/www.ibm.com\/developerworks\/db2\/library\/techarticle\/dm-0606ahuja\/ 2006.  R. Ahuja. Self-tuning Memory in DB2 Version 9. http:\/\/www.ibm.com\/developerworks\/db2\/library\/techarticle\/dm-0606ahuja\/ 2006."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066184"},{"key":"e_1_2_1_3_1","first-page":"499","volume-title":"VLDB","author":"Bruno N.","year":"2006","unstructured":"N. Bruno and S. Chaudhuri . To Tune or not to Tune? A Lightweight Physical Design Alerter . In VLDB , pages 499 -- 510 , 2006 . N. Bruno and S. Chaudhuri. To Tune or not to Tune? A Lightweight Physical Design Alerter. In VLDB, pages 499--510, 2006."},{"key":"e_1_2_1_4_1","first-page":"3","volume-title":"VLDB","author":"Chaudhuri S.","year":"2007","unstructured":"S. Chaudhuri and V. R. Narasayya . Self-Tuning Database Systems: A Decade of Progress . In VLDB , pages 3 -- 14 , 2007 . S. Chaudhuri and V. R. Narasayya. Self-Tuning Database Systems: A Decade of Progress. In VLDB, pages 3--14, 2007."},{"key":"e_1_2_1_5_1","first-page":"59","volume-title":"VLDB","author":"Chirkova R.","year":"2001","unstructured":"R. Chirkova , A. Y. Halevy , and D. Suciu . A Formal Perspective on the View Selection Problem . In VLDB , pages 59 -- 69 , 2001 . R. Chirkova, A. Y. Halevy, and D. Suciu. A Formal Perspective on the View Selection Problem. In VLDB, pages 59--69, 2001."},{"key":"e_1_2_1_6_1","first-page":"84","volume-title":"CIDR","author":"Dias K.","year":"2005","unstructured":"K. Dias , M. Ramacher , U. Shaft , V. Venkataramani , and G. Wood . Automatic Performance Diagnosis and Tuning in Oracle . In CIDR , pages 84 -- 94 , 2005 . K. Dias, M. Ramacher, U. Shaft, V. Venkataramani, and G. Wood. Automatic Performance Diagnosis and Tuning in Oracle. In CIDR, pages 84--94, 2005."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/571026"},{"key":"e_1_2_1_8_1","volume-title":"Envisioning Information","author":"Tufte E. R.","year":"1990","unstructured":"E. R. Tufte . Envisioning Information . Graphics Press , 1990 . E. R. Tufte. Envisioning Information. Graphics Press, 1990."},{"key":"e_1_2_1_9_1","first-page":"1087","volume-title":"VLDB","author":"Zilio D. C.","year":"2004","unstructured":"D. C. Zilio , J. Rao , S. Lightstone , G. M. Lohman , A. Storm , C. Garcia-Arellano , and S. Fadden . DB2 Design Advisor: Integrated Automatic Physical Database Design . In VLDB , pages 1087 -- 1097 , 2004 . D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In VLDB, pages 1087--1097, 2004."},{"key":"e_1_2_1_10_1","volume-title":"International Conference on Autonomic Computing","author":"Zilio D. C.","year":"2004","unstructured":"D. C. Zilio , C. Zuzarte , S. Lightstone , and W. M. et al. Recommending Materialized Views and Indexes With the IBM DB2 Design Advisor . In International Conference on Autonomic Computing , 2004 . D. C. Zilio, C. Zuzarte, S. Lightstone, and W. M. et al. Recommending Materialized Views and Indexes With the IBM DB2 Design Advisor. In International Conference on Autonomic Computing, 2004."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1454159.1454209","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:59:28Z","timestamp":1672221568000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1454159.1454209"}},"subtitle":["visualizing queries for repeatable database tuning"],"short-title":[],"issued":{"date-parts":[[2008,8]]},"references-count":10,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2008,8]]}},"alternative-id":["10.14778\/1454159.1454209"],"URL":"https:\/\/doi.org\/10.14778\/1454159.1454209","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2008,8]]}}}