Guidance on Schema Design for Complex Data Relationships

Support
1

Hey guys… :blush:

I am new to Weaviate and am working on a project that involves storing and querying a dataset with complex relationships. My dataset includes entities such as “Products,” “Customers,” and “Orders,” where:

  • Each order is linked to a customer and one or more products.
  • Products have various attributes, including categories and tags.
  • Customers can have multiple attributes, like preferences and past order history.

I want to design the schema in a way that allows for efficient querying, such as:

  1. Finding customers who have purchased products with specific tags or categories.
  2. Analyzing trends in product orders based on customer preferences.
  3. Recommending products based on a customer’s order history.

I check this: https://forum.weaviate.io/t/setting-preference-on-properties salesforcedeveloper But I have not found any solution. Could anyone guide me about this? Could someone provide advice or examples on how to structure such a schema in Weaviate? Are there specific strategies or pitfalls I should be aware of when modeling these types of relationships?

Thanks in advance!

Respected community member!