Some problems concerning Armstrong relations of dual schemes and relation schemes in the relational datamodel

Demetrovics János and Thi Vu Duc: Some problems concerning Armstrong relations of dual schemes and relation schemes in the relational datamodel. In: Acta cybernetica, (11) 1-2. pp. 35-47. (1993)

[thumbnail of cybernetica_011_numb_001_002_035-047.pdf]
Preview
Cikk, tanulmány, mű
cybernetica_011_numb_001_002_035-047.pdf

Download (814kB) | Preview

Abstract

Several papers [3,5,6,7,8,9,11,12] have appeared for investigating dual dependency. The practical meaning of dual dependency was shown in [5,6]. In this paper we give some new results concerning dual dependency. The concept of dual scheme is introduced. Some characterizations of dual scheme, such as closure, generator, generating Armstrong relation, inferring dual dependencies, irredundant cover, normal cover are studied from different aspects. We give a characterization of Armstrong relations for a given dual scheme. We prove that the membership problem for dual dependencies is solved by a polynomial time algorithm. We show that the time complexity of finding an Armstrong relation of a given dual scheme is exponential in the number of attributes. Conversely, we give an algorithm to construct a dual scheme from a given relation R such that R is Armstrong relation of it. This paper gives some polynomial time algorithms which find closure, irredundant cover, normal cover from a given dual scheme. In the second part of this paper we present some results related to Armstrong relations for functional dependency (FD for short) in Boyce-Codd normal form. The concepts of unique relation and unique relation scheme are introduced. We prove that deciding whether a given relation R over a set of attributes U is unique is solved by a polynomial time algorithm. We show some cases in which FD-relation equivalence problem is solved .in polynomial time.

Item Type: Article
Journal or Publication Title: Acta cybernetica
Date: 1993
Volume: 11
Number: 1-2
ISSN: 0324-721X
Page Range: pp. 35-47
Language: English
Place of Publication: Szeged
Related URLs: http://acta.bibl.u-szeged.hu/38496/
Uncontrolled Keywords: Számítástechnika, Kibernetika
Additional Information: Bibliogr.: p. 46-47. ; összefoglalás angol nyelven
Subjects: 01. Natural sciences
01. Natural sciences > 01.02. Computer and information sciences
Date Deposited: 2016. Oct. 15. 12:26
Last Modified: 2022. Jun. 13. 10:47
URI: http://acta.bibl.u-szeged.hu/id/eprint/12519

Actions (login required)

View Item View Item