Avatar

Yuankai FAN

PostDoc, Computer Science

Fudan University

Hi there! I am presently serving as a postdoctoral researcher at Fudan University, collaborating with Prof. X. Sean Wang. I earned my Ph.D. degree from the School of Computer Science from Fudan University, where I was also advised by Prof. X. Sean Wang, and Prof. Zhenying He.

My main research interest lies in Artificial Intelligence for Database Systems (AI4DB), Data Governance and Natural Language Processing (NLP), specifically, (1) building advanced natural language interfaces for databases and knowledge graphs (a.k.a. Text-to-SQL and KBQA), interactive and conversational AI systems; (2) natural language understanding includes semantic parsing and text generation; (3) large language model (pre-)training, parameter-efficient fine-tuning, prompting, agent systems, retrieval-augmented generation and edge-side language models; (4) data cleaning, schema matching, and data integration. Free feel to reach out if you’d like to chat! 👏

Publications

The Power of Constraints in Natural Language to SQL Translation New (VLDB, 2025). PDF
Tonghui Ren, Chen Ke, Yuankai FAN, Yinan Jing, Zhenying He, Kai Zhang, X.Sean Wang
Grounding Natural Language to SQL Translation with Data-Based Self-Explanations (ICDE, 2025). PDF Code
Yuankai FAN, Tonghui Ren, Huang Can, Zhenying He, X. Sean Wang
A Confidence-based Knowledge Integration Framework for Cross-Domain Table Question Answering (KBS, 2024). PDF Code
Yuankai FAN, Tonghui Ren, Huang Can, Beini Zheng, Yinan Jing, Zhenying He, Jinbao Li, Jianxin Li*
MetaSQL: A Generate-and-Rank Framework for Natural Language to SQL Translation (ICDE, 2024). PDF Code Video
Yuankai FAN, Zhenying He*, Tonghui Ren, Huang Can, Yinan Jing, Kai Zhang, X.Sean Wang
PURPLE: Making a Large Language Model a Better SQL Writer (ICDE, 2024). PDF
Tonghui Ren, Yuankai FAN, Zhenying He, Ren Huang, Jiaqi Dai, Huang Can, Yinan Jing, Kai Zhang, Yifan Yang, X.Sean Wang
GAR++: Natural Language to SQL Translation with Efficient Generate-and-Rank (APWeb, 2024). PDF
Yuankai FAN, Huang Can, Tonghui Ren, Zhenying He, X.Sean Wang, Xianglian Wu, Yue Wang, Jiaming Li, Yifan Yang
GAR: A Generate-and-Rank Approach for Natural Language to SQL Translation (ICDE, 2023). PDF Code Video
Yuankai FAN, Zhenying He, Tonghui Ren, Dianjun Guo, Lin Chen, Ruisi Zhu, Guanduo Chen, Yinan Jing, Kai Zhang, X.Sean Wang
GENSQL: A Generative Natural Language Interface to Database Systems (ICDE (Demo), 2023). PDF
Yuankai FAN, Tonghui Ren, Zhenying He, X.Sean Wang, Ye Zhang, Xingang Li
An Integrated Interactive Framework for Natural Language to SQL Translation (WISE, 2023). PDF
Yuankai FAN, Tonghui Ren, Dianjun Guo, Zhigang Zhao, Zhenying He, X. Sean Wang, Yu Wang, Tao Sui
Staged Query Graph Generation Based on Answer Type for Question Answering over Knowledge Base (KBS, 2022). PDF
Haoyuan Chen, Fei Ye, Yuankai FAN, Zhenying He, Yinan Jing, Kai Zhang, X. Sean Wang
Zebra: A Novel Method for Optimizing Text Classification Query in Overload Scenario (WWWJ, 2022). PDF
Tianhuan Yu, Zhenying He, Zhihui Yang, Fei Ye, Yuankai FAN, Yinan Jing, Kai Zhang, X. Sean Wang
the New Trend in Natural Language Inter faces for Databases - Opportunities and Challenges in the Era of Large Language Models (Communications of the CCF, 2023).
Yuankai Fan, Zhenying He, X. Sean Wang

Education

PhD in Software Engineering (Combined M.S./Ph.D. program)

Fudan University

September 2017 - January 2023

M.Eng. in Computer Science and Technology

Yanshan University

September 2009 - July 2013