Changeset 34791

Timestamp:

2021-02-02T12:00:44+13:00 (3 years ago)

Author:

davidb

Message:

Update to info displayed on about page

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl (modified) (3 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl

@@ -13 +13 @@
 
 
-    <xsl:template name="coll-description">
+  <xsl:template name="coll-description">
+        <div id="about-desc">
+      <h2>Introduction</h2>
+      <p style="padding-bottom: 10px;">
+        The <a href="https://eurovision.tv">Eurovision Song
+        Content</a> is a live-broadcast televised event that
+        was first held in 1956 featuring artists singing original songs from
+        7 countries.  Since then it has grown into an event involving
+        over 40 countries, and streamed all around the world. ...
+        
+      </p>
+
+      <p>
+        The aim of this site is to demonstrate the use the Greenstone3 Digital Library software platform to channel
+        and transform Linked Open Data Resources into an appealing web site for fans of the contest.        
+      </p>
+      
 
       <script type="text/javascript" src="//www.google.com/jsapi"><xsl:text> </xsl:text></script>
           <script type="text/javascript" src="//mgskjaeveland.github.io/sgvizler/v/0.6/sgvizler.js"><xsl:text> </xsl:text></script>
-
+        
       <script type="text/javascript">
         <xsl:text disable-output-escaping="yes">
@@ -46 +62 @@
            data-sgvizler-loglevel="2"
            data-sgvizler-chart-options="title=Number of Songs from each Country"
-           style="width:650px; height:400px; margin-left: auto; margin-right: auto">
+           style="width:650px; height:500px; margin-left: auto; margin-right: auto">
         <xsl:attribute name="data-sgvizler-query">
               SELECT (?country) (COUNT(?country) AS ?freqCount)
@@ -58 +74 @@
         <xsl:text> </xsl:text>
       </div>
+
       
-    </xsl:template>
+      <h2>Technical Development</h2>
+      <p>
+        In terms of how this collection was developed using the Greenstone DL architecture, the starting point is
+        the formulation of a SPARQL query to retrieve from DBpedia entries about all the entrants in the contest
+        over the years:
+        <pre style="background-color: #fff; color: #000; padding: 12px;">
+SELECT ?countries_in_esc_by_year ?country_in_year ?year as ?Year ?country as ?Country ?entrant ?entrant_label as ?Creator ?song ?song_label as ?Title ?was_derived_from as ?WikipediaURL
+WHERE {
+    ?countries_in_esc_by_year skos:broader dbc:Countries_in_the_Eurovision_Song_Contest_by_year.
+
+    ?country_in_year dct:subject ?countries_in_esc_by_year.
+    bind( REPLACE(str(?country_in_year), ".*(\\d{4})", "$1") as ?year).
+    FILTER ( xsd:integer(?year) &lt; 2020).
+
+    ?country_in_year dbp:country ?country.
+
+    ?country_in_year dbp:entrant ?entrant.
+    ?entrant rdfs:label ?entrant_label
+      FILTER (lang(?entrant_label) = 'en').
+
+    ?country_in_year dbp:song ?song.
+    ?song rdfs:label ?song_label
+      FILTER (lang(?song_label) = 'en').
+
+    OPTIONAL {
+      ?song prov:wasDerivedFrom ?was_derived_from
+    }
+}
+ORDER BY DESC(?countries_in_esc_by_year)
+        </pre>
+        
+      </p>
+        
+      <p>
+
+        The resulting SPARQL query result set (JSON format selected for output) is then ingested into a Greenstone DL
+        collection, and used in a variety of ways.
+        For now an (admittedly cryptic) list of technical steps that were developed and/or deployed to
+        provide the functionality encountered in interacting with this site.
+        
+        <ul>
+          <li>New SPARQL plugin for <i>download_from.pl</i> developed, used in GLI to enter the above query</li>
+          <li>New SPARQL <i>Document Processing</i> plugin developed</li>
+          <li>Greenstone3 Apache Jena Triple Store Extension activated</li>
+          <li>SGVizler used to display Google Visualizations such as the pie-chart above.</li>
+          <li>Metadata in document view enhanced through Greenstone Format Statements micro-data</li>
+          <li>Custom <i>interface</i> developed</li>
+        </ul>
+      </p>
+
+      <p>
+        Bullet points above to be expanded upon!
+      </p>
+
+      <p>
+        Viewing the <a download="collectionConfig.xml" href="sites/{$site_name}/collect/{$collName}/etc/collectionConfig.xml">collection configuration file</a> provides
+        a good insight into how all of these technical aspectcs are brought together.
+      </p>
+      
+      <p>
+        Full disclosure as to how the collection all ticks is provided through our
+        Subversion repository.  Topping up our <a href="https//trac.greenstone.org/browser/main/trunk/greenstone3">Greenstone3 code base</a>
+        we have:
+
+        <ul>
+          <li>The site: <a href="https://trac.greenstone.org/browser/main/trunk/model-sites-dev/eurovision-lod">eurovision-lod</a></li>
+          <li>The interface: <a href="https://trac.greenstone.org/browser/main/trunk/model-interfaces-dev/eurovision-lod">eurovision-lod</a></li>
+          <li>The triplestore extension: <a href="https://trac.greenstone.org/browser/gs2-extensions/apache-jena/trunk/src">apache-jena</a></li>
+        </ul>
+        
+        
+      </p>
+
+      <h2>Eurovision LOD SPARQL Endpoint</h2>
+      <p>
+        This Digital Library collection can be queried through this
+        <a href="{$library_name}/collection/{$collName}/page/sparql">SPARQL endpoint</a>
+      </p>
+      
+      <h2>Eurovision LOD Errata</h2>
+      <p>
+        Songs titles and Entrants (artists) that do not resolve to URIs:
+        <ul>
+          <li>
+        <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-songs.html">Problem Songs (titles are string literals)</a>
+          </li>
+          <li>
+        <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-entrants.html">Problem Entrants (artists are string literals)</a>
+          </li>
+          <li>
+        <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-songs-and-entrants.html">Problem Songs and Entrants (both titles and artists are string literals)</a>
+          </li>
+          <li>
+        <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-return-paths-songs-and-entrants.html">Problem 'return paths' for Songs and Entrants (the reverse check that a song entry specifies the dbp:artist as a URI fails)</a>
+          </li>
+        </ul>
+      </p>
+      
+    </div>
+
+    
+  </xsl:template>