SQL struggles with unstructured data. Which of the following databases is better suited for unstructured data?单项选择题
A
SQL Server
B
MySQL
C
MongoDB
D
Oracle

Question

SQL struggles with unstructured data. Which of the following databases is better suited for unstructured data?

BlackTom AI · Accepted Answer

Document-oriented databases such as MongoDB are designed to handle unstructured and semi-structured data because they use a flexible, schema-less model (BSON/JSON documents).

1. Relevant knowledge points and concepts
- Structured data: fits tables with fixed schema (columns, types); relational databases (SQL Server, MySQL, Oracle) excel here.
- Unstructured/semi-structured data: documents, JSON, logs, multimedia, variable fields. NoSQL databases (document stores, key-value, wide-column, graph) are better suited.
- MongoDB: a document-oriented NoSQL DB that stores BSON documents, supports dynamic schemas, indexing, rich queries, and horizontal scaling.

2. Step-by-step reasoning
- Relational DBs require predefined schemas and normalized tables. When fields vary across records (e.g., different attributes per item), mapping to fixed tables becomes cumbersome and performance-degrading.
- MongoDB stores each record as a document that can contain differing fields and nested structures, avoiding costly schema migrations or many join operations.
- For use cases like content management, IoT, logs, and JSON APIs, documents naturally represent the data shape and can be queried without rigid table definitions.

3. Intermediate steps (conceptual)
- Identify data: if fields vary or nesting exists → need flexible schema.
- Compare storage model: relational rows vs document objects.
- Evaluate operations: frequent schema changes or heavy reads of whole documents → document DB preferred.

4. Why the correct answer is correct
- MongoDB’s schema-less document model is explicitly built for unstructured/semi-structured data; it allows arbitrary fields, nested objects, and arrays per document, making it well suited.

5. Why other options are incorrect
- SQL Server, MySQL, Oracle: all are relational SQL databases with fixed schemas, table joins, and schema migrations when structure changes—poor fit for highly unstructured data.

6. Conclusion
MongoDB is the best choice among the options for unstructured data. This matches the provided correct answer: MongoDB.

SQL struggles with unstructured data. Which of the following databases is better suited for unstructured data?单项选择题

类似问题

Which of the following statements on tuple and document stores is correct?

In the context of modern data architecture, which of the following scenarios best highlights a primary strength of NoSQL databases over traditional Relational Database Management Systems (RDBMS)?

Which of the following database types would be best suited for storing unstructured audio and video data?

What does NoSQL stand for?

Which of the following is NOT a characteristic of NoSQL databases?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单