I am building ecommerce app with spring boot and mysql.I want to make catalog system like in amazon where items split into categories, items of each category have fheir own filters and attributes. After searching on web i found out the there is widely used database pattern for such case - eva. But this pattern make filtering too complex, because you need to make join + intersect, which is kind of performance intensive. What other database pattern can be used in this case? Or should i use eva and change my database to nosql?
#What is best alternative to eav database pattern for catalog using spring?
median harbor
jovial plinthBOT