Pivot Collections (Part 5) Contents Part 1: Introduction Part 2: SparqlCxml Part 3: SparqlCxml Deep Zoom Collections Part 4: PivotViewer Part 5: Importing CXML Importing CXML DB.DBA.CXML_TO_RDF_IMPORT_URL() Generated Subject URIs Generated Predicates Predicates for Collection and Item Attributes Predicates for Item Facets Converting Generated Predicates to Common Predicates Part 6: Facet Pivot Bridge Part 7: DETs : Persisting SPARQL Query Results to DAV Part 8: Frequently Asked Questions (FAQs) Part 9: Glossary Importing CXML As well as being able to generate CXML from RDF, Virtuoso provides the facility to do the reverse and generate RDF from imported CXML. The sparql_cxml VAD includes the procedure: DB.DBA.CXML_TO_RDF_IMPORT_URL (in url varchar) Parameters: url : the URL of the CXML file to import Usage examples: DB.DBA.CXML_TO_RDF_IMPORT_URL ('http://content.getpivot.com/Collections/uspresidents/uspresidents.cxml'); DB.DBA.CXML_TO_RDF_IMPORT_URL ('http://www.bluesware.ch/parlament/collection/Parlament.cxml'); DB.DBA.CXML_TO_RDF_IMPORT_URL ('http://pivot.lobsterpot.com.au/Collections/WindowsPhone7Pivot.cxml'); DB.DBA.CXML_TO_RDF_IMPORT_URL ('http://pivot.lobsterpot.com.au/collections/PASSChapters.cxml'); DB.DBA.CXML_TO_RDF_IMPORT_URL ('http://www.wssdemo.com/livepivot/collections/sharepoint/sharepoint.cxml'); The given CXML file is imported into a graph of the same name and can be queried like any other. e.g. DESCRIBE ?s FROM <http://content.getpivot.com/Collections/uspresidents/uspresidents.cxml> where { ?s ?p ?o } SELECT * FROM <http://content.getpivot.com/Collections/uspresidents/uspresidents.cxml> WHERE {?s ?p ?o . ?s virtcxml:FacetImage ?image . } define input:inference "virtrdf-label" DESCRIBE ?s from <http://pivot.lobsterpot.com.au/collections/PASSChapters.cxml> where { ?s ?p ?o } Deep Zoom images associated with the collection are also imported into the DZC_xxx tables used to serve DZIs when generating CXML (see VirtSparqlCxmlDzcs). Imported images are assigned to the virtcxml:FacetImage predicate. This can be used directly with the ?image reserved query variable in SELECT statements used for CXML generation. The second DESCRIBE example above exploits inferencing to use the imported images as images for a new dynamic collection. The virtrdf-label inference context includes an entry: virtcxml:FacetImage owl:equivalentProperty foaf:depiction Graph virtcxml: in turn includes an entry: foaf:depiction a virtcxml:FacetCategoryPattern ; virtcxml:FacetType "Item/@virt:Image" ; virtcxml:FacetDescription "A facet for absolute URI of depiction of a collection item" . with the result that imported images associated with virtcxml:FacetImage automatically have a virtcxml:FacetType of "Item/@virt:Image" and are seen by DESCRIBE as candidate images for the dynamic collection. Generated Subject URIs Each item in the collection receives its own subject URI. The subject URI takes the form: <{collection-URI}#{item-ID}>. e.g. Item #2565 in collection http://www.bluesware.ch/parlament/collection/Parlament.cxml <Collection Name="Das Schweizer Parlament 2010 (aktualisiert am 6. Dez.2010)" SchemaVersion="1.0"> <FacetCategories> <FacetCategory Name="Funktion" Type="String" p:IsFilterVisible="true" p:IsMetaDataVisible="true" p:IsWordWheelVisible="true"/> . . . </FacetCategories> <Items ImgBase="p_deepzoom\p1.dzc"> <Item Id="2565" Name="Abate Fabio" Img="#0" Href="http://www.parlament.ch/d/suche/Seiten/biografie.aspx?biografie_id=801"> . . . is assigned subject URI <http://www.bluesware.ch/parlament/collection/Parlament.cxml#2565> Generated Predicates Predicates for Collection and Item Attributes Item attributes Href, Description etc are mapped to predicates named virtcxml:Facet{attribute-name}, where: prefix virtcxml: <http://www.openlinksw.com/schemas/virtcxml#>