Member-only story
Database Concepts: distinguishing between DB, DB Server and DBMS
Here is an article I wrote about database vs database server vs database management system:
Introduction
A database is a collection of structured data that can be stored, accessed, and manipulated by various applications. A database server is a computer program or device that provides database services to other programs or devices. A database management system (DBMS) is a software system that manages the creation, maintenance, and operation of databases.
Database
A database is a logical representation of data that is organized into tables, records, fields, and indexes. A table is a collection of related data that consists of rows (records) and columns (fields). A record is a single instance of data in a table that contains values for each field. A field is a specific attribute or property of a record that can store a single value. An index is a data structure that allows fast retrieval of records based on certain criteria.
A database can store various types of data, such as text, numbers, dates, images, audio, video, etc. A database can also enforce rules and constraints on the data, such as data types, primary keys, foreign keys, unique values, etc. A database can also support various operations on the data, such as…
