{"created":"2025-01-18T23:34:14.864911+00:00","metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00079520","sets":["581:6276:6633"]},"path":["6633"],"owner":"11","recid":"79520","title":["Efficient Continual Top-k Keyword Search in Relational Databases"],"pubdate":{"attribute_name":"公開日","attribute_value":"2011-12-15"},"_buckets":{"deposit":"9f6df708-dbc8-4f26-a996-e10a3e1b0327"},"_deposit":{"id":"79520","pid":{"type":"depid","value":"79520","revision_id":0},"owners":[11],"status":"published","created_by":11},"item_title":"Efficient Continual Top-k Keyword Search in Relational Databases","author_link":["357321","357318","357320","357323","357319","357322"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"Efficient Continual Top-k Keyword Search in Relational Databases"},{"subitem_title":"Efficient Continual Top-k Keyword Search in Relational Databases","subitem_title_language":"en"}]},"item_keyword":{"attribute_name":"キーワード","attribute_value_mlt":[{"subitem_subject":"特集:情報爆発時代におけるIT基盤技術","subitem_subject_scheme":"Other"}]},"item_type_id":"2","publish_date":"2011-12-15","item_2_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"Department of Computer Science and Technology, Tongji University"},{"subitem_text_value":"Information Technology Center, Nagoya University/Graduate School of Information Science, Nagoya University/National Institute of Informatics"},{"subitem_text_value":"Department of Computer Science and Technology, Tongji University"}]},"item_2_text_4":{"attribute_name":"著者所属(英)","attribute_value_mlt":[{"subitem_text_value":"Department of Computer Science and Technology, Tongji University","subitem_text_language":"en"},{"subitem_text_value":"Information Technology Center, Nagoya University / Graduate School of Information Science, Nagoya University / National Institute of Informatics","subitem_text_language":"en"},{"subitem_text_value":"Department of Computer Science and Technology, Tongji University","subitem_text_language":"en"}]},"item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"eng"}]},"publish_status":"0","weko_shared_id":11,"item_file_price":{"attribute_name":"Billing file","attribute_type":"file","attribute_value_mlt":[{"url":{"url":"https://ipsj.ixsq.nii.ac.jp/record/79520/files/IPSJ-JNL5212026.pdf","label":"IPSJ-JNL5212026"},"date":[{"dateType":"Available","dateValue":"2013-12-15"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-JNL5212026.pdf","filesize":[{"value":"903.5 kB"}],"mimetype":"application/pdf","priceinfo":[{"tax":["include_tax"],"price":"660","billingrole":"5"},{"tax":["include_tax"],"price":"330","billingrole":"6"},{"tax":["include_tax"],"price":"0","billingrole":"8"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"122c5246-49dd-47fd-91b4-a033ee691497","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 2011 by the Information Processing Society of Japan"}]},"item_2_creator_5":{"attribute_name":"著者名","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Yanwei, Xu"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Yoshiharu, Ishikawa"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Jihong, Guan"}],"nameIdentifiers":[{}]}]},"item_2_creator_6":{"attribute_name":"著者名(英)","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Yanwei, Xu","creatorNameLang":"en"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Yoshiharu, Ishikawa","creatorNameLang":"en"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Jihong, Guan","creatorNameLang":"en"}],"nameIdentifiers":[{}]}]},"item_2_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AN00116647","subitem_source_identifier_type":"NCID"}]},"item_resource_type":{"attribute_name":"資源タイプ","attribute_value_mlt":[{"resourceuri":"http://purl.org/coar/resource_type/c_6501","resourcetype":"journal article"}]},"item_2_source_id_11":{"attribute_name":"ISSN","attribute_value_mlt":[{"subitem_source_identifier":"1882-7764","subitem_source_identifier_type":"ISSN"}]},"item_2_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"Keyword search in relational databases has been widely studied in recent years because it requires users neither to master a certain structured query language nor to know the complex underlying database schemas. Most existing methods focus on answering snapshot keyword queries in static databases. In practice, however, databases are updated frequently, and users may have long-term interests on specific topics. To deal with such situations, it is necessary to build effective and efficient facilities in a database system to support continual keyword queries. In this paper, we propose an efficient method for answering continual keyword queries over relational databases. The proposed method consists of two core algorithms. The first one computes a set of potential top-k results by evaluating the range of the future relevance score for every query result and creates a light-weight state for each keyword query. The second one uses these states to maintain the top-k results of keyword queries while the database is continually being updated. Experimental results validate the effectiveness and efficiency of the proposed method.\n------------------------------ \nThis is a preprint of an article intended for publication Journal of \nInformation Processing(JIP). This preprint should not be cited. This \narticle should be cited as: Journal of Information Processing Vol.20(2012) No.1 (online) \nDOI http://dx.doi.org/10.2197/ipsjjip.20.114\n------------------------------ \n","subitem_description_type":"Other"}]},"item_2_description_8":{"attribute_name":"論文抄録(英)","attribute_value_mlt":[{"subitem_description":"Keyword search in relational databases has been widely studied in recent years because it requires users neither to master a certain structured query language nor to know the complex underlying database schemas. Most existing methods focus on answering snapshot keyword queries in static databases. In practice, however, databases are updated frequently, and users may have long-term interests on specific topics. To deal with such situations, it is necessary to build effective and efficient facilities in a database system to support continual keyword queries. In this paper, we propose an efficient method for answering continual keyword queries over relational databases. The proposed method consists of two core algorithms. The first one computes a set of potential top-k results by evaluating the range of the future relevance score for every query result and creates a light-weight state for each keyword query. The second one uses these states to maintain the top-k results of keyword queries while the database is continually being updated. Experimental results validate the effectiveness and efficiency of the proposed method.\n------------------------------ \nThis is a preprint of an article intended for publication Journal of \nInformation Processing(JIP). This preprint should not be cited. This \narticle should be cited as: Journal of Information Processing Vol.20(2012) No.1 (online) \nDOI http://dx.doi.org/10.2197/ipsjjip.20.114\n------------------------------ \n","subitem_description_type":"Other"}]},"item_2_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographic_titles":[{"bibliographic_title":"情報処理学会論文誌"}],"bibliographicIssueDates":{"bibliographicIssueDate":"2011-12-15","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"12","bibliographicVolumeNumber":"52"}]},"relation_version_is_last":true,"weko_creator_id":"11"},"id":79520,"updated":"2025-01-20T06:56:08.975585+00:00","links":{}}