Design and implementation of Xinjiang raw cotton fiber quality information management system based on web

doi:10.6048/j.issn.1001-4330.2025.08.025

Abstract

Abstract: 【Objective】The notarization inspection system is implemented for raw cotton in China. As an important data resource，raw cotton quality inspection results can give full play to the advantages of big data if they are fully developed and reasonably utilized. To establish Xinjiang raw cotton fiber quality information management system by using computer technology to realize the scientific storage，query and visual analysis of Xinjiang cotton fiber quality and meteorological data，and to provide Scientific basis for cotton production management and quality improvement.【Methods】The notarization inspection data of fiber quality of ginning enterprises in Xinjiang and meteorological data of meteorological stations in Xinjiang cotton region from 2012 to 2022 were collected，and the data were scientifically stored by MySQL database management system，and the Xinjiang raw cotton fiber quality information management system was established based on Web by using HTML，CSS and JavaScript web page front-end programming technology，the Express framework of Node.js platform and the visualization technology of Echarts library.【Results】A lightweight web-based Xinjiang raw cotton fiber quality information management system was developed，which realized the functions of cotton fiber quality data query，download and spatio-temporal visual analysis. The system also had the production status and meteorological factors of cotton producing areas.【Conclusion】The establishment of Xinjiang raw cotton fiber quality information management system is helpful to promote the digitalization and visualization of cotton quality data，and can provide technical support for the utilization and mining of cotton fiber quality data in Xinjiang.

Key words: raw cotton; fiber quality; information management; system design; visual analysis

摘要： 【目的】我国原棉实行公证检验制度，原棉质量检验结果作为重要的数据资源，如能充分开发、合理利用，可发挥大数据优势。应用计算机技术建立新疆原棉纤维品质信息管理系统，实现新疆棉花纤维质量及气象数据的科学存储、查询以及可视化分析，为棉花生产管理和品质提升提供科学依据。【方法】收集2012~2022年新疆轧花企业纤维品质公证检验数据和新疆棉区各气象站点气象数据资料，利用MySQL数据库管理系统科学存储数据，采用HTML、CSS与JavaScript网页前端编程技术、Node.js平台的Express框架和Echarts库可视化技术，搭建基于Web 的新疆原棉纤维品质信息管理系统。【结果】开发轻量级网页端新疆原棉纤维品质信息管理系统，实现了棉花纤维品质数据查询、下载及时空可视化分析功能，该系统同时具有棉花产地的生产状况、气象因素等。【结论】新疆原棉纤维品质信息管理系统的建立，有助于推进棉花品质数据的数字化与可视化进程，可为新疆棉花纤维品质数据利用及挖掘提供技术支持。

关键词: 原棉, 纤维品质, 信息管理, 系统设计, 可视化分析

CLC Number:

S562
TP315

GUO Yu, LU Yongdi, LI Peisong, TIAN Jingshan, ZHANG Wangfeng. Design and implementation of Xinjiang raw cotton fiber quality information management system based on web[J]. Xinjiang Agricultural Sciences, 2025, 62(8): 2074-2080.

郭郁, 陆永迪, 李培松, 田景山, 张旺锋. 基于Web的新疆原棉纤维品质信息管理系统设计与实现[J]. 新疆农业科学, 2025, 62(8): 2074-2080.

References

