How can one distinguish between document-oriented databases and column-oriented databases in terms of data storage?

• A. Document-oriented databases store data in rows, column-oriented stores in columns.
• B. Document-oriented databases store data in XML or JSON formats, while column-oriented databases store data in columns rather than rows.
• C. Column-oriented databases are slower than document-oriented ones.
• D. Document-oriented databases cannot manage relationships among data.

Answer: (B)

The distinction between document-oriented databases and column-oriented databases is best represented by the formats in which they store data. Document-oriented databases typically store data in flexible, semi-structured formats such as XML or JSON. This allows for the storage of entire documents as single entities, accommodating varying data types and structures within the same database.

On the other hand, column-oriented databases arrange data into columns. This allows for efficient data retrieval when working with large datasets, particularly for analytical queries that aggregate data across multiple rows.

The choice of document formats (such as JSON or XML) is a fundamental characteristic of document-oriented databases. It enables rapid and flexible schema evolution, as each document can have its unique structure. This flexibility further supports applications that require the integration of structured and unstructured data.

Thus, the correct answer highlights the primary distinguishing feature concerning data storage methods and structures between these two types of databases.