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

Keita Takenouchi

dblp:276/5426 · DBLP profile ↗
← Back
1ranked-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 · 1 · 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
Data models and query languages · 50% Query processing and optimization · 50%
Software engineering, system software, and programming languages
1 paper
Program synthesis and code generation · 100%

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

TopicWeightPapersLastEvidence papers
Query processing and optimization › query rewriting
query transformation
0.512021
PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns · Proc. VLDB Endow. 2021
Data models and query languages
relational algebra
0.512021
PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns · Proc. VLDB Endow. 2021
Program synthesis and code generation
programming by example
0.512021
PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns · Proc. VLDB Endow. 2021
Program synthesis and code generation › programming by example
SQL query synthesis
0.512021
PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns · Proc. VLDB Endow. 2021

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

projection lifting · 1.0constraint propagation · 1.0
YearPublicationVenuePosition
2021 PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns
abstract
SQL is one of the most popular tools for data analysis, and it is now used by an increasing number of users without having expertise in databases. Several studies have proposed programming-by-example approaches to help such non-experts to write correct SQL queries. While existing methods support a variety of SQL features such as aggregation and nested query, they suffer a significant increase in computational cost as the scale of example tables increases. In this paper, we propose an efficient algorithm utilizing properties known in relational algebra to synthesize SQL queries from input and output tables. Our key insight is that a projection operator in a program sketch can be lifted above other operators by applying transformation rules in relational algebra, while preserving the semantics of the program. This enables a quick inference of appropriate columns in the projection operator, which is an essential component in synthesis but causes combinatorial explosions in prior work. We also introduce a novel form of constraints and its top-down propagation mechanism for efficient sketch completion. We implemented this algorithm in our tool PATSQL and evaluated it on 226 queries from prior benchmarks and Kaggle's tutorials. As a result, PATSQL solved 68% of the benchmarks and found 89% of the solutions within a second. Our tool is available at https://naist-se.github.io/patsql/.
Keita Takenouchi, Takashi Ishio, Joji Okada, Yuji Sakata
Proc. VLDB Endow.1