A CLAIM TO INCORPORATE FUNCTIONAL DEPENDENCIES IN DEVELOPMENT TOOLS - Benchmarking and Checking Functional Dependencies Algorithms

Manuel Enciso Garcia-Oliveros, Angel Mora Bonilla, Pablo Cordero, Rosario Baena

2011

Abstract

In this work we summarize the state of the art in the use of database functional dependencies. We compare the low impact that it has in the commercial environment with its successful acceptation in the academic environment. Particularly we remark that there does not exists any commercial development tool which uses the information provided by functional dependencies and this useful information is also deprecated by the database management systems. As a result of this, large database designs have to be re-built a few years after their establishment. In this work we identify the reasons which causes this situation and we propose a guideline to wide spread the effective use of Functional Dependencies in commercial design and tools.

References

  1. Antony, S. R. and Batra, D. (2002). CODASYS: a consulting tool for novice database designers. ACM SIGMIS Database, 33:54-68.
  2. Beeri, C. and Bernstein, P. A. (1979). Computational problems related to the design of normal form relational schemas. ACM TDS, 4(1):30-59.
  3. Codd, E. F. (1970). A relational model of data for large shared data banks. Commun. ACM, 13(6):377-387.
  4. Diederich, J. and Milton, J. (1988). New methods and fast algorithms for database normalization. ACM TODS, 13:339-365.
  5. Maier, D. (1983). The theory of relational database. Computer Science Press.
  6. Mora, A., Aguilera, G., Enciso, M., Cordero, P., and de Guzmán, I. P. (2006). A new closure algorithm based in logic: Slfd-closure versus classical closures. Inteligencia Artificial, Revista Iberoamericana de Inteligencia Artificial, 10(31):31-40.
  7. Í ngel Mora, Enciso, M., Cordero, P., and de Guzmán, I. P. (2004). An efficient preprocessing transformation for functional dependencies sets based on the substitution paradigm. In Current Topics in Artificial Intelligence, volume 3040 of LNCS, pages 136-146. Springer.
  8. Paredaens, J., Bra, P. D., Gyssens, M., and Gucht, D. V. (1989). The structure of the relational database model. Springer.
  9. Wirth, N. (1978). Algorithms + Data Structures = Programs. Prentice Hall PTR.
Download


Paper Citation


in Harvard Style

Enciso Garcia-Oliveros M., Mora Bonilla A., Cordero P. and Baena R. (2011). A CLAIM TO INCORPORATE FUNCTIONAL DEPENDENCIES IN DEVELOPMENT TOOLS - Benchmarking and Checking Functional Dependencies Algorithms . In Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT, ISBN 978-989-8425-76-8, pages 313-316. DOI: 10.5220/0003608803130316


in Bibtex Style

@conference{icsoft11,
author={Manuel Enciso Garcia-Oliveros and Angel Mora Bonilla and Pablo Cordero and Rosario Baena},
title={A CLAIM TO INCORPORATE FUNCTIONAL DEPENDENCIES IN DEVELOPMENT TOOLS - Benchmarking and Checking Functional Dependencies Algorithms},
booktitle={Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,},
year={2011},
pages={313-316},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003608803130316},
isbn={978-989-8425-76-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Software and Database Technologies - Volume 1: ICSOFT,
TI - A CLAIM TO INCORPORATE FUNCTIONAL DEPENDENCIES IN DEVELOPMENT TOOLS - Benchmarking and Checking Functional Dependencies Algorithms
SN - 978-989-8425-76-8
AU - Enciso Garcia-Oliveros M.
AU - Mora Bonilla A.
AU - Cordero P.
AU - Baena R.
PY - 2011
SP - 313
EP - 316
DO - 10.5220/0003608803130316