2.8. Types of Database Systems

The classification of a database management system (DBMS) is greatly influenced by the underlying computing system on which it runs, in particular of computer architecture such as parallel, networked or distributed. However, the DBMS can be classified according to the number of users, the database site locations and the expected type and extent of use.

  1. On the basis of the number of users:

    • Single-user DBMS.

    • Multi-user DBMS.

  2. On the basis of the site locations:

    • Centralised DBMS.

    • Parallel DBMS.

    • Distributed DBMS.

    • Client/server DBMS.

  3. On the basis of the type and the extent of use:

    • Transactional or production DBMS.

    • Decision support DBMS.

    • Data warehouse.

In this section, we will discuss about some of the important types of DBMS system, ...

Get Database Systems: Concepts, Design and Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.