Re: [Virtuoso-users] update a million triples graph

Kingsley Idehen Sun, 13 Feb 2011 00:25:22 +0000

On 2/12/11 1:21 PM, bin chen wrote:

Hi, Kingsley,
I am not allowed to delete the db file cause we have other graphsthere (the size of db upto 14GB). I first run:
sparql clear graph <GraphIRI> ;


Fine.

Did you then run:

select * from <DeletedGraphIRI> where {?s ?p ?o}

and then delete .trx under the db directory and then restart virtuoso.
I update the deleted graph using ld_dir and rdf_loader_run (), it doesnot work, here is a copy of the command:
Done. -- 52 msec.
SQL> rdf_loader_run ();

Done. -- 1 msec.


What is your load directory?

What are you passing to ld_dir() ?

I don't believe your source directory is being picked up, hence no load.

It should be:

ld_dir ('<source-filename-or-directory>', '<file name pattern>', 'graphiri');

or

ld_dir ('<source-filename-or-directory>', '<file name pattern>', 'graphiri');


or

ld_dir ('/directoty/files', '*.n3', 'http://dbpedia.org');

Links:

1.http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleDbpedia-- DBpedia example2.http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleMultiple-- Multiple source files load .



Kingsley


Thanks,
Bin

On Sat, Feb 12, 2011 at 8:31 AM, Kingsley Idehen<kide...@openlinksw.com <mailto:kide...@openlinksw.com>> wrote:


    On 2/12/11 9:52 AM, bin chen wrote:

    Hi,

    I have a huge graph to update. I first deleted the graph using
    the following command:

    delete from DB.DBA.RDF_QUAD where G =DB.DBA.RDF_MAKE_IID_OF_QNAME
    ("graphname');

    then using
    ld_dir and rdf_loader_run ();

    it finished within a second, but the data was not uploaded at
    all, so I guess the graph name is still not fully deleted...
    I looked the table DB.DBA.load_list has the graphname, then I
    deleted it, and reran the uploading again, but several days past,
    it has not completed? I guess there are some problems.

    I want to know how long it will take to upload a million triples
    graph? what's the best way to update a graph? thanks.


    Clear the graph using this command from the iSQL commandline
    editor or Conductor UI:

    sparql clear graph <GraphIRI> ;

    Shorter cut, delete your .db and .trx files, and restart Virtuoso.

    Kingsley

    Bin


    
------------------------------------------------------------------------------
    The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
    Pinpoint memory and threading errors before they happen.
    Find and fix more than 250 security defects in the development cycle.
    Locate bottlenecks in serial and parallel code that limit performance.
    http://p.sf.net/sfu/intel-dev2devfeb


    _______________________________________________
    Virtuoso-users mailing list
    Virtuoso-users@lists.sourceforge.net  
<mailto:Virtuoso-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--

    Regards,

    Kingsley Idehen     
    President&  CEO
    OpenLink Software
    Web:http://www.openlinksw.com
    Weblog:http://www.openlinksw.com/blog/~kidehen  
<http://www.openlinksw.com/blog/%7Ekidehen>
    Twitter/Identi.ca: kidehen






    
------------------------------------------------------------------------------
    The ultimate all-in-one performance toolkit: Intel(R) Parallel
    Studio XE:
    Pinpoint memory and threading errors before they happen.
    Find and fix more than 250 security defects in the development cycle.
    Locate bottlenecks in serial and parallel code that limit performance.
    http://p.sf.net/sfu/intel-dev2devfeb
    _______________________________________________
    Virtuoso-users mailing list
    Virtuoso-users@lists.sourceforge.net
    <mailto:Virtuoso-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
Bin Chen
PHD student, Informatics,
Indiana University at Bloomington

http://cheminfo.informatics.indiana.edu/~binchen<http://cheminfo.informatics.indiana.edu/%7Ebinchen>



------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb


_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users



--

Regards,

Kingsley Idehen 
President&  CEO
OpenLink Software
Web: http://www.openlinksw.com
Weblog: http://www.openlinksw.com/blog/~kidehen
Twitter/Identi.ca: kidehen

Re: [Virtuoso-users] update a million triples graph

Reply via email to