基于Word2vec的数据元素匹配相似度分析

Wenhong Liu, Zhiyuan Peng, Shuang Zhao, Jiawei Liu
{"title":"基于Word2vec的数据元素匹配相似度分析","authors":"Wenhong Liu, Zhiyuan Peng, Shuang Zhao, Jiawei Liu","doi":"10.1109/QRS-C57518.2022.00054","DOIUrl":null,"url":null,"abstract":"With the increasing demand for computer-aided big data processing, deep learning has gradually become an effective means to help big data processing. There are often many redundant database fields between different departments. These fields are often completely equivalent, but there are certain differences in field names, which brings trouble to data element matching. To this end, we propose a more targeted approach - ‘MetaMatch’ to handle database fields, combining $W$ ord2vec with a high-performance database. To measure the effectiveness of the proposed method, we propose a $W$ ord2vec-based data element matching method. The method performs semantic segmentation on key fields of the database and trains word vectors. Then, we perform tokenization processing on each training case. According to the result of word segmentation, the corresponding word vector is constructed. We use this method to implement data element matching for big data systems in our experiments and design a validation experiment to evaluate the matching accuracy. The matching accuracy rate reached 79.3%.","PeriodicalId":183728,"journal":{"name":"2022 IEEE 22nd International Conference on Software Quality, Reliability, and Security Companion (QRS-C)","volume":"39 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-12-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Similarity Analysis in Data Element Matching based on Word2vec\",\"authors\":\"Wenhong Liu, Zhiyuan Peng, Shuang Zhao, Jiawei Liu\",\"doi\":\"10.1109/QRS-C57518.2022.00054\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"With the increasing demand for computer-aided big data processing, deep learning has gradually become an effective means to help big data processing. There are often many redundant database fields between different departments. These fields are often completely equivalent, but there are certain differences in field names, which brings trouble to data element matching. To this end, we propose a more targeted approach - ‘MetaMatch’ to handle database fields, combining $W$ ord2vec with a high-performance database. To measure the effectiveness of the proposed method, we propose a $W$ ord2vec-based data element matching method. The method performs semantic segmentation on key fields of the database and trains word vectors. Then, we perform tokenization processing on each training case. According to the result of word segmentation, the corresponding word vector is constructed. We use this method to implement data element matching for big data systems in our experiments and design a validation experiment to evaluate the matching accuracy. The matching accuracy rate reached 79.3%.\",\"PeriodicalId\":183728,\"journal\":{\"name\":\"2022 IEEE 22nd International Conference on Software Quality, Reliability, and Security Companion (QRS-C)\",\"volume\":\"39 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-12-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 IEEE 22nd International Conference on Software Quality, Reliability, and Security Companion (QRS-C)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/QRS-C57518.2022.00054\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 IEEE 22nd International Conference on Software Quality, Reliability, and Security Companion (QRS-C)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/QRS-C57518.2022.00054","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

摘要

随着计算机辅助大数据处理需求的不断增加,深度学习逐渐成为帮助大数据处理的有效手段。在不同的部门之间经常有许多冗余的数据库字段。这些字段通常是完全等价的,但在字段名称上存在一定的差异,这给数据元素匹配带来了麻烦。为此,我们提出了一种更有针对性的方法——“metmatch”来处理数据库字段,将$W$ ord2vec与高性能数据库相结合。为了衡量所提方法的有效性,我们提出了一种基于$W$ ord2vec的数据元素匹配方法。该方法对数据库的关键字段进行语义分割,并训练词向量。然后,对每个训练案例进行标记化处理。根据分词结果,构造相应的词向量。我们在实验中使用该方法实现了大数据系统的数据元素匹配,并设计了验证实验来评估匹配的准确性。匹配正确率达到79.3%。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
Similarity Analysis in Data Element Matching based on Word2vec
With the increasing demand for computer-aided big data processing, deep learning has gradually become an effective means to help big data processing. There are often many redundant database fields between different departments. These fields are often completely equivalent, but there are certain differences in field names, which brings trouble to data element matching. To this end, we propose a more targeted approach - ‘MetaMatch’ to handle database fields, combining $W$ ord2vec with a high-performance database. To measure the effectiveness of the proposed method, we propose a $W$ ord2vec-based data element matching method. The method performs semantic segmentation on key fields of the database and trains word vectors. Then, we perform tokenization processing on each training case. According to the result of word segmentation, the corresponding word vector is constructed. We use this method to implement data element matching for big data systems in our experiments and design a validation experiment to evaluate the matching accuracy. The matching accuracy rate reached 79.3%.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
期刊最新文献
Software Bug Prediction based on Complex Network Considering Control Flow A Fault Localization Method Based on Similarity Weighting with Unlabeled Test Cases What Should Abeeha do? an Activity for Phishing Awareness The Real-Time General Display and Control Platform Designing Method based on Software Product Line Code Search Method Based on Multimodal Representation
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1