Demo Data from EDBT 2026 / reviewers in the wild / expert
Keita Takenouchi
dblp:276/5426
· DBLP profile ↗
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
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Query processing and optimization › query rewriting
query transformation |
0.5 | 1 | 2021 | 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.5 | 1 | 2021 | 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.5 | 1 | 2021 | 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.5 | 1 | 2021 | 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
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2021 | PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected ColumnsabstractSQL 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 |