DS Catalog:SPARQL Query Service/example queries: Difference between revisions

Because of this data structure, unlike traditional library catalogs or search interfaces ([https://search.digital-scriptorium.org/ like the one for the DS Catalog]), users may find that SPARQL queries seem at first circuitous in comparison to other search and retrieval systems. This is because graphs databases like the DS Wikibase are queried on the basis of pattern matching for particular entities (items) and relationships between entities. A machine rapidly traverses the graph finding patterns that match the path indicated by the query. For purposes of querying DS data, that means that seemingly disparate elements of DS Records, Manuscripts, and even [https://catalog.digital-scriptorium.org/entity/Q2 Holding Information] (i.e., information about and assigned by the institution that owns and/or contributes data about a manuscript object) may all need to be invoked as part of a constructed queried in order to get solutions to seemingly simple questions (such as which institutions own items with texts authored by Avicenna). Taking some time to understand the items, properties, and linking structures in the DS data model and its substantiation in the DS Wikibase will help to elucidate how queries of this nature can be constructed.

after declaring prefixes, you can type out

Below is a taxonomy of two types of basic queries based on whether the records in the DS Catalog are described by a particular data element in general (e.g., have any author, any assigned genre, or any place of production) or whether the records meet certain criteria (e.g., were produced by a specific author, were assigned a specific genre, or identified as produced in a particular place). The following queries were originally developed by L.P. Coladangelo (DS Catalog and Data Manager) for prototype testing, and adapted by LEADING Fellows Mace Jones and Jade Snelling as part of their fellowship research.  

===TBD===

 

#BIND (wd:Q17 as ?authorityType) # material authority

SELECT ?authorityValue ?authorityValueLabel ?authorityTypeLabel ?DSID ?externalID

BIND (wd:Q6 as ?authorityType) # standard title authority

===Terms (Genres and Subjects)===

This query generates a list of manuscript items which have and have not be classified as [https://catalog.digital-scriptorium.org/wiki/Property:P26 dated]. Classified items will either be [https://catalog.digital-scriptorium.org/wiki/Item:Q14 dated] or [https://catalog.digital-scriptorium.org/wiki/Item:Q15 non-dated]. Items without a classification are pending more information.

SELECT  

?record

?holdingLabel

?link

?recordLabel

WHERE

{

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }

GROUP BY ?record ?holdingLabel ?link ?recordLabel ?datedStatusLabel

ORDER BY DESC (?datedStatusLabel)

==Receipt Generator==

This query generates a list of DS Wikibase items which shows successful ingest of DS Records, creation of Manuscript items / DS IDs, and assignment of Holding information for an institution, to serve as a receipt for data contributions made to the DS Catalog.

<syntaxhighlight lang="SPARQL>

  # Variables for holding values used in the construction of the receipt

  (?holder as ?ds_holding_inst_url)

  (?dsid as ?ds_id)

  (?manuscript as ?ds_manuscript_url)

  (?shelfmark as ?holding_inst_shelfmark)

  (?institutionalID as ?holding_inst_id)

  (?linkToRecord as ?holding_inst_link)

  (?iiifManifest as ?iiif_manifest)

  (?holdingLabel as ?ds_holding)

  (?holding as ?ds_holding_info_url)

  # Specify a holding institution (remove comment tag)

#  BIND (wd:Q28019 as ?holder) # burke - Burke Library at Union Theological Seminary

#  BIND (wd:Q16442 as ?holder) # bpl - Boston Public Library

# BIND (wd:Q27887 as ?holder) # columbia - Columbia University Rare Book and Manuscript Library

#  BIND (wd:Q667 as ?holder) # conception - Conception Abbey

#  BIND (wd:Q825 as ?holder) # csl - State of Calfornia Library

#  BIND (wd:Q858 as ?holder) # cuny - City College of New York

#  BIND (wd:Q18629 as ?holder) # flp - Free Library of Philadelphia

#  BIND (wd:Q868 as ?holder) # grolier - Grolier Club

#  BIND (wd:Q1487 as ?holder) # gts - General Theological Seminary

# BIND (wd:Q17632 as ?holder) # hrc - Harry Ransom Center

#  BIND (wd:Qxxxxx as ?holder) # huntington - The Huntington

#  BIND (wd:Q1521 as ?holder) # indiana - Indiana University

#  BIND (wd:Q6060 as ?holder) # kansas - University of Kansas

#  BIND (wd:Q1123 as ?holder) # nelsonatkins - Nelson-Atkins Museum of Art

#  BIND (wd:Q1914 as ?holder) # nyu - New York University

#  BIND (wd:Q10856 as ?holder) # oregon - University of Oregon

#  BIND (wd:Q374 as ?holder) # penn - University of Pennsylvania

#  BIND (wd:Q12264 as ?holder) # princeton - Princeton University

#  BIND (wd:Q801 as ?holder) # providence - Providence Public Library

#  BIND (wd:Q1101 as ?holder) # rome - American Academy in Rome

#  BIND (wd:Q1936 as ?holder) # rutgers - Rutgers University

#  BIND (wd:Q27854 as ?holder) # shi - Science History Institute

#  BIND (wd:Q1247 as ?holder) # smith - Smith College

#  BIND (wd:Q27869 as ?holder) # wmu - Western Michigan University

   # holding and holding properties

  BIND ( wdt:P9 as ?hasLinkToInstRecord )

  BIND ( wdt:P39 as ?hasHoldingEndDate )

  BIND ( wdt:P1 as ?hasDSID )

  # DS 2.0 Record properties

  BIND ( wdt:P3 as ?describesManuscript )

  BIND ( wdt:P35 as ?hasDateLastUpdated )

  BIND ( wdt:P41 as ?hasIIIFManifest )

              ?hasDSID ?dsid .

  # filter results by a period of time when records were last updated

  FILTER ((?lastUpdated > "2023-01-01"^^xsd:dateTime) && (?lastUpdated < "2024-01-01"^^xsd:dateTime)).

 

==Statement Count Generator==

This query generates a count of the number of statements (triples) in the DS Wikibase matching a particular pattern.

SELECT (COUNT(?string) AS ?stringCount)

 

WHERE {

   ?stringStatement ps:P10 ?string .

     # use "as recorded" property P-value for the data you want to count

    bd:serviceParam wikibase:language "en" .

GROUP BY (?stringCount)

  # this sorts the results by number, and is necessary for COUNT clauses

 

This query generates a list of string values of a particular type of ''as recorded'' data occurring in a DS Record which have not be qualified by an authority value (i.e., reconciled to its linked data equivalent in a Linked Open Vocabulary or Authority). This example uses properties for name data, but any authority enriched data can be queried using a similar query structure.

 

<syntaxhighlight lang="SPARQL">

 

  # where applicable, a label for role information (un-comment roleLabel variable when querying name data to get role information)

 

    ?record p:P14 ?stringStatement .

  # identifies records with statements with corresponding property (change P-value for as recorded value to be queried)

  # identifies statements that have strings with corresponding property (change P-value for as recorded value to be queried)

    FILTER NOT EXISTS { ?stringStatement pq:P17 ?authority . }

  # identifies those statements which have not been enriched with authority values (change P-value for authority file value to be queried)

    #OPTIONAL { ?stringStatement pq:P15 ?role . }

  # only used for name data, un-comment optional clause when querying name data

ORDER BY ASC (?string)