Difference between a Database and DBMS

Just finished my training and certification exam for an IBM academic evangelist. The training covered database fundamentals and DB2. There were other topics covered relating to databases and database management systems like SQL and XML, but I'd like to put more emphasis on database and DBMS or Database Management Systems. Although I have been practicing as a software developer and IT instructor, I have never taken any particular detail to the theories and concepts of databases, much more handle such subjects. The training refreshed me with what I learned in college as well as given me more information about databases and DBMSs. Here are a few things that I've re-learned (because apparently, I forgot or I did not learn at all):

  1. Database in a general point of view refers to any data repository. It can be a software. It provides an interface to access DATA. 
  2. DBMS or Database Management System is a software system. Whereas database provides a way to access data, DBMS provides a way to manage databases. I have been too accustomed to using the terms database and DBMS interchangeably which is widely accepted but not necessarily correct.
  3. SQL was originally invented by IBM. I have been using SQL in different DBMSs and I did not know that it was invented by IBM which made me think that IBM is no where in the competition for software. 
  4. DB2 is from IBM
  5. DB2 is the second in the market for DBMS. I have been working on software projects that use only free databases such as Firebird and MySQL. I have also worked on an Oracle database as well as MS SQL Server. I never researched about market share for these DBMSs and I thought that Oracle was first in line (which is still true) and followed by Microsoft's SQL Server (it turns out that this is the third in the line), then followed by others. 
  6. DB2 now has a free version for academic use. I always thought that DB2 was unpopular (at least in our place) because only a few can afford it and if anyone can afford it, they would opt to use Oracle or MS SQL instead.
There are a lot more misconceptions that I had which are now corrected, and I am very thankful that I went under this training.


0 Responses to "Difference between a Database and DBMS"