Moving Graph data to a Rectangular Analytical Store
Graph style databases can be used to model some data sets in a more intuitive fashion. This lets us leverage the structure for special purpose applications and data exploration. Standard analytics tools often work best against relational record-oriented data. There are a couple strategies for moving graph modeled data to relational stores for analytics. We will walk through some very basic options. There are more sophisticated approaches than what we will discuss Video - YouTube The Initial Graph DB Here we have a simple graph modeling a person with their various addresses and phone numbers. We have modeled two different address types, mailing, and billing. The model supports multiple phone numbers but does not break them out by type and purpose. Each of the graph node types can have additional business and technical properties. The Person might have FirstName , LastName, last modified at. The relationships or edges can also have additiona...