A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies-Reference-Cited by-同舟云学术

A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies

Published:1986-06-15 Issue:2 Volume:15 Page:356-367
ISSN:0163-5808
Container-title:ACM SIGMOD Record
language:en
Short-container-title:SIGMOD Rec.

Author:

Dadam P.¹,Kuespert K.¹,Andersen F.¹,Blanken H.¹,Erbe R.¹

Affiliation:

1. IBM Heidelberg Scientific Center, Tiergartenstr 15, D-6900 Heidelberg, West Germany

Abstract

Recently, extensions for relational database management systems (DBMS) have been proposed to support also hierarchical structures (complex objects). These extensions have been mainly implemented on top of an existing DBMS. Such an approach leads to many disadvantages not only from the conceptual point of view but also from performance aspects. Thus paper reports on a 3-year effort to design and prototype a DBMS to support a generalized relational data model, called extended NF 2 ( N on F irst N ormal F orm) data model which treats flat relations, lists, and hierarchical structures in a uniform way. The logical data model, a language for this model, and alternatives for storage structures to implement generalized relations are presented and discussed.

Publisher

Association for Computing Machinery (ACM)

Subject

Information Systems,Software

Link

https://dl.acm.org/doi/pdf/10.1145/16856.16889

Reference41 articles.

1. System R

2. Blanken H et al Storage Structures and Query t landlmg for Tune Vemons m an Advanced Informatton Management System (m preparatton) Blanken H et al Storage Structures and Query t landlmg for Tune Vemons m an Advanced Informatton Management System (m preparatton)

3. Bartels R Moeller J Entwurf und lmplementlerung emer regelbaslerenden Planungskomponente fuer &e Optmuerung yon Datenbankanfragen m emer SEQUEL-arttgen Sprache (Design and ImplementaUon of a Rule-Based Planning Component for the OptumzaUon of SEQUEL-hke Database Quenes) Master's Thesis Tech UmversRy of Darmstadt and IBM lteldelberg Sclentdic Center Nov 1985 (m German) Bartels R Moeller J Entwurf und lmplementlerung emer regelbaslerenden Planungskomponente fuer &e Optmuerung yon Datenbankanfragen m emer SEQUEL-arttgen Sprache (Design and ImplementaUon of a Rule-Based Planning Component for the OptumzaUon of SEQUEL-hke Database Quenes) Master's Thesis Tech UmversRy of Darmstadt and IBM lteldelberg Sclentdic Center Nov 1985 (m German)

4. SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control

Cited by 29 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Big Data Management: What to Keep from the Past to Face Future Challenges?;Data Science and Engineering;2017-08-10

2. Advantages of complex SQL types in storing XML documents;Future Generation Computer Systems;2017-03

3. Mapping XML Documents Using Complex SQL Data Types;Model and Data Engineering;2014

4. Moa and the Multi-model Architecture: A New Perspective on NF2;Lecture Notes in Computer Science;2003

5. On Multisets in Database Systems;Lecture Notes in Computer Science;2001