A Database By Any Other Name...

A Database By Any Other Name…

by Donald Feinberg | December 22, 2014 | 3 Comments

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 and Nielsen sell databases.

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.

Additional Resources

Category: banco-de-dados data-management dbms it-infrastructure

Tags: banco-de-dados curmudgeon data-management database-management-system dbms in-memory structured-data

Donald Feinberg
VP Distinguished Analyst
25 years at Gartner
50 years IT industry

Donald Feinberg is a vice president and distinguished analyst in Gartner Intelligence in the Information Infrastructure group. Mr. Feinberg is responsible for Gartner's research on database management systems and data warehousing infrastructure. Read Full Bio

Thoughts on A Database By Any Other Name…

Dan Graham says:

January 6, 2015 at 7:55 pm

There were so many times I wished for these distinctions to be clarified and public. I spent many searches on Wikipedia to get less than this. Hadoop has made us re-examine terms and concepts. This is useful Don. Thank you.
You’re last line is grate. You right very well.
Common Human Errors as DBA (part 2) - DBA THINGS says:

January 12, 2015 at 3:36 am

[…] A Database By Any Other Name… […]
The Terms We Use In Technology - the Need For New Hype - Donald Feinberg says:

July 29, 2017 at 11:03 am

[…] 22, 2014, I published a blog about the terms Database vs. Database Management System (DBMS) (A Database By Any Other Name…) in an effort to correctly define these terms that are widely misused by practitioners and vendors […]

Gartner Blog Network

Donald Feinberg