Multi-computer database system

from Wikipedia, the free encyclopedia

A multi-computer database system (abbreviated as MRDBS ), in contrast to " single- computer DBS", is not run on a central system but on several systems (computers) in order to implement parallel database systems and distributed database management systems , the two main groups into which MRDBS are divided .

The most important advantage of an MRDBS is the possibility of needs-based scaling (e.g. adding additional computer units if higher performance is required). This also enables an increase in the possible performance capacities compared to a single-computer system. The only exception are problems whose processing cannot be broken down into individual steps that can be processed in parallel. There can also be other advantages such as B. higher reliability (through spatial distribution of the individual systems, e.g. on different continents). Further distinctions, requirements and advantages are explained in the articles " Distributed database management system " and " Parallel database system ".

(further) classification possibilities of MRDBS

  • Parallel, distributed
  • Integrated (virtual, physical), federal
  • Workstations / server architecture, multi-tier architecture, PDBS architecture (Parallel Database Shared Architecture)
  • PDBS architecture: Shared Everything, Shared Noting, Shared Disk
  • Spatial distribution (distributed, local)
  • Computer coupling (close, loose, close coupling)

Individual evidence

  1. Thomas Kudraß: Pocket book databases (see references)

literature

  • Thomas Kudraß: Pocket book databases. Fachbuchverlag Leipzig in Carl Hanser Verlag Munich 2007, ISBN 978-3-446-40944-6
  • E. Rahm: Multi-computer database systems - basics of distributed and parallel data processing. Addison-Wesley, Bonn, 1994: Available online