Patent ID: 7840607

Claim:
A method comprising: determining a plurality of relational database tables based on a class model representing tag-based data and non-tag-based data and on a plurality of objects instantiated based on the class model; after determining the plurality of relational database tables, receiving a selection of one object of the objects as a dimension of a logical model; receiving a first indication of a first plurality of members of the selected object to be associated with dimension data of the logical model; receiving a second indication of a second plurality of members of the selected object to be associated with fact data of the logical model; creating, with a device, at least one dimension table after receiving the selection of the selected object, the at least one dimension table associated with the selected object and including a primary key column and columns corresponding to the first plurality of members; creating a fact table after receiving the selection of the selected object, the fact table including a foreign key column corresponding to each of the at least one dimension table, such that a plurality of dimension tables would result in a corresponding plurality of foreign key columns in the fact table, the fact table additionally including a column corresponding to each of the second plurality of members; and a primary key of the at least one dimension table being placed in a record of the fact table within the foreign key column corresponding to the at least one dimension table.