In MIS class today, our lecturer talks about database
system. To say that database is a very critical part in today’s technology-driven
life is an understatement. Its becoming a critical part of everything in technology
today. From raw data, we can achieve a lot from data manipulation. But, in
order to access all these raw data, we need a system called DBMS, which is
Database Management System. This is what we are going to talk about today. I
will try explain this as simple as possible to make sure we understand how DBMS
and database works together.
If you are familiar with Microsoft Words, we can use that
analogy to further explain the relationship between DBMS and Database. Bear in
mind that, DBMS is a system, not a database. Database is the database. DBMS
will manipulate, store, managing and creating a database from all the raw data
in the database.
The other example that we can take is from banking. We make
thousands of transactions through banks daily and we can do this without going
to the bank. So how banking has become so easy that by sitting at home we can
send or get money through banks. That is all possible just because of DBMS that
manages all the bank transactions. (1)
There are two types of DBMS as per below:
A desktop DBMS is
aimed toward single user desktop applications. There are a number of different
desktop DBMS products including Microsoft Access, Filemaker Pro, Paradox, Lotus
Approach, and Fox Pro.
A server DBMS is
designed with security, reliability, and performance in mind. These DBMS
products run as services on servers, and are connected to over the network.
Server DBMS products include Apache Derby, Microsoft SQL Server, Oracle, IBM
DB2, Sybase ASE, Informix, MySQL, and ProgreSQL. (2)
References:
(1)http://whatisdbms.com/application-and-uses-of-database-management-system-dbms/ (2)https://swinbrain.ict.swin.edu.au/wiki/Database_Management_Systems_Introduction
