Abstract
Relations with relation-valued attributes (NF2 relations) are proposed to serve as a model for internal data structures of a data base system. A related NF2 relational algebra is described and a suitable subset of it is selected to define the interface of a basic NF2 algebra processor. It will be shown that specific projection-selection-join-sequences expressed in 1NF relations at the conceptual level are mapped to nested projection-selection sequences of the internal of NF2 relations. Costly joins therefore can be eliminated and substituted by equivalent cheaper linear queries. The selection of the subset of NF2 algebra operations is motivated by this join elimination and by the restriction to single-scan operations.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
S. Abiteboul, N. Bidoit: Non First Normal Form Relations to Represent Hierarchically Organized Data, Proc. 3rd ACM SIGACT/SIGMOD Symp. on Princ. of Database Systems, Waterloo, Ontario, Canada, 1984
H. Arisawa, K. Moriya, T. Miura: Operations and Properties on Non-First Normal-Form Relational Databases, Proc. VLDB Conf., Florence, Italy, 1983
F. Bancilhon, P. Richard, M. Scholl: On Line Processing of Compacted Relations, Proc. VLDB Conf., Mexico City, 1982
U. Deppisch, J. Guenauer, G. Walch: Storage Structures and Address Techniques for the Complex Objects of the NF2 Relational Model, GI-Conference on “Data Base Systems for Office, Engineering, and Science Environments”, Karlsruhe, March 1985, (in German)
U.Deppisch, V. Obermeit, B. Paul, H.-J. Schek, M.H. Scholl, G. Weikum: A Subsystem for the Stable Storage of Versioned Hierarchically Structured Tuples, GI-Conference on “Data Base Systems for Office, Engineering, and Science Environments”, Karlsruhe, March 1985, (in German)
P.C. Fischer, S,J. Thomas: Operators for Non-First-Normal-Form Relations, Proc. IEEE COMPSAC, 1983
R. Haskin, R. Lorie: On Extending the Functions of a Relational Database System, Proc. ACM SIGMOD Conf., Orlando, FL, 1982
G. Jaeschke: Recursive Algebra for Relations with Relation-Valued Attributes, Techn. Report No. 84.01.003 IBM Heidelberg Scientific Centre, 1984
G. Jaeschke, H.-J. Schek: Remarks on the Algebra of Non-First-Normal-Form Relations, Proc. 1st. ACM SIGACT/SIGMOD Symp. on Princ. of Database Systems, Los Angeles, Ca. 1982
J. Kobayashi: An Overview of Database Management Technology, TRCS-4, SANNO College, 1753 Kamikasuya, Isehara, Kanagawa 259-11, Japan
Y.Kambayashi, K. Tanaka, K. Takeda: Synthesis of Unnormalized Relations Incorporating More Meaning, Int. Journal of Information Sciences, Special Issue on Databases, 1983
V. Lum, P. Dadam, R. Erbe, J. Guenauer, P. Pistor, G. Walch, H. Werner, J. Woodfill: Design of an Integrated DBMS to Support Advanced Applications, GI-Conference on “Data Base Systems for Office, Engineering, and Science”, Karlsruhe, March 1985
A. Makinouchi: A Consideration on Normal Form of Not-Necessarily-Normalized Relations in the Relational Data Model, Proc. VLDB Conf., Tokyo, Japan, 1977
M. Schkolnick, P. Sorensen: The Effects of Denormalization on Database Performance, Res. Rep. RJ3082 (38128). IBM Res. Lab., San Jose, Ca., 1981
N.C. Shu, V.Y. Lum, F.C. Tung, C.L. Chang: Specification of Forms Processing and Business Procedures for Office Automation, IEEE, Trans, on Softw. Eng., Vol. SE-8:5, 1982
H.-J. Schek, P. Pistor: Data Structures for an Integrated Database Management and Information Retrieval System, Proc. VLDB Conf., Mexico City, Mexico, 1982
H.-J. Schek, M.H. Scholl: The NF2 Relational Algebra for a Uniform Manipulation of the External, Conceptual and Internal Data Models (in German), in: Sprachen fuer Datenbanken, J.W. Schmidt (ed.), Informatik Fachberichte Nr. 72, Springer, Berlin Heidelberg New York Tokyo, 1983
H.-J. Schek, M.H. Scholl: An Algebra for the Relational Model with Relation Valued Attributes, Technical Report No. DVSI-1984-T1, Technical University of Darmstadt, 1984
J.D. Ullman: Principles of Database Systems, 2nd edition, Pitman, London, 1982
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1987 Plenum Press, New York
About this chapter
Cite this chapter
Schek, HJ. (1987). Towards a Basic Relational NF2 Algebra Processor. In: Ghosh, S.P., Kambayashi, Y., Tanaka, K. (eds) Foundations of Data Organization. Springer, Boston, MA. https://doi.org/10.1007/978-1-4613-1881-1_46
Download citation
DOI: https://doi.org/10.1007/978-1-4613-1881-1_46
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4612-9048-3
Online ISBN: 978-1-4613-1881-1
eBook Packages: Springer Book Archive