ACTIVE MECHANISMS FOR CHECKING PARTICIPATION CONSTRAINTS IN UML

Djamel Berrabah, Charles-François Ducateau, Faouzi Boufarès

Abstract

The automation of the database design process using CASE tools is among the multiple efforts devoted to face the problems of database modeling. These tools often do not take into account all information presented in a conceptual schema. Consequently, the relational elements obtained during these processes do not coincide completely with the conceptual elements, and that produces some semantic losses. The idea is to enrich these tools and to improve them in order to solve some problems of modeling. The goal of this work is to propose an efficient approach to generate mechanisms that preserve the participation constraints during the transformation of a conceptual schema into a relational one.

References

  1. Al-Jumaily, H.T., Cuadra, D., Martinez, P. "Plugging Active Mechanisms to Control Dynamic Aspects Derived from the Multiplicity Constraint in UML", The workshop of 7th International Conference on the Unified Modeling Language, October 2004, Portugal.
  2. Berrabah, D., Boufarès, F., Ducateau, C.F. "Analysing UML Graphic Constraint, How to cope with OCL", 3rd International Conference on Computer Science and its Applications, June 2005, California, USA.
  3. Boufarès, F., Berrabah, D., Ducateau, C.F., Gargouri, F. "Les conflits entre les contraintes dans les schémas conceptuels de Bases de Données : UML - EER", Journal of Information Sciences for Decision Making, Special Issue of The 8th MCSEAI'04, 2005, N°19 Paper number 234.
  4. Boufarès, F. "Un outil intelligent pour l'analyse des schémas EA". Interne Report. Informatics Laboratory of Paris Nord. University of Paris 13. 2001. France.
  5. Ceri, S. and Widom, J. "Deriving production rules for constraint maintenance". In Proc. of the 16th ht. Conf. on Very Large Data Bases, pages 566-577, Brisbane, Australia, August 1990.
  6. Cochrane, R.J., Pirahesh, H. and Mattos, N.M. "Integrating triggers and declarative constraints in SQL database systems". In Proceedings of the Twenty Second International Conference on Very Large Data Bases, pages 567--578, Mumbai, India, September 1996.
  7. Eisenberg, A., Melton, J., Kulkarni, K., Michels, J., Zemke, F. "SQL: 2003 has been published", ACM SIGMOD Record, Volume 33, Issue 1, March 2004.
  8. Elmasri, R., Navathe, S. "Fundamentals of Database Systems ", Fourth Edition, Addison-Wesley, 2004.
  9. Horowitz, B. "Intermediate states as a source of non deterministic behavior in triggers". In Fourth International Workshop on Research Issues in Data Engineering: Active Database Systems, pages 148- 155, Houston, TX, February 1994.
  10. Nanci, D., Espinasse, B. "Ingénierie des systèmes d'information : Merise deuxième generation", (4th edition)". Edition-Vuibert, 2001.
  11. OMG, editor: "UML 2.0 Object Constraint Language Specification", OMG, 2005. http://omg.org.
  12. Rational. http://www-306.ibm.com/software/rational/swbycategory/subcategory/SW710.html
  13. Toby, J. Teorey, "Database Modeling & Design", Third edition, Morgan, Kaufmann Series in data management systems, 1999.
Download


Paper Citation


in Harvard Style

Berrabah D., Ducateau C. and Boufarès F. (2006). ACTIVE MECHANISMS FOR CHECKING PARTICIPATION CONSTRAINTS IN UML . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 310-313. DOI: 10.5220/0002453903100313


in Bibtex Style

@conference{iceis06,
author={Djamel Berrabah and Charles-François Ducateau and Faouzi Boufarès},
title={ACTIVE MECHANISMS FOR CHECKING PARTICIPATION CONSTRAINTS IN UML},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={310-313},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002453903100313},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ACTIVE MECHANISMS FOR CHECKING PARTICIPATION CONSTRAINTS IN UML
SN - 978-972-8865-41-2
AU - Berrabah D.
AU - Ducateau C.
AU - Boufarès F.
PY - 2006
SP - 310
EP - 313
DO - 10.5220/0002453903100313