Q12Big Data Analytics
Question
4 marks
Differentiate between Relational and NoSQL databases.
Answer
Relational databases use structured schemas and SQL, while NoSQL databases handle unstructured data with flexible schemas.
Relational databases (RDBMS) are table-based, highly structured, and strictly adhere to ACID properties, making them suitable for complex queries. NoSQL databases can be document-based, key-value pairs, graph, or wide-column stores. They offer horizontal scalability, flexible data models, and are better suited for hierarchical data and large-scale big data applications.