Search

Your search keyword '"Pan, Hongyan"' showing total 263 results
Start Over Author "Pan, Hongyan"
263 results on '"Pan, Hongyan"'

2. CodeS: Towards Building Open-source Language Models for Text-to-SQL

Author

Li, Haoyang, Zhang, Jing, Liu, Hanbing, Fan, Ju, Zhang, Xiaokang, Zhu, Jun, Wei, Renjie, Pan, Hongyan, Li, Cuiping, and Chen, Hong

Subjects
Computer Science - Computation and Language, Computer Science - Databases
Abstract

Language models have shown promising performance on the task of translating natural language questions into SQL queries (Text-to-SQL). However, most of the state-of-the-art (SOTA) approaches rely on powerful yet closed-source large language models (LLMs), such as ChatGPT and GPT-4, which may have the limitations of unclear model architectures, data privacy risks, and expensive inference overheads. To address the limitations, we introduce CodeS, a series of pre-trained language models with parameters ranging from 1B to 15B, specifically designed for the text-to-SQL task. CodeS is a fully open-source language model, which achieves superior accuracy with much smaller parameter sizes. This paper studies the research challenges in building CodeS. To enhance the SQL generation abilities of CodeS, we adopt an incremental pre-training approach using a specifically curated SQL-centric corpus. Based on this, we address the challenges of schema linking and rapid domain adaptation through strategic prompt construction and a bi-directional data augmentation technique. We conduct comprehensive evaluations on multiple datasets, including the widely used Spider benchmark, the newly released BIRD benchmark, robustness-diagnostic benchmarks such as Spider-DK, Spider-Syn, Spider-Realistic, and Dr.Spider, as well as two real-world datasets created for financial and academic applications. The experimental results show that our CodeS achieves new SOTA accuracy and robustness on nearly all challenging text-to-SQL benchmarks., Comment: Accepted to SIGMOD 2024

Published
2024

12. Research on the Guidelines for Green Ecological Planning and Construction of New Cities in Shanghai

Author

Pan Hongyan, Yang Guoshu, and Qiu Xilan

Subjects
Environmental sciences, GE1-350
Abstract

During the 14th Five-Year Plan period, Shanghai's five new cities (Jiading, Qingpu, Songjiang, Fengxian, and Nanhui) are designated as key development areas, with the goal of becoming future cities that lead high-quality living standards and the most ecologically advanced urban areas. In response to the evolving demands for the development of green ecological urban areas in Shanghai, the standards for urban evaluation have been revised. To fully implement the planning and construction requirements of green ecological urban areas in the new cities, a targeted green ecological planning study was conducted at the overall level for these five new cities. Following the approach of “separate cities, separate regions, and distinct focuses,” target units for green ecological urban areas were defined, and a tailored indicator system (“one city, one policy”) along with a list of key regional projects was developed.

Published
2025
Full Text
View/download PDF

13. Jiading New City Green Ecological Urban Planning and Practice — A Case Study of Yuanxiang Lake Central Activity Zone

Author

Yang Guoshu, Pan Hongyan, and Sun Hua

Subjects
Environmental sciences, GE1-350
Abstract

The “14th Five-Year Plan” represents a critical window for the green and low-carbon transition. Jiading New City, characterized by its pioneering role as a “Low-Carbon Urban Area Leader,” focuses on advancing the development of a green ecological urban district and explores the construction of a livable, green, and low-carbon new city. This paper takes the Yuanxiang Lake Central Activity Zone as the subject, elaborating on the green ecological positioning, green ecological indicator system, planning strategies, and the implementation safeguard system. It innovatively proposes the planning and design scheme of a “Green Gene Chain” to activate the Yuanxiang Lake Central Activity Zone, establishing it as a model for the green ecological urban district of Jiading New City and providing a reference for the green ecological planning and construction of other new citys.

Published
2025
Full Text
View/download PDF

29. How can the construction of social credit system in the context of digitalization empower grassroots governance? — A Case Study of 'Moral Bank' in Yuyao City, Zhejiang Province

Author

Pan Hongyan and Zhang Chen

Subjects
credit system construction, grassroots governance, digitalization, moral bank, Political institutions and public administration (General), JF20-2112
Abstract

The 20th Party Congress report proposed to improve the grid-based management, refinement of services, information technology to support the grassroots governance platform, and improve the urban and rural community governance system [1, p. 24]. Grass-roots social governance is the basis of the entire national governance system, which concerns the vital interests of millions of people. At present, the government concentrates funds and material resources on infrastructure construction, and while the hardware environment at the grassroots level is improving, the construction of soft power is seriously lagging behind, and residents’ awareness of participation and public spirit are seriously lacking, so grassroots governance needs to be transformed. The basic function of social credit system is to form incentives and constraints for various subjects with the help of credit evaluation mechanism, so as to realize effective social governance. The establishment of social credit system can not only create an environment to serve social governance, but also provide important support for the modernization of social governance system and national governance capacity. Thus, under the strategic choice of building a comprehensive social credit system, combining an effective social credit system with grassroots social governance is an inevitable choice for China’s future development. Meanwhile, along with the accelerated development of digitization in China, the digitization of social credit system construction has become a powerful boost to promote credit governance. The digital transformation of social credit system can fully activate the path of credit information formation and collection in the traditional social credit system, optimize the operation mechanism and application scenario of credit evaluation mechanism, and thus maximize the functional utility of credit-enabled grassroots social governance. Based on this, this paper attempts to take the many challenges faced by grassroots governance as a logical starting point, take the “moral bank” in Yuyao, Zhejiang Province as a case study, trace how the construction of social credit system empowers grassroots social governance in the context of digitalization, explore the operation mechanism and practical effects of it, and extract corresponding insights.

Published
2023
Full Text
View/download PDF

Catalog

Books, media, physical & digital resources
See catalog results