Designing a Generalized NF2 Model with an SQL-Type Language Interface

Summary: Generalizes NF2 with orthogonal atoms, lists, multisets, and tuples, addressing order, duplicates, and composite-item asymmetries. Defines a consistent SQL-like language whose transitive operations support expressive DML/DDL without added complexity. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hf5bfff7aef68a84e
Venue: VLDB
Year: 1986
Pagerank: 9.0234169e-05
Overall Rank: 2,107 | 85.88%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. P. Pistor (IBM)
2. F. Andersen (IBM)

BibTeX Citation

@article{pistor_vldb86,
        title = {{Designing a Generalized NF2 Model with an SQL-Type Language Interface}},
        author = {Pistor, P. and Andersen, F.},
        journal = {PVLDB},
        series = {{VLDB} '86},
        pages = {278},
        year = {1986}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,163	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9189753e-05
2,538	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB	8.3052522e-05
2,761	Possibilities and Limitations of Using Flat Operators in Nested Algebra Expressions	1988	PODS	8.0258082e-05
3,003	Design and Implementation of an Extensible Database Management System Supporting User Defined Data Types and Functions	1988	VLDB	7.747067e-05
4,456	PRIMA - a DBMS Prototype Supporting Engineering Applications	1987	VLDB	6.5769766e-05
5,405	An Implementation for Nested Relational Databases	1988	VLDB	6.1329715e-05
6,015	Cooperative Object Buffer Management in the Advanced Information Management Prototype	1987	VLDB	5.8954288e-05
6,430	An Object-Oriented Database System for Engineering Applications	1987	SIGMOD	5.7690302e-05
6,986	Sorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype	1989	VLDB	5.6115347e-05
8,631	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB	5.28407e-05
9,048	The Power of Nested Parallelism in Big Data Processing – Hitting Three Flies with One Slap –	2021	SIGMOD	5.2155403e-05
9,346	From Nested-Loop to Join Queries in OODB	1994	VLDB	5.1765714e-05
9,384	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1701116e-05
13,464	On Restructuring Nested Relations in Partitioned Normal Form	1990	VLDB	4.9605343e-05
13,498	Management of Complex Objects as Dynamic Forms	1988	VLDB	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
10	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD	0.00075677079
16	The Functional Data Model and the Data Language DAPLEX	1979	SIGMOD	0.00059778867
185	On Extending the Functions of a Relational Database System	1982	SIGMOD	0.00026084927
642	Data Structures for an Integrated Data Base Management and Information Retrieval System	1982	VLDB	0.00015230974
2,835	Determining When a Structure Is a Nested Relation	1985	VLDB	7.9414981e-05
5,474	Language Support for Office Modelling	1984	VLDB	6.1011175e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,631	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB
2	13,592	A Modularization Mechanism for Conceptual Modeling	1983	VLDB
3	10	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD
4	1,788	Molecular Objects, Abstract Data Types, and Data Models: A Framework	1984	VLDB
5	5,099	A Relationship Mechanism for a Strongly Typed Object-Oriented Database Programming Language	1991	VLDB
6	2,538	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB
7	6,430	An Object-Oriented Database System for Engineering Applications	1987	SIGMOD
8	140	Remarks on the Algebra of Non First Normal Form Relations	1982	PODS
9	642	Data Structures for an Integrated Data Base Management and Information Retrieval System	1982	VLDB
10	354	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD