CompTIA DataSys+ (DS0-001)Database FundamentalsMedium
A data architect is designing a database for a high-traffic e-commerce platform that needs to handle millions of simultaneous read and write operations across geographically distributed servers. Consistency is important, but availability and partition tolerance are paramount. Which database model would best fit these requirements?
- ADocument Database
- BRelational Database Management System (RDBMS)
- CKey-Value Store
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: C. Key-Value Store
For high-traffic, geographically distributed systems where availability and partition tolerance are prioritized over immediate consistency (AP in CAP theorem), NoSQL databases are typically preferred. Key-value stores offer the highest scalability and performance for simple data access patterns.
Why the other options are wrong
- A. Document databases offer schema flexibility but might not achieve the same raw read/write performance as key-value stores under extreme load.
- B. RDBMS prioritizes strong consistency (ACID) which can limit scalability and availability in distributed environments.
- D. Graph databases are specialized for interconnected data and complex relationship queries, not raw read/write throughput for simple data.
Key-Value Store
A type of NoSQL database that stores data as a collection of key-value pairs, where each key is unique and maps to a specific value.
- Offers extreme scalability and high availability.
- Simple data model, ideal for fast reads and writes.
- Often used for caching, session management, and real-time data.
Memory trick: Key-Value stores are 'Key' for 'Value' in speed and scale.