Regarding the Bulk Loading in ORACLE 10gR2
617912Apr 4 2008 — edited Apr 7 2008I am trying to load an Ontology of size 1,10,000 triples into ORACLE 10gR2. it is taking nearly 45 minutes to load the data. I have hundreds of such ontologies to load in to the database. I am using 'graph.getBulkUpdatehandler().add(ontoloyGraph)' to add the entire ontologyGraph(of size 1,10,000 triples) to the back-end model. The back-end model isempty.
In this context can anyone please tell me:
1). Why the time to load Ontologies is kind of exponentially increasing with the size of the Ontology?
2).Given that I have to use 10g only, what are the ways to improve the loading time?
Please do mention the reason behind it taking so much time for loading....
Thanks,
Rajesh.