Categories
Parameters | DBMS | RDBMS |
Access | Data elements need to be accessed separately | Multiple data elements can be accessed at the same time |
Relationship Between Data | No relationship between data | Data in tables is related to each other |
Normalization | It is not present | It is present |
Distributed Database | It does not support distributed database | It supports distributed database |
Data Storage Format | Data is stored in either a navigational or hierarchical form | Data is stored in a tabular structure with headers being the column names and the rows containing corresponding values |
Amount of Data | It deals with a small quantity of data | It deals with a larger amount of data |
Data Redundancy | It is prevalent | Keys and indexes do not allow data redundancy |
Number of Users | It supports a single user | It supports multiple users |
Data Fetching | It is slower for large amounts of data | It is speedy due to the relational approach |
Data Security | Low-security levels when it comes to data manipulation | Multiple levels of data security exist |
Software and Hardware Requirements | Low | High |
Examples | XML, Window Registry, etc. | MySQL, SQL Server, Oracle, Microsoft Access, PostgreSQL, etc. |
Parameters | Clustered Index | Non-clustered Index |
Used For | Sorting and storing records physically in memory | Creating a logical order for data rows; pointers are used for physical data files |
Methods for Storing | Stores data in the leaf nodes of the index | Never stores data in the leaf nodes of the index |
Size | Quite large | Comparatively, small |
Data Accessing | Fast | Slow |
Additional Disk Space | Not required | Required to store indexes separately |
Type of Key | By default, the primary key of a table is a clustered index | It can be used with the unique constraint on the table that acts as a composite key |
Main Feature | Improves the performance of data retrieval | Should be created on columns used in Joins |
SQL | MySQL |
It is a structured query language used in a database | It is a database management system |
It is used for query and operating database system | It allows data handling, storing, and modifying in an organized manner |
It is always the same | It keeps updating |
It supports only a single storage engine | It supports multiple storage engines |
The server is independent | During backup sessions, the server blocks the database |
