1. A processor-implemented method for performing a query, comprising: receiving an identification of data item components and an association between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated; creating a database query for retrieving data item components, wherein the database query includes a first Uquery, wherein the first Uquery includes a Mx segment subquery and a U0 segment subquery, wherein the Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and wherein the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table; executing the Mx segment subquery to generate Mx segment subquery results; executing the U0 segment subquery to generate U0 segment subquery results; joining the Mx segment subquery results with the U0 segment subquery results to generate Uquery results.