Neo4j has been around for just a few years, while most organizations that are trying to move into business intelligence and analytics have their decades of data piled up in SQL databases. So, rather than moving or transforming the data, it is better to fit in a graph database along with the existing one in order to make the process a less disruptive one.
The two databases in our system are arranged in a way that the already-in-place MySQL database will continue being the primary mode of storage. Neo4j acts as the secondary storage and works on small related subsets of data. This would be done in two specific ways:
Online mode for transactions that are critical for essential business decisions that are needed in real time and are operated on current sets of data
The system can also operate in batch mode in which we collect the required data and process it when feasible
This will require us to first tune our Neo4j system to get updated...