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 > [email protected] > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > _______________________________________________ BaseX-Talk mailing list [email protected] https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
