Refine the daily Technopedia API pull so that any child dependencies are automatically resolved

Currently in the daily API pull from Technopedia (and subsequent insert into GEAR), if there is a child dependency that is violated (e.g. a softwareProduct title is being inserted into the database, but its parent softwareFamily reference does not exist) the insert fails and is not caught. It has to manually be resolved or hope that a subsequent API pull will correct the issue once that record is updated again. This should be automatically resolved so that GEAR's schema matches the data in Technopedia.

Start by tracing the daily Technopedia API pull through its insertion path into GEAR, focusing on how child dependencies such as softwareProduct and softwareFamily are handled. Done means a missing parent dependency is automatically resolved or otherwise handled so the insert succeeds and GEAR's schema matches Technopedia data.

Written by the indexing model from the issue text.