User-Optimizer Communication using Abstract Plans in Sybase ASE

Summary: Introduces Sybase ASE Abstract Plans: a physical relational-algebra language enabling two-way user–optimizer communication. Persistent catalog objects let optimizers expose chosen plans and users steer/reuse them independently of query text, mitigating optimizer errors. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hf13b14b3b5e8123a
Venue: VLDB
Year: 2001
Pagerank: 5.3449621e-05
Overall Rank: 8,286 | 44.46%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Mihnea Andrei (Sybase France)
2. Patrik Valduriez (University of Paris 6)

BibTeX Citation

@article{andrei_vldb01,
        title = {{User-Optimizer Communication using Abstract Plans in Sybase ASE}},
        author = {Andrei, Mihnea and Valduriez, Patrik},
        journal = {PVLDB},
        series = {{VLDB} '01},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,502	Xplus: A SQL-Tuning-Aware Query Optimizer	2010	VLDB	6.5572851e-05
9,754	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	5.115551e-05
12,842	Ordering, Distinctness, Aggregation, Partitioning and DQP Optimization in Sybase ASE 15	2009	SIGMOD	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 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.0023948467
89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035265687
93	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.00034518001
99	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034024478
118	The EXODUS Optimizer Generator	1987	SIGMOD	0.00031320165
133	Optimization of Nested SQL Queries Revisited	1987	SIGMOD	0.0003015194
197	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00025558952
204	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002516936
213	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00024695393
259	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022881075
275	Extensible Query Processing in Starburst	1989	SIGMOD	0.000224395
291	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD	0.00021898776
479	Dynamic Query Evaluation Plans	1989	SIGMOD	0.00017595584
534	Answering Recursive Queries Using Views	1997	PODS	0.0001677412
633	A Rule-Based View of Query Optimization	1987	SIGMOD	0.00015365563
1,453	Design and Analysis of Parametric Query Optimization Algorithms	1998	VLDB	0.00010582865
2,630	On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces	1993	VLDB	8.1828876e-05
8,167	Optimization of Object-Oriented Recursive Queries using Cost-Controlled Strategies	1992	SIGMOD	5.3707278e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	259	An Overview of Query Optimization in Relational Systems	1998	PODS
2	3,531	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB
3	3,218	Implementing an Interpreter for Functional Rules in a Query Optimizer	1988	VLDB
4	4,724	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB
5	633	A Rule-Based View of Query Optimization	1987	SIGMOD
6	479	Dynamic Query Evaluation Plans	1989	SIGMOD
7	291	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD
8	4,069	Adaptive Query Processing in the Looking Glass	2005	CIDR
9	646	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD
10	12,842	Ordering, Distinctness, Aggregation, Partitioning and DQP Optimization in Sybase ASE 15	2009	SIGMOD