Client-Site Query Extensions

Summary: Client-site UDFs drive query execution; server-side approaches perform poorly. Adapts distributed DB algorithms to client locations; implemented in Cornell Predator; extends System-R style optimization for client-site ops, with empirical gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3174
Venue: SIGMOD
Year: 1999
Pagerank: 5.5173328e-05
Overall Rank: 7,966 | 45.35%
DOI: 10.1145/304182.304213

Incoming Non-self Citations Over Time

Authors

1. Tobias Mayr (Cornell University)
2. Praveen Seshadri (Cornell University)

BibTeX Citation

@inproceedings{mayr_sigmod99,
        title = {{Client-Site Query Extensions}},
        author = {Mayr, Tobias and Seshadri, Praveen},
        series = {{SIGMOD} '99},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/304182.304213},
        url = {https://dl.acm.org/doi/10.1145/304182.304213},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,273	Optimization of Query Streams Using Semantic Prefetching	2004	SIGMOD	5.9317551e-05
14,139	The Cornell Jaguar Project: Adding Mobility to PREDATOR	1999	SIGMOD	-

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0024089429
132	Predicate Migration: Optimizing Queries with Expensive Predicates	1993	SIGMOD	0.00030378624
143	Optimization of Nonrecursive Queries	1986	VLDB	0.0002959213
342	R* Optimizer Validation and Performance Evaluation for Distributed Queries	1986	VLDB	0.00020673706
677	Query Optimization in the Presence of Foreign Functions	1993	VLDB	0.00015065909
801	Query Execution Techniques for Caching Expensive Methods	1996	SIGMOD	0.00013909408
1,062	Towards an Open Architecture for LDL	1989	VLDB	0.000123618
2,244	Join Queries with External Text Sources: Execution and Optimization Techniques	1995	SIGMOD	8.8737737e-05
2,336	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD	8.7302865e-05
2,465	Optimization of Queries with User-defined Predicates	1996	VLDB	8.5428786e-05
5,313	Secure and Portable Database Extensibility	1998	SIGMOD	6.2693036e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	342	R* Optimizer Validation and Performance Evaluation for Distributed Queries	1986	VLDB
2	1,651	On the Design of a Query Processing Strategy in a Distributed Database Environment	1983	SIGMOD
3	8,086	Load Balancing in a Locally Distributed Database System	1986	SIGMOD
4	4,507	Scalable Multi-Query Optimization for Exploratory Queries over Federated Scientific Databases	2008	VLDB
5	2,336	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD
6	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
7	2,465	Optimization of Queries with User-defined Predicates	1996	VLDB
8	5,313	Secure and Portable Database Extensibility	1998	SIGMOD
9	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB
10	3,945	Exploiting Correlations for Expensive Predicate Evaluation	2015	SIGMOD