Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regarding the Bulk Loading in ORACLE 10gR2

617912Apr 4 2008 — edited Apr 7 2008
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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 5 2008
Added on Apr 4 2008
1 comment
2,075 views