Oracle Corporation
SYSTEM AND METHOD FOR SLOWLY CHANGING DIMENSION AND METADATA VERSIONING IN A MULTIDIMENSIONAL DATABASE ENVIRONMENT

Abstract:

In accordance with an embodiment, described herein are systems and methods for supporting slowly changing dimensions and metadata versioning in a multidimensional database, comprising. A system can comprise a computer that includes one or more microprocessors, and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. A data dimension can slowly change over time. When such changes occur, metadata associated with the data dimension can be updated. Advantageously, a current snapshot of the data structure can allow searching of previous changes to the slowly changing dimension based upon the metadata.