Data processing apparatuses, methods, and non-transitory tangible machine-readable medium thereof

A data processing method for use in an electronic apparatus, comprising the following steps of:

• accessing a dimension table, wherein the dimension table is defined with a plurality of attributes and comprises at least one member, wherein each of the at least one member comprises a plurality of attribute values corresponding to the attributes one-on-one;
• generating a smart index for each of the distinct attribute values, wherein each of the smart indexes comprises a first value equivalent to one of the attribute values, a second value equivalent to the attribute corresponding to the first value, and a third value indicating a rank of the first value comparing to the rest attribute values corresponding to the second value, the first values are distinct;
• and
• integrating the smart indexes into a smart index record, wherein each of the smart indexes has an index within the smart index record.

A non-transitory tangible machine-readable medium, being stored with a computer program, the computer program comprising a plurality of codes, the codes being able to execute a data processing method when the computer program is loaded into an electronic apparatus, the data processing method comprising the steps of:

• accessing a dimension table, wherein the dimension table is defined with a plurality of attributes and comprises at least one member, wherein each of the at least one member comprises a plurality of attribute values corresponding to the attributes one-on-one;
• generating a smart index for each of the distinct attribute values, wherein each of the smart indexes comprises a first value equivalent to one of the attribute values, a second value equivalent to the attribute corresponding to the first value, and a third value indicating a rank of the first value comparing to the rest attribute values corresponding to the second value, the first values are distinct;
• and
• integrating the smart indexes into a smart index record, wherein each of the smart indexes has an index within the smart index record.