MDD Approach for Maintaining Integrity Constraints in Databases

MDD Approach for Maintaining Integrity Constraints in Databases

Harith T. Al-Jumaily, Dolores Cuadra, Paloma Martínez
ISBN13: 9781605662428|ISBN10: 1605662429|EISBN13: 9781605662435
DOI: 10.4018/978-1-60566-242-8.ch017
Cite Chapter Cite Chapter

MLA

Al-Jumaily, Harith T., et al. "MDD Approach for Maintaining Integrity Constraints in Databases." Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, edited by Viviana E. Ferraggine, et al., IGI Global, 2009, pp. 145-153. https://doi.org/10.4018/978-1-60566-242-8.ch017

APA

Al-Jumaily, H. T., Cuadra, D., & Martínez, P. (2009). MDD Approach for Maintaining Integrity Constraints in Databases. In V. Ferraggine, J. Doorn, & L. Rivero (Eds.), Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends (pp. 145-153). IGI Global. https://doi.org/10.4018/978-1-60566-242-8.ch017

Chicago

Al-Jumaily, Harith T., Dolores Cuadra, and Paloma Martínez. "MDD Approach for Maintaining Integrity Constraints in Databases." In Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, edited by Viviana E. Ferraggine, Jorge Horacio Doorn, and Laura C. Rivero, 145-153. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-242-8.ch017

Export Reference

Mendeley
Favorite

Abstract

In the context of database, we believe that MDD (Model-Driven Development) (OMG, 2006) is a very ambitious task because we find that when applying database development methodologies such as (Elmasri, et al., 2007), there are processes devoted to transforming conceptual into logical schemata. In such processes, semantic losses are produced since logical elements are not coincident with conceptual elements. A correct constraints transformation is necessary to preserve the semantics that reflects the Universe of Discourse. The multiplicity constraint, also called cardinality constraint, is one of these constraints that can be established in a conceptual schema. It has dynamic aspects that are transformed into the logical model as certain conditions to verify the insertion, deletion, and update operations. The verification of these constraints is a serious and complex problem because currently database systems are not able to preserve the multiplicity constraints of their objects. To solve the modeling problem, CASE tools have been introduced to automate the life cycle of database development. These platforms try to help the database developers in different design phases. Nevertheless, these tools are frequently simple graphical interfaces and do not completely carryout the design methodology that they are should to support.

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.