#1
June 13th, 2014, 12:06 PM
| |||
| |||
Differentiate between DBMS and RDBMS
Can you please give me the details of differences between DBMS and RDBMS as it is very urgent for me? As you want to get the details of differences between DBMS and RDBMS so here is the information of the same for you: DBMS: DBMS is defined as the software program that is used to manage all the databases that are stored on the network or system hard disk. There are different types of database management systems and some of them are configured for specific purposes. RDBMS: The database system in which the relationships among different tables are maintained is called Relational Database Management System. Both RDBMS and DBMS are used to store information in physical database. Differences: Data Base Management System is a process of managingdata for efficient retrieval & storage of data.Ex: sysbase , FoxproThe database which is used by relations(tables) toacquire information retrival are known as RDBMSEX: SQL, ORACLE,MY-SQL SERVER2) In DBMS,client server concept is not present. In RDBMS,client server architecture is present (i.e) the client sends the request to the server and the server responds to that particular request. DBMS does not impose any constraints or security withregard to data manipulation. It is user or the programmerresponsibility to ensure the ACID PROPERTY of the database.RDBMS defines the integrity constraint for the purpose ofholding ACID PROPERTY. In DBMS Normalization process will not be present.In RDBMS, normalization process will be present to checkthe database table cosistency. Last edited by Neelurk; April 20th, 2020 at 11:35 AM. |
|