James F. Terwilliger James F. Terwilliger, Ph.D.

james dot terwilliger # hotmail dot com
A full list of my publications can be found on DBLP.
You can find my full CV here.
Yes, that is me singing opera in a museum while wearing a kilt.

Research Interests:


My primary interests are in conceptual modeling; information integration; bidirectional data transformation; data and schema evolution; and query languages and interfaces. My dissertation research focused on finding new ways to query or update data and schema through complex views. My current work focus is on allowing users of all skill levels to find, manipulate, and share data seamlessly.
 
Microsoft Codename Data Explorer

DATA EXPLORER:

Microsoft Codename Data Explorer is a tool for discovering, transforming, and publishing data. The product has both a downloadable client and a cloud offering. I am a Senior Software Developer on the team, and have worked extensively with how the tool works with external data sources.
Have you found the pony in your data?

Publications:

  • S. J. Maine, L. Prem, C. A. Szyperski, and J. F. Terwilliger. Microsoft Codename "Montego" - Data Import, Transformation, and Publication for Information Workers. PVLDB 4(12) (VLDB 2011), 1454-1457.
 
Bidirectional Transformations (BX)

BIDIRECTIONAL TRANFORMATIONS:

Since 2008, I have helped coordinate a series of cross-disciplinary seminars and workshops on bidirectional transformations of data. Different disciplines in computer science have developed divergent but similar techniques for modeling or implementing reversible, invertible, or otherwise two-directional data transformations. These events have served as a way to introduce researchers and industrial practitioners to technologies outside of their speciality, and to hopefully unify or taxonomize these ideas to improve collaboration.

Publications:

  • J. F. Terwilliger. Bidirectional by Necessity. GTTSE 2011 (to appear).
  • Z. Hu, A. Schürr, P. Stevens, J. F. Terwilliger. Dagstuhl seminar on bidirectional transformations (BX). SIGMOD Record 40(1): 35-39.
  • Z. Hu, A. Schürr, P. Stevens, J. F. Terwilliger. Bidirectional Transformation "bx" (Dagstuhl Seminar 11031). Dagstuhl Reports 1(1): 42-67.
  • K. Czarnecki, J. N. Foster, Z. Hu, R. Laemmel, A. Schurr, and J. F. Terwilliger. Bidirectional Transformations: A Cross-Discipline Perspective, GRACE Meeting Notes, State of the Art, and Outlook. ICMT 2009, 260-283.
 
Microsoft Research

DATA MODELING AND SCHEMA EVOLUTION:

During my time as a PhD student at Portland State and an intern and post-doctoral researcher at Microsoft Research, my research focus was on novel ways to handle schema evolution in the presence of a mapping or a conceptual model.

Publications (XML data management):

  • L. J. Chen, P. A. Bernstein, P. Carlin, D. Filipovic, M. Rys, N. Shamgunov, J. F. Terwilliger, M. Todic, S. Tomasevic, and D. Tomic. Mapping XML to a Sparse, Wide Table. ICDE 2012 (to appear).
  • J. F. Terwilliger, P. A. Bernstein, and S. Melnik. Full-Fidelity Strongly Typed Object-Oriented XML Access. PVLDB 2(1) (VLDB 2009): 1030-1041.
  • J. F. Terwilliger, S. Melnik, and P. A. Bernstein. Language-Integrated Querying of XML Data in SQL Server. PVLDB 1(2) (VLDB 2008), 1396-1399.

Publications (Schema evolution):

  • M. Hartung, J. F. Terwilliger, and E. Rahm. Recent Advances in Schema and Ontology Evolution. Chapter 6 in Schema Matching and Mapping, Springer-Verlag, ISBN 978-3-642-16517-7, 149-190.
  • J. F. Terwilliger, R. J. Fernandez, L. M. L. Delcambre, and D. Maier. Support for Schema Evolution in Data Stream Management Systems. J. UCS 16(20), 3073-3101.
  • R. J. Fernandez, J. F. Terwilliger, L. M. L. Delcambre, and D. Maier. Towards Formal Semantics for Data and Schema Evolution in Data Stream Management Systems. ETheCom 2009 (ER Workshops 2009), 85-94.

Publications (Object-relational mapping management):

  • J. F. Terwilliger, P. A. Bernstein, and A. Unnithan. Automated Co-evolution of Conceptual Models, Physical Databases, and Mappings. ER 2010, 146-159.
  • J. F. Terwilliger, P. A. Bernstein, and A. Unnithan. Worry-free database upgrades: automated model-driven evolution of schemas and complex mappings. SIGMOD 2010, 1191-1194.
  • A. Malpani, P. A. Bernstein, S. Melnik, and J. F. Terwilliger. Reverse Engineering Models from Databases to Bootstrap Application Development. ICDE 2010, 1177-1180.
 
The Guava Project

GUAVA (GUI-As-View):

Guava is a framework that allows the user interface of an application to generate most of the rest of the artifacts of a software application semi-automatically, such as in-memory data structures and a persistent database. It also generates a query interface that resembles the original UI; using this interface, a novice user can pose educated queries of the database without ever using SQL or knowing the database schema.

Publications:

  • J. F. Terwilliger, L. M. L. Delcambre, J. R. Logan, D. Maier, D. W. Archer, J. Steinhauer, and S. Britell. Enabling revisitation of fine-grained clinical information. In Proceedings of the 1st ACM International Health Informatics Symposium (IHI '10), 420-424.
  • J. F. Terwilliger, L. M. L. Delcambre, D. Maier, J. Steinhauer, and S. Britell. Updatable and Evolvable Transforms for Virtual Databases. PVLDB 3(1) (VLDB 2010), 309-319.
  • J. F. Terwilliger, L. M. L. Delcambre, and J. Logan. Querying Through a User Interface. Data and Knowledge Engineering (DKE) Journal, December 2007, 63(3):748–768.
  • J. F. Terwilliger, L. M. L. Delcambre, and J. Logan. The User Interface is the Conceptual Model. ER 2006, 424–436. Ranked as one of the best papers at the conference.
  • J. F. Terwilliger, L. M. L. Delcambre, and J. Logan. Context-Sensitive Data Integration. In Proceedings of the EDBT 2006 Workshops, 387–398.
Portland State

Teaching Experience:

CS 510 Information Integration, Portland State University
  • Winter 2008 (Co-Instructor)
  • Winter 2006 (Co-Instructor)
  • Fall 2003 (Teaching Assistant - at OHSU School of Engineering, listed as CSE 506)
CS 386/586 Introduction to Databases, Portland State University
  • Fall 2008 (Co-Instructor)
  • Winter 2007 (Co-Instructor)
  • Fall 2005 (Co-Instructor)
  • Fall 2003 (Teaching Assistant - at OHSU School of Engineering, listed as CSE 514)
CS 251 Logical Structures, Portland State University
  • Spring 2007 (Instructor)
CS 510 Principles of Database Systems, Portland State University
  • Spring 2007 (Co-Instructor, Temporal Databases unit)
Portland Opera

OPERA:

I was a regular member of the chorus of Portland Opera for seven amazing years.  Click here to see pictures from each of the shows that I have been in, and a few of my thoughts about the shows.