Windows On The World

Summary: Window functions are a semantic, database-wide abstraction and the basis for universal scheme interfaces, anchored by the unique role assumption. It contrasts computational and weak-inst definitions, surveys PIQUE's association-object window, and formalizes containment, faithfulness, and implicit objects. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2272
Venue: SIGMOD
Year: 1983
Pagerank: 8.7994393e-05
Overall Rank: 2,289 | 84.30%
DOI: 10.1145/582192.582207

Incoming Non-self Citations Over Time

Authors

1. David Maier (Oregon Graduate Institute)
2. David Rozenshtein (State University of New York at Stony Brook)
3. David S. Warren (State University of New York at Stony Brook)

BibTeX Citation

@inproceedings{maier_sigmod83,
        title = {{WINDOWS ON THE WORLD}},
        author = {Maier, David and Rozenshtein, David and Warren, David S.},
        series = {{SIGMOD} '83},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/582192.582207},
        url = {https://dl.acm.org/doi/10.1145/582192.582207},
        year = {1983}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,551	Efficient Query Answering in the Representative Instance Approach	1985	PODS	7.3196924e-05
7,132	Optimal Computation of Total Projections with Unions of Simple Chase Join Expressions	1984	SIGMOD	5.694968e-05
9,043	A Layered Architecture for Querying Dynamic Web Content	1999	SIGMOD	5.3253843e-05
9,259	Querying Weak Instances	1984	PODS	5.2970277e-05
13,029	Incomplete Path Expressions and their Disambiguation	1994	SIGMOD	5.093636e-05
13,171	On Designing Database Schemes Bounded or Constant-time-maintainable with respect to Functional Dependencies	1987	PODS	5.093636e-05
13,193	On the Properties and Characterisation of Connection-trap-free Schemes (Extended Abstract)	1986	PODS	5.093636e-05
13,213	Chordality Properties on Graphs and Minimal Conceptual Connections in Semantic Data Models	1985	PODS	5.093636e-05
13,219	A High-Level User Interface for Update and Retrieval in Relational Databases - Language Aspects	1985	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
40	Testing Implications Of Data Dependencies	1979	SIGMOD	0.00046918506
97	Efficient Optimization of a Class of Relational Expressions	1978	SIGMOD	0.00034574497
266	Can We Use The Universal Instance Assumption Without Using Nulls?	1981	SIGMOD	0.00022823892
540	Synthesizing Independent Database Schemas	1979	SIGMOD	0.0001686137
1,111	The U. R. Strikes Back	1982	PODS	0.00012131168
1,577	Compatible Attributes In A Universal Relation	1982	PODS	0.00010310871
1,929	A Generalized Access Path Model And Its Application To A Relational Data Base System	1976	SIGMOD	9.4676007e-05
2,712	Improving Semantic Specification in a Relational Database	1979	SIGMOD	8.2127746e-05
3,648	A Universal Relation Database System Implemented Via the Network Model	1982	PODS	7.2267453e-05
3,957	Specifying Connections for a Universal Relation Scheme Database	1982	SIGMOD	6.9945541e-05
4,267	Toward Logical Data Independence: A Relational Query Language without Relations	1982	SIGMOD	6.7929169e-05
7,120	An Algorithm For Servicing Multi-Relational Queries	1977	SIGMOD	5.6970022e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	589	On The Semantics Of The Relational Data Model	1975	SIGMOD
2	5,392	On the Computation of Relational View Complements	2002	PODS
3	13,233	On Lossless Transformation of Database Schemes Not Necessarily Satisfying Universal Instance Assumption (preliminary version)	1984	PODS
4	1,537	Assumptions in Relational Database Theory	1982	PODS
5	1,703	Semantics and Evaluation Techniques for Window Aggregates in Data Streams	2005	SIGMOD
6	8,500	Answering Queries In Relational Databases	1983	SIGMOD
7	8,299	Implementing Queries and Updates on Universal Scheme Interfaces	1988	VLDB
8	3,673	Efficient Processing of Window Functions in Analytical SQL Queries	2015	VLDB
9	3,957	Specifying Connections for a Universal Relation Scheme Database	1982	SIGMOD
10	9,098	ONE FLAVOR ASSUMPTION AND gamma-ACYCLICITY FOR UNIVERSAL RELATION VIEWS	1986	PODS