Towards Evolutionary, Domain-Specific Query Classification Based on Policy Rules
Schwab P, Meyer-Wegener K (2020)
Publication Language: English
Publication Type: Conference contribution, Conference Contribution
Publication year: 2020
Publisher: CEUR-WS
Pages Range: 291-295
Conference Proceedings Title: Proceedings of the Conference "Lernen, Wissen, Daten, Analysen"
Event location: Online
URI: http://ceur-ws.org/Vol-2738/LWDA2020_paper_18.pdf
Abstract
Many devices like smart sensors produce a vast amount of
data that are still commonly stored in relational databases and are being
processed using SQL queries. This data is only useable if it is processed
in a fashion that results in applicable information for the users posing
these queries. Thus, it can be very supportive for them to assess other
queries that have already processed the targeted data. This is not a
simple exercise, as SQL allows alias names and various syntactic structures to express equivalent queries. A manual assessment is also hard to
accomplish due to the amount of qualified queries. We present a framework for evolutionary SQL query classification. Based on the analysis of
query logs, query metadata like schema lineage and result statistics are
automatically derived. Our framework enables users to define domain-specific policy rules for automatic query classification based on the query
metadata. Classification is done according to domain-specific, contextual
attributes that can be defined evolutionary at runtime, together with the
policy rules. The classification results enrich the query metadata.
Authors with CRIS profile
Peter Schwab
Chair for Computer Science 6 (Data Management)
Klaus Meyer-Wegener
Chair for Computer Science 6 (Data Management)
Related research project(s)
How to cite
APA:
Schwab, P., & Meyer-Wegener, K. (2020). Towards Evolutionary, Domain-Specific Query Classification Based on Policy Rules. In Daniel Trabold, Pascal Welke, Nico Piatkowski (Eds.), Proceedings of the Conference "Lernen, Wissen, Daten, Analysen" (pp. 291-295). Online, DE: CEUR-WS.
MLA:
Schwab, Peter, and Klaus Meyer-Wegener. "Towards Evolutionary, Domain-Specific Query Classification Based on Policy Rules." Proceedings of the Lernen, Wissen, Daten, Analysen (LWDA) 2020, Online Ed. Daniel Trabold, Pascal Welke, Nico Piatkowski, CEUR-WS, 2020. 291-295.
BibTeX: Download