Patent ID: 8671084

Claim:
A method on an information processing system for modifying at least one data warehouse schema based on detected changes in an associated observation model, the method comprising: determining if at least one new observation model has been created, wherein an observation model is separate and distinct from a data schema, and wherein an observation model models a business process and comprises a set of annotations identifying metrics associated with observation model as one of a dimension and a measure; determining if at least one existing observation model is associated with the new observation model; in response to the existing observation model being associated with the new observation model, identifying at least one changed attribute by comparing the new observation model and the existing observation model, wherein the at least one changed attribute is at least one or more of measure metrics of a monitoring context, dimension metrics of a monitoring context, and monitoring contexts, wherein a monitoring context generates at least one of a set of measure metrics and a set of dimension metrics for a given observation model; generating, based on the at least one changed attribute, a data definition language; and updating, based on the data definition language, a data schema associated with the existing observation model, wherein the updating comprises updating a set of files associated with the existing observation model to reflect the changed attribute between the new observation model and the existing observation model, wherein the updating further comprises updating at least one existing fact table associated with the existing monitoring context so that at least one pointer entry is marked as inactive, wherein marking the at least one pointer entry as inactive prevents data associated with the at least one pointer entry from being stored in the at least one existing fact table.