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

Jun Hyung Shin

dblp:222/2964 · DBLP profile ↗
← Back
2ranked-venue papers
1as first author
1since 2021 · last 2021
—ORCID · none

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

Databases, data management, data science and information retrieval · 2 · 1 first-author · 1 since 2021

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
1 paper
Query processing and optimization · 100%

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

TopicWeightPapersLastEvidence papers
Query processing and optimization
cardinality estimation
0.512021
COMPASS: Online Sketch-based Query Optimization for In-Memory Databases · SIGMOD Conference 2021
Query processing and optimization › query optimization
join ordering
0.512021
COMPASS: Online Sketch-based Query Optimization for In-Memory Databases · SIGMOD Conference 2021
Query processing and optimization › query planning
query plan enumeration
0.512021
COMPASS: Online Sketch-based Query Optimization for In-Memory Databases · SIGMOD Conference 2021
Query processing and optimization › cardinality estimation
sketch-based cardinality estimation
0.512021
COMPASS: Online Sketch-based Query Optimization for In-Memory Databases · SIGMOD Conference 2021

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

cost-based optimization · 0.5Fast-AGMS sketches · 0.5
YearPublicationVenuePosition
2021 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases
abstract
Cost-based query optimization remains a critical task in relational databases even after decades of research and industrial development. Query optimizers rely on a large range of statistical synopses for accurate cardinality estimation. As the complexity of selections and the number of join predicates increase, two problems arise. First, statistics cannot be incrementally composed to effectively estimate the cost of the sub-plans generated in plan enumeration. Second, small errors are propagated exponentially through joins, which can lead to severely sub-optimal plans. In this paper, we introduce COMPASS, a novel query optimization paradigm for in-memory databases based on a single type of statistics---Fast-AGMS sketches. In COMPASS, query optimization and execution are intertwined. Selection predicates and sketch updates are pushed-down and evaluated online during query optimization. This allows Fast-AGMS sketches to be computed only over the relevant tuples---which enhances cardinality estimation accuracy. Plan enumeration is performed over the query join graph by incrementally composing attribute-level sketches---not by building a separate sketch for every sub-plan. We prototype COMPASS in MapD -- an open-source parallel database -- and perform extensive experiments over the complete JOB benchmark. The results prove that COMPASS generates better execution plans -- both in terms of cardinality and runtime -- compared to four other database systems. Overall, COMPASS achieves a speedup ranging from 1.35X to 11.28X in cumulative query execution time over the considered competitors.
Yesdaulet Izenov, Asoke Datta, Florin Rusu, Jun Hyung Shin
SIGMOD Conference4
2019 Selectivity Computation for In-Memory Query Optimization
Jun Hyung Shin, Florin Rusu, Alex Suhan
CIDR1