{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,13]],"date-time":"2026-06-13T15:34:49Z","timestamp":1781364889745,"version":"3.54.1"},"publisher-location":"Cham","reference-count":25,"publisher":"Springer International Publishing","isbn-type":[{"value":"9783030890216","type":"print"},{"value":"9783030890223","type":"electronic"}],"license":[{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2021]]},"DOI":"10.1007\/978-3-030-89022-3_14","type":"book-chapter","created":{"date-parts":[[2021,10,15]],"date-time":"2021-10-15T10:01:29Z","timestamp":1634292089000},"page":"160-175","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["Temporal Keyword Search with\u00a0Aggregates and Group-By"],"prefix":"10.1007","author":[{"given":"Qiao","family":"Gao","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mong Li","family":"Lee","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tok Wang","family":"Ling","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2021,10,16]]},"reference":[{"key":"14_CR1","doi-asserted-by":"crossref","unstructured":"Aditya, B., Bhalotia, G., Chakrabarti, S., et al. BANKS: browsing and keyword searching in relational databases. In: VLDB (2002)","DOI":"10.1016\/B978-155860869-6\/50114-1"},{"key":"14_CR2","doi-asserted-by":"publisher","first-page":"832","DOI":"10.1145\/182.358434","volume":"26","author":"JF Allen","year":"1983","unstructured":"Allen, J.F.: Maintaining knowledge about temporal intervals. Commun. ACM 26, 832\u2013843 (1983)","journal-title":"Commun. ACM"},{"key":"14_CR3","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"257","DOI":"10.1007\/11687238_18","volume-title":"Advances in Database Technology - EDBT 2006","author":"M B\u00f6hlen","year":"2006","unstructured":"B\u00f6hlen, M., Gamper, J., Jensen, C.S.: Multi-dimensional aggregation for temporal data. In: Ioannidis, Y., et al. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 257\u2013275. Springer, Heidelberg (2006). https:\/\/doi.org\/10.1007\/11687238_18"},{"key":"14_CR4","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4614-8265-9_1053","volume-title":"Encyclopedia of Database Systems","author":"MH B\u00f6hlen","year":"2018","unstructured":"B\u00f6hlen, M.H., Jensen, C.S.: Sequenced semantics. In: Liu, L., \u00d6zsu, M.T. (eds.) Encyclopedia of Database Systems, 2nd edn. Springer, New York (2018). https:\/\/doi.org\/10.1007\/978-1-4614-8265-9_1053","edition":"2"},{"key":"14_CR5","doi-asserted-by":"publisher","first-page":"1346","DOI":"10.14778\/3137628.3137644","volume":"10","author":"P Bouros","year":"2017","unstructured":"Bouros, P., Mamoulis, N.: A forward scan based plane sweep algorithm for parallel interval joins. Proc. VLDB Endow. 10, 1346\u20131357 (2017)","journal-title":"Proc. VLDB Endow."},{"issue":"3","key":"14_CR6","doi-asserted-by":"publisher","first-page":"447","DOI":"10.1007\/s00778-017-0456-7","volume":"26","author":"F Cafagna","year":"2017","unstructured":"Cafagna, F., B\u00f6hlen, M.H.: Disjoint interval partitioning. VLDB J. 26(3), 447\u2013466 (2017). https:\/\/doi.org\/10.1007\/s00778-017-0456-7","journal-title":"VLDB J."},{"key":"14_CR7","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/2967608","volume":"41","author":"A Dign\u00f6s","year":"2016","unstructured":"Dign\u00f6s, A., B\u00f6hlen, M.H., Gamper, J., Jensen, C.S.: Extending the kernel of a relational DBMS with comprehensive support for sequenced temporal queries. ACM TODS 41, 1\u201346 (2016)","journal-title":"ACM TODS"},{"key":"14_CR8","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"382","DOI":"10.1007\/978-3-030-00847-5_27","volume-title":"Conceptual Modeling","author":"Q Gao","year":"2018","unstructured":"Gao, Q., Lee, M.L., Dobbie, G., Zeng, Z.: A semantic framework for designing temporal SQL databases. In: Trujillo, J.C., et al. (eds.) ER 2018. LNCS, vol. 11157, pp. 382\u2013396. Springer, Cham (2018). https:\/\/doi.org\/10.1007\/978-3-030-00847-5_27"},{"key":"14_CR9","unstructured":"Gao, Q., Lee, M.L., Ling, T.W.: Temporal keyword search with aggregates and group-by. Technical report TRA7\/21, NUS (2021). https:\/\/dl.comp.nus.edu.sg\/handle\/1900.100\/10184"},{"key":"14_CR10","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"355","DOI":"10.1007\/978-3-319-98809-2_22","volume-title":"Database and Expert Systems Applications","author":"Q Gao","year":"2018","unstructured":"Gao, Q., Lee, M.L., Ling, T.W., Dobbie, G., Zeng, Z.: Analyzing temporal keyword queries for interactive search over temporal databases. In: Hartmann, S., Ma, H., Hameurlain, A., Pernul, G., Wagner, R.R. (eds.) DEXA 2018. LNCS, vol. 11029, pp. 355\u2013371. Springer, Cham (2018). https:\/\/doi.org\/10.1007\/978-3-319-98809-2_22"},{"key":"14_CR11","unstructured":"Gunadhi, H., Segev, A.: Query processing algorithms for temporal intersection joins. In: IEEE ICDE (1991)"},{"key":"14_CR12","doi-asserted-by":"crossref","unstructured":"Hormozi, N.: Disambiguation and result expansion in keyword search over relational databases. In: ICDE. IEEE (2019)","DOI":"10.1109\/ICDE.2019.00248"},{"key":"14_CR13","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"3","DOI":"10.1007\/978-3-319-44403-1_1","volume-title":"Database and Expert Systems Applications","author":"X Jia","year":"2016","unstructured":"Jia, X., Hsu, W., Lee, M.L.: Target-oriented keyword search over temporal databases. In: Hartmann, S., Ma, H. (eds.) DEXA 2016. LNCS, vol. 9827, pp. 3\u201319. Springer, Cham (2016). https:\/\/doi.org\/10.1007\/978-3-319-44403-1_1"},{"key":"14_CR14","doi-asserted-by":"crossref","unstructured":"Kaufmann, M., Manjili, A., Vagenas, P., et al.: Timeline index: unified data structure for processing queries on temporal data in SAP HANA. In: SIGMOD (2013)","DOI":"10.1145\/2463676.2465293"},{"key":"14_CR15","doi-asserted-by":"publisher","first-page":"34","DOI":"10.1145\/2380776.2380786","volume":"41","author":"KG Kulkarni","year":"2012","unstructured":"Kulkarni, K.G., Michels, J.: Temporal features in SQL: 2011. SIGMOD Rec. 41, 34\u201343 (2012)","journal-title":"SIGMOD Rec."},{"key":"14_CR16","first-page":"1667","volume":"29","author":"Z Liu","year":"2017","unstructured":"Liu, Z., Wang, C., Chen, Y.: Keyword search on temporal graphs. TKDE 29, 1667\u20131680 (2017)","journal-title":"TKDE"},{"key":"14_CR17","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"125","DOI":"10.1007\/978-3-319-64367-0_7","volume-title":"Advances in Spatial and Temporal Databases","author":"D Piatov","year":"2017","unstructured":"Piatov, D., Helmer, S.: Sweeping-based temporal aggregation. In: Gertz, M., et al. (eds.) SSTD 2017. LNCS, vol. 10411, pp. 125\u2013144. Springer, Cham (2017). https:\/\/doi.org\/10.1007\/978-3-319-64367-0_7"},{"key":"14_CR18","doi-asserted-by":"crossref","unstructured":"Pilman, M., Kaufmann, M., K\u00f6hl, F., Kossmann, D., Profeta, D.: Partime: parallel temporal aggregation. In: ACM SIGMOD (2016)","DOI":"10.1145\/2882903.2903732"},{"key":"14_CR19","doi-asserted-by":"crossref","unstructured":"Tata, S., Lohman, G.: SQAK: doing more with keywords. In SIGMOD (2008)","DOI":"10.1145\/1376616.1376705"},{"key":"14_CR20","first-page":"67","volume":"33","author":"JX Yu","year":"2010","unstructured":"Yu, J.X., Qin, L., Chang, L.: Keyword search in relational databases: a survey. IEEE Data Eng. Bull. 33, 67\u201378 (2010)","journal-title":"IEEE Data Eng. Bull."},{"key":"14_CR21","doi-asserted-by":"publisher","first-page":"169","DOI":"10.1016\/j.engappai.2019.01.017","volume":"81","author":"Z Yu","year":"2019","unstructured":"Yu, Z., Abraham, A., Yu, X., Liu, Y., Zhou, J., Ma, K.: Improving the effectiveness of keyword search in databases using query logs. Eng. Appl. Artif. Intell. 81, 169\u2013179 (2019)","journal-title":"Eng. Appl. Artif. Intell."},{"key":"14_CR22","doi-asserted-by":"crossref","unstructured":"Zeng, Z., Bao, Z., Le, T.N., Lee, M.L., Ling, T.W.: ExpressQ: identifying keyword context and search target in relational keyword queries. In: CIKM (2014)","DOI":"10.1145\/2661829.2661870"},{"key":"14_CR23","unstructured":"Zeng, Z., Lee, M.L., Ling, T.W.: Answering keyword queries involving aggregates and GROUP-BYS on relational databases. In: EDBT (2016)"},{"issue":"2","key":"14_CR24","doi-asserted-by":"publisher","first-page":"225","DOI":"10.1007\/s00778-018-0497-6","volume":"27","author":"D Zhang","year":"2018","unstructured":"Zhang, D., Li, Y., Cao, X., Shao, J., Shen, H.T.: Augmented keyword search on spatial entity databases. VLDB J. 27(2), 225\u2013244 (2018). https:\/\/doi.org\/10.1007\/s00778-018-0497-6","journal-title":"VLDB J."},{"key":"14_CR25","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/1366102.1366109","volume":"33","author":"D Zhang","year":"2008","unstructured":"Zhang, D., Markowetz, A., Tsotras, V.J., Gunopulos, D., Seeger, B.: On computing temporal aggregates with range predicates. ACM TODS 33, 1\u201339 (2008)","journal-title":"ACM TODS"}],"container-title":["Lecture Notes in Computer Science","Conceptual Modeling"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-89022-3_14","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,10,15]],"date-time":"2021-10-15T10:10:58Z","timestamp":1634292658000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-89022-3_14"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021]]},"ISBN":["9783030890216","9783030890223"],"references-count":25,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-89022-3_14","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2021]]},"assertion":[{"value":"16 October 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"ER","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Conceptual Modeling","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"18 October 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"21 October 2021","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"40","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"er2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.er2021.org\/index.html","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"85","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"14","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"18","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"16% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.9","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"2.4","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}