Abstract

In the study of the relational database model, the vertical decomposition of relations into projections of these relations was emphasized since the introduction in /CODD 72/. The use of vertical decompositions always requires some constraints to be satisfied, for instance a join dependency or a functional dependency, in order to be able to regain the original relation by taking the join of its projections. In /ARDE 80/, /THAL 84/ and AABM 80/ the idea of D. Smith and J. Smith /SMSM 77/, to decompose a relation horizontally into restrictions of these relations, using the union as composition operator, was formalized, using Codd-functional and multivalued dependencies. Such horizontal decompositions /DBPA 83/ are useful in the normalization of schemata in which hidden constraints are involved.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.