Study of History Management of Data: Slowly Changing Dimension to Independent Data Mart

Abstract

Data History plays vital role on management of historical data on data mart such as real time updating and recording difficulties especially when many operations are performing. The difficulties of data management include timely update and strong storage system. In this paper, we describe few methods of managing data history in independent data marts as well as databases. And also illustrate the concept of slowly changing dimension that this how it can be utilized in the independent data mart of institutions to update and maintain campaign records of customers. There are many kinds of dealing with the history of the data. In this article we will present some examples, advantages and disadvantages of each of the method and use of possible prospective.