Patent ID: 7844613
Filing Date: 2010-11-30
Classification: G06F

Abstract:
1. A method of managing a data warehouse, the method comprising: managing historical data stored in the data warehouse in an historical format, the historical data being generated from operational data stored in an operational format using a first set of data operations, wherein the historical format comprises a data structure that is conducive for performing queries on the historical data and wherein the operational format comprises a different data structure that is conducive for facilitating transactions in an operational environment; and generating, by using a computer, a set of layers for the data warehouse, the set of layers including an operational layer that enables access to the historical data in the operational format, the operational layer including a second set of data operations configured to undo the first set of data operations to create a representation of the historical data in the operational format, wherein the generating uses a metadata later for the data warehouse and the metadata layer defines a plurality of mappings for the second set of data operations.