August 2021 - BaseX-Talk - mailman.uni-konstanz.de

Can XQuery return unique values present across multiple databases?
by Tamara Marnell 14 Aug '21

14 Aug '21

Short question: Is it possible to write an XQuery FLWOR statement that can return a set of unique values present across multiple databases? Long question: Our new website in development displays EAD finding aids stored across 45 databases in BaseX. I've built "facet" databases that index terms in the EADs from controlled vocabularies like subjects, places, personal names, etc. The indexes follow this structure, where each EAD node contains a unique identifier: <terms type="subject"> <term text="Literature" db="1"> <ead>12345</ead> <ead>67890</ead> </term> <term text="Poetry" db="1"> <ead>abcde</ead> </term> {etc.} </terms> In the search interface, users can select multiple facets to apply to one search. For example, they could browse database 12 for EADs with the subject "Literature" *and* the place "Oregon," etc. I currently use the REST server to run an XQuery file that loops through each selected facet and prints *all* EAD IDs for each submitted term and database. Then after results are returned, I use PHP to count occurences of each EAD and print them only if the total count matches the count of facets used. declare variable $d as xs:string external; declare variable $f as xs:string external; let $db_ids := tokenize($d, '\|') return <facets>{ for $facet in tokenize($f, '\|') let $split := tokenize($facet, ':') let $facet_type := $split[1] let $facet_term := $split[2] let $facet_db := 'facet-' || $facet_type return <facet type="{$facet_type}" term="{$facet_term}">{ for $ead in db:open($facet_db)/terms/term[@text=$facet_term and @db=$db_ids]/ead return $ead }</facet> }</facets> So in the hypothetical example above, I'd pass "12" as d (or multiple selected databases separated by bars) and "subject:Literature|geogname:Oregon" as f, and I'd get back a document like: <facets> <facet type="subject" term="Literature"> <ead>12345</ead> <ead>67890</ead> </facet> <facet type="geogname" term="Oregon"> <ead>12345</ead> </facet> </facets> The count of "12345" will equal the count of the user's selected facets, so that result will be printed, but 67890 will not. Is there a more efficient way to do this? I'd prefer the XQuery to return only the EADs that meet all criteria, so only 12345 would be returned because it's in facet-subject under Literature *and* in facet-geogname under "Oregon," and then I don't have to do any post-processing. -Tamara -- Tamara Marnell IT Manager Orbis Cascade Alliance (orbiscascade.org <https://www.orbiscascade.org/>) Pronouns: she/her/hers

4 4

Pretty-print the -V optimized query? See what indexes are used?
by Jonathan Robie 12 Aug '21

12 Aug '21

Is there a way to pretty-print the optimized query from the -V option? What is the best way to see which indexes are being used? Jonathan

2 1

XProc?
by Jonathan Robie 12 Aug '21

12 Aug '21

What hooks does BaseX provide for XProc? Where can I find examples of BaseX use in an XProc pipeline? Jonathan

3 2

PR for DBA issue
by Marco Lettere 03 Aug '21

03 Aug '21

Dear Christian, I've just submitted a PR [1] that fixes an issue occurring with some combination of browser/proxy and that we stumbled upon in 9.5.3 beta. I attach a picture that shows how it looks like in DBA. To make error disappear it's sufficient to put a . in the query input. We propose to make query parameter optional in signature of RestXQ handling that call. Let us know if any further info is required. Regards, Marco. [1] https://github.com/BaseXdb/basex/pull/2030

1 0