But what happens as the company expands its products and customers in the following scenarios?
- The scalability of a relational database (in terms of volume of products and number of concurrent requests) becomes a bottleneck.
- The product structure is different based on the category and is difficult to model in a fixed schema of a relational database.
- The search criteria starts increasing in scope. As of now, we are searching only by category; later on, we might want to search by product description, filter fields, and also by category description.
Will a single relational database suffice for all requirements?
Let's address the concerns with a few design techniques.