International Journal of Pure and Applied Research in Engineering and Technology (IJPRET)
Distributed computer environments are becoming the norm. In this type of environment, users share peripherals, data and programs while the infrastructure provides system management across the network. Designing databases in a distributed environment is significantly more complex than designing databases in a centralized environment, largely because of the need to consider network sources, data partitions schemes, redundant data placement alternatives, an replication approaches. In this paper, the authors present two alternatives design for database partitioning at both primary and replicate locations.