MonetDB developers
Sourceforge cvs has serious problems (my guess is their raid system is
broken and no spare is available). This (again) raises the question if
sourceforge is the appropriate place for our cvs repository.
Does anybody have better experiences with other sites like sourceforge?
Niels Nes
--
Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl
Thank you everyone for your responses. I am working on a project on persistant storage of XML documents. Where I have simultaneously query multiple XML documents that are persistantly stored (but not cached) in a database like monetdb. I do all the querying using JDBC. I was wondering if there is any way that I can storage the XMLdocuments through my program rather than explicitly storing them using the shred_doc() before the execution of the program. Once again Thank you all.
Swati
-----Original Message-----
From: Stefan Manegold <Stefan.Manegold(a)cwi.nl>
To: Swati Tata <swtata(a)uky.edu>, monetdb-developers(a)lists.sourceforge.net
Date: Thu, 16 Mar 2006 11:04:46 +0100
Subject: Re: [Monetdb-developers] adding documents to Monetdb
Fabian, Jens,
thanks you very much for providing Swati (and all other readers of this
list) with the detailed information.
Swati (and others),
here's the "missing" bit:
> o Upon each access to a cached document, MonetDB will try to figure out
> if the document has changed since caching it. In particular, it
> verifies file size and timestamp for documents in the local
> filesystem. (I don't know, actually, what the caching system does
> for documents from the network.)
========
# Monet Database Server V4.10.3 # Copyright (c) 1993-2006, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
MonetDB>module(pathfinder);
MonetDB>sigs("pathfinder");
#---------------------------------------------------------#
# signature # name
# str # type
#---------------------------------------------------------#
[ "delete_all_docs(bit) : void" ]
[ "delete_doc(str) : void" ]
[ "pfstart(bit, lng) : void" ]
[ "shred_doc(str, str) : void" ]
[ "xmlcache_add_rule(str, any) : void" ]
[ "xmlcache_del_rule(str) : void" ]
[ "xmlcache_print() : void" ]
[ "xmlcache_print_rules() : void" ]
[ "xmldb_print() : void" ]
[ "xquery(mode str, xquery str, is_url bit) : str " ]
[ "xquery_server(Stream in, Stream out) : void " ]
[ "xquery_start_query_cache(lng) : ptr" ]
MonetDB>help("xmlcache_add_rule");
PROC: xmlcache_add_rule(str, lng) : void
no text available
PROC: xmlcache_add_rule(str, any) : void
MODULE: pathfinder
COMPILED: by boncz on May 2005
DESCRIPTION:
add a new URI lifetime rule.
The XML document cache keeps indexed copies of documents that where recently
used in the fn:doc(URI) xquery function.
The size of the cache is controlled using the 'xquery_cacheMB' setting in
the 'MonetDB.conf' file.
For file URIs, the cache looks at the last-modification-time of the file on disk
to guarantee that the cached document is still up-to-date for answering queries from.
For other URIs, *lifetime rules* determine how long documents can stay in the cache.
Each lifetime rule consists of a URI prefix and the registered seconds of lifetime.
The rule with longest prefix that matches an URI counts. Specifying a lifetime
of 'int(nil)' seconds means that the URI will *not* be cached at all.
This is also the default if no prefix matches an URI.
The name of a cached document is the same as its location (URI). For explicitly
shredded documents (with 'shred_doc(location,name)'), the name is an 'alias' and
may differ from the URI. Explicitly shredded documents fall outside the XML document
cache; documents are only removed at explicit user request (with 'delete_doc(name)').
MonetDB>
========
Cheers,
Stefan
--
| Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
| CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
| 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
| The Netherlands | Fax : +31 (20) 592-4312 |
---------------------------------------------
Swati Tata
Research Assistant
Advanced Genetic Technology Center (AGTC)
University of Kentucky
Room# 222 Plant Science Building, 1405 Veterans Drive
Lexington, KY 40546-0312
Ph: (859)257-7445 x80740
Email: swtata(a)uky.edu
Hello Everyone,
Is it possible to load the XML documents to MonetDb using a java application? I have been using Shred_doc() from the command line to load the documents. Is there any other method using JDBC.
Thank you,
Swati
---------------------------------------------
Swati Tata
Research Assistant
Advanced Genetic Technology Center (AGTC)
University of Kentucky
Room# 222 Plant Science Building, 1405 Veterans Drive
Lexington, KY 40546-0312
Ph: (859)257-7445 x80740
Email: swtata(a)uky.edu
