Architecture for Social Graph data that has a Time Frame Associated?

Posted by Jay Stevens on Programmers See other posts from Programmers or by Jay Stevens
Published on 2012-10-08T18:10:19Z Indexed on 2012/10/08 21:50 UTC
Read the original article Hit count: 361

I am adding some "social" type features to an existing application. There are a limited # of node & edge types. Overall the data itself is relatively small (50,000 - 70,000 for each type of node) there will be a number of edges (relationships) between them (almost all directional).

This, I know, is relatively easy to represent with an SDF store (such as BrightstarDB) or something like Microsoft's Trinity (or really many of the noSQL options).

The thing that, I think, makes this a unique use case is that each relationship will have a timeframe associated with it (start and end dates). Right now, I'm thinking of just storing this in a relational structure and dealing with the headaches of "traversing the graph", but I'm looking for suggestions on a better approach (both in terms of data structure and server):

Column
================
From_Node_ID  
Relationship
To_Node_ID
StartDate
EndDate

Any suggestions or thoughts are welcomed.

© Programmers or respective owner

Related posts about database-design

Related posts about graph-databases