基于SQL的教育资源数据库索引自动推荐模型  

Automatic Recommendation Model of Educational Resource Database Index Based on SQL

作　　者：秦慧娟 QIN Hui-juan(Shanghai Zhenhua Foreing Trade Professional School Affiliated To Sspu,Shanghai 200120 China)

机构地区：[1]上海第二工业大学附属浦东振华外经职业技术学校,上海200120

出　　处：《自动化技术与应用》2022年第10期117-120,136,共5页Techniques of Automation and Applications

摘　　要：针对传统方法存在的推荐结果召回率和准确率较低的问题,提出了基于SQL的教育资源数据库索引自动推荐模型。构建自动推荐模型体系结构,利用索引器抓取互联网上所有网页,创建正向索引和反向索引。利用控制器搜索网页,控制所有网页都能被搜索。通过用户接口限制查询条件。建立基于SQL教育资源数据索引库,对文档查询与处理,结合基于SQL查询语言结构,构建推荐模型。由实验结果可知,该模型推荐准确率高,召回率高,可为用户提供精准的教育资源。Aiming at the low recall and accuracy of recommendation results in traditional methods, an automatic recommendation model based on SQL for education resource database index is proposed. An automatic recommendation model architecture is built, an indexer is used to crawl all web pages on the Internet, and a forward index and a reverse index are created. controller to search web pages and control all web pages are used to be searched. Through the user interface, the query conditions are restricted. A SQL-based educational resource data index database is established, to query and process documents, and it builds a recommendation model based on the SQL query language structure. It can be seen from the experimental results that the highest recommendation accuracy rate of this model is 95%, and the recall rate is 0.95, which can provide users with precise educational resources.

关 键 词：SQL 教育资源 数据库索引 自动推荐 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]