Top data analysis performance – case study

Obtaining top data based on defined criteria requires sorting the data, which can be applied to all data in one group or to individual data partitions specified in analytical functions. The limitation of the database system performance is associated with the cardinality of the data set processed in the individual evaluation steps, especially regarding data warehouses and large sets that need to be joined. However, most of the data are refused while maintaining only top data. Many solutions are available, but the significant aspect is related to the performance from the system resources and time consumption point of view. This paper aims to analyze individual solutions and techniques and provide a methodology for processing top data not only in the data warehouse but also in an online transaction processing environment limiting the index number range.