Abstract
The authors investigate the inference problems due to functional dependencies (FD) and multivalued dependencies (MVD) in a multilevel relational database (MDB) with attribute and record classification schemes, respectively. The set of functional dependencies to be taken into account in order to prevent FD-compromises is determined. It is proven that incurring minimum information loss to prevent compromises is an NP-complete problem. An exact algorithm to adjust the attribute levels so that no compromise due to functional dependencies occurs is given. Some necessary and sufficient conditions for MVD-compromises are presented. The set of MVDs to be taken into account for controlling inferences is determined. An algorithm to prevent MVD-compromises in a relation with conflict-free MVDs is given.< <ETX xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">></ETX>
Keywords
Computer scienceRelational databaseSet (abstract data type)Functional dependencyRelation (database)InferenceData miningData integrityCompromiseTheoretical computer scienceAlgorithmDatabaseArtificial intelligenceProgramming language
Affiliated Institutions
Related Publications
Matched filter performance bounds for diversity combining receivers in digital mobile radio
By employing the technique known as the matched filter bound, the authors derive analytical expressions for the distribution and average of the bit-error-rate in an ideal space ...
MMSE diversity combining for wide-band digital cellular radio
A study of minimum mean-square error (MMSE) diversity combining for wide-band digital cellular radio, designed to combat intersymbol interference (ISI) caused by frequency selec...
Optimum diversity combining and equalization in digital data transmission with applications to cellular mobile radio. I. Theoretical considerations
A comprehensive theory for Nth-order space diversity reception combined with various equalization techniques in digital data transmission over frequency-selective fading channel...
Performance of a cellular hybrid C/TDMA mobile radio system applying joint detection and coherent receiver antenna diversity
For future mobile radio systems, an appropriately chosen multiple access technique is a critical issue. Multiple access techniques presently under discussion are code division m...
Compressed sensing and best 𝑘-term approximation
Compressed sensing is a new concept in signal processing where one seeks to minimize the number of measurements to be taken from signals while still retaining the information ne...
Publication Info
- Year
- 1991
- Type
- article
- Volume
- 3
- Issue
- 4
- Pages
- 474-485
- Citations
- 71
- Access
- Closed
External Links
Social Impact
Altmetric
PlumX Metrics
Social media, news, blog, policy document mentions
Citation Metrics
71
OpenAlex
Cite This
Tzong-An Su,
Gültekin Özsoyoğlu
(1991).
Controlling FD and MVD inferences in multilevel relational database systems.
IEEE Transactions on Knowledge and Data Engineering
, 3
(4)
, 474-485.
https://doi.org/10.1109/69.109108
Identifiers
- DOI
- 10.1109/69.109108