Demonstration venue · read-only. Every page can be browsed; the buttons that would change it are switched off. Create an account to run TaxoReview on your own data. A simulation from public publication records: the people listed were not invited and did not agree to review.
? Tutorial for this page

Pooja N. Darera

dblp:42/5906 · DBLP profile ↗
← Back
2ranked-venue papers
0as first author
0since 2021 · last 2008
—ORCID · none

Domains — the database's venue-derived domains; a paper can count in several

Databases, data management, data science and information retrieval · 2

Expertise — from the expertise taxonomy: the topics of the expert's papers under the CCF categories. A weight counts papers with recency: 1 for a paper about the topic, 0.3 when the topic is its context, halved every five years.

Databases, data mining, and information retrieval
2 papers
Query processing and optimization · 94% Database system architecture and tuning · 6%

Topics — the 4 heaviest of 6, each with the papers that count most for it

TopicWeightPapersLastEvidence papers
Query processing and optimization
cardinality estimation
0.112008
Identifying robust plans through plan diagram reduction · Proc. VLDB Endow. 2008
Query processing and optimization › query planning
query plan robustness
0.112008
Identifying robust plans through plan diagram reduction · Proc. VLDB Endow. 2008
Query processing and optimization › query planning
query plan selection
0.112008
Identifying robust plans through plan diagram reduction · Proc. VLDB Endow. 2008
Database system architecture and tuning › database performance management › query performance analysis › query plan analysis
query plan visualization
0.012007
On the Production of Anorexic Plan Diagrams · VLDB 2007

Methods — techniques the papers use, named apart from their topics

mathematical characterization of plan cost · 0.1
YearPublicationVenuePosition
2008 Identifying robust plans through plan diagram reduction
abstract
Estimates of predicate selectivities by database query optimizers often differ significantly from those actually encountered during query execution, leading to poor plan choices and inflated response times. In this paper, we investigate mitigating this problem by replacing selectivity error-sensitive plan choices with alternative plans that provide robust performance. Our approach is based on the recent observation that even the complex and dense "plan diagrams" associated with industrial-strength optimizers can be efficiently reduced to "anorexic" equivalents featuring only a few plans, without materially impacting query processing quality. Extensive experimentation with a rich set of TPC-H and TPC-DS-based query templates in a variety of database environments indicate that plan diagram reduction typically retains plans that are substantially resistant to selectivity errors on the base relations. However, it can sometimes also be severely counter-productive, with the replacements performing much worse. We address this problem through a generalized mathematical characterization of plan cost behavior over the parameter space, which lends itself to efficient criteria of when it is safe to reduce. Our strategies are fully non-invasive and have been implemented in the Picasso optimizer visualization tool.
Harish Doraiswamy, Pooja N. Darera, Jayant R. Haritsa
Proc. VLDB Endow.2
2007 On the Production of Anorexic Plan Diagrams
Harish Doraiswamy, Pooja N. Darera, Jayant R. Haritsa
VLDB2