Mapping for query life events of user

Mapping for time-series data

Alind ·

Lecture 13

· a minute ago

Hi,

I am trying to create a mapping where intent is to record events for a user and aggregate them based on any given condition,

for example

a user can have

id -1 ,name - Sarah James ,status-Single ,address- ccc,xxxx,date- 01/01/1900

with time it can change to( Status,name and address changed)

id-1 ,name -Sarah James Smith, Status -Married,address- aaa,bbb,date - 01/06/1900

and than again change to (address changed)

id-1 ,name -Sarah James Smith, Status -Married,address- ppp,qqq,date-02/01/1903

At the same time,I also intend to record every purchase event of the user,

id- 1 ,name - Sarah James, Bought:4 wheeler,date -01/01/1900

id- 1 ,name - Sarah James Smith, Bought: Vacuum Cleaner,date -01/01/1901

id- 1 ,name - Sarah James Smith, Bought: Personal Computer,date -01/10/1901

id- 1 ,name - Sarah James Smith, Bought: House,date -01/01/1903

The use case is that I intend to aggregate the purchase history of a user based on time and map it to same id when the purchaser's name is different .