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: 7947
Venue: VLDB
Year: 1986
Pagerank: 9.2538701e-05
Overall Rank: 2,051 | 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,198	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9680897e-05
2,494	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB	8.5053229e-05
2,701	Possibilities and Limitations of Using Flat Operators in Nested Algebra Expressions	1988	PODS	8.240179e-05
2,971	Design and Implementation of an Extensible Database Management System Supporting User Defined Data Types and Functions	1988	VLDB	7.9120946e-05
4,364	PRIMA - a DBMS Prototype Supporting Engineering Applications	1987	VLDB	6.7411088e-05
5,259	An Implementation for Nested Relational Databases	1988	VLDB	6.2965521e-05
5,880	Cooperative Object Buffer Management in the Advanced Information Management Prototype	1987	VLDB	6.0533041e-05
6,317	An Object-Oriented Database System for Engineering Applications	1987	SIGMOD	5.915075e-05
6,996	Sorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype	1989	VLDB	5.7301343e-05
8,433	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB	5.4258503e-05
8,958	The Power of Nested Parallelism in Big Data Processing – Hitting Three Flies with One Slap –	2021	SIGMOD	5.3449654e-05
9,142	From Nested-Loop to Join Queries in OODB	1994	VLDB	5.3154287e-05
9,216	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.3051647e-05
13,127	On Restructuring Nested Relations in Partitioned Normal Form	1990	VLDB	5.093636e-05
13,161	Management of Complex Objects as Dynamic Forms	1988	VLDB	5.093636e-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.0007727299
15	The Functional Data Model and the Data Language DAPLEX	1979	SIGMOD	0.00061144858
181	On Extending the Functions of a Relational Database System	1982	SIGMOD	0.00026752689
627	Data Structures for an Integrated Data Base Management and Information Retrieval System	1982	VLDB	0.00015634312
2,764	Determining When a Structure Is a Nested Relation	1985	VLDB	8.1535144e-05
5,326	Language Support for Office Modelling	1984	VLDB	6.2639903e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,433	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB
2	13,255	A Modularization Mechanism for Conceptual Modeling	1983	VLDB
3	10	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD
4	1,737	Molecular Objects, Abstract Data Types, and Data Models: A Framework	1984	VLDB
5	4,951	A Relationship Mechanism for a Strongly Typed Object-Oriented Database Programming Language	1991	VLDB
6	2,494	Supporting Flat Relations by a Nested Relational Kernel	1987	VLDB
7	6,317	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	627	Data Structures for an Integrated Data Base Management and Information Retrieval System	1982	VLDB
10	346	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD