Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Clinical Outcomes Research Initiative (2006), available at: http://www.cori.org/ (last accessed on April 10, 2006)
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)
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)
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)
Miller, R.J.: Using Schematically Heterogeneous Structures. In: Proceedings of ACM SIGMOD, Seattle, WA, vol. 27(2), pp. 189–200 (June 1998)
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)
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)
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)
Ruby on Rails (2006), available at: http://www.rubyonrails.org/ (last accessed on April 10, 2006)
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)
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)
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)
XAML (2006), available at: http://www.xaml.net/ (last accessed on April 10, 2006)
XUL (2006), available at: http://www.xulplanet.com/ (last accessed on April 10, 2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Terwilliger, J.F., Delcambre, L.M.L., Logan, J. (2006). The User Interface Is the Conceptual Model. In: Embley, D.W., Olivé, A., Ram, S. (eds) Conceptual Modeling - ER 2006. ER 2006. Lecture Notes in Computer Science, vol 4215. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11901181_32
Download citation
DOI: https://doi.org/10.1007/11901181_32
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-47224-7
Online ISBN: 978-3-540-47227-8
eBook Packages: Computer ScienceComputer Science (R0)