Bulk loading multiple hierarchical levels of relational data to a database

A method operating a computing system comprising a processor, a program memory coupled to the processor and to store an application, and a database coupled to the processor, the method comprising:

• operating the processor to execute the application to perform the following:
• storing a plurality of objects in the program memory, with the plurality of objects being organized in a relational hierarchy having a plurality of levels, with each object having a respective pseudo-key associated therewith indicating each object's position within the relational hierarchy,
• writing in bulk the objects and the respective pseudo-keys in a first level of the relational hierarchy to the database, with the database matching each pseudo-key in the first level with an actual key to generate the first level of the relational hierarchy with actual keys,
• receiving a first level map mapping the pseudo-keys with the actual keys for the objects in the first level of the relational hierarchy,
• reconciling the pseudo-keys for the objects in a second level of the relational hierarchy with the first level map, and
• writing in bulk the objects and the respective reconciled pseudo-keys in the second level of the relational hierarchy to the database.

A non-transitory computer readable memory having a plurality of computer executable instructions for causing a computing system comprising a processor, a program memory coupled to the processor and to store an application, and a database coupled to the processor and the program memory to perform steps comprising:

• operating the processor to execute the application to perform the following:
• storing a plurality of objects in the program memory, with the plurality of objects being organized in a relational hierarchy having a plurality of levels, with each object having a respective pseudo-key associated therewith indicating each object's position within the relational hierarchy,
• writing in bulk the objects and the respective pseudo-keys in a first level of the relational hierarchy to the database, with the database matching each pseudo-key in the first level with an actual key to generate the first level of the relational hierarchy with actual keys,
• receiving a first level map mapping the pseudo-keys with the actual keys for the objects in the first level of the relational hierarchy,
• reconciling the pseudo-keys for the objects in a second level of the relational hierarchy with the first level map, and
• writing in bulk the objects and the respective reconciled pseudo-keys in the second level of the relational hierarchy to the database.