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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial