Implementation of Distributed Sale System by Using Updatable Materialized View

Abstract

In distributed environments, materialized views are used to replicate the data at distributed sites and to synchronize data updates at several sites. Thus, Materialized view is a kind of way to replicate the distributed data .The data are replicated from master table and then sent to other sites as a materialized view that is used to access the distributed data. Therefore the user can access about the data in local site and even can access data from other sites in entire domain. The user should not need to know where a piece of data is stored physically. This system is intended to implement the Sale System in updateable materialized views (MV) for distributed data.In order to access data not only from local sale site but also from other sale sites and data concurrency is controlled by the timestamp ordering.