Skip to main content
SpringerLink
Log in

Facilitating Data-Metadata Transformation by Domain Specialists in a Web-Based Information System Using Simple Correspondences

  • Conference paper
  • First Online:
Conceptual Modeling (ER 2016)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 9974))

Included in the following conference series:

Abstract

We seek to empower domain specialists and non-technical web designers to be able to design and configure their system directly, without necessarily requiring interaction with a software developer or DB specialist. We observe that structured information shown on a web page presents a conceptual model of the information shown; and, that such web pages make a variety of choices regarding whether or not application information is presented in the data (with or without schema labels) or in the metadata (schema). Also, the same application may present the same data in different schemas on different pages. In this paper, we extend our earlier work—on providing generic widgets for structured information that can be easily used and configured by domain specialists—to also include data/metadata transformation. Thus, we put data/metadata transformation (from one conceptual model to another) in the hands of domain specialists without database expertise. The contributions of this paper are: showing how our approach can be used to support data/metadata transformation in both directions and demonstrating this capability in a non-trivial case study. The paper also provides evidence that non-expert users can successfully provide simple correspondences through the results of a small-scale user study.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    In our earlier papers, we called it local dominance.

  2. 2.

    http://computingportal.org.

  3. 3.

    http://computingportal.org/node/11172.

  4. 4.

    We use a straightforward translation of the ER model of the domain structures into the relational model.

References

  1. Allen, R.B.: Two digital library interfaces that exploit hierarchical structure. In: Proceedings of DAGS 1995. Electronic Publishing and the Information Superhighway (1995)

    Google Scholar 

  2. Bernstein, P.A., Melnik, S.: Model management 2.0: manipulating richer mappings. In: Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data, SIGMOD 2007, pp. 1–12. ACM, New York (2007)

    Google Scholar 

  3. Britell, S., Delcambre, L.M.L., Atzeni, P.: Flexible information integration with local dominance. In: International Conference on Information Modelling and Knowledge Bases, Kiel, Germany (2014)

    Google Scholar 

  4. Britell, S., Delcambre, L.M.L.: Mapping semantic widgets to web-based, domain-specific collections. In: Atzeni, P., Cheung, D., Ram, S. (eds.) ER 2012. LNCS, vol. 7532, pp. 204–213. Springer, Heidelberg (2012). doi:10.1007/978-3-642-34002-4_16

    Chapter  Google Scholar 

  5. Britell, S., Delcambre, L.M.L., Atzeni, P.: Generic data manipulation in a mixed global/local conceptual model. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 246–259. Springer, Heidelberg (2014). doi:10.1007/978-3-319-12206-9_20

    Google Scholar 

  6. Cunningham, C., Galindo-Legaria, C.A., Graefe, G.: Pivot and unpivot: optimization and execution strategies in an RDBMs. In: VLDB 2004, pp. 998–1009. VLDB Endowment (2004)

    Google Scholar 

  7. Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336(1), 89–124 (2005)

    Article  MathSciNet  MATH  Google Scholar 

  8. Gupta, A., Harinarayan, V., Quass, D.: Generalized projections: a powerful approach to aggregation. In: Proceedings of 21st VLDB Conference, pp. 11–15 (1995)

    Google Scholar 

  9. Haas, L.M., Hernández, M.A., Ho, H., Popa, L., Roth, M.: Clio grows up: from research prototype to industrial tool. In: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, SIGMOD 2005, pp. 805–810. ACM, New York (2005)

    Google Scholar 

  10. Hearst, M.A.: Design recommendations for hierarchical faceted search interfaces. In: Proceedings of SIGIR 2006 Workshop on Faceted Search (2006)

    Google Scholar 

  11. Hernández, M.A., Papotti, P., Tan, W.C.: Data exchange with data-metadata translations. Proc. VLDB Endow. 1(1), 260–273 (2008)

    Article  Google Scholar 

  12. Lakshmanan, L.V.S., Sadri, F., Subramanian, I.N.: SchemaSQL - a language for interoperability in relational multi-database systems. In: VLDB 1996, pp. 239–250. Morgan Kaufmann Publishers Inc., San Francisco (1996)

    Google Scholar 

  13. Madhavan, J., Jeffery, S.R., Cohen, S., Dong, X.L., Ko, D., Yu, C., Halevy, A.: Web-scale data integration: you can only afford to pay as you go. World Wide Web Internet Web Inf. Syst. 7, 342–350 (2007)

    Google Scholar 

  14. Marchionini, G.: Exploratory search: from finding to understanding. Commun. ACM 49(4), 41 (2006)

    Article  Google Scholar 

  15. Papotti, P., Torlone, R.: Schema exchange: generic mappings for transforming data and metadata. Data Knowl. Eng. 68(7), 665–682 (2009)

    Article  Google Scholar 

  16. Sacco, G.: Dynamic taxonomies: a model for large information bases. IEEE Trans. Knowl. Data Eng. 12(3), 468–479 (2000)

    Article  Google Scholar 

  17. Schek, H.J., Scholl, M.H.: The relational model with relation-valued attributes. Inf. Syst. 11(2), 137–147 (1986)

    Article  MATH  Google Scholar 

  18. Wyss, C.M., Robertson, E.L.: A formal characterization of pivot/unpivot. In: Proceedings of the 14th ACM International Conference on Information and Knowledge Management, CIKM 2005, pp. 602–608. ACM, New York (2005)

    Google Scholar 

  19. Wyss, C.M., Robertson, E.L.: Relational languages for metadata integration. ACM Trans. Database Syst. 30(2), 624–660 (2005)

    Article  Google Scholar 

  20. Yee, K.P., Swearingen, K., Li, K., Hearst, M.: Faceted metadata for image search and browsing. In: CHI 2003, p. 401, April 2003

    Google Scholar 

Download references

Acknowledgments

This work was supported in part by National Science Foundation grants 0840668 and 1250340. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Author information

Authors and Affiliations

  1. Department of Computer Science, Portland State University, PO Box 751, Portland, OR, 97207, USA

    Scott Britell & Lois M. L. Delcambre

  2. Dipartimento di Ingegneria, Università Roma Tre, Via della Vasca Navale 79, 00146, Roma, Italy

    Paolo Atzeni

Authors
  1. Scott Britell
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Lois M. L. Delcambre
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Paolo Atzeni
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Scott Britell .

Editor information

Editors and Affiliations

  1. CEDRIC-CNAM & ESSEC Business School, Cergy-Pontoise, France

    Isabelle Comyn-Wattiau

  2. Kyoto University , Kyoto, Japan

    Katsumi Tanaka

  3. Drexel University , Philadelphia, Pennsylvania, USA

    Il-Yeol Song

  4. Nagoya University , Nagoya, Japan

    Shuichiro Yamamoto

  5. Tokyo Institute of Technology , Tokyo, Japan

    Motoshi Saeki

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing AG

About this paper

Cite this paper

Britell, S., Delcambre, L.M.L., Atzeni, P. (2016). Facilitating Data-Metadata Transformation by Domain Specialists in a Web-Based Information System Using Simple Correspondences. In: Comyn-Wattiau, I., Tanaka, K., Song, IY., Yamamoto, S., Saeki, M. (eds) Conceptual Modeling. ER 2016. Lecture Notes in Computer Science(), vol 9974. Springer, Cham. https://doi.org/10.1007/978-3-319-46397-1_34

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-46397-1_34

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-46396-4

  • Online ISBN: 978-3-319-46397-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation