CompTIA DataSys+ (DS0-001)Database FundamentalsMedium
A database administrator is designing a new database for a social media application that needs to store large volumes of unstructured data, such as user posts, comments, and media files. The application requires high scalability and availability, with flexible schema changes over time. Which database type is BEST suited for this scenario?
- ADocument Database
- BKey-Value Store
- CRelational Database Management System (RDBMS)
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: A. Document Database
A document database, a type of NoSQL database, is ideal for storing unstructured or semi-structured data like JSON or BSON documents, which fits the requirements of user posts and comments. Its flexible schema and horizontal scalability are well-suited for social media applications.
Why the other options are wrong
- B. Key-value stores are simple and fast but lack the rich query capabilities and nesting of document databases needed for complex social media posts.
- C. RDBMS is best for structured data with predefined schemas and ACID properties, not flexible unstructured data.
- D. Graph databases are optimized for relationships between entities, not primarily for storing large unstructured documents.
Document Database
A NoSQL database type that stores data in flexible, semi-structured documents, typically JSON, BSON, or XML format.
- Schemaless or schema-flexible.
- High scalability and availability.
- Ideal for handling large volumes of unstructured or semi-structured data.
Memory trick: NoSQL is a DOC-KEY-GRAPH-COL family party!