title: Do I really need a NoSQL Database?
body: <p><strong>Background:</strong> Trying to integrate two separate systems; Oracle and MS-SQL Server. Multiple applications reside on each and need to do ad hoc analysis.</p>
  
  <p><strong>The Problem:</strong> The reason I am considering a multiple NoSQL situation is the best course of actions is; There is a very complex and hierarchical relationship between some entities (military unit hierarchy). Such as each Unit has a complex relationship to Commands, States, Geographic location, and Mission. The user database is not special in this case, it as typical as any (No special social network graphing needed) But, I feel the Unit hierarchy would most benefit from a Graph Database when analysis is done.</p>
  
  <p>The Second NoSQL consideration is that the current system cannot do any ad hoc analysis on the systems. As in, "brings it to it's knees" - Lead Developer had said to me once, writing custom scripts for top brass trying to do some sort of analysis with the applications.</p>
  
  <p>So I was considering a Column/Big Table or Document database NoSQL solutions. This would be to create a "Data Lake" to house all the applications data and do some analysis.</p>
  
  <p><strong>Solution:</strong> </p>
  
  <ul>
  <li>What I am looking for is simply am I right to even consider this? </li>
  <li>Am I way off base for the idea? </li>
  <li>Am I missing some implementation that already exists?</li>
  </ul>