| DBMS |
RDBMS |
| 1. DBMS applications store data as file. |
1. RDBMS applications store data in a tabular form. |
| 2. In DBMS, data is generally stored in either a hierarchical form or a navigational form. |
2. In RDBMS the tables have an identifier called primary key and the data values are stored in the form of tables. |
| 3. Normalization is not present in DBMS. |
3. Normalization is present in DBMS. |
| 4. DBMS does not apply any security with regards to data manipulation. |
4. RDBMS defines the integrity constraint for the purpose of ACID(Atomicity, Consistency, Isolation and Durability) property. |
| 5. DBMS uses file system to sote data, so there will be no relation between the tables. |
5. In RDBMS, data values are stored in the form of tables, so a relationship between these data values will be stored in the form of a table as well. |
| 6. DBMS has to provide some uniform methods to access the stored information. |
6. RDBMS system supports a tabular strucutre of the data and a relationship between them to access the stored infromation. |
| 7. DBMS doesnot support distributed database. |
7. RDBMS supports distributed databases. |
| 8. DBMS is meant to be for small organization and deal with small data, It supports single user. |
8. RDBMS is designed to handle large amount of data, it supports multiple users. |
| 9. Data Redundancy is common in this model leading to difficulty in maintaining the data. |
9. Keys and indexes are used in the tables to avoid redundancy. |
| 10. Examples DBMS are dBase, Microsoft Access, LibreOffice Base, FoxPro etc. |
10. Examples RDBMS are SQL Server, Oracle, MySQL, Maria DB, SQLite etc. |
| RDBMS |
ORDBMS |
| 1. A database management system based on the relational model of data. |
1. DBMS that is similar to RDBMS but with an object oriented database mode. |
| 2. RDBMS stands for Relational Database Management System. |
2. ORDBMS stands for Object Relational Database Management System. |
| 3. RDBMS is based on Relational data model. |
3. ORDBMS is based on the Relational as well as Object Oriented database model. |
| 4. RDBMS is suitable for traditional application tasks such as for data administration and processing. |
4. ORDBMS is suitable for application with complex objects. |
| 5. MS SQL Server, MYSQL, SQLite, MariaDB are some examples of RDBMS. |
5. PostgreSQL is an ORDBMS. |
Post a Comment
Note: only a member of this blog may post a comment.