Consider applying a strategy pattern to the writer to support varying levels of complexity on indexing behaviors when mapping to a relational model

[iamgollum]

Observation

Mapping data to a relational model is a complex task. There are 1-1, 1-Many, Many-Many, and Recursive relationships that are commonly found in this world.

Action Item

We should look into supporting different strategies based on the complexity of the relationships we want to support.

For example, we currently support a "Basic" writer strategy of sorts with id, timestamp, and value (as entire JSON payload). However, we could dig into the payload and start attempting to map relationships. Including Apache Avro from #3 could also be incorporated as another more advanced strategy option.