Another post from the DBMS Curmudgeon
“What’s in a name? that which we call a rose by any other name would smell as sweet;”, From Shakespeare‘s Romeo and Juliet, 1594. Not true for a Database Management System (DBMS).
The IT industry uses the words database and DBMS interchangeably. They are not! Simply put, a DBMS is software used to create and manage a database. A database contains data; a DBMS is a software product. First, let me define the two terms.
Gartner defines DBMS and database as follows: A database management system (DBMS) is the software used to organize, support and maintain the information or data in a structure stored in a computer. Although, normally stored on magnetic storage media such as disc or flash, it can also be stored in memory. The software includes the rules to organize the data and enforce the model (for example relational, network, hierarchical), insert, update and delete data, provide security for the data, enforce persistence and facilitate backup and recovery of the data. Vendors such as IBM, Microsoft, Oracle and SAP sell DBMSs.
A database is a structured
collection of records or data. A computerised database
relies upon software
to organize the storage of data. The software models the database structure in what are known as database models
. The model in most common use today is the relational model
. Other models such as the hierarchical model
and the network model
use a more explicit representation of relationships. Vendors such as Dun & Bradstreet
My problem is that many professionals in the DBMS software world, continue to call the DBMS product a database product. Are they referring to the DBMS or database? Some might think I am being picky, however, when reading documents that misuse the terminology, it is often difficult to understand if the author is referring to the software or the data. E.g., “My database crashed”. Does this imply a software problem or a hard disk crash? We all must be more careful to use the correct terminology.
So let’s make a New Year’s resolution: Try to use the correct terminology.
If you sea someone using terminology in air, you should should let them no.