Search code examples
rdbmsdatabase

How DBMS differ from RDBMS?

Is this how they differ, This is what I have understood.

DBMS

stored data in files , that computer hard disk is a DBMS since it stored data in Disks. And there are no such thing called Tables and relationships between tables no Primary keys, No foreign keys.

And used for simple small applications. Security is not concerned.

RDBMS

Stores data in tables , has relationships between tables, can do normalization. RDBMS is a DBMS. MS Access , SQL server , MYSQL are RDBMS. And RDBMS used for huge databases. Supports Client server architecture.

Now I need to clarify,

  1. DBMS example is hard disk data storage. Is RDBMS for software applications data storage?

  2. It says DBMS is for small data-storage and RDBMS for large data storage. If 1. is true then, doesn't hard disk contain a huge amount of data?.

  3. How security come to issue? Why DBMS does not have security and HOW RDBMS have a security?

  4. So we can create a RDBMS using MySQL, SQL Server etc. How can we create a DBMS?

  5. And finally what else differences are there than what I found?

Solution

  • Hope the following answers might help.

    1. For DBMS, you can say it is Hard disk data storage. Data is stored in flat files. There is not relation between the tables. Relations are maintained programmatically but not by the database itself.
    2. No, both DBMS and RDBMS are used for storing data, small or Huge. For example mainframes have non-relational data (huge amounts of it) and are still in use as legacy systems.
    3. Well DBMS(essentially non-relational data) are simply stored in flat files. It is easy to get hold of them and transfer them if you have access to the file system :) . RDBMS, even though some use files, reading data from the files is a bit trivial. And need to have absolute knowledge about the system to convert the data, again you should have access to the file system which is at the same high level for both DBMS and RDBMS.
    4. DBMS is currently in place as legacy system. COBOL maybe can create DBMS.
    5. You essentially covered everything. :D