CompTIA DataSys+ (DS0-001)Database FundamentalsMedium
A database administrator is evaluating different database technologies for storing highly variable, unstructured data like sensor readings and social media posts, where schema changes are frequent and horizontal scalability is a primary concern. Which type of database is best suited for this use case?
- ANoSQL database
- BIn-memory database
- CRelational database
- DObject-oriented database
Show answer & explanationAnswer & explanation
Correct answer: A. NoSQL database
NoSQL databases are designed to handle large volumes of unstructured or semi-structured data, offer flexible schemas, and provide high availability and horizontal scalability, making them ideal for sensor data and social media posts.
Why the other options are wrong
- B. In-memory databases prioritize speed by storing data in RAM but don't inherently address schema flexibility or horizontal scalability for diverse data types.
- C. Relational databases require a predefined schema and are less flexible for unstructured data and rapid schema changes.
- D. Object-oriented databases store data as objects, but are less common for large-scale unstructured data than NoSQL.
NoSQL Database
A class of non-relational databases that provide a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.
- Handles unstructured, semi-structured, and polymorphic data.
- Offers flexible schemas (schema-less or schema-on-read).
- Designed for horizontal scalability and high availability.
- Includes document, key-value, column-family, and graph databases.
Memory trick: NoSQL is for when SQL just won't 'flex' enough.