{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:52:46Z","timestamp":1750308766207,"version":"3.41.0"},"reference-count":40,"publisher":"Association for Computing Machinery (ACM)","issue":"3","license":[{"start":{"date-parts":[[2009,8,1]],"date-time":"2009-08-01T00:00:00Z","timestamp":1249084800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Database Syst."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>\n            <jats:italic>Relational Keyword Search<\/jats:italic>\n            (R-KWS) provides an intuitive way to query relational data without requiring SQL, or knowledge of the underlying schema. In this article we describe a comprehensive framework for R-KWS covering snapshot queries on conventional tables and continuous queries on relational streams. Our contributions are summarized as follows: (i) We provide formal semantics, addressing the temporal validity and order of results, spanning uniformly over tables and streams; (ii) we investigate two general methodologies for query processing,\n            <jats:italic>graph based<\/jats:italic>\n            and\n            <jats:italic>operator based<\/jats:italic>\n            , that resolve several problems of previous approaches; and (iii) we develop a range of algorithms and optimizations covering both methodologies. We demonstrate the effectiveness of R-KWS, as well as the significant performance benefits of the proposed techniques, through extensive experiments with static and streaming datasets.\n          <\/jats:p>","DOI":"10.1145\/1567274.1567279","type":"journal-article","created":{"date-parts":[[2009,9,1]],"date-time":"2009-09-01T17:52:59Z","timestamp":1251827579000},"page":"1-51","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["Keyword search over relational tables and streams"],"prefix":"10.1145","volume":"34","author":[{"given":"Alexander","family":"Markowetz","sequence":"first","affiliation":[{"name":"University of Bonn, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yin","family":"Yang","sequence":"additional","affiliation":[{"name":"Hong Kong University of Science and Technology, Hong Kong"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dimitris","family":"Papadias","sequence":"additional","affiliation":[{"name":"Hong Kong University of Science and Technology, Hong Kong"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2009,9,3]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-003-0095-z"},{"volume-title":"Proceedings of the IEEE International Conference on Data Engineering (ICDE). 5--16","author":"Agrawal S.","key":"e_1_2_1_2_1"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-004-0147-z"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335420"},{"volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB). 564--575","author":"Balmin A.","key":"e_1_2_1_5_1"},{"volume-title":"Proceedings of the IEEE International Conference on Data Engineering (ICDE). 431--440","author":"Bhalotia G.","key":"e_1_2_1_6_1"},{"volume-title":"Proceedings of the Biennial Conference on Innovative Data Systems Research (CIDR).","author":"Chandrasekaran S.","key":"e_1_2_1_7_1"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223856"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1099554.1099674"},{"volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB). 645--649","author":"Dar S.","key":"e_1_2_1_10_1"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497474"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/376284.375677"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/776985.776986"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376708"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/775152.775166"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872762"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247516"},{"volume-title":"Proceedings of 29th International Conference on Very Large Data Bases (VLDB). 850--861","author":"Hristidis V.","key":"e_1_2_1_18_1"},{"volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB). 670--681","author":"Hristidis V.","key":"e_1_2_1_19_1"},{"volume-title":"Proceedings of the IEEE International Conference on Data Engineering (ICDE). 367--378","author":"Hristidis V.","key":"e_1_2_1_20_1"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1183614.1183738"},{"volume-title":"Proceedings of the USENIX Annual Technical Conference. 375--380","author":"Irmak U.","key":"e_1_2_1_22_1"},{"volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB). 505--516","author":"Kacholia V.","key":"e_1_2_1_23_1"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1007\/11601524_4"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142351.1142377"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007699"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376706"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142536"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247518"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247495"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247548"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2009.191"},{"volume-title":"Mragyati: A system for keyword-based searching in databases. Tech. rep. CoRR, cs.DB\/0110052.","year":"2001","author":"Sarda N. L.","key":"e_1_2_1_33_1"},{"volume-title":"Proceedings of the IEEE International Conference on Data Engineering (ICDE). 346--355","author":"Sayyadian M.","key":"e_1_2_1_34_1"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/IDEAS.2005.36"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376707"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247549"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066217"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247498"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/331983.331992"}],"container-title":["ACM Transactions on Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1567274.1567279","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1567274.1567279","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T20:22:32Z","timestamp":1750278152000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1567274.1567279"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":40,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.1145\/1567274.1567279"],"URL":"https:\/\/doi.org\/10.1145\/1567274.1567279","relation":{},"ISSN":["0362-5915","1557-4644"],"issn-type":[{"type":"print","value":"0362-5915"},{"type":"electronic","value":"1557-4644"}],"subject":[],"published":{"date-parts":[[2009,8]]},"assertion":[{"value":"2008-09-01","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2009-06-01","order":1,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2009-09-03","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}