Distributed Database Design
Data replication; Horizontal fragmentation; Vertical fragmentation
Distributed database design refers to the following problem: given a database and its workload, how should the database be split and allocated to sites so as to optimize certain objective function (e.g., to minimize the resource consumption in processing the query workload). There are two issues: (i) data fragmentation which determines how the data should be fragmented and (ii) data allocation which determines how the fragments should be allocated. While these two problems are interrelated, the two issues have traditionally been studied independently, giving rise to a two-phase approach to the design problem.
The design problem is applicable when a distributed database system has to be built from scratch. In the case when multiple existing databases are to be integrated (e.g., in multi-database context), there is no design issue.
In a distributed database system, relations are...
- 1.Ceri S, Negri M, Pelagatti G. Horizontal data partitioning in database design. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1982. p. 128–36.Google Scholar
- 4.Özsu MT, Valduriez P. Principles of distributed database systems. 2nd ed: Prentice-Hall; 1999.Google Scholar
- 10.Chang CC, Shieh JC. On the complexity of file allocation problem. In: Proceedings of the International Conference on the Foundations of Data Organization; 1985. p. 177–81.Google Scholar
- 11.Brunstrom A, Leutenegger ST, Simha R. Experimental evaluation of dynamic data allocation strategies in a distributed database with changing workloads. In: Proceedings of the 4th International Conference on Information and Knowledge Management; 1995. p. 395–402.Google Scholar
- 12.Karlapalem K, Ng MP. Query-driven data allocation algorithms for distributed database systems. In: Proceedings of the 8th International Conference Database and Expert Systems Applications; 1997. p. 347–56.Google Scholar
- 14.Muri S, Ibaraki T, Miyajima H, Hasegawa T. Evaluation of file redundancy in distributed database systems. IEEE Trans Softw Eng. 1995;11(2):199–205.Google Scholar