How to organize the storage of a large number of different characteristics of goods?

Question

Data storage

There is an online store with a catalog of goods, the number of goods is about 100,000, each product has a list of its characteristics. Products are divided into groups, for example, TVs, refrigerators, and so on, respectively, products in one group will have the same set of characteristics.
The main characteristics of goods can be added by content managers, some of the characteristics can be added by users of the online store.
While it is known for sure that the store will work on PHP and Symfony, the DBMS has not yet been decided in connection with this issue, so there is an opportunity to make the best choice for this task.
So far, we see two solutions:
1. Use EAV
2. Organize storage in a document-oriented DBMS
3. Use a data warehouse (Content Repository, in our case PHPCR) Tell me
, how best to organize the storage of characteristics for products in this case?

Answer 1

Combine both approaches, and use a ready-made solution like elasticsearch.
elasticsearch can also be used as a document-oriented DBMS for products,
and is suitable for search.