Hi Gary,

thanks for your report. Using more than one database is indeed a
viable, and recommended, approach. If your data fits into memory, you
could use a single XQuery and the functions provided by the Database
Module [1] in order to directly store the converted data in a second
database.

Reports on other approaches out there are welcome!

Best,
Christian

[1] http://docs.basex.org/wiki/Database_Module
___________________________

> Just thought I'd share a problem I've got and to see if I'm solving it in
> the most efficient way.
>
> One of the XML documents I process contains various attributes which contain
> dates in non xs:date forat, e.g. "2010/1/20", "2010/12/1". In order to use
> the various date functions in XQuery I first need to bulk change all of
> these attribute values so they're in xs:date format.
>
> What I've found is that if I set the UPDINDEX property before I create the
> database, the XQuery function I have to change the date formats takes an age
> to complete. If I don't set it then the function completes pretty quickly. I
> need to use the UPDINDEX setting as I do a lot of updates and queries and I
> don't want to manually have to keep the indexes up to date.
>
> The solution I have at the moment is to create two databases, the first
> doesn't have UPDINDEX set, I load the document, do the date conversion, then
> export to a temporary file. I then create a second database from the
> temporary file, this time with UPDINDEX set. Is there a better/more
> efficient way of doing this?
>
> My date conversion function is this:
>
> declare updating function ts:convertToXsDate()
> {
> for $e in /*:NML/*:COLLECTION/*:ENTRY/@MODIFIED_DATE union
> /*:NML/*:COLLECTION/*:ENTRY/INFO/@RELEASE_DATE union
> /*:NML/*:COLLECTION/*:ENTRY/INFO/@LAST_PLAYED union
> /*:NML/*:COLLECTION/*:ENTRY/INFO/@IMPORT_DATE
> let $dateParts:= tokenize( data($e), "/")
> let $year:= $dateParts[1]
> let $month:= if( string-length($dateParts[2]) = 1) then
> concat("0",$dateParts[2]) else $dateParts[2]
> let $day:= if( string-length($dateParts[3]) = 1) then
> concat("0",$dateParts[3]) else $dateParts[3]
> return
> try
> {
> replace value of node $e with xs:date(concat($year,"-",$month,"-",$day))
> }
> catch FORG0001
> {
> ()
> }
> };
>
>
> Thanks in advance,
> Gary
>
> _______________________________________________
> BaseX-Talk mailing list
> BaseX-Talk@mailman.uni-konstanz.de
> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
>