Efficiently Labeling and Retrieving Temporal Anomalies in Relational Databases.
Saved in:
| Title: | Efficiently Labeling and Retrieving Temporal Anomalies in Relational Databases. |
|---|---|
| Authors: | Khnaisser, Christina1 (AUTHOR) Christina.Khnaisser@usherbrooke.ca, Hamrouni, Hind2 (AUTHOR) hindhamrouni@gmail.com, Blumenthal, David B.3 (AUTHOR) david.b.blumenthal@fau.de, Dignös, Anton2 (AUTHOR) anton.dignoes@unibz.it, Gamper, Johann2 (AUTHOR) johann.gamper@unibz.it |
| Source: | Information Systems Frontiers. Apr2026, Vol. 28 Issue 2, p561-585. 25p. |
| Subjects: | Relational databases, Data quality, Constraint satisfaction, Outlier detection, Data extraction, Medical databases |
| Abstract: | Time and temporal constraints are implicit in most databases. To facilitate data analysis and quality assessment, a database should provide explicit operations to identify the violation of temporal constraints. Against this background, the purpose of this paper is threefold: (1) we identify and provide a formal definition of five common anomalies in temporal databases, (2) we propose two new relational operations that allow, respectively, to label anomalous tuples in and to retrieve the anomalous tuples from a dataset, and (3) we provide three different SQL implementations of these operations for current relational database management systems. The healthcare domain is used to illustrate the usage and utility of the temporal anomalies. Finally, an experimental evaluation on real-world and synthetic data analyses the performance of the different implementations of the anomaly operators. [ABSTRACT FROM AUTHOR] |
| Copyright of Information Systems Frontiers is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
|
Full text is not displayed to guests.
Login for full access.
|
|
| Abstract: | Time and temporal constraints are implicit in most databases. To facilitate data analysis and quality assessment, a database should provide explicit operations to identify the violation of temporal constraints. Against this background, the purpose of this paper is threefold: (1) we identify and provide a formal definition of five common anomalies in temporal databases, (2) we propose two new relational operations that allow, respectively, to label anomalous tuples in and to retrieve the anomalous tuples from a dataset, and (3) we provide three different SQL implementations of these operations for current relational database management systems. The healthcare domain is used to illustrate the usage and utility of the temporal anomalies. Finally, an experimental evaluation on real-world and synthetic data analyses the performance of the different implementations of the anomaly operators. [ABSTRACT FROM AUTHOR] |
|---|---|
| ISSN: | 13873326 |
| DOI: | 10.1007/s10796-024-10495-w |
