Data Analysis - Aggregate Function Performance

Increasingly expanding data analytics brings the need to store a large and structurally diverse amount of data. Related to this is the design of analytical data structures and performance optimization. Individual data are typically aggregated in reports. The goal of this paper is to create a methodology for using aggregation functions in analytical-transactional SQL databases. We focus on the impact of the used parameter format and values, as well as grant total calculation technique with the aim of minimizing processing costs and time.