Proactive wrangling: Mixed-initiative end-user programming of data transformation scripts

UIST'11 - Proceedings of the 24th Annual ACM Symposium on User Interface Software and Technology

Volumn , Issue , 2011, Pages 65-74

  Guo, Philip J ^a   Kandel, Sean ^a   Hellerstein, Joseph M ^b   Heer, Jeffrey ^a  

^a STANFORD UNIVERSITY   (United States)

^b UNIVERSITY OF CALIFORNIA   (United States)

Author keywords

Data cleaning; Data transformation; End user programming; Mixed initiative interfaces

Indexed keywords

ANALYSIS TOOLS; COMPUTATIONAL TOOLS; DATA CLEANING; DATA TRANSFORMATION; DATA TRANSFORMS; DELIMITERS; END USER PROGRAMMING; INPUT DATAS; INTERACTIVE TOOL; MIXED-INITIATIVE; USER STUDY;

COMPUTER PROGRAMMING; DATA REDUCTION; USER INTERFACES;

METADATA;

EID: 80755144051     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2047196.2047205     Document Type: Conference Paper

References (23)

1. M. Burnett. Visual programming. In J. G. Webster, editor, Encyclopedia of Electrical and Electronics Engineering. John Wiley & Sons Inc., 1999.
2. A. Cypher. Watch What I Do: Programming by Demonstration. MIT Press, 1993.
3. T. Dasu and T. Johnson. Exploratory Data Mining and Data Cleaning. John Wiley & Sons, Inc., New York, NY, 2003.
4. M. Dontcheva, S. M. Drucker, D. Salesin, and M. F. Cohen. Relations, cards, and search templates: user-guided web data integration and layout. In ACM UIST, pages 61-70, 2007. (Pubitemid 351429338)
5. K. Fisher and D. Walker. The Pads project: An overview. In International Conference on Database Theory, March 2011.
6. H. Galhardas, D. Florescu, D. Shasha, and E. Simon. Ajax: an extensible data cleaning tool. In ACM SIGMOD, page 590, 2000.
7. T. R. G. Green. Cognitive dimensions of notations. In British Computer Society, Human-Computer Interaction Specialist Group on People and Computers V, pages 443-460. Cambridge University Press, 1989.
8. S. Gulwani. Automating string processing in spreadsheets using input-output examples. In ACM POPL, pages 317-330, 2011.
9. W. Harris and S. Gulwani. Spreadsheet table transformations from examples. In ACM PLDI, 2011.
10. E. Horvitz. Principles of mixed-initiative user interfaces. In ACM CHI, pages 159-166, 1999.
11. D. Huynh and S. Mazzocchi. Google Refine. http://code.google.com/p/ google-refine/.
12. D. F. Huynh, R. C. Miller, and D. R. Karger. Potluck: semi-ontology alignment for casual users. In ISWC, pages 903-910, 2007.
13. S. Kandel, A. Paepcke, J. Hellerstein, and J. Heer. Wrangler: Interactive visual specification of data transformation scripts. In ACM CHI, 2011.
14. L. V. S. Lakshmanan, F. Sadri, and S. N. Subramanian. SchemaSQL: An extension to SQL for multidatabase interoperability. ACM TODS, 26(4):476-519, 2001. (Pubitemid 33649616)
15. G. Leshed, E. M. Haber, T. Matthews, and T. Lau. CoScripter: automating & sharing how-to knowledge in the enterprise. In ACM CHI, pages 1719-1728, 2008.
16. J. Lin, J. Wong, J. Nichols, A. Cypher, and T. A. Lau. End-user programming of mashups with Vegemite. In IUI, pages 97-106, 2009.
17. G. Little and R. C. Miller. Translating keyword commands into executable code. In ACM UIST, pages 135-144, 2006. (Pubitemid 47142434)
18. M. Mernik, J. Heering, and A. M. Sloane. When and how to develop domain-specific languages. ACM Comput. Surv., 37(4):316-344, 2005. (Pubitemid 43898543)
19. R. C. Miller and B. A. Myers. Interactive simultaneous editing of multiple text regions. In USENIX Tech. Conf., pages 161-174, 2001.
20. B. A. Myers, A. J. Ko, and M. M. Burnett. Invited research overview: end-user programming. In ACM CHI Extended Abstracts, pages 75-80, 2006.
21. V. Raman and J. M. Hellerstein. Potter's wheel: An interactive data cleaning system. In Proc. VLDB, 2001.
22. R. Tuchinda, P. Szekely, and C. A. Knoblock. Building mashups by example. In ACM IUI, pages 139-148, 2008.
23. H. Varian. Hal Varian on how the Web challenges managers. In McKinsey Quarterly, Jan 2009.