1 Reply Latest reply on Apr 7, 2008 2:02 PM by alwu-Oracle

    Regarding the Bulk Loading in ORACLE 10gR2

    617912
      I 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.
        • 1. Re: Regarding the Bulk Loading in ORACLE 10gR2
          alwu-Oracle
          You are using 10gR2 so 11g bulk loader is not available. You can try the
          addInBatch API. Behind the scene, it is invoking 10gR2 batch loader.

          The reason for a slow loading speed is
          1) quite a few indexes are maintained incrementally,
          2) loading is handled in a triple by triple fashion. So there is quite a bit of PL/SQL overhead.