A FORMAL TOOL THAT INTEGRATES RELATIONAL DATABASE SCHEMES AND PRESERVES THE ORIGINAL INFORMATION

A. Mora, M. Enciso

2006

Abstract

In this work we face on with the main problem concerning the database design process in a collaborative environment: several users provide different models representing a part of the global model and we must integrate these database sub-shemes to render a unified database schema. In this work we propose a technique to integrate relational database sub-schemes based on a formal language. The extraction, integration and generation tasks are carried out efficiently using the SLFD logic (Substitution Logic for functional dependencies). We have selected this logic because it is appropriated to manage the functional dependencies in a automatic way.

References

  1. Arch-int, S. and Batanov, D. (2003). Development of industrial information systems on the web using business components. Computers in Industry, 50 (2):231-250.
  2. Armstrong, W. W. (1974). Dependency structures of data base relationships. Proc. IFIP Congress., pages 580- 583.
  3. Chang, L. and Moskowitz, I. S. (2000). An integrated framework for database privacy protection. IFIP Workshop on Database Security, ISBN: 0-7923-8129- 7:161-172.
  4. Codd, E. F. (1974). Recent investigations into relational data base systems. IFIP Congress, Estocolmo, Suecia.
  5. Enciso, M. and Mora, A. (2002). FD3: A functional dependencies data dictionary. Proceedings of the Fourth Conference on Enterprise Information Systems - ICEIS, 2:807-811.
  6. Fagin, R. (1977). Functional dependencies in a relational database and propositional logic. IBM. Journal of research and development, 21 (6):534-544.
  7. Lee, M. L., Ling, T. W., and Low, W. L. (2002). Designing functional dependencies for xml. LNCS, 2287:124- 141.
  8. Ling, T., Goh, C., and Lee, J. (1996). Extending classical functional dependencies for physical database design. Information and Software Technology, 38:601-608.
  9. Mora, A., Enciso, M., Cordero, P., Guzmán, I. P. d., and Guerrero, J. (2004). A/d case: a new heart for FD3. Proceedings of ICEIS 2004 - 6th International Conference on Enterprise Information Systems. Porto, PORTUGAL.
Download


Paper Citation


in Harvard Style

Mora A. and Enciso M. (2006). A FORMAL TOOL THAT INTEGRATES RELATIONAL DATABASE SCHEMES AND PRESERVES THE ORIGINAL INFORMATION . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 302-305. DOI: 10.5220/0002451603020305


in Bibtex Style

@conference{iceis06,
author={A. Mora and M. Enciso},
title={A FORMAL TOOL THAT INTEGRATES RELATIONAL DATABASE SCHEMES AND PRESERVES THE ORIGINAL INFORMATION},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={302-305},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002451603020305},
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 - A FORMAL TOOL THAT INTEGRATES RELATIONAL DATABASE SCHEMES AND PRESERVES THE ORIGINAL INFORMATION
SN - 978-972-8865-41-2
AU - Mora A.
AU - Enciso M.
PY - 2006
SP - 302
EP - 305
DO - 10.5220/0002451603020305