This HTML5 document contains 41 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n11:this

foaf:made

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n10:this

sioc:creator_of

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n15:item

n16:services_of

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n13:this

sioc:creator_of

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n9:VOS

sioc:container_of

n2:VirtSparqlCxmlFacetPivotBridge

atom:entry

n2:VirtSparqlCxmlFacetPivotBridge

atom:contains

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n2:VirtSparqlCxmlImport

sioc:links_to

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n2:VirtSparqlCxmlHtml

sioc:links_to

n2:VirtSparqlCxmlFacetPivotBridge

Subject Item

n2:VirtSparqlCxmlFacetPivotBridge

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:45:51.997388

dcterms:modified

2017-06-29T07:40:51.088024

rdfs:label

VirtSparqlCxmlFacetPivotBridge

foaf:maker

n11:this n21:this

dc:title

VirtSparqlCxmlFacetPivotBridge

opl:isDescribedUsing

n20:rdf

sioc:has_creator

n10:this n13:this

sioc:attachment

n5:jpg n6:jpg n7:jpg

sioc:content

---+Pivot Collections (Part 6) ---++Contents Part 1: [[VirtSparqlCxml][Introduction]] Part 2: [[VirtSparqlCxml][SparqlCxml]] Part 3: [[VirtSparqlCxmlDzcs][SparqlCxml Deep Zoom Collections]] Part 4: [[VirtSparqlCxmlPivotViewer][PivotViewer]] Part 5: [[VirtSparqlCxmlImport][Importing CXML]] Part 6: <nowiki>Facet Pivot Bridge</nowiki> * [[#AncSparqlCxmlFacetPivotBridge][<nowiki>Facet Pivot Bridge</nowiki>]] * [[#AncFpbOverview][Overview]] * [[#AncFpbCxmlTailoring][Tailoring the CXML Output]] * [[#AncFpbPagedCollections][Paged Collections]] * [[#AncFpbLimits][Limits]] * [[#AncMaxCxmlFileSize][Maximum CXML File Size]] * [[#AncMaxSortedTopRows][Collection Truncation & MaxSortedTopRows]] Part 7: [[VirtSparqlCxmlDETs][DETs : Persisting SPARQL Query Results to DAV]] Part 8: [[VirtSparqlCxmlFAQs][Frequently Asked Questions (FAQs)]] Part 9: [[VirtSparqlCxmlGlossary][Glossary]] --- #AncSparqlCxmlFacetPivotBridge ---++<nowiki>Facet Pivot Bridge</nowiki> The Facet Pivot Bridge provides one alternative to the /sparql endpoint and Conductor /sparql UI for CXML generation. It presents a more user-friendly front end for users unfamiliar with SPARQL or not wanting to use it directly. As its name suggests, it forms a bridge between Virtuoso's [[http://docs.openlinksw.com/virtuoso/virtuosospongerfacetinstall.html][Facet Browser]] and Pivot Viewer, through which Pivot collections can be generated directly from search results returned by the [[http://docs.openlinksw.com/virtuoso/virtuosospongerfacent.html][Facets Web Service]]. #AncFpbOverview ---+++Overview The screenshot below shows the standard Facet Browser start screen displayed by the Faceted Search service at /fct. On entering some search text, for example "CEO", and clicking "Search", the Facet Browser displays all entities in the host RDF quad store with any attribute containing the specified text. <img src="%ATTACHURLPATH%/fct_ceo_search_text.jpg" style="wikiautogen"/> If the Facet Pivot Bridge VAD is installed, the result page includes a 'Make Pivot Collection' link for generating a CXML snapshot of the results. When clicked, the Bridge automatically redirects to <nowiki>PivotViewer</nowiki> to display the resulting collection. Adjacent to the 'Make Pivot Collection' link are controls for tailoring the collection. Large collections can be split into pages, a QRcode (matrix bar code) can be included alongside each item's image and URIs can be typed as CXML Strings or Links. <img src="%ATTACHURLPATH%/fpb_results.jpg" style="wikiautogen" width="1000" height="584" /><br/> <a href="%ATTACHURLPATH%/fpb_results.jpg" target="_blank">Click to enlarge</a> Collections generated by the Bridge are saved to a file named <nowiki><code>collection_{timestamp}.cxml</code></nowiki> and placed in virtual directory <nowiki>http://&lt;hostname&gt;/pivot_collections/</nowiki>. The virtual directory maps to the <nowiki>WebDAV</nowiki> folder DAV/pivot_collections. So, the full URI to display a Bridge-created collection in <nowiki>PivotViewer</nowiki> would be something like: * <nowiki><code>http://linkeddata.uriburner.com/PivotViewer/?url=http://linkeddata.uriburner.com/pivot_collections/collection_2010-12-23_16-55-48.cxml</code></nowiki> #AncFpbCxmlTailoring ---+++Tailoring the CXML Output The Facet Pivot Bridge is built atop <nowiki>SparqlCxml</nowiki>. However, because the bridge shields users from the complexities of SPARQL, much of the flexibility of <nowiki>SparqlCxml</nowiki> for controlling the CXML output is necessarily lost. Internally, the bridge uses SPARQL DESCRIBEs rather than SELECTs for CXML generation. Consequently the same restrictions apply as discussed in the comparison of these two query types in section <nowiki>SparqlCxml</nowiki>. Specifically, adjusting the RDF to CXML mapping through SPARQL SELECT reserved query variables is not possible. All customisation of the CXML output must be done through graph virtcxml: #AncFpbPagedCollections ---+++Paged Collections When a collection is split into pages, links to the first, last, next and previous pages are displayed under the 'Related Collections' section of <nowiki>PivotViewer's</nowiki> Info Panel. Depending on the current page position, some of these links may not be displayed. For instance the first and previous links will not be shown if you are already viewing the first page. <img src="%ATTACHURLPATH%/fpb_page_links.jpg" style="wikiautogen"/> #AncFpbLimits ---+++Limits #AncMaxCxmlFileSize ---++++Maximum CXML File Size Experience has shown that the [[VirtSparqlCxmlPivotViewer][PivotViewer]] control can struggle to handle large CXML files. To avoid browser hangs, the Bridge checks the size of a generated CXML file before serving it to <nowiki>PivotViewer</nowiki>. It will report an error if the file size exceeds the configured maximum. By default, this is set to 5MB. To adjust this limit, change the <nowiki>PVT_MAX_CXML_FILE_SIZE</nowiki> entry in the Facet Pivot Bridge configuration table <nowiki>DB.DBA.PIVOT_CFG</nowiki>. #AncMaxSortedTopRows ---++++<nowiki>Collection Truncation & MaxSortedTopRows</nowiki> In order to support paged Pivot collections, a faceted search on the free text "CEO" might result in the Facet Pivot Bridge constructing a query similar to: <verbatim> describe ?s1 where { { select distinct ?s1 where { ?s1 a ?concept . ?s1 ?s1textp ?o1 . ?o1 bif:contains '"CEO"' . } order by ?s1 limit 100 offset 10300 } } </verbatim> to provide, in this instance, the result set for page 104 of the collection, where the chosen page size is 100 items. The "order by/limit/offset" construct used by this query is subject to a Virtuoso limit, <nowiki>MaxTopSortedRows</nowiki>, which may be hit when handling very large collections. <nowiki>MaxSortedTopRows</nowiki> limits the combined size of the limit and offset in an 'order by' query. The default value is 10000. Ordinarily, an error similar to: <verbatim> Error: (22023) SR353: Sorted TOP clause specifies more then 10400 rows to sort. Only 10000 are allowed. Either decrease the offset and/or row count or use a scrollable cursor" </verbatim> might result, but the Facet Pivot Bridge protects against this condition arising by limiting, if necessary, the number of pages in a collection. When such a limit is imposed, the 'Last Page' link in the 'Related Collections' section of <nowiki>PivotViewer's</nowiki> Info Panel will read 'Last Page (collection truncated)'. This condition will only arise when handling very large collections. It can be avoided by increasing the value of the <nowiki>MaxTopSortedRows</nowiki> parameter under the "Parameters" section of the virtuoso.ini configuration file.

sioc:id

4a2164e7c98e0e6fd3045baec7931e75

sioc:link

n2:VirtSparqlCxmlFacetPivotBridge

sioc:has_container

n9:VOS

n16:has_services

n15:item

atom:title

VirtSparqlCxmlFacetPivotBridge

sioc:links_to

n2:VirtSparqlCxmlDzcs n2:VirtSparqlCxml n2:VirtSparqlCxmlGlossary n2:VirtSparqlCxmlDETs n17:html n22:html

atom:source

n9:VOS

atom:author

n11:this

atom:published

2017-06-13T05:45:51Z

atom:updated

2017-06-29T07:40:51Z

sioc:topic

n9:VOS

Subject Item

n2:VirtSparqlCxmlPivotViewer

sioc:links_to

n2:VirtSparqlCxmlFacetPivotBridge