The User Interface Is the Conceptual Model

  • James F. Terwilliger
  • Lois M. L. Delcambre
  • Judith Logan
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4215)


Frequently, the structure and description of the data in a database bears little resemblance to the structure and description of data as it appears in the tool that captured it. This makes it difficult for users to write queries because they receive little information from the database schema regarding the precise meaning of the data. We assert that the semantics of data can be more reliably understood by viewing the data in the context of the user interface (UI) of the software tool used to enter the data rather than the bare framework of a database. GUAVA (GUi As View) presents a conceptual model that captures information about user interface components. In this paper, we describe how to model a forms-based UI using a GUAVA-tree (g-tree), which can be used to generate a natural schema against which querying is simple. We then introduce and formalize the notion of a channel of database transformation operators from the natural schema to the underlying physical schema.


User Interface Inverse Operator Database Schema Context Element Attribute Node 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Clinical Outcomes Research Initiative (2006), available at: (last accessed on April 10, 2006)
  2. 2.
    Du, F., Amir-Yahia, S., Freire, J.: A comprehensive solution to the XML-to-relational mapping problem. In: Proceedings of the 6th Annual ACM International Workshop on Web Information and Data Management, Washington DC, November 12-13, pp. 31–38 (2004)Google Scholar
  3. 3.
    Lakshmanan, L.V.S., Sadri, F., Subramanian, S.N.: On efficiently implementing SchemaSQL on a SQL database system. In: Proceedings of the International Conference on Very Large Databases (VLDB 1999), Edinburg, Scotland, September 1999, pp. 471–482 (1999)Google Scholar
  4. 4.
    Larson, J.A., Navathe, S.B., Elmasri, R.: A Theory of Attribute Equivalence in Databases with Application to Schema Integration. IEEE Transactions on Software Engineering 15(4), 449–463 (1989)MATHCrossRefGoogle Scholar
  5. 5.
    Miller, R.J.: Using Schematically Heterogeneous Structures. In: Proceedings of ACM SIGMOD, Seattle, WA, vol. 27(2), pp. 189–200 (June 1998)Google Scholar
  6. 6.
    Miller, R.J., Hernandez, M.A., Haas, L.M., Yan, L.-L., Ho, C.T.H., Fagin, R., Popa, L.: The Clio Project: Managing Heterogeneity. SIGMOD Record 30(1), 78–83 (2001)CrossRefGoogle Scholar
  7. 7.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. In: Proceedings of the 27th International Conferences on Very Large Databases, vol. 10(4), pp. 334–350 (2001)Google Scholar
  8. 8.
    Rollinson, S.R., Roberts, S.A.: Formalizing the Informational Content of Database User Interfaces. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 65–77. Springer, Heidelberg (1998)Google Scholar
  9. 9.
    Ruby on Rails (2006), available at: (last accessed on April 10, 2006)
  10. 10.
    Sciore, E., Siegel, M., Rosenthal, A.: Using semantic values to facilitate interoperability among heterogeneous information systems. ACM Transactions on Database Systems 19(2), 254–290 (1994)CrossRefGoogle Scholar
  11. 11.
    Terwilliger, J.F., Delcambre, L.M.L., Logan, J.: Context-Sensitive Clinical Data Integration. In: Grust, T., Höpfner, H., Illarramendi, A., Jablonski, S., Mesiti, M., Müller, S., Patranjan, P.-L., Sattler, K.-U., Spiliopoulou, M., Wijsen, J. (eds.) EDBT 2006. LNCS, vol. 4254, pp. 387–398. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  12. 12.
    Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., Skiadopoulos, S.: A generic and customizable framework for the design of ETL scenarios. Information Systems 30(7), 492–525 (2005)CrossRefGoogle Scholar
  13. 13.
    XAML (2006), available at: (last accessed on April 10, 2006)
  14. 14.
    XUL (2006), available at: (last accessed on April 10, 2006)

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • James F. Terwilliger
    • 1
  • Lois M. L. Delcambre
    • 1
  • Judith Logan
    • 2
  1. 1.Department of Computer SciencePortland State UniversityPortlandUSA
  2. 2.Department of Medical Informatics and Clinical Epidemiology, School of MedicineOregon Health and Science UniversityPortlandUSA

Personalised recommendations