Five Steps to Construct a Model of Data Allocation for Distributed Database Systems

The allocation of data to nodes in a computer communications network is a critical issue in distributed database design, specially in wide area network where optimizing the distributed queries is the main objective. Numerous models of data allocation have been presented so far (Ceri and Pelagatti, 1986; Lee et al., 1994; Apers, 1988; Mahmood et al., 1994; Theel, 1994; Saha and Mukherjee, 1994; Walfson and Jajodia, 1995), but no optimal or universally accepted algorithm exists yet, and very few algorithms have been implemented to date (Rob and Cornonel, 1993). In this paper a method to construct a model of data allocation for distributed database system has been proposed. The adopted method for the construction of the data allocation model leads to an efficient model of its kind. The proposed model not only solves distributed database design problem, but also solves distributed database maintenance problem by covering initial allocation and post allocation of the data. The efficiency of proposed model has been proved by comparing proposed model with other relevant models.