Patent ID: 7610300

Claim:
A computer-implemented system comprising: a computer; a relational database; and a schema generator in the form of software instructions executing on the computer to produce a database schema for the relational database to store multidimensional data in relational database form, wherein the multidimensional data has a plurality of measures, at least a first one of the measures having a plurality of different data types and formats that vary along one or more dimensions of a data cube, wherein the schema generator produces the database schema to include a table having one or more columns for identifying members along the dimensions of the data cube and a plurality of additional columns to store values for the plurality of measures, wherein, for the same members of the dimensions of the data cube, at least two of the additional columns contain values for the plurality of different data type and formats for the at least first one of the measures, and wherein the relational database executes a calculation on at least one of the members of the at least first one of the measures in the relational database, wherein the at least one of the members includes a first value in a first one of the columns in a data type and format corresponding to the first one of the columns and a second value in a second, different one of the columns in a different data type and format corresponding to the second one of the columns, wherein the calculation references the first value and the second value.