centralized database system
the DBMS and database are stored at a single site that is used by several other systems too
With a centralized database system, the DBMS and database are stored at a single site that is used by several other systems too.
distributed database system
the actual database and the DBMS software are distributed from various sites that are connected by a computer network
In a distributed database system, the actual database and the DBMS software are distributed from various sites that are connected by a computer network, as shown in Figure 6.2.
heterogeneous distributed database system
different sites might use different DBMS software, but there is additional common software to support data exchange between these sites
In a heterogeneous distributed database system, different sites might use different DBMS software, but there is additional common software to support data exchange between these sites.
homogeneous distributed database systems
use the same DBMS software at multiple sites
Homogeneous distributed database systems use the same DBMS software from multiple sites.
multiuser database system
a database management system which supports multiple users concurrently
It can be a single-user database system, which supports one user at a time, or a multiuser database system, which supports multiple users concurrently.
object-oriented data model
a database management system in which information is represented in the form of objects as used in object-oriented programming
In recent years, the newer object-oriented data models were introduced.
single-user database system
a database management system which supports one user at a time
It can be a single-user database system, which supports one user at a time, or a multiuser database system, which supports multiple users concurrently.
traditional models
data models that preceded the relational model
Other traditional models, such as hierarchical data models and network data models, are still used in industry mainly on mainframe platforms.
These terms were extracted from Database Design – 2nd Edition by Adrienne Watt, eCampusOntario (originally published by BCcampus) which is licensed under a Creative Commons Attribution 4.0 International License. Chapter text adapted from Database System Concepts by Nguyen Kim Anh, licensed under CC BY 3.0.