Databased Questions You are implementing a NoSQL database to record the grievanc
ID: 3822540 • Letter: D
Question
Databased Questions
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
With the given scenario we are good to with Key-value type database. Because in the given scenario there is no complex data it is very simple with just customer id , automobile model and greviance category. We can best use this in key-value type database.
In the key -value type database the stores values indexed by key. In this the database things that the data is single opaque collection which contains different fields for every record. The data is rereived based on the key value. It searches the data in the database based on key values i t retrieves the data which matches the key value.
Key value database retrieves data very fastly. It is also very simple. while the other one i.e. document which is the extended one to the key-value database. It works well with complex datasets which contains different fields and records. It works very efficiently with the complex dataset.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.