Abstract
Unnormalized (NF2) relations, not conforming to the first normal form condition (1NF) of the relational model have been proposed recently for a variety of new applications. In this paper we extend NF2 relational theory in a way that it becomes possible to use NF2 relations as storage structures for conventional 1NF relational database interfaces. Physical clustering of precomputed joins can be achieved this way without introducing redundancy. However, applying transformation rules to internal relations straightforwardly, will still yield unnecessary join operations. With the equivalence rules introduced here we prove that efficient algebraic optimization can be performed using standard (1NF) techniques. Particularly, all redundant joins can be properly removed.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
7. References
S. Abiteboul, N. Bidoit: Non First Normal Form Relations to Represent Hierarchically Organised Data, Proc. 3rd ACM PODS, Waterloo, Ontario, Canada, 1984
A.V. Aho, C. Beeri, J.D. Ullman: The Theory of Joins in Relational Databases, ACM TODS, Vol. 4:3, 1979
A.V. Aho, Y. Sagiv, J.D. Ullman: Equivalences Among Relational Expressions, SIAM Journ. of Computing, Vol. 8:2, 1979
N. Bidoit: Efficient Evaluation of Queries Using Nested Relations, Techn. Report INRIA, 1985
W. Benn, B. Radig: Retrieval of Relational Structures for Image Sequence Analysis, Proc. 10th VLDB Conference, Singapore, 1984
F. Bancilhon, P. Richard, M. Scholl: On Line Processing of Compacted Relations, Proc. 8th VLDB Conference, Mexico, 1982
U. Deppisch, V. Obermeit, H.-B. Paul, H.-J. Schek, M.H. Scholl, G. Weikum: The Storage Component of a Database Kernel System, Techn. Rep. DVSI-1985-T1, TU Darmstadt, Short German version in: Proc. GI Conf. on DBSs in Office, Technical and Scientific Applications, Karlsruhe, 1985, IFB 94, Springer, german title: Ein Subsystem zur stabilen Speicherung versionenbehafteter, hierarchisch strukturierter Tupel
U. Deppisch, H.-B. Paul, H.-J. Schek: A Storage System for Complex Objects, Proc. Int'l Workshop on Object-Oriented Database Systems, Pacific Grove, CA, 1986
R. Fagin: Mulitvalued Dependencies and a New Normal Form for Relational Databases, ACM TODS, Vol. 2:3, 1977
P.C. Fischer, D. van Gucht: Determining When a Structure is a Nested Relation, Proc. 11th VLDB Conference, Stockholm, 1985
P.C. Fischer, S.J. Thomas: Operators for Non-First-Normal-Form Relations, Proc. IEEE COMPSAC 1983
D. van Gucht: Theory of Unnormalized Relational Structures, Ph. D. Thesis, also available as Techn. Rep. CS-85-07, Vanderbilt University, Nassville, TN, 1985
G. Jaeschke: Recursive Algebra for Relations with Relation Valued Attributes, Techn. Rep. TR 85.03.002, IBM Heidelberg Scientific Centre, 1985
G. Jaeschke: Algebraic Expressions for Higher Order Relational Databases, unpublished manuscript
G. Jaeschke, H.-J. Schek: Remarks on the Algebra of Non-First-Normal-Form Relations, Proc. 1st ACM PODS, Los Angeles, 1982
D. Maier: The Theory of Relational Databases, Pitman Publishing Ltd., London, 1983
F. Maher, H.-J. Schek, W. Waterfeld: A Database Kernel System for Geoscientific Applications, to appear in: Proc. 2nd Int'l Symp. on Spatial Data Handling, Seattle, 1986
Z.M. Ozsoyoglu, L.Y. Yuan: A Normal Form for Nested Relations, Proc. 4th ACM PODS, 1985
M.A. Roth, H.F. Korth, A. Silberschatz: Extended Algebra and Calculus for ¬1NF Relational Databases, Techn. Rep. TR-84-36, Revised Version, University of Texas at Austin, 1985
M.A. Roth, H.F. Korth, A. Silberschatz: Null Values in ¬1NF Relational Databases, Techn. Rep. TR-85-32, University of Texas at Austin, 1985
H.-J. Schek: Towards a Basic Relational NF 2 Algebra Processor, Proc. Int'l Conf. on FODO, Kyoto, 1985
H.-J. Schek: Research Activities of the DVSI-Group 1983–1985, Techn. Rep. DVSI-1986-T2, TU Darmstadt, 1986
N.C. Shu, V.Y. Lum, F.C. Tung, C.L. Chang: Specification of Forms Processing and Business Procedures for Office Automation, IEEE TOSE, Vol. SE-8:5, 1982
H.-J. Schek, P. Pistor: Data Structures for an Integrated Database Management and Information Retrieval System, Proc. 8th VLDB Conference, Mexico, 1982
H.-J. Schek, U. Reimer: A Frame Representation Model and its Mapping to NF 2 Relations, submitted for publication, 1986
M. Schkolnik, P. Sorenson: Denormalization: A Performance Oriented Database Design Technique, Proc. AICA Conf., Bologna, Italy, 1980
M. Schkolnik, P. Sorenson: The Effects of Denormalization on Database Performance, Res. Rep. RJ3082 (38128), IBM Res. Lab. San Jose, Ca., 1981
H.-J. Schek, M.H. Scholl: Die NF 2-Relationenalgebra zur einheitlichen Manipulation externer, konzeptueller und interner Datenstrukturen, in: J.W. Schmidt (ed.): Sprachen für Datenbanken, IFB 72, Springer, 1983
H.-J. Schek, M.H. Scholl: The Relational Model with Relation-Valued Attributes, Techn. Rep. DVSI-1984-T1, TU Darmstadt, published in: Information Systems, Vol. 11:2, 1986
H.-J. Schek, G. Weikum: DASDBS: Concepts and Architecture of a Database System for Advanced Applications, Techn. Rep. DVSI-1986-T1, TU Darmstadt, 1986
Verso, J. (pen name for the Verso team): Verso: A Database Machine Based on Non-First-Normal-Form Relations, INRIA Report, 1986
J.D. Ullman: Principles of Database Systems (2nd ed.), Computer Science Press, Rockville, MD, 1982
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1986 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Scholl, M.H. (1986). Theoretical foundation of algebraic optimization utilizing unnormalized relations. In: Ausiello, G., Atzeni, P. (eds) ICDT '86. ICDT 1986. Lecture Notes in Computer Science, vol 243. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-17187-8_48
Download citation
DOI: https://doi.org/10.1007/3-540-17187-8_48
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-17187-4
Online ISBN: 978-3-540-47346-6
eBook Packages: Springer Book Archive