Schema and physical design in NoSQL databases

Post date: Aug 29, 2015

Considerable work has been done on the topic of schema design for relational databases. However, it has not been formally studied for NoSQL databases. We consider the schema design for NoSQL databases in following two use cases. In the first case, an application administrator has an application running on a relational database, and wants to migrate it to a NoSQL system. In the second case, an application designer is developing a new application on a NoSQL database. In order to recommend the schema in these two cases, we have developed transformation rules, a cost model, and a search algorithm as part of a recommendation utility that analyses the observed or the user-provided application access patterns and offers a recommendation.