{"id":"https://openalex.org/W4399246642","doi":"https://doi.org/10.1007/s10796-024-10495-w","title":"Efficiently Labeling and Retrieving Temporal Anomalies in Relational Databases","display_name":"Efficiently Labeling and Retrieving Temporal Anomalies in Relational Databases","publication_year":2024,"publication_date":"2024-05-31","ids":{"openalex":"https://openalex.org/W4399246642","doi":"https://doi.org/10.1007/s10796-024-10495-w"},"language":"en","primary_location":{"id":"doi:10.1007/s10796-024-10495-w","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1007/s10796-024-10495-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10796-024-10495-w.pdf","source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10796-024-10495-w.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5052892262","display_name":"Christina Khnaisser","orcid":"https://orcid.org/0000-0002-1186-0300"},"institutions":[{"id":"https://openalex.org/I135117807","display_name":"Universit\u00e9 de Sherbrooke","ror":"https://ror.org/00kybxq39","country_code":"CA","type":"education","lineage":["https://openalex.org/I135117807"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Christina Khnaisser","raw_affiliation_strings":["Faculty of Medicine and Health Sciences, Universit\u00e9 de Sherbrooke, 3001, 12e avenue Nord, Sherbrooke, Sherbrooke, J1H 5N4, Qu\u00e9bec, Canada","Faculty of Medicine and Health Sciences, Universit\u00e9 de Sherbrooke, Sherbrooke, Canada"],"raw_orcid":"https://orcid.org/0000-0002-1186-0300","affiliations":[{"raw_affiliation_string":"Faculty of Medicine and Health Sciences, Universit\u00e9 de Sherbrooke, 3001, 12e avenue Nord, Sherbrooke, Sherbrooke, J1H 5N4, Qu\u00e9bec, Canada","institution_ids":["https://openalex.org/I135117807"]},{"raw_affiliation_string":"Faculty of Medicine and Health Sciences, Universit\u00e9 de Sherbrooke, Sherbrooke, Canada","institution_ids":["https://openalex.org/I135117807"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013704620","display_name":"Hind Hamrouni","orcid":"https://orcid.org/0000-0001-8462-3085"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Hind Hamrouni","raw_affiliation_strings":["Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy"],"raw_orcid":"https://orcid.org/0000-0001-8462-3085","affiliations":[{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]},{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087738237","display_name":"David B. Blumenthal","orcid":"https://orcid.org/0000-0001-8651-750X"},"institutions":[{"id":"https://openalex.org/I1325886976","display_name":"Siemens (Germany)","ror":"https://ror.org/059mq0909","country_code":"DE","type":"company","lineage":["https://openalex.org/I1325886976"]},{"id":"https://openalex.org/I181369854","display_name":"Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg","ror":"https://ror.org/00f7hpc57","country_code":"DE","type":"education","lineage":["https://openalex.org/I181369854"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"David B. Blumenthal","raw_affiliation_strings":["Department Artificial Intelligence in Biomedical Engineering, Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Erlangen, Germany","Department Artificial Intelligence in Biomedical Engineering, Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Werner-von-Siemens-Str. 61, Erlangen, 91052, Germany"],"raw_orcid":"https://orcid.org/0000-0001-8651-750X","affiliations":[{"raw_affiliation_string":"Department Artificial Intelligence in Biomedical Engineering, Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Erlangen, Germany","institution_ids":["https://openalex.org/I181369854"]},{"raw_affiliation_string":"Department Artificial Intelligence in Biomedical Engineering, Friedrich-Alexander-Universit\u00e4t Erlangen-N\u00fcrnberg, Werner-von-Siemens-Str. 61, Erlangen, 91052, Germany","institution_ids":["https://openalex.org/I1325886976","https://openalex.org/I181369854"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037964119","display_name":"Anton Dign\u00f6s","orcid":"https://orcid.org/0000-0002-7621-967X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Anton Dign\u00f6s","raw_affiliation_strings":["Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy"],"raw_orcid":"https://orcid.org/0000-0002-7621-967X","affiliations":[{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]},{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5043864804","display_name":"Johann Gamper","orcid":"https://orcid.org/0000-0002-7128-507X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Johann Gamper","raw_affiliation_strings":["Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy"],"raw_orcid":"https://orcid.org/0000-0002-7128-507X","affiliations":[{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]},{"raw_affiliation_string":"Faculty of Engineering, Free University of Bozen-Bolzano, Piazza Domenicani, 3, Bolzano, 39100, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5013704620","https://openalex.org/A5037964119","https://openalex.org/A5043864804","https://openalex.org/A5052892262","https://openalex.org/A5087738237"],"corresponding_institution_ids":["https://openalex.org/I1325886976","https://openalex.org/I135117807","https://openalex.org/I171543936","https://openalex.org/I181369854"],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":{"value":2890,"currency":"USD","value_usd":2890},"fwci":0.2126,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.42943404,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"28","issue":"2","first_page":"561","last_page":"585"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7313395142555237},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5676751732826233},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5543526411056519},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4685536324977875},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.4670509397983551}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7313395142555237},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5676751732826233},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5543526411056519},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4685536324977875},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.4670509397983551}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1007/s10796-024-10495-w","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1007/s10796-024-10495-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10796-024-10495-w.pdf","source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},{"id":"pmh:oai:econstor.eu:10419/342015","is_oa":true,"landing_page_url":"https://hdl.handle.net/10419/342015","pdf_url":null,"source":{"id":"https://openalex.org/S4306401696","display_name":"Econstor (Econstor)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:article"},{"id":"pmh:oai:open.fau.de:openfau/39933","is_oa":true,"landing_page_url":"https://open.fau.de/handle/openfau/39933","pdf_url":null,"source":{"id":"https://openalex.org/S4306402340","display_name":"OPUS FAU (Kooperativer Bibliotheksverbund Berlin-Brandenburg (KOBV), on behalf of the Universit\u00e4tsbibliothek Erlangen-N\u00fcrnberg)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:unibz.it:11326802630001241","is_oa":true,"landing_page_url":"https://bia.unibz.it/esploro/outputs/journalArticle/Efficiently-Labeling-and-Retrieving-Temporal-Anomalies/991006900954201241","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1007/s10796-024-10495-w","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1007/s10796-024-10495-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10796-024-10495-w.pdf","source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320314455","display_name":"Minist\u00e8re de l'\u00c9conomie, de la Science et de l'Innovation - Qu\u00e9bec","ror":null},{"id":"https://openalex.org/F4320328864","display_name":"Provincia autonoma di Bolzano - Alto Adige","ror":null}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4399246642.pdf"},"referenced_works_count":29,"referenced_works":["https://openalex.org/W79227567","https://openalex.org/W1494888044","https://openalex.org/W1531918044","https://openalex.org/W1552038313","https://openalex.org/W1602871442","https://openalex.org/W1748990669","https://openalex.org/W2032311942","https://openalex.org/W2083150957","https://openalex.org/W2113056857","https://openalex.org/W2123588622","https://openalex.org/W2139125912","https://openalex.org/W2147270837","https://openalex.org/W2444247778","https://openalex.org/W2526076264","https://openalex.org/W2546460896","https://openalex.org/W2801794212","https://openalex.org/W2884270003","https://openalex.org/W2923282531","https://openalex.org/W2941931512","https://openalex.org/W2996730172","https://openalex.org/W3149027868","https://openalex.org/W3197576545","https://openalex.org/W3213289795","https://openalex.org/W4235612640","https://openalex.org/W4249550060","https://openalex.org/W4293657573","https://openalex.org/W4299448072","https://openalex.org/W4312675885","https://openalex.org/W6884898520"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W124328752","https://openalex.org/W1596616643","https://openalex.org/W2405416608"],"abstract_inverted_index":{"Abstract":[0],"Time":[1],"and":[2,14,43,70,79,105,117],"temporal":[3,28,53,109],"constraints":[4],"are":[5],"implicit":[6],"in":[7,52,69],"most":[8],"databases.":[9],"To":[10],"facilitate":[11],"data":[12,119],"analysis":[13],"quality":[15],"assessment,":[16],"a":[17,45,77],"database":[18,93],"should":[19],"provide":[20,44,82],"explicit":[21],"operations":[22,61,89],"to":[23,65,71,101],"identify":[24,42],"the":[25,33,73,103,108,121,124,128],"violation":[26],"of":[27,35,48,87,107,123,127],"constraints.":[29],"Against":[30],"this":[31,36],"background,":[32],"purpose":[34],"paper":[37],"is":[38,99],"threefold:":[39],"(1)":[40],"we":[41,56,81],"formal":[46],"definition":[47],"five":[49],"common":[50],"anomalies":[51],"databases,":[54],"(2)":[55],"propose":[57],"two":[58],"new":[59],"relational":[60,92],"that":[62],"allow,":[63],"respectively,":[64],"label":[66],"anomalous":[67,74],"tuples":[68,75],"retrieve":[72],"from":[76],"dataset,":[78],"(3)":[80],"three":[83],"different":[84,125],"SQL":[85],"implementations":[86,126],"these":[88],"for":[90],"current":[91],"management":[94],"systems.":[95],"The":[96],"healthcare":[97],"domain":[98],"used":[100],"illustrate":[102],"usage":[104],"utility":[106],"anomalies.":[110],"Finally,":[111],"an":[112],"experimental":[113],"evaluation":[114],"on":[115],"real-world":[116],"synthetic":[118],"analyses":[120],"performance":[122],"anomaly":[129],"operators.":[130]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-07-29T09:40:50.615796","created_date":"2025-10-10T00:00:00"}