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.0571741e-05
Overall Rank: 2,094 | 85.93%
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,154	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9474855e-05
2,531	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB	8.3351949e-05
2,751	Possibilities and Limitations of Using Flat Operators in Nested Algebra Expressions	1988	PODS	8.0562002e-05
2,992	Design and Implementation of an Extensible Database Management System Supporting User Defined Data Types and Functions	1988	VLDB	7.7729638e-05
4,432	PRIMA - a DBMS Prototype Supporting Engineering Applications	1987	VLDB	6.601596e-05
5,378	An Implementation for Nested Relational Databases	1988	VLDB	6.1561988e-05
6,002	Cooperative Object Buffer Management in the Advanced Information Management Prototype	1987	VLDB	5.9177524e-05
6,420	An Object-Oriented Database System for Engineering Applications	1987	SIGMOD	5.7903037e-05
6,964	Sorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype	1989	VLDB	5.6328172e-05
8,606	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB	5.3041112e-05
9,034	The Power of Nested Parallelism in Big Data Processing – Hitting Three Flies with One Slap –	2021	SIGMOD	5.2334993e-05
9,312	From Nested-Loop to Join Queries in OODB	1994	VLDB	5.1962034e-05
9,349	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.1897188e-05
13,417	On Restructuring Nested Relations in Partitioned Normal Form	1990	VLDB	4.9793485e-05
13,451	Management of Complex Objects as Dynamic Forms	1988	VLDB	4.9793485e-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.00075944947
16	The Functional Data Model and the Data Language DAPLEX	1979	SIGMOD	0.00059996338
183	On Extending the Functions of a Relational Database System	1982	SIGMOD	0.00026178731
640	Data Structures for an Integrated Data Base Management and Information Retrieval System	1982	VLDB	0.00015288268
2,820	Determining When a Structure Is a Nested Relation	1985	VLDB	7.9715759e-05
5,453	Language Support for Office Modelling	1984	VLDB	6.1242243e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,606	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB
2	13,545	A Modularization Mechanism for Conceptual Modeling	1983	VLDB
3	10	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD
4	1,775	Molecular Objects, Abstract Data Types, and Data Models: A Framework	1984	VLDB
5	5,074	A Relationship Mechanism for a Strongly Typed Object-Oriented Database Programming Language	1991	VLDB
6	2,531	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB
7	6,420	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	640	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