[1] 国家统计局. 国家统计局关于2023年棉花产量的公告[EB/OL]. (2021.12.25)[2024.04.16]. https://www.stats.gov.cn/sj/zxfb/202312/t20231225_1945745.html National Bureau of Statistics. Announcement of the National Bureau of Statistics on the Cotton Production in 2023[EB/OL]. (2021.12.25)[2024.04.16].https://www.stats.gov.cn/sj/zxfb/202312/t20231225_1945745.html
[2] 董晓波,郭莎莎. 棉花公证检验的经济价值[J]. 中国纤检, 2023,(4):39-41. DONG Xiaobo,GUO Shasha. Economic value of cotton notarization inspection[J]. China Fiber Inspection,2023,(4):39-41.
[3] 李昕航,李超,张桂刚,等. 区块链与数据库技术融合综述[J]. 计算机科学与探索,2023,17(4):761-770. LI Xinhang,LI Chao,ZHANG Guigang,et al. Overview of blockchain and database fusion[J]. Journal of Frontiers of Computer Science and Technology,2023,17(4):761-770.
[4] 刘智慧,张泉灵. 大数据技术研究综述[J]. 浙江大学学报(工学版),2014,48(6):957-972. LIU Zhihui,ZHANG Quanling. Research overview of big data technology[J]. Journal of Zhejiang University(Engineering Science),2014,48(6):957-972.
[5] 梁杰,吴志镛,符景洲,等. 数据库管理系统模糊测试技术研究综述[J]. 软件学报,2025,36(1):399-423. LIANG Jie,WU Zhiyong,FU Jingzhou,et al. Survey on database management system fuzzing techniques[J]. Journal of Software,2025,36(1):399-423.
[6] 孟小峰,周龙骧,王珊. 数据库技术发展趋势[J]. 软件学报, 2004,15(12):1822-1836. MENG Xiaofeng,ZHOU Longxiang,WANG Shan. State of the art and trends in database research[J]. Journal of Software, 2004,15(12):1822-1836.
[7] Codd E F. A relational model of data for large shared data banks[J]. Communications of the ACM,1983,26(1):64-69.
[8] 张浩然,李中良,邹腾飞,等. 农业大数据综述[J]. 计算机科学,2014,41(B11):387-392. ZHANG Haoran,LI Zhongliang,ZOU Tengfei,et al. Overview of agriculture big data research[J]. Computer Science, 2014,41(B11):387-392.
[9] 罗童元,郑雷,谭鑫,等. 江西省水稻需水量预报与网络发布系统开发[J]. 中国农村水利水电,2023,(2):154-159. LUO Tongyuan,ZHENG Lei,TAN Xin,et al. Development of rice water demand forecast and network release system in Jiangxi Province[J]. China Rural Water and Hydropower,2023, (2):154-159.
[10] 杨华,王国军,杨少友,等. 上海农作物种质资源数据库的设计和构建[J]. 植物遗传资源学报,2020,21(2):477-482. YANG Hua,WANG Guojun,YANG Shaoyou,et al. Design and construction of Shanghai crop germplasm resource database[J]. Journal of Plant Genetic Resources,2020,21(2):477-482.
[11] 张莉,任银玲,李国领,等. 河南省小麦品种信息数据库的构建[J]. 河南农业科学,2011,40(10):149-152. ZHANG Li,REN Yinling,LI Guoling,et al. Construction of information database of Henan wheat varieties[J]. Journal of Henan Agricultural Sciences,2011,40(10):149-152.
[12] Horler R S P,Turner A S,Fretter P,et al. SeedStor:a germplasm information management system and public database[J]. Plant & Cell Physiology,2018,59(1):e5.
[13] Reynolds D,Ball J,Bauer A,et al. CropSight:a scalable and open-source information management system for distributed plant phenotyping and IoT-based crop management[J]. GigaScience,2019,8(3):giz009.
[14] Fan R R,Xu H,Zhao Y Y. Design and implementation of information management system for rice[J]. Journal of Physics:Conference Series,2019,1302(2):022008.
[15] 董通,努尔麦麦提·艾尔肯,蒋平安,等. 基于WebGIS的新疆绿洲农田土壤信息集成与共享系统设计[J]. 土壤通报, 2020,51(3):538-544. DONG Tong,Nuermaimaiti Aierken,Jiang Pingan,et al. Design of the soil information sharing and integration system in the oasis farmland of Xinjiang based on WebGIS[J]. Chinese Journal of Soil Science,2020,51(3):538-544.
[16] 张磊,邓良,查睿,等. 基于天地图API的地质灾害管理信息系统研究与应用[J]. 地球与环境,2018,46(2):197-203. ZHANG Lei,DENG Liang,ZHA Rui,et al. Research and application of geological disaster management information system based on"map world"API[J]. Earth and Environment, 2018,46(2):197-203.
[17] 张志,李瑞利. 基于WebGIS的红树林生态管理在线系统[J]. 北京大学学报(自然科学版),2023,59(4):602-608. ZHANG Zhi,LI Ruili. Mangrove ecological management online system based on WebGIS[J]. Acta Scientiarum Naturalium Universitatis Pekinensis,2023,59(4):602-608.
[18] 翟皓,景德广,李黎,等. 基于WebGIS的河南省草地资源信息化系统的设计与实现[J]. 草地学报,2019,27(5):1441-1447. ZHAI Hao,JING Deguang,LI Li,et al. Design and implementation of Henan Province rangeland resource information system based on WebGIS[J]. Acta Agrestia Sinica,2019,27(5):1441-1447.
[19] 魏佳楠,吴勇,林华剑,等. 基于WebGIS的自然资源"一张图"管理信息系统设计与实现[J]. 计算机应用与软件, 2020,37(9):20-26. WEI Jianan,WU Yong,LIN Huajian,et al. Design and implementation of"one map"management information system for natural resources based on WebGIS[J]. Computer Applications and Software,2020,37(9):20-26.
[20] 何延波,刘园,姜月清,等. 经济林果水旱灾害综合数据库设计与建设实践:以北方苹果/葡萄水旱灾害为例[J]. 中国农业气象,2022,43(10):846-859. HE Yanbo,LIU Yuan,JIANG Yueqing,et al. Design and construction practice of the comprehensive database for CashTrees' flood and drought disasters:a case study on apple and grape in northern China[J]. Chinese Journal of Agrometeorology,2022,43(10):846-859.
[21] Zulfiqar F,Datta A,Thapa G B. Determinants and resource use efficiency of"better cotton":an innovative cleaner production alternative[J]. Journal of Cleaner Production,2017,166:1372-1380.