Gengyuan Shi

dblp:289/7804 · DBLP profile ↗
← Back
4ranked-venue papers in the field
3as first author
4since 2021 · last 2025
0009-0007-2938-1539ORCID · reported

Domains — venue-derived; a paper can count in several

Database Systems & Data Management · 3 (2 first)Business Process & Enterprise Data · 1 (1 first)
YearPublicationVenuePosition
2025 PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL
abstract
Procedural Language extensions of SQL (abbr. PL/SQL) enhance database programming by integrating procedural constructs with SQL's declarative syntax, thereby improving the reusability, modularity, and maintainability of SQL. Besides, PL/SQL in database systems presents significant challenges in real-world development, primarily due to the inherent complexity of programming. To reduce the development difficulty of PL/SQL, this paper studies the novel task of translating natural language (NL) to PL/SQL (i.e., NL-to-PL/SQL), aimed at simplifying PL/SQL development. Recent advancements in language models have shown promise in translating natural language questions into SQL queries (i.e., Text-to-SQL). However, the state-of-the-art Text-to-SQL methods focus only on single SQL queries, neglecting the procedural extensions of SQL, which limits their effectiveness for the NL-to-PL/SQL task. In this paper, we propose PLForge, a suite of pre-trained language models with parameter configurations of 3B, 7B, and 15B, tailored for NL-to-PL/SQL tasks. To enhance the PL/SQL generation capabilities of PLForge, we leverage a curated PL/SQL-centric data corpus and employ an incremental pre-training approach. Furthermore, to fully exploit the potential of PLForge, we propose a comprehensive prompt construction strategy tailored specifically for PL/SQL. Given the scarcity of NL-to-PL/SQL datasets, we develop a template-based method for generating NL-to-PL/SQL data. We conduct a series of experiments on PLForge and several baseline models. Based on execution match and exact match metrics that are designed specifically for the NL-to-PL/SQL task, the experimental results demonstrate that PLForge outperforms existing models in both in-context learning and supervised fine-tuning settings.
Hang Zhang 0032, Chaokun Wang, Hongwei Li 0032, Cheng Wu 0004, Songyao Wang, Yabin Liu, Gengyuan Shi, Ziyang Liu 0004
Proc. ACM Manag. Data7
2024 ECQL: Towards Succinct and Extensible Modeling of Multi-model Query Results
Gengyuan Shi, Chaokun Wang, Yabin Liu
ER1
2024 FONT: A Flexible Polystore Evaluation Platform
abstract
The concept of polystore has been proposed and studied for heterogeneous data storage and cross-model query processing. Correspondingly, the evaluation of diverse polystores is an essential yet challenging task. However, most current evaluation approaches for polystores only focus on cross-model analytical workloads and provide limited configurations. To address these problems, this paper presents a flexible polystore evaluation platform named FONT. FONT incorporates hybrid single-model and cross-model workloads that combine read and write operations, as well as diagnostic analytical workloads. FONT supports customization of both multi-model dataset generation and workload generation procedures. The proposed platform is the first visual tool for polystore evaluation, providing user-friendly graphical interfaces for user customization and displaying evaluation results.
Gengyuan Shi, Chaokun Wang
ICDE1
2021 UniTest: A Universal Testing Framework for Database Management Systems
Gengyuan Shi, Chaokun Wang, Bingyang Huang, Hao Feng 0007
DASFAA (1)1