Abstract
This paper reports an algorithm (DTV) for determining the minimal reduced-covering of an acyclic database scheme over a specified subset of attributes. The output of this algorithm contains not only minimum number of attributes but also minimum number of partial relation schemes. The algorithm has complexityO(⋎N⋎·⋎E⋎2), where ⋎N⋎ is the number of attributes and ⋎E⋎ the number of relation schemes. It is also proved that for Berge, γ or β acyclic database schemes, the output of algorithm DTV maintains the acyclicity correspondence.
Similar content being viewed by others
References
Fagin R. Degrees of acyclicity for hypergraphs and relational database scheme.J. ACM, 1983, 30(3): 514–550.
Ye Xinming. An algorithm for determining minimal covers of acyclic database schemes.Journal of Inner Mongolia University, 1994, 25(2): 219–225.
Beeri C, Fagin R, Maier D, Mendelzon A O, Ullman J D, Yannakakis M. Properties of acyclic database schemes. InProc. 13th Ann. ACM Symp. on Theory of Computing. New York, 1981, pp. 355–362.
Cheng T Y, Zhu Y Tech. An algorithm for determining minimal covers of Alpha-acyclic database schemes. Report TR-81-07, Ottawa, Dept. of Comp. Sci., Univ. of Ottawa, 1986, pp. 1–26.
Tarjan R E, Yannakakis M. Simple linear time algorithm to test chordality of graphs, test acyclicity of hypergraph, and selectively reduce acyclic hypergraphs.SIAM J. Comput., 1984, 13(3): 566–579.
Liu Tieying. An algorithm for reducing acyclic database schemes.Journal of Inner Mongolia University, 1995, 26(3): 220–225.
Ausiello G, D’Atri A. Chordality properties on graphs and minimal conceptual connections in semantidata models.J. of Comput. and Sys. Sci., 1984, 33: 179–202.
Goodman N, Shmueli O. Characterizations of tree database schemes. Tech. Rep., Harvard Univ., Cambridge, Mass., 1981.
Author information
Authors and Affiliations
Additional information
Liu Tieying received his B.S. and M.S. degrees from Mathematics Department of Inner Mongolia University in 1981 and 1989, respectively. He is currently an Associate Professor in the Department of Computer Science at Inner Mongolia University. He is a member of the Inner Mongolia Association for Computing Mathematics. His research interests include applied mathematics and theory of database.
Ye Xinming received his B.S. degree in mathematics from Inner Mongolia University in 1965. He is currently a Professor and Head of the Department of Computer Science at Inner Mongolia University. He is a member of Council of Chinese Computer Federation and Chairman of Association of Inner Mongolia Computer Sociaty. His research interests include software engineering, network protocols, distributed algorithms and database.
Rights and permissions
About this article
Cite this article
Liu, T., Ye, X. An algorithm for determining minimal reduced-coverings of acyclic database schemes. J. of Comput. Sci. & Technol. 11, 347–355 (1996). https://doi.org/10.1007/BF02948478
Received:
Revised:
Issue Date:
DOI: https://doi.org/10.1007/BF02948478