cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Best practices relationship properties - Retail: Product/Pricelist

Hi all,

I'm currently building a concept in Neo4j to store retail data, which in our case (as in most) includes products, articles/variants, stock-levels and pricelists.

A product itself doesn't have a price until it's combined with a specific pricelist and a date (a timespan for which a pricelist is active and valid). A given price needs other metadata, such as currency. I was pondering how this could/should look in a graph database.

My solution is that I have nodes for products and pricelists - where the relationship between a product and pricelist contains the metadata; for example the given price (in its currency) for a specific product that is included in this pricelist.

Does this seem like a good solution, or should a combination of product/pricelist have its own node which contains the pricing?

Thank you in advance,
Mattias

1 REPLY 1

ameyasoft
Graph Maven

Hi,
Please check this article, "Time-Based Vesrioned Graphs":

http://iansrobinson.com/2014/05/13/time-based-versioned-graphs/

Very nice article and you can get some good ideas for your use case.

-Kamal