{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,13]],"date-time":"2026-07-13T14:38:23Z","timestamp":1783953503588,"version":"3.55.0"},"publisher-location":"New York, NY, USA","reference-count":78,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,10]],"date-time":"2022-06-10T00:00:00Z","timestamp":1654819200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"Amazon"},{"DOI":"10.13039\/100006785","name":"Google","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100006785","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/100000001","name":"NSF (National Science Foundation)","doi-asserted-by":"publisher","award":["1845638, 2008295, 2106197, 2103794"],"award-info":[{"award-number":["1845638, 2008295, 2106197, 2103794"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,10]]},"DOI":"10.1145\/3514221.3526166","type":"proceedings-article","created":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T02:33:49Z","timestamp":1655001229000},"page":"1711-1725","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":24,"title":["PI2: End-to-end Interactive Visualization Interface Generation from Queries"],"prefix":"10.1145","author":[{"given":"Yiru","family":"Chen","sequence":"first","affiliation":[{"name":"Columbia University, New York, NY, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Eugene","family":"Wu","sequence":"additional","affiliation":[{"name":"Columbia University, New York, NY, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2022,6,11]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"2021. Count -- The SQL notebook. https:\/\/count.co\/."},{"key":"e_1_3_2_1_2_1","unstructured":"2021. Hex Technologies. https:\/\/hex.tech\/."},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/258549.258760"},{"key":"e_1_3_2_1_4_1","unstructured":"Airtable. 2021. Airtable. https:\/\/airtable.com\/."},{"key":"e_1_3_2_1_5_1","volume-title":"Articulate2: Toward a conversational interface for visual data exploration","author":"Aurisano Jillian","unstructured":"Jillian Aurisano, Abhinav Kumar, Alberto Gonzalez, Jason Leigh, Barbara DiEugenio, and Andrew Johnson. 2016. Articulate2: Toward a conversational interface for visual data exploration. In IEEE Visualization."},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/TCIAIG.2009.2018702"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2011.185"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2013.124"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/TCIAIG.2012.2186810"},{"key":"e_1_3_2_1_11_1","unstructured":"S. Card T. Moran and A. Newell. 1983. The psychology of human-computer interaction."},{"key":"e_1_3_2_1_12_1","unstructured":"Winston Chang Joe Cheng J Allaire Yihui Xie Jonathan McPherson et al. 2015. shiny: Web Application Framework for R 2015. In CRAN."},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452769"},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3384404"},{"key":"e_1_3_2_1_15_1","volume-title":"PI2: Generating Visual Analysis Interfaces From Queries (technical report). CoRR abs\/2107.08203","author":"Chen Yiru","year":"2021","unstructured":"Yiru Chen and Eugene Wu. 2021. PI2: Generating Visual Analysis Interfaces From Queries (technical report). CoRR abs\/2107.08203 (2021). arXiv:2107.08203 https:\/\/arxiv.org\/abs\/2107.08203"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"crossref","unstructured":"R\u00e9mi Coulom. 2006. Efficient Selectivity and Backup Operators in Monte-Carlo Tree Search. In Computers and Games.","DOI":"10.1007\/978-3-540-75538-8_7"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1011368926479"},{"key":"e_1_3_2_1_18_1","unstructured":"Figma. 2021. Figma: a collaborative interface design tool. https:\/\/www.figma.com."},{"key":"e_1_3_2_1_19_1","unstructured":"FiveThirtyEight. 2021. All Posts Tagged Data Visualization. https:\/\/fivethirtyeight.com\/tag\/data-visualization\/."},{"key":"e_1_3_2_1_20_1","volume-title":"IUI '04","author":"Gajos Krzysztof Z","unstructured":"Krzysztof Z Gajos and Daniel S. Weld. 2004. SUPPLE: automatically generating user interfaces. In IUI '04."},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.artint.2010.05.005"},{"key":"e_1_3_2_1_22_1","volume-title":"Natural SQL: Making SQL Easier to Infer from Natural Language Specifications. arXiv preprint arXiv:2109.05153","author":"Gan Yujian","year":"2021","unstructured":"Yujian Gan, Xinyun Chen, Jinxia Xie, Matthew Purver, John R Woodward, John Drake, and Qiaofu Zhang. 2021. Natural SQL: Making SQL Easier to Infer from Natural Language Specifications. arXiv preprint arXiv:2109.05153 (2021)."},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2807442.2807478"},{"key":"e_1_3_2_1_24_1","unstructured":"Google. 2021. Facets - Know Your Data. https:\/\/pair-code.github.io\/facets\/."},{"key":"e_1_3_2_1_25_1","unstructured":"Hex. 2022. Hex Chart Cells. https:\/\/learn.hex.tech\/docs\/logic-cell-types\/display-cells\/chart-cells."},{"key":"e_1_3_2_1_26_1","unstructured":"Hex. 2022. Hex Parameterize Sql. https:\/\/learn.hex.tech\/tutorials\/connect-to-data\/parameterize-sql."},{"key":"e_1_3_2_1_27_1","unstructured":"iCheck. 2021. iCheck. icheckuclaim.org."},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"crossref","unstructured":"H. V. Jagadish Adriane Chapman Aaron Elkiss Magesh Jayapandian Yunyao Li Arnab Nandi and Cong Yu. 2007. Making database systems usable. In SIGMOD.","DOI":"10.1145\/1247480.1247483"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"crossref","unstructured":"Magesh Jayapandian and HV Jagadish. 2008. Automated creation of a forms-based database query interface. In PVLDB. VLDB Endowment.","DOI":"10.14778\/1453856.1453932"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"crossref","unstructured":"Magesh Jayapandian and H. V. Jagadish. 2006. Automating the Design and Construction of Query Forms. In TKDE.","DOI":"10.1109\/ICDE.2006.29"},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"crossref","unstructured":"Bonnie E John and David E Kieras. 1996. The GOMS family of user interface analysis techniques: Comparison and contrast. In TOCHI.","DOI":"10.1145\/235833.236054"},{"key":"e_1_3_2_1_32_1","unstructured":"JQuery. 2021. jQuery. https:\/\/jquery.com\/."},{"key":"e_1_3_2_1_33_1","volume-title":"Dataset: Supermarket Sales. https:\/\/www.kaggle.com\/aungpyaeap\/supermarket-sales.","year":"2021","unstructured":"Kaggle. 2021. Dataset: Supermarket Sales. https:\/\/www.kaggle.com\/aungpyaeap\/supermarket-sales."},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/1978942.1979444"},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/259963.260467"},{"key":"e_1_3_2_1_36_1","unstructured":"Doris Jung-Lin Lee Dixin Tang Kunal Agarwal et al. 20. Lux: Always-on Visualization Recommendations for Exploratory Data Science. VLDB (20)."},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2018.00019"},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/142750.142794"},{"key":"e_1_3_2_1_39_1","doi-asserted-by":"crossref","unstructured":"Jock Mackinlay. 1986. Automating the design of graphical presentations of relational information. In Transactions On Graphics.","DOI":"10.1145\/22949.22950"},{"key":"e_1_3_2_1_40_1","volume-title":"Show Me: Automatic Presentation for Visual Analysis","author":"Mackinlay J.","year":"2007","unstructured":"J. Mackinlay, P. Hanrahan, and Chris Stolte. 2007. Show Me: Automatic Presentation for Visual Analysis. IEEE Transactions on Visualization and Computer Graphics 13 (2007)."},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"crossref","unstructured":"Jock Mackinlay Pat Hanrahan and Chris Stolte. 2007. Show me: Automatic presentation for visual analysis. In TVCG.","DOI":"10.1109\/TVCG.2007.70594"},{"key":"e_1_3_2_1_42_1","unstructured":"Metabase. 2021. Metabase. https:\/\/www.metabase.com."},{"key":"e_1_3_2_1_43_1","volume-title":"Metabase Documentation: SQL Parameters. https:\/\/www.metabase.com\/docs\/latest\/users-guide\/13-sql-parameters.html.","year":"2021","unstructured":"Metabase. 2021. Metabase Documentation: SQL Parameters. https:\/\/www.metabase.com\/docs\/latest\/users-guide\/13-sql-parameters.html."},{"key":"e_1_3_2_1_44_1","doi-asserted-by":"crossref","unstructured":"Dominik Moritz Chenglong Wang Greg L. Nelson H. Lin Adam M. Smith Bill Howe and Jeffrey Heer. 2018. Formalizing Visualization Design Knowledge as Constraints: Actionable and Extensible Models in Draco.. In TVCG.","DOI":"10.31219\/osf.io\/3eg9c"},{"key":"e_1_3_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2018.2865240"},{"key":"e_1_3_2_1_46_1","volume-title":"Visualization analysis and design","author":"Munzner Tamara","unstructured":"Tamara Munzner. 2014. Visualization analysis and design. CRC press."},{"key":"e_1_3_2_1_47_1","unstructured":"Daniel Murray. 2013. Tableau Your Data!: Fast and Easy Visual Analysis with Tableau Software."},{"key":"e_1_3_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2020.3030378"},{"key":"e_1_3_2_1_49_1","doi-asserted-by":"crossref","unstructured":"Jeffrey Nichols Brad A Myers and Kevin Litwack. 2004. Improving automatic interface generation with smart templates. In IUI.","DOI":"10.1145\/964482.964507"},{"key":"e_1_3_2_1_50_1","volume-title":"Plasmic: The visual builder for your tech stack. https:\/\/www.plasmic.app\/.","year":"2021","unstructured":"Plasmic. 2021. Plasmic: The visual builder for your tech stack. https:\/\/www.plasmic.app\/."},{"key":"e_1_3_2_1_51_1","unstructured":"Angel R Puerta Henrik Eriksson John H Gennari and Mark A Musen. 1994. Model-based automated generation of user interfaces. In AAAI."},{"key":"e_1_3_2_1_52_1","unstructured":"React. 2021. A JavaScript library for building user interfaces. https:\/\/reactjs.org\/."},{"key":"e_1_3_2_1_53_1","unstructured":"Retool. 2021. Build internal tools remarkably fast. https:\/\/www.retool.com."},{"key":"e_1_3_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2016.2599030"},{"key":"e_1_3_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-87608-3_1"},{"key":"e_1_3_2_1_56_1","volume-title":"PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models. arXiv preprint arXiv:2109.05093","author":"Scholak Torsten","year":"2021","unstructured":"Torsten Scholak, Nathan Schucher, and Dzmitry Bahdanau. 2021. PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Models. arXiv preprint arXiv:2109.05093 (2021)."},{"key":"e_1_3_2_1_57_1","unstructured":"SDSS. 2021. SDSS Weblog SQL Search. http:\/\/skyserver.sdss.org\/log\/en\/traffic\/sql.asp?url=http:\/\/skyserver.sdss.org\/log\/en\/traffic\/\/\/help\/download\/."},{"key":"e_1_3_2_1_58_1","volume-title":"Sloan Digital Sky Survey","author":"SDSS.","year":"2017","unstructured":"SDSS. 2021. Sloan Digital Sky Survey, 2017. http:\/\/www.sdss.org\/."},{"key":"e_1_3_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.238571"},{"key":"e_1_3_2_1_60_1","doi-asserted-by":"publisher","DOI":"10.1145\/2984511.2984588"},{"key":"e_1_3_2_1_61_1","doi-asserted-by":"publisher","DOI":"10.1038\/nature16961"},{"key":"e_1_3_2_1_62_1","volume-title":"Proceedings of the Eurographics\/IEEE VGTC conference on visualization: Short papers. 55--59","author":"Srinivasan Arjun","year":"2017","unstructured":"Arjun Srinivasan and John Stasko. 2017. Natural language interfaces for data analysis with visualization: Considering what has and could be asked. In Proceedings of the Eurographics\/IEEE VGTC conference on visualization: Short papers. 55--59."},{"key":"e_1_3_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.1145\/1400214.1400234"},{"key":"e_1_3_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.5555\/1894345.1894369"},{"key":"e_1_3_2_1_65_1","doi-asserted-by":"publisher","DOI":"10.1145\/3313831.3376593"},{"key":"e_1_3_2_1_66_1","unstructured":"Tableau. 2012. Tableau Software. http:\/\/www.tableausoftware.com\/."},{"key":"e_1_3_2_1_67_1","unstructured":"Tableau. 2021. Connect to a Custom SQL Query. https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/customsql.htm."},{"key":"e_1_3_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3520153"},{"key":"e_1_3_2_1_69_1","unstructured":"New York Times. 2021. Coronavirus (Covid-19) Data in the United States. https:\/\/github.com\/nytimes\/covid-19-data."},{"key":"e_1_3_2_1_70_1","doi-asserted-by":"crossref","unstructured":"Jean Vanderdonckt. 1994. Automatic generation of a user interface for highly interactive business-oriented applications. In CHI.","DOI":"10.1145\/259963.260104"},{"key":"e_1_3_2_1_71_1","unstructured":"Vega-lite. 2022. Vega-lite Mark Types. https:\/\/vega.github.io\/vega-lite\/docs\/mark.html."},{"key":"e_1_3_2_1_72_1","doi-asserted-by":"publisher","DOI":"10.1145\/3411764.3445249"},{"key":"e_1_3_2_1_73_1","volume-title":"Voyager: Exploratory analysis via faceted browsing of visualization recommendations. In TVCG.","author":"Wongsuphasawat Kanit","year":"2016","unstructured":"Kanit Wongsuphasawat, Dominik Moritz, Anushka Anand, Jock Mackinlay, Bill Howe, and Jeffrey Heer. 2016. Voyager: Exploratory analysis via faceted browsing of visualization recommendations. In TVCG."},{"key":"e_1_3_2_1_74_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536354.2536356"},{"key":"e_1_3_2_1_75_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2007.70515"},{"key":"e_1_3_2_1_76_1","volume-title":"Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. arXiv preprint arXiv:1809.08887","author":"Yu Tao","year":"2018","unstructured":"Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, Dongxu Wang, Zifan Li, James Ma, Irene Li, Qingning Yao, Shanelle Roman, et al. 2018. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. arXiv preprint arXiv:1809.08887 (2018)."},{"key":"e_1_3_2_1_77_1","volume-title":"Are We There Yet? A Review on Existing Perceptual Theory and Experiment Support for Visualization Recommendation Systems. arXiv preprint arXiv:2109.01271","author":"Zeng Zehua","year":"2021","unstructured":"Zehua Zeng, Minhui Xie, Matthew Gouzoulis, and Leilani Battle. 2021. Are We There Yet? A Review on Existing Perceptual Theory and Experiment Support for Visualization Recommendation Systems. arXiv preprint arXiv:2109.01271 (2021)."},{"key":"e_1_3_2_1_78_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3319872"},{"key":"e_1_3_2_1_79_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2020.3030367"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2022 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526166","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526166","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526166","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T18:10:13Z","timestamp":1750183813000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526166"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,10]]},"references-count":78,"alternative-id":["10.1145\/3514221.3526166","10.1145\/3514221"],"URL":"https:\/\/doi.org\/10.1145\/3514221.3526166","relation":{},"subject":[],"published":{"date-parts":[[2022,6,10]]},"assertion":[{"value":"2022-06-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}