Temporal Keyword Search with Aggregates and Group-By
| dc.contributor.author | Gao, Qiao | |
| dc.contributor.author | Lee, Mong Li | |
| dc.contributor.author | Ling, Tok Wang | |
| dc.date.accessioned | 2021-08-05T04:21:58Z | |
| dc.date.available | 2021-08-05T04:21:58Z | |
| dc.date.issued | 2021-07 | |
| dc.description.abstract | Abstract. Temporal keyword search enables non-expert users to query temporal relational databases with time conditions. However, aggregates and group-by are currently not supported in temporal keyword search, which hinders querying of statistical information in temporal databases. This work proposes a framework to support aggregate, group-by and time condition in temporal keyword search. We observe that simply combining non-temporal keyword search with aggregates, group-by, and temporal aggregate operators may lead to incorrect and meaningless results as a result of data duplication over time periods. As such, our framework utilizes Object-Relationship-Attribute semantics to identify a unique at-tribute set in the join sequence relation and remove data duplicates from this attribute set to ensure the correctness of aggregate and group-by computation. We also consider the time period in which temporal at-tributes occur when computing aggregate to return meaningful results. Experiment results demonstrate the importance of these steps to retrieve correct results for keyword queries over temporal databases. | en_US |
| dc.identifier.uri | https://dl.comp.nus.edu.sg/xmlui/handle/1900.100/10184 | |
| dc.language.iso | en_US | en_US |
| dc.relation.ispartofseries | ;TRA7/21 | |
| dc.subject | Temporal Keyword Search, Aggregates and Group-By, Se-mantic Approach | en_US |
| dc.title | Temporal Keyword Search with Aggregates and Group-By | en_US |
| dc.type | Technical Report | en_US |