Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Distributed Database Design

  • Kian-Lee TanEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_703


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.

Historical Background

In a distributed database system, relations are...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 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
  2. 2.
    Ceri S, Pelagatti G. Distributed databases: principles and systems. New York: McGraw-Hill; 1984.zbMATHGoogle Scholar
  3. 3.
    Navathe S, Ceri S, Wiederhold G, Dou J. Vertical partitioning of algorithms for database design. ACM Trans Database Syst. 1984;9(4):680–710.CrossRefGoogle Scholar
  4. 4.
    Özsu MT, Valduriez P. Principles of distributed database systems. 2nd ed: Prentice-Hall; 1999.Google Scholar
  5. 5.
    Sacca D, Wiederhold G. Database partitioning in a cluster of processors. ACM Trans Database Syst. 1985;10(1):29–56.CrossRefzbMATHGoogle Scholar
  6. 6.
    McCormick WT, Schweitzer PJ, White TW. Problem decomposition and data reorganization by a clustering techniqiue. Oper Res. 1972;20(5):993–1009.CrossRefzbMATHGoogle Scholar
  7. 7.
    Chu WW. Optimal file allocation in a multiple computer network. IEEE Trans Comput. 1969;C-18(10):885–9.CrossRefzbMATHGoogle Scholar
  8. 8.
    Apers PM. Data allocation in distributed database systems. ACM Trans Database Syst. 1988;13(2):263–304.CrossRefGoogle Scholar
  9. 9.
    Bell DA. Difficult data placement problems. Comput J. 1984;27(4):315–20.CrossRefMathSciNetGoogle Scholar
  10. 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. 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. 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
  13. 13.
    Yoshida M, Mizumachi K, Wakino A, Oyake I, Matsushita Y. Time and cost evaluation schemes of multiple copies of data in distributed database systems. IEEE Trans Softw Eng. 1985;11(9):954–8.CrossRefGoogle Scholar
  14. 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

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceNational University of SingaporeSingaporeSingapore

Section editors and affiliations

  • Kian-Lee Tan
    • 1
  1. 1.Department of Computer ScienceNational University of SingaporeSingaporeSingapore