Database Integrity in Integrated Systems

José Francisco Zelasco, Judith Donayo



This article makes a proposal, looking into certain aspects of Unified Modelling Language (UML) and Unified Process (UP) usage, when applied to the database integrity in integrated information systems. The usage of some tools and heuristics based on the gathered experience originated on the MERISE method evolution, gives place to comparative benefits while conceiving this type of informatics applications. The heuristic and employed tools consist of starting from a higher level of abstraction provided with inverse engineering and re-engineering instrumentation methods. The knowledge of a minimal data schema enables a global vision. The data integrity is assured by means of verifications between the minimal data diagram and the persistent data object, reducing the number of modifications done to the initially built subsystem data. Finally, the conceptual and organizational levels of treatment allow the comparison of the organization options, yielding naturally into the user manual and object design.


  1. An Lu, Wilfred Ng, 2009: Maintaining consistency of vague databases using data dependencies. Data & Knowledge Engineering, In Press, Corrected Proof, Available online 28 February 2009.
  2. Batini C., S. Ceri y S. B. Navathe, 1991, “Database Design: An Entity-Relationship Approach”, Prentice-Hall.
  3. Ceri, S., Fraternali, P., 1997, “Designing Database Applications with Objects and Rules: The IDEA Methodology” Addison Wesley; 1st edition, ISBN: 0201403692.
  4. Chen, P. S., 1976: “The entity relationship model: to-ward a unified view of data”, ACM Transactions on Data-base Systems, (1), 9-36.
  5. Chu, f., Proth, J-M., Savi, V. M., 1993: “Ordonnancement base sur les reseaux de Petri“. Raport de recher-che No 1960 INRIA Francia.
  6. Dey D., Storey V. C. and Barron T. M., 1999, “Im-proving Database Design trough the Analysis of Relation-ship“, ACM Transactions on Database Systems, 24 (4), 453-486.
  7. Dullea J. and I. Y. Song, 1998, "An Analysis of Struc-tural Validity of Ternary Relationships in Entity Relation-ship Modeling", Proceed. 7º Int. Conf. on Information and Knowledge Management, 331-339.
  8. Eastman C, Stott Parker D. and Tay-Sheng Jeng 1997: “Managing the integrity of design data generated by multiple applications: The principle of patching.” Research in Engineering Design, Volume 9, Number 3 / septiembre de 1997
  9. FAQ Merise et modelisation de donnees - Club d'entraides developpeurs francophones.
  10. González, J. A., Dankel, D., 1993: “The Engineering of Knowledge-Based Systems“. Prentice Hall.
  11. Guoqi Feng, Dongliang Cui, Chengen Wang, Jiapeng Yu 2009: “Integrated data management in complex product collaborative design” Computers in Industry, Volume 60, Issue 1, January 2009, Pages 48-63
  12. He, X., Chu, W., Yang, H., 2003: “A New Approach to Verify Rule-Based Systems Using Petri Nets“. Information and Software Technology 45(10).
  13. Larman Craig, 2001: “Applying UML and Patterns: An Introduction to Object-Oriented. Analysis and Design and the Unified Process” Prentice Hall PTR; 2d edition July 13, ISBN: 0130925691.
  14. Melton J, Simon A R, 2002 “Constraints, Assertions, and Referential Integrity” SQL: 1999, 2002, Pages 355-394
  15. MERISE - Introduction à la conception de systèmes d'information.
  16. Mounyol, R. “MERISE étendue: Cas professionnels de synthèse“. ISBN : 2729895574. Rojer Mounyol ed. Elipses
  17. Post G., Kagan A., 2001:“Database Management systems: design considerations and attribute facilities” Journal of Systems and Software, Volume 56, Issue 2, 1 March 2001, Pages 183-193
  18. Song, I. Y., Evans, M. and Park, E. K., 1995: “A comparative Análisis of EntityRelationship Diagrams”, Journal of Computer and Software Engineering, 3 (4), 427-459.
  19. Tardieu, H., Rochfeld, A., Colletti, R., 1985 “La Méthode MERISE“. Tome 1. ISBN: 2- 7081-1106-X. Ed. Les Edition d'organization.
  20. Tardieu, H., Rochfeld, A., Colletti, R., Panet, G., Va-hée, G., 1987 “La Méthode MERISE“. Tome 2. ISBN: 2-7081-0703-8. Ed. Les Edition d'organization.
  21. Ullman J. D. and J. Windom, 1997, “A FirstCourse in Database Systems”, Prentice-Hall.
  22. Ullman Jeffrey D. & Freeman W. H., 1988, “Principles of Database and Knowledge-Base Systems” Vol. 1, 1a edition, ISBN: 0716781581.
  23. Wu, Q., Zhou, C., Wu, J., Wang, C., 2005: “Study on Knowledge Base Verification Based on Petri Nets. Inter-national Conference on Control and Automation“ (ICCA 2005) Budapest, Hungry, June 27-29.
  24. Yourdon, Inc., 1993: “Yourdon Method“, Prentice-Hall.
  25. Zelasco J. F, Alvano, C. E., Diorio, G., Berrueta, N., O'Neill, P., Gonzalez, C., 1998: “Criterios Metódicos Básicos para Concepción de Bases de Datos Orientadas a Objetos“. Info-Net, III Congreso Internacional y Exposición de Informática e Internet. Proceding en CD. Mendoza, Argentina.
  26. Zelasco J. F., Donayo J., Merayo G., 2007: Complementary Utilities for UML and UP in Information Systems. EATIS 2007 (ACM DL). El Faro, Portugal.
  27. Zhang, D., Nguyen, D., 1994: “PREPARE: A Tool for Knowledge Base Verification“. IEEE Trans. on Knowledge and Data Engineering (6).

Paper Citation

in Harvard Style

Zelasco J. and Donayo J. (2009). Database Integrity in Integrated Systems . In Proceedings of the 7th International Workshop on Modelling, Simulation, Verification and Validation of Enterprise Information Systems - Volume 1: MSVVEIS, (ICEIS 2009) ISBN 978-989-8111-90-6, pages 132-140. DOI: 10.5220/0002200001320140

in Bibtex Style

author={José Francisco Zelasco and Judith Donayo},
title={Database Integrity in Integrated Systems},
booktitle={Proceedings of the 7th International Workshop on Modelling, Simulation, Verification and Validation of Enterprise Information Systems - Volume 1: MSVVEIS, (ICEIS 2009)},

in EndNote Style

JO - Proceedings of the 7th International Workshop on Modelling, Simulation, Verification and Validation of Enterprise Information Systems - Volume 1: MSVVEIS, (ICEIS 2009)
TI - Database Integrity in Integrated Systems
SN - 978-989-8111-90-6
AU - Zelasco J.
AU - Donayo J.
PY - 2009
SP - 132
EP - 140
DO - 10.5220/0002200001320140