Converting numeric values to strings for optimized database storage

A computer implemented method for classifying a textual representation of a numeric database value within a database file, the method comprising:

• determining whether a plurality of database values comprise a plurality of class types, wherein the plurality of class types comprise at least two of:
• numeric, date, string, Boolean, and null data class types;
• in response to determining whether the database values comprise a plurality of data class types, assigning a code to the textual representation of the numeric database value, wherein the code identifies the class type of the textual representation;
• appending the code to the textual representation of the numeric database value;
• determining a numeric data type of the numeric database value;
• assigning a sub-code to the textual representation of the numeric database value, wherein the sub-code identifies the sub-class numeric data type of the textual representation of the numeric database value and wherein the sub-code comprises one of a plurality of sub-codes associated with the code assigned to the textual representation;
• appending the sub-code to the textual representation of the numeric database value, wherein appending the sub-code to the textual representation of the numeric database value comprises enabling the numeric database values to be sorted by the class type of the textual representation of the numeric database value;
• converting the numeric database value to a text string if the precision of the numeric database value is greater than can be stored in a double precision floating point number;
• appending the text string to the textual representation of the numeric database value if the precision of the numeric data is greater than can be stored in a double precision floating point number;
• sorting the textual representation within the database file according to the code assigned to the first dimension member;
• and
• sorting the textual representation against at least one other textual representation assigned the same code independently of the sub-code appended to the converted dimension member.

A computer readable medium having stored thereon computer-executable instructions for performing a method for populating a database file with text strings representing numeric database values, the method comprising:

• receiving a first dimension member;
• determining whether the database values comprise a plurality of data class types, wherein the plurality of data class types comprise at least two of:
• numeric, date, string, Boolean, and null data class types;
• in response to determining whether the database values comprise a plurality of data class types, assigning a code associated with a class type to the first dimension member;
• determining whether the first dimension member is a numeric database value;
• in response to determining that the first dimension member is the numeric database value, determining a numeric data type of the numeric database value;
• converting the first dimension member to a text string;
• storing the converted dimension member in the database file in response to a determination that the first dimension member is a numeric database value, wherein the step of converting the first dimension member to a text string comprises appending a sub-code associated with the numeric data type to the numeric database value to enable the numeric database value to be sorted by the numeric data type and wherein the sub-code comprises one of a plurality of sub-codes associated with the code assigned to the first dimension member;
• converting the numeric database value to a second text string if the precision of the numeric database value is greater than can be stored in a double precision floating point number;
• appending the second text string to the textual representation of the numeric database value if the precision of the numeric data is greater than can be stored in a double precision floating point number;
• storing the first dimension member in the database file, in response to a determination that the first dimension member is not a numeric database value;
• and
• sorting the converted dimension member within the database file according to the code assigned to the first dimension member;
• and
• sorting the first dimension member with at least one second dimension member assigned the same code independently of the sub-code appended to the converted dimension member.

A computer implemented method for converting a numeric database value in a binary representation, having a plurality of bits, to a text string while preserving numeric precision and sort order, wherein the numeric database value comprises at least one of an integer type, floating point type, and decimal type numeric database value, the method comprising:

• determining whether the numeric database value comprises at least one of a plurality of data class types, wherein the plurality of data class types comprise at least two of:
• numeric, date, string, Boolean, and null data class types;
• in response to determining that the numeric database value comprises at least one of the plurality of data class types, assigning a code associated with the data class type to the numeric database value;
• determining, by a computing device comprising a processing unit coupled to a memory storage, a numeric data type of the numeric database value, wherein the numeric data type comprises a sub-type of the assigned data class type;
• assigning a sub-code to the text string of the numeric database value, wherein the sub-code identifies the numeric data type of the text string of the numeric database value and wherein the sub-code comprises one of a plurality of sub-codes associated with the code associated with the assigned data class type;
• in response to a determination that the numeric database value is an integer type, performing the steps of:
• inverting an integer sign bit, and
• converting the integer type numeric database value from the binary representation to a hexadecimal representation;
• in response to a determination that the numeric database value is a floating point type, performing the steps of:
• determining whether the floating point type numeric database value is positive;
• in response to a determination that the floating point type numeric database value is positive, performing the steps of:
• inverting a sign bit, and
• converting the floating point type numeric database value from the binary representation to a hexadecimal representation;
• in response to a determination that the floating point type numeric database value is not positive, performing the steps of:
• inverting each of the plurality of bits, and
• converting the floating point type numeric database value from the binary representation to the hexadecimal representation;
• in response to a determination that the numeric database value is a decimal type numeric database value, performing the steps of:
• determining whether the decimal type numeric database value is positive,
• in response to a determination that the decimal type numeric database value is positive, performing the steps of:
• inverting the integer sign bit,
• converting the decimal type numeric database value from the binary representation to a decimal representation having a plurality of digits, and
• inverting each of the plurality of digits,
• in response to a determination that the decimal type numeric database value is not positive, performing the steps of:
• inverting the sign bit, and
• converting the decimal type numeric database value from the binary representation to a decimal representation having a plurality of digits;
• and
• storing the converted database value in a database file;
• sorting the converted database value within the database file according to the code assigned to the numeric database value;
• and
• sorting the converted database value with at least one second converted database value assigned the same code independently of the sub-code appended to the converted dimension member.

A method for populating a database file with text strings representing numeric data, the method comprising:

• receiving a first dimension member out of a plurality of dimension members;
• determining whether the plurality of dimension members comprise a plurality of data class types, wherein the plurality of data class types comprise at least two of:
• numeric, date, string, Boolean, and null data class types;
• in response to determining that the plurality of dimension members comprise a plurality of data class types, determining a data class type of the first dimension member and assigning a code associated with the data class type to the first dimension member;
• determining, by a computing device comprising a processing unit coupled to a memory storage, whether the first dimension member is numeric data;
• in response to determining that a first dimension member is numeric data, determining a numeric data type of the numeric data;
• converting the first dimension member to a double precision floating point number;
• converting the resultant double precision floating point number to a text string and storing the resultant text string in the database file, in response to a determination that the first dimension member is numeric data, wherein in converting the first dimension to a text string, the numeric precision and sort order of the first dimension member in the plurality of dimension members is maintained;
• assigning a sub-code to the text string, wherein the sub-code identifies the numeric data type of the text string of the numeric data and wherein the sub-code comprises one of a plurality of sub-codes associated with the code assigned to the first dimension member;
• converting the numeric database value to a second text string if the precision of the numeric database value is greater than can be stored in the double precision floating point number;
• and
• appending the second text string to the first text string if the precision of the numeric data is greater than can be stored in the double precision floating point number;
• and
• storing the first dimension member in the database file, in response to a determination that the first dimension member is not numeric data;
• and
• storing the first dimension member in the database file, in response to a determination that the first dimension member is not a numeric database value;
• sorting the first dimension member within the database file according to the code assigned to the first dimension member;
• and
• sorting the first dimension member against at least one second dimension member assigned the same code independently of the sub-code appended to the converted dimension member.