Implementation of Sales Data Warehouse Using Materialized View

Abstract

A distributed database is not stored in its entirety at a single physical location. Instead, it is spread across a network of computers that are geographically dispersed and connected via communications links. A distributed database allows faster local queries and can reduce network traffic. It allows applications to access data from local and remote database. In distributed environments, materialized views are used to replicate data at distributed sites and synchronize updates done at several sites with conflict resolution methods. The user should not need to know where a piece of data is stored physically. If materialized views are used, Database Administrator (DBA) can easily manage the database without too much effort. Utilizing the materialized views can not only reduce system errors but also improve system performance. So, this system is intended to develop Sales Data warehouse by using updateable materialized views.