private void determineAffectedAddressing() throws OseeCoreException {
    gammaJoin.store();

    try {
      console.writeln("counter: [%s]", counter);
      console.writeln("query id: [%s]", gammaJoin.getQueryId());
      chStmt.runPreparedQuery(10000, SELECT_RELATION_ADDRESSING, gammaJoin.getQueryId());

      while (chStmt.next()) {
        long obsoleteGammaId = chStmt.getLong("gamma_id");
        int transactionId = chStmt.getInt("transaction_id");
        long netGammaId = chStmt.getLong("net_gamma_id");
        int modType = chStmt.getInt("mod_type");
        TxChange txCurrent = TxChange.getChangeType(chStmt.getInt("tx_current"));

        if (isNextAddressing(netGammaId, transactionId)) {
          if (updateAddressing) {
            updateAddressingData.add(
                new Object[] {
                  previousNetGammaId,
                  netModType.getValue(),
                  netTxCurrent.getValue(),
                  previousTransactionId,
                  previousObsoleteGammaId
                });
          }
          updateAddressing = obsoleteGammaId != netGammaId;
          previousNetGammaId = netGammaId;
          previousObsoleteGammaId = obsoleteGammaId;
          previousTransactionId = transactionId;
          netModType = ModificationType.getMod(modType);
          netTxCurrent = txCurrent;
        } else {
          addressingToDelete.add(
              new Object[] {chStmt.getInt("branch_id"), transactionId, obsoleteGammaId});
          computeNetAddressing(ModificationType.getMod(modType), txCurrent);
        }

        writeAddressingBackup(obsoleteGammaId, transactionId, netGammaId, modType, txCurrent);
      }
    } finally {
      chStmt.close();
    }
    gammaJoin.delete();
  }
  private void findObsoleteRelations() throws OseeCoreException {
    try {
      chStmt.runPreparedQuery(10000, SELECT_RELATIONS);
      while (chStmt.next()) {
        int relationTypeId = chStmt.getInt("rel_link_type_id");
        int artifactAId = chStmt.getInt("a_art_id");
        int artiafctBId = chStmt.getInt("b_art_id");

        if (isNextConceptualRelation(relationTypeId, artifactAId, artiafctBId)) {
          consolidate();
          initNextConceptualRelation(relationTypeId, artifactAId, artiafctBId);
        } else {
          obsoleteGammas.add(chStmt.getLong("gamma_id"));
          relationMateriallyDiffers(chStmt);
        }
      }
    } finally {
      chStmt.close();
    }
  }