Patent ID: 8190555

Claim:
A data-warehouse-based computational system comprising computers that support interactive creation and exchange of content, the data-warehouse-based computational system further comprising: a data warehouse configured to store data according to a dimensional model and that is accessible by users and application programs, the data warehouse configured to store the data in a dimensional-model-based data-storage facility to which data is added by extract-transform-and-load operations at predetermined intervals; and a semantic-model-based data-storage facility configured to store user-created content for access by application programs and users, wherein the user-created content is according to a semantic model different from the dimensional model, and wherein the semantic-model-based data-storage facility is configured to store the user-created content, as the user-created content is created, within a time frame that is less than a time between successive ones of the extract-transform-and-load operations; and a mechanism to migrate the user-created content from the semantic-model-based data-storage facility to the dimensional-model-based data-storage facility.