Graph realization while there is a date / time data

Hi,
I have a data in RDBMS in two tables,
Table A - company_name, time_stamp, buying_price, selling_price, shopping_mode,
buying_price will have value only while "shopping_mode" is '1'
selling_price will have value only while "shopping_mode" is '2'

Table B - company_name, time_stamp, volume, buying_price, selling_price, shopping_mode,
buying_price will have value only while "shopping_mode" is '1'
selling_price will have value only while "shopping_mode" is '2'

While rendering the data in the chart data will be pulled for specific "company_code" and then union values for buying and selling figures will be shown in the chart with / without timebound aggregation.

I thought of two approach while modeling the data in the graph,

  1. single node having all the properties
  2. (c:Company {name:'companyName'})-[HAS_FURTHER_DATA]->(b:BuyingInformation {timeStamp:'',...})
    (c:Company {name:'companyName'})-[HAS_FURTHER_DATA]->(s:SellingInformation {timeStamp:'',...})

Can anyone suggest which one would be the optimal way of representing data in the graph and if there is any better solution of creating timebound intermidiate node and then create buying or selling profile relationship.

Regards,
Maulik

1 Like

Hi,
Traditionally, to create purchase / sale profiles, items are grouped into homogeneous categories.

regards
Alessio