ARTICLE

Volume 4,Issue 6

Cite this article
1
Download
2
Citations
11
Views
20 June 2026

基于预训练模型适配的烟草营销领域智能查询增强技术研究

一平 李1 刚 舒2 滔 张1 凯 祝1 康 程2
Show Less
1 湖北省烟草公司黄石市公司, 中国
2 湖北省烟草公司鄂州市公司, 中国
ERA 2026 , 4(6), 82–85; https://doi.org/10.61369/ERA.2026060042
© 2026 by the Author(s). Licensee Art and Technology, USA. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution -Noncommercial 4.0 International License (CC BY-NC 4.0) ( https://creativecommons.org/licenses/by-nc/4.0/ )
Abstract

针对XX 烟草企业营销数据孤岛严重、业务人员数据分析能力不强、需求响应迟缓等问题,本文结合业务需求及现有技术,提出融合湖仓一体架构与改进型NL2SQL 技术的查询增强方案,以满足企业技术需求。

Keywords
查询增强
NL2SQL
维度建模
烟草营销
References

[1] Gartner. Hype Cycle for Data Management, 2022[R]. Stamford: Gartner, 2022.
[2] Zaharia M, Ghodsi A, Xin R, et al. Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics[C]// Proceedings of the 11th Conference on Innovative Data Systems Research (CIDR). Online: www.cidrdb.org, 2021.
[3] Elizabeth M. Pierce, Song I Y. Dimensional modeling: Identification, classification, and evaluation of patterns[J]. Decision Support Systems, 2008, 45(1): 59-76.
[4] Wang B, Shin R, Liu X, et al. RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers[C]// Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics (ACL). Online: ACL, 2020: 7567-7578.
[5] Sun Z, Deng Z H, Nie J Y, Tang J. RotatE: Knowledge Graph Embedding by Relational Rotation in Complex Space[C]// Proceedings of the 7th International Conference on Learning Representations (ICLR). New Orleans: OpenReview.net, 2019.
[6] Hu E J, Shen Y, Wallis P, et al. LoRA: Low-Rank Adaptation of Large Language Models[C]// Proceedings of the 10th International Conference on Learning Representations (ICLR). Online: OpenReview.net, 2022.

Share
Back to top