Wrangler: Interactive visual specification of data transformation scripts

Conference on Human Factors in Computing Systems - Proceedings

Volumn , Issue , 2011, Pages 3363-3372

  Kandel, Sean ^a   Paepcke, Andreas ^a   Hellerstein, Joseph ^b   Heer, Jeffrey ^a  

^a STANFORD UNIVERSITY   (United States)

^b UNIVERSITY OF CALIFORNIA   (United States)

Author keywords

Data cleaning; Programming by demonstration

Indexed keywords

METADATA; QUALITY CONTROL; SEMANTICS;

DATA ANALYSIS TOOL; DATA CLEANING; DATA LAYOUTS; DATA QUALITY; DATA VALUES; DATUM TRANSFORMATION; MISSING VALUES; PROGRAMMING BY DEMON-STRATION; QUALITY ISSUES; VISUAL SPECIFICATION;

SPECIFICATIONS;

EID: 79958148978     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1978942.1979444     Document Type: Conference Paper

References (26)

1. A. Arasu and H. Garcia-Molina. Extracting structured data from web pages. In ACM SIGMOD, pages 337-348, 2003.
2. A. F. Blackwell. SWYN: A visual representation for regular expressions. In Your Wish is my Command: Programming by Example, pages 245-270, 2001.
3. L. Chiticariu, P. G. Kolaitis, and L. Popa. Interactive generation of integrated schemas. In ACM SIGMOD, pages 833-846, 2008.
4. T. Dasu and T. Johnson. Exploratory Data Mining and Data Cleaning. John Wiley & Sons, Inc., New York, NY, 2003.
5. T. Dasu, T. Johnson, S. Muthukrishnan, and V. Shkapenyuk. Mining database structure; or, how to build a data quality browser. In ACM SIGMOD, pages 240-251, 2002. (Pubitemid 34985551)
6. A. K. Elmagarmid, P. G. Ipeirotis, and V. S. Verykios. Duplicate record detection: A survey. IEEE TKDE, 19(1):1-16, 2007. (Pubitemid 44955773)
7. K. Fisher and R. Gruber. Pads: a domain-specific language for processing ad hoc data. In ACM PLDI, pages 295-304, 2005.
8. H. Galhardas, D. Florescu, D. Shasha, and E. Simon. Ajax: an extensible data cleaning tool. In ACM SIGMOD, page 590, 2000.
9. L. M. Haas, M. A. Hernández, H. Ho, L. Popa, and M. Roth. Clio grows up: from research prototype to industrial tool. In ACM SIGMOD, pages 805-810, 2005. (Pubitemid 43038980)
10. J. M. Hellerstein. Quantitative data cleaning for large databases, 2008. White Paper, United Nations Economic Commission for Europe.
11. V. Hodge and J. Austin. A survey of outlier detection methodologies. Artif. Intell. Rev., 22(2):85-126, 2004.
12. E. Horvitz. Principles of mixed-initiative user interfaces. In ACM CHI, pages 159-166, 1999.
13. D. Huynh and S. Mazzocchi. Google Refine. http://code.google.com/p/ google-refine/.
14. D. F. Huynh, R. C. Miller, and D. R. Karger. Potluck: semi-ontology alignment for casual users. In ISWC, pages 903-910, 2007.
15. Z. G. Ives, C. A. Knoblock, S. Minton, M. Jacob, P. Pratim, T. R. Tuchinda, J. Luis, A. Maria, and M. C. Gazen. Interactive data integration through smart copy & paste. In CIDR, 2009.
16. H. Kang, L. Getoor, B. Shneiderman, M. Bilgic, and L. Licamele. Interactive entity resolution in relational data: A visual analytic tool and its evaluation. IEEE TVCG, 14(5):999-1014, 2008.
17. L. V. S. Lakshmanan, F. Sadri, and S. N. Subramanian. SchemaSQL: An extension to SQL for multidatabase interoperability. ACM Trans. Database Syst., 26(4):476-519, 2001. (Pubitemid 33649616)
18. 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.
19. R. C. Miller and B. A. Myers. Interactive simultaneous editing of multiple text regions. In USENIX Tech. Conf., pages 161-174, 2001.
20. D. A. Norman. The Design of Everyday Things. Basic Books, 2002.
21. E. Rahm and P. A. Bernstein. A survey of approaches to automatic schema matching. The VLDB Journal, 10:334-350, 2001. (Pubitemid 33570972)
22. V. Raman and J. M. Hellerstein. Potter's wheel: An interactive data cleaning system. In VLDB, pages 381-390, 2001.
23. G. G. Robertson, M. P. Czerwinski, and J. E. Churchill. Visualization of mappings between schemas. In ACM CHI, pages 431-439, 2005. (Pubitemid 41809080)
24. C. Scaffidi, B. Myers, and M. Shaw. Intelligently creating and recommending reusable reformatting rules. In ACM IUI, pages 297-306, 2009.
25. S. Soderland. Learning information extraction rules for semi-structured and free text. Mach. Learn., 34(1-3):233-272, 1999.
26. R. Tuchinda, P. Szekely, and C. A. Knoblock. Building mashups by example. In ACM IUI, pages 139-148, 2008.