1. A method for performing an aggregating query based on distinctness of data values in a target dimension by ensuring uniqueness of each data item in the target dimension, the method comprising: finding a non-unique value in a dimension of a data table of a relational database, wherein the data table includes a fact table and the dimension contains numeric values; perturbing the non-unique value to render a perturbed instance of the non-unique value that is unique in the dimension of the data table; replacing the non-unique value with the perturbed instance; repeating the above steps to provide a perturbed data table consisting of unique values in the dimension; and performing an aggregating query of the perturbed data table in the relational database without using a SQL join command.