ON THE SEMI-AUTOMATIC VALIDATION AND DECOMPOSITION OF TERNARY RELATIONSHIPS WITH OPTIONAL ELEMENTS

Ignacio-J. Santos, Paloma Martínez Fernandez, Dolores Cuadra

2007

Abstract

This paper analyzes the problems that concern the design of databases. CASE tools supply a resources kit for the design and creation of database in a DBMS (Database Management System). Sometimes, these tools only help to draw diagrams. Ideally, they would verify and validate DB design and transform it from Conceptual to Logical Model. In a last step, they would transform the Logical Model to a specific DBMS. Currently, commercial tools do not verify or validate the model in an optimal way. This paper is focused on the validation and checking of database schemas. This work specially analyzes the ternary or higher-order relationships when there are optional components.

References

  1. Bouzeghoub, M., Kedad, Z., Métais, E. “CASE Tools: Computer Support for Conceptual Modeling”, chapter 13 of “Advanced Database Technology and Design” of Piattini, M. and Díaz Oscar. Ed. Artech House, Inc. 2000.
  2. Camps, R. (2002) “From Ternary Relationship to relational tables: A case against common beliefs”. ACM/SIGMON Record 31, July 2nd 2002.
  3. Cuadra, D. (2003). “Aproximación formal a las restricciones de cardinalidad en un marco metodológico de desarrollo de Bases de Datos”. Doctoral thesis. Carlos III University of Madrid. Computer Science Department.
  4. Dullea, James and Il Yeol Sung (1998). “An Analysis of the Structural Validity of Ternary Relationships in Entity Relationship Modeling”. CIKM, pages 331- 339.
  5. Al-Jumaily, Harith T. (September 2006). “Aplicación de Técnicas Activas para el Control de Restricciones en el Desarrollo de Bases de Datos”. Doctoral thesis, Carlos III University of Madrid, Computer Science Department.
  6. McAllister, Andrew. (1997). “ Complete roles for n-ary relationship cardinality constraint”. Data & Knowledge Engineering 27 pages 255-288.
  7. McAllister Andrew J. and Sharpe David. February 1998. “An approach for decomposing N-ary Data Relationships”. Software-Practice &Experience 28(2), pages 125-154.
  8. Millist W. Vincent and Bala Srinivasan. (1993). “A Note on Relation Schemes which are in 3NF but not in BCNF”, in Information Processing Letters 48 page 281-283.
  9. Millist W. Vincent. 1994. PH. D. Thesis, “Semantic Justification for Normal Forms in Relation Database Design”, Department of Computer Science, Monasch University.
  10. Millist W. Vincent. (1999). “Semantic Foundations of 4NF in Relational Database Design”. In Acta Informática 36, pages 173-213.
  11. NLDB'2000 5th International conference on Applications of Natural Language to Information Systems. Versailles (France), June 28-30, 2000.
  12. Santos, I., Martinez Fernández, P. and Cuadra Fernández, D. (25-28 February 2006). “On the Semi-Automatic Validation and Decomposition of Ternary Relationships”. IADIS, 2006.
  13. Thalheim, Bernhard 2000. “Entity-relationship modeling: foundations of database technology”. Publishing: Springer.
  14. Trevor H Jones and Il-Yeol Song. (1996), “Analysis of Binary/Ternary Cardinality Combinations in EntityRelationship Modelling”. Data & Knowledge Engineering, Vol. 19, n 1 pages 39-64.
Download


Paper Citation


in Harvard Style

Santos I., Martínez Fernandez P. and Cuadra D. (2007). ON THE SEMI-AUTOMATIC VALIDATION AND DECOMPOSITION OF TERNARY RELATIONSHIPS WITH OPTIONAL ELEMENTS . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 465-472. DOI: 10.5220/0002386804650472


in Bibtex Style

@conference{iceis07,
author={Ignacio-J. Santos and Paloma Martínez Fernandez and Dolores Cuadra},
title={ON THE SEMI-AUTOMATIC VALIDATION AND DECOMPOSITION OF TERNARY RELATIONSHIPS WITH OPTIONAL ELEMENTS},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={465-472},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002386804650472},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ON THE SEMI-AUTOMATIC VALIDATION AND DECOMPOSITION OF TERNARY RELATIONSHIPS WITH OPTIONAL ELEMENTS
SN - 978-972-8865-88-7
AU - Santos I.
AU - Martínez Fernandez P.
AU - Cuadra D.
PY - 2007
SP - 465
EP - 472
DO - 10.5220/0002386804650472