{"title":"一种基于内容和非键属性的排序算法,用于关系型数据库的对象级关键字搜索","authors":"Jianmin Bao, Huan Wang, Xuan Shen, Gang Cui","doi":"10.1109/ICIST.2014.6920333","DOIUrl":null,"url":null,"abstract":"Keyword search technique over relational databases is a research hot-spot in database field. At present, there have been many ranking correlation algorithms for object-level keyword search over relational databases. Object-level keyword search can better integrate information scattered in various tuples. OCS(Object-level Correction Sort) algorithm cannot rank results in keyword search accurately as was expected. This paper foucuses on the problems of ranking results in keyword search system for object-level over relational databases and proposes a new ranking algorithm SOCA(Sort of Correction Algorithm) which takes into consideration the content information of key attributes, and the correlation of non-key attributes. We use Weight to evaluate the content information of key attributes, and Correlation to assess the correlation of non-key attributes Finally, we give a score function about contents Correlation and Weight. Experiments demonstrate that this algorithm can effectively rank results and verify its reasonableness and effectiveness.","PeriodicalId":306383,"journal":{"name":"2014 4th IEEE International Conference on Information Science and Technology","volume":"2 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2014-04-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A ranking algorithm based on contents and non-key attributes for object-level keyword search over relational databases\",\"authors\":\"Jianmin Bao, Huan Wang, Xuan Shen, Gang Cui\",\"doi\":\"10.1109/ICIST.2014.6920333\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Keyword search technique over relational databases is a research hot-spot in database field. At present, there have been many ranking correlation algorithms for object-level keyword search over relational databases. Object-level keyword search can better integrate information scattered in various tuples. OCS(Object-level Correction Sort) algorithm cannot rank results in keyword search accurately as was expected. This paper foucuses on the problems of ranking results in keyword search system for object-level over relational databases and proposes a new ranking algorithm SOCA(Sort of Correction Algorithm) which takes into consideration the content information of key attributes, and the correlation of non-key attributes. We use Weight to evaluate the content information of key attributes, and Correlation to assess the correlation of non-key attributes Finally, we give a score function about contents Correlation and Weight. Experiments demonstrate that this algorithm can effectively rank results and verify its reasonableness and effectiveness.\",\"PeriodicalId\":306383,\"journal\":{\"name\":\"2014 4th IEEE International Conference on Information Science and Technology\",\"volume\":\"2 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2014-04-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2014 4th IEEE International Conference on Information Science and Technology\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICIST.2014.6920333\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2014 4th IEEE International Conference on Information Science and Technology","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICIST.2014.6920333","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
关系型数据库关键字搜索技术是数据库领域的研究热点。目前,针对关系数据库中对象级关键字搜索,已经出现了许多排序关联算法。对象级关键字搜索可以更好地整合分散在各种元组中的信息。OCS(Object-level Correction Sort,对象级校正排序)算法在关键字搜索中不能按预期对结果进行准确排序。针对对象级关系型数据库关键字搜索系统中的排序问题,提出了一种考虑关键属性内容信息和非关键属性相关性的排序算法SOCA(Sort of Correction algorithm)。我们用权重来评价关键属性的内容信息,用相关性来评价非关键属性的相关性,最后给出了内容相关性和权重的评分函数。实验表明,该算法能有效地对结果进行排序,验证了算法的合理性和有效性。
A ranking algorithm based on contents and non-key attributes for object-level keyword search over relational databases
Keyword search technique over relational databases is a research hot-spot in database field. At present, there have been many ranking correlation algorithms for object-level keyword search over relational databases. Object-level keyword search can better integrate information scattered in various tuples. OCS(Object-level Correction Sort) algorithm cannot rank results in keyword search accurately as was expected. This paper foucuses on the problems of ranking results in keyword search system for object-level over relational databases and proposes a new ranking algorithm SOCA(Sort of Correction Algorithm) which takes into consideration the content information of key attributes, and the correlation of non-key attributes. We use Weight to evaluate the content information of key attributes, and Correlation to assess the correlation of non-key attributes Finally, we give a score function about contents Correlation and Weight. Experiments demonstrate that this algorithm can effectively rank results and verify its reasonableness and effectiveness.