Temporal Keyword Search with Aggregates and Group-By

Autor:	Tok Wang Ling, Mong Li Lee, Qiao Gao
Rok vydání:	2021
Předmět:	Set (abstract data type) Information retrieval Correctness Relation (database) Relational database Computer science Aggregate (data warehouse) Data deduplication Semantics Temporal database
Zdroj:	Conceptual Modeling ISBN: 9783030890216 ER
DOI:	10.1007/978-3-030-89022-3_14
Popis:	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 attribute 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 attributes 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.
Databáze:	OpenAIRE
Externí odkaz:	https://explore.openaire.eu/search/publication?articleId=doi_________::4aa836db75550cebf12b48dcc7d6fd9a https://doi.org/10.1007/978-3-030-89022-3_14 Zobrazit plný text záznamu