You are implementing a NoSQL database to record the grievances of customers of a

Question

You are implementing a NoSQL database to record the grievances of customers of an automobile company. You have freedom of recommending a Key-Value type database or a Document Database. Each of the grievance record is keyed on Customer ID, and contains certain other information like the Automobile model (examples: Camry, Civic, Corolla, Escort….), grievance category (Example: Mileage/Fuel consumption, Maintenance costs, pickup time…), and some description of the grievance. The system needs an ability to index and query the grievance records based on values for Automobile model and grievance category. As the Database Designer, would you recommend a Key-value type of database or a Document database? Please provide explanation(s) for your recommendation.

Explanation / Answer

The best choice for this requirement is Document database. Because Key-value type of database store data in a simple JSON structure which lacks search and indexing capability. If we use document type database then all data regarding a single grievance record can be found in one document. Those document can be queried for data if we use document type database, but in key-value database data is referenced using keys and it doesn't support any query.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.