Maintaining Mappings between Conceptual Models and Relational Schemas

Maintaining Mappings between Conceptual Models and Relational Schemas

Yuan An, Xiaohua Hu, Il-Yeol Song
ISBN13: 9781613504710|ISBN10: 1613504713|EISBN13: 9781613504727
DOI: 10.4018/978-1-61350-471-0.ch010
Cite Chapter Cite Chapter

MLA

An, Yuan, et al. "Maintaining Mappings between Conceptual Models and Relational Schemas." Cross-Disciplinary Models and Applications of Database Management: Advancing Approaches, edited by Keng Siau, IGI Global, 2012, pp. 245-276. https://doi.org/10.4018/978-1-61350-471-0.ch010

APA

An, Y., Hu, X., & Song, I. (2012). Maintaining Mappings between Conceptual Models and Relational Schemas. In K. Siau (Ed.), Cross-Disciplinary Models and Applications of Database Management: Advancing Approaches (pp. 245-276). IGI Global. https://doi.org/10.4018/978-1-61350-471-0.ch010

Chicago

An, Yuan, Xiaohua Hu, and Il-Yeol Song. "Maintaining Mappings between Conceptual Models and Relational Schemas." In Cross-Disciplinary Models and Applications of Database Management: Advancing Approaches, edited by Keng Siau, 245-276. Hershey, PA: IGI Global, 2012. https://doi.org/10.4018/978-1-61350-471-0.ch010

Export Reference

Mendeley
Favorite

Abstract

This paper describes a round-trip engineering approach for incrementally maintaining mappings between conceptual models and relational schemas. When either schema or conceptual model evolves to accommodate new information needs, the existing mapping must be maintained accordingly to continuously provide valid services. In this paper, the authors examine the mappings specifying “consistent” relationships between models. First, they define the consistency of a conceptual-relational mapping through “semantically compatible” instances. Next, the authors analyze the knowledge encoded in the standard database design process and develop round-trip algorithms for incrementally maintaining the consistency of conceptual-relational mappings under evolution. Finally, they conduct a set of comprehensive experiments. The results show that the proposed solution is efficient and provides significant benefits in comparison to the mapping reconstructing approach.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.