title: Which is the suitable database for storing a large JSON?
body: <p>I have <em>only one</em> large JSON file. For example,</p>
  
  <pre><code>{   
      "Name": "Motor_M23",
      "AASID": {
          "IDType": "URI",
          "IDSpec": "http://acplt.org/AAS/Motor_M23"
      },
      "AssetID": {
          "IDType": "URI",
          "IDSpec": "http://acplt.org/Assets/Motor_M23"
      },
      "Header": {
          "PropertyValueStatementContainers": [
              {
                  "Name": "Config",
                          .
                          .
                          .
                          .
  </code></pre>
  
  <p>I need to support operations following operations:</p>
  
  <ol>
  <li><p>Querying for an element should return all child elements e.g. Querying for <code>AssetID</code> should return </p>
  
  <pre><code>"AssetID": {
      "IDType": "URI",
      "IDSpec": "http://acplt.org/Assets/Motor_M23"
  }
  </code></pre></li>
  <li><p>Update value of elements.</p></li>
  <li>Delete elements.</li>
  <li>Move elements between hierarchy levels e.g. make <code>AssetID</code> child element of <code>AASID</code>.</li>
  </ol>
  
  <p>I considered following approaches:</p>
  
  <ol>
  <li><strong>Graph database</strong> : I started reading about Neo4J. However, it can not create graph from JSON <em>intellgently</em>. One has to specify node type and their hierarchy order.</li>
  <li><strong>ElasticSearch</strong> : It can work by treating JSON as text and hence not efficient solution.</li>
  <li><strong>Postgres</strong> : It supports querying over JSON objects but updating, deletions won't be efficient.</li>
  </ol>
  
  <p>Is there any good database out there which can load data from large JSON and handle my operations?</p>