| Base of difference | RDBMS | Hadoop |
| Type of data | When we say about type of data in RDBMS it is mainly for Structured data. | When we say about type of data in Hadoop it is used for Structured, Semi-Structured and Unstructured data. |
| Query Langauge | When we say about the language it have SQL Language | Langauage here is HQL (Hive Query Language) |
| Integrity | When we say about the Integrity in RDBMS it is high (ACID is the example for this). | When we say about the integrity in Hadoop it is very Low. |
| Data Storage | When we say about the Data storage it is average size data which can be in GBs(Gigabyte). | When we say about the Data storage in Hadoop it have large data set like TBs and PBs(Terabyte and Petabyte). |
| Schema | When we say about data schema in RDBMS we defines how data is organized within a relational database(Static Schema). | When we say about the schema on-Read is the new data investigation approach is new tools like Hadoop and otehr data-handling technologies(dynamic schema). |
| Speed | When we say about the Speed here reads is much faster then write. | When we say about the Speed here both Reads and Writes are fast. |
| Cost | When we say about cost for RDBMS we need a License. | When we say about the Cost for Hadoop it is free. |
| use Case | When we say about the use case we have OLTP(Online Transaction Processing). | When we say about the use case in Hadoop we have Analytics(for Audio, Video, Logs etc) and Data Discovery. |
| Data Objects | In RDBMS we works on Relational Tables. | When we say about Hadoop it works on Key/Value apir. |
| Scalability | When we say about scalability in RDBMS it is vertical. | When we say about the scalability in Hadoop it is Horizontal. |
| Throughtput | Relational database queries tend to be slower and can't handle high-throughput as well as NoSQL queries. | Hadoop provides high throughput access to application data and is suitable for applications that have large data sets. |
| hardware Profile | When we say about hardware for RDBMS it requires High-End Servers. | When we say about the Hardware for Hadoop it have Commodity/Utility Hardware.
|