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.