Bernd Amann
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Previous Organizations / Institutes
The organizations / institutes from the scholar's other articles in the past ten years
Bernd Amann has a total of 98 co-authors. Here are the top co-authors by number of shared publications:
Michel Scholl
Cedric-CNAM Paris and INRIA-Futurs
8 shared publicationsIrini Fundulaki
Cedric-CNAM Paris and INRIA-Futurs
6 shared publicationsCamelia Constantin
LIP6 - Univ. de Pierre et Marie Curie (UPMC)
5 shared publicationsHubert Naacke
4 shared publicationsCatriel Beeri
The Hebrew University
3 shared publicationsDan Vodislav
3 shared publications
Latest Publications
- Open Access
- 23 June 2023
- Published by Association for Computing Machinery (ACM) in Journal of Data and Information Quality
- Vol. 15 (2) , 1-41
Controlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries
We present a comprehensive set of conditions and rules to control the correctness of aggregation queries within an interactive data analysis session. The goal is to extend self-service data preparation and Business Intelligence (BI) tools to automatically detect semantically incorrect aggregate queries on analytic tables and views built by using the common analytic operations including filter, project, join, aggregate, union, difference, and pivot. We introduceaggregable propertiesto describe for any attribute of an analytic table, which aggregation functions correctly aggregate the attribute along which sets of dimension attributes. These properties can also be used to formally identify attributes that aresummarizablewith respect to some aggregation function along a given set of dimension attributes. This is particularly helpful to detect incorrect aggregations of measures obtained through the use of non-distributive aggregation functions like average and count. We extend the notion of summarizability by introducing a newgeneralized summarizability conditionto control the aggregation of attributes after any analytic operation. Finally, we definepropagation rulesthat transform aggregable properties of the query input tables into new aggregable properties for the result tables, preserving summarizability and generalized summarizability.
- 23 June 2023
- Published by Association for Computing Machinery (ACM) in Journal of Data and Information Quality
- Vol. 15 (2) , 1-41
Open AccessControlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries
We present a comprehensive set of conditions and rules to control the correctness of aggregation queries within an interactive data analysis session. The goal is to extend self-service data preparation and Business Intelligence (BI) tools to automatically detect semantically incorrect aggregate queries on analytic tables and views built by using the common analytic operations including filter, project, join, aggregate, union, difference, and pivot. We introduceaggregable propertiesto describe for any attribute of an analytic table, which aggregation functions correctly aggregate the attribute along which sets of dimension attributes. These properties can also be used to formally identify attributes that aresummarizablewith respect to some aggregation function along a given set of dimension attributes. This is particularly helpful to detect incorrect aggregations of measures obtained through the use of non-distributive aggregation functions like average and count. We extend the notion of summarizability by introducing a newgeneralized summarizability conditionto control the aggregation of attributes after any analytic operation. Finally, we definepropagation rulesthat transform aggregable properties of the query input tables into new aggregable properties for the result tables, preserving summarizability and generalized summarizability.
- Open Access
Controlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries
We present a comprehensive set of conditions and rules to control the correctness of aggregation queries within an interactive data analysis session. The goal is to extend self-service data preparation and BI tools to automatically detect semantically incorrect aggregate queries on analytic tables and views built by using the common analytic operations including filter, project, join, aggregate, union, difference, and pivot. We introduce aggregable properties to describe for any attribute of an analytic table which aggregation functions correctly aggregates the attribute along which sets of dimension attributes. These properties can also be used to formally identify attributes which are summarizable with respect to some aggregation function along a given set of dimension attributes. This is particularly helpful to detect incorrect aggregations of measures obtained through the use of non-distributive aggregation functions like average and count. We extend the notion of summarizability by introducing a new generalized summarizability condition to control the aggregation of attributes after any analytic operation. Finally, we define propagation rules which transform aggregable properties of the query input tables into new aggregable properties for the result tables, preserving summarizability and generalized summarizability.
Open AccessControlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries
We present a comprehensive set of conditions and rules to control the correctness of aggregation queries within an interactive data analysis session. The goal is to extend self-service data preparation and BI tools to automatically detect semantically incorrect aggregate queries on analytic tables and views built by using the common analytic operations including filter, project, join, aggregate, union, difference, and pivot. We introduce aggregable properties to describe for any attribute of an analytic table which aggregation functions correctly aggregates the attribute along which sets of dimension attributes. These properties can also be used to formally identify attributes which are summarizable with respect to some aggregation function along a given set of dimension attributes. This is particularly helpful to detect incorrect aggregations of measures obtained through the use of non-distributive aggregation functions like average and count. We extend the notion of summarizability by introducing a new generalized summarizability condition to control the aggregation of attributes after any analytic operation. Finally, we define propagation rules which transform aggregable properties of the query input tables into new aggregable properties for the result tables, preserving summarizability and generalized summarizability.
- 1 November 2021
- Published by Elsevier in Big Data Research
- Vol. 26
An Analytic Graph Data Model and Query Language for Exploring the Evolution of Science
- 1 November 2021
- Published by Elsevier in Big Data Research
- Vol. 26
An Analytic Graph Data Model and Query Language for Exploring the Evolution of Science
- 1 July 2020
- Published by Elsevier in Information Systems
- Vol. 91
Discovering and merging related analytic datasets
- 1 July 2020
- Published by Elsevier in Information Systems
- Vol. 91
Discovering and merging related analytic datasets
- 1 December 2019
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 4793-4798
Efficient similarity-based alignment of temporally-situated graph nodes with Apache Spark
- 1 December 2019
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 4793-4798
Efficient similarity-based alignment of temporally-situated graph nodes with Apache Spark
- 13 August 2019
- Published by Springer Nature
- p. 302-318
Query-Oriented Answer Imputation for Aggregate Queries
- 13 August 2019
- Published by Springer Nature
- p. 302-318
Query-Oriented Answer Imputation for Aggregate Queries
- 6 August 2019
- Published by Springer Nature
- p. 47-62
Explaining Query Answer Completeness and Correctness with Partition Patterns
- 6 August 2019
- Published by Springer Nature
- p. 47-62
Explaining Query Answer Completeness and Correctness with Partition Patterns
- 7 December 2018
- Published by Springer Nature
- p. 4852-4858
XSL/XSLT
- 6 August 2018
- Published by Wiley
- p. 21-55
Distributed SPARQL Query Processing: a Case Study with Apache Spark
- 6 August 2018
- Published by Wiley
- p. 21-55
Distributed SPARQL Query Processing: a Case Study with Apache Spark
- 12 June 2018
- Published by Springer Nature
- p. 3424-3427
XSLT