sql中将字段内容为****单耗kge改成****单耗
时间: 2024-03-01 14:48:10 浏览: 14
在SQL中,可以使用UPDATE语句来将字段内容进行修改。如果要将字段内容中的"****单耗kge"改成"****单耗",可以使用如下的SQL语句:
```
UPDATE 表名
SET 字段名 = REPLACE(字段名, 'kge', '')
WHERE 字段名 LIKE '%kge';
```
其中,表名是要修改的表的名称,字段名是要修改的字段的名称。REPLACE函数用于替换字符串中的指定内容,这里将"kge"替换为空字符串。WHERE子句用于筛选出字段内容中包含"kge"的记录。
请注意,在执行UPDATE语句之前,请务必备份数据或在测试环境中进行操作,以免意外修改数据。
相关问题
Compared with homogeneous network-based methods, het- erogeneous network-based treatment is closer to reality, due to the different kinds of entities with various kinds of relations [22– 24]. In recent years, knowledge graph (KG) has been utilized for data integration and federation [11, 17]. It allows the knowledge graph embedding (KGE) model to excel in the link prediction tasks [18, 19]. For example, Dai et al. provided a method using Wasser- stein adversarial autoencoder-based KGE, which can solve the problem of vanishing gradient on the discrete representation and exploit autoencoder to generate high-quality negative samples [20]. The SumGNN model proposed by Yu et al. succeeds in inte- grating external information of KG by combining high-quality fea- tures and multi-channel knowledge of the sub-graph [21]. Lin et al. proposed KGNN to predict DDI only based on triple facts of KG [66]. Although these methods have used KG information, only focusing on the triple facts or simple data fusion can limit performance and inductive capability [69]. Su et al. successively proposed two DDIs prediction methods [55, 56]. The first one is an end-to-end model called KG2ECapsule based on the biomedical knowledge graph (BKG), which can generate high-quality negative samples and make predictions through feature recursively propagating. Another one learns both drug attributes and triple facts based on attention to extract global representation and obtains good performance. However, these methods also have limited ability or ignore the merging of information from multiple perspectives. Apart from the above, the single perspective has many limitations, such as the need to ensure the integrity of related descriptions, just as network-based methods cannot process new nodes [65]. So, the methods only based on network are not inductive, causing limited generalization [69]. However, it can be alleviated by fully using the intrinsic property of the drug seen as local information, such as chemical structure (CS) [40]. And a handful of existing frameworks can effectively integrate multi-information without losing induction [69]. Thus, there is a necessity for us to propose an effective model to fully learn and fuse the local and global infor- mation for improving performance of DDI identification through multiple information complementing.是什么意思
这段文字讨论了异质网络方法相对于同质网络方法更接近现实的原因,并介绍了知识图谱和知识图谱嵌入模型在链接预测任务中的应用。作者提出了一些方法来解决多信息融合和归纳能力限制等问题,包括使用药物的局部信息如化学结构,以及利用多种信息来提高药物相互作用识别的性能。这段文字主要是关于药物相互作用预测领域的研究。
知识图谱嵌入评价指标
KGE模型的性能评价指标通常包括MRR、HITS@1和HITS@10。其中,MRR是平均倒数排名,表示所有正确三元组的平均倒数排名,其计算公式为:
$$MRR=\frac{1}{|\mathcal{T}|}\sum_{(h,r,t)\in\mathcal{T}}\frac{1}{rank_{(h,r,t)}}$$
其中,$\mathcal{T}$表示测试集中的所有正确三元组,$rank_{(h,r,t)}$表示正确三元组$(h,r,t)$在模型预测结果中的排名。MRR的取值范围为$[0,1]$,其值越大表示模型性能越好。
另外,HITS@k是命中率指标,表示模型预测结果中前$k$个三元组中包含正确三元组的比例,其计算公式为:
$$HITS@k=\frac{1}{|\mathcal{T}|}\sum_{(h,r,t)\in\mathcal{T}}indicator(rank_{(h,r,t)}\leq k)$$
其中,$\mathcal{T}$表示测试集中的所有正确三元组,$indicator$函数表示条件成立时函数值为1,否则为0。HITS@1和HITS@10分别表示命中率指标中$k=1$和$k=10$的情况。HITS@k的取值范围为$[0,1]$,其值越大表示模型性能越好。