Difference between revisions of "SimpleGraph Semantic Media Wiki Module"

From BITPlan E-Bike Wiki
Jump to navigation Jump to search
 
(99 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
;subfooter: [https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2018 SMW CON Fall 2018 Regensburg]
 
;subfooter: [https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2018 SMW CON Fall 2018 Regensburg]
 
</slideshow>
 
</slideshow>
−
==⌘⌘ Intro ==
 
−
# [http://royal-family.bitplan.com/index.php?title=WikiCMS&action=slide SMWCon Fall 2017 Rotterdam - WikiCMS]
 
  
−
[[File:Saturnia_Cascate_del_Mulino.jpg|800px]]
+
=== ⌘⌘ Wolfgang Fahl ===
 +
[[File:Wfjuggling.png|left]]
 +
{|
 +
|-
 +
|colspan="2"|
 +
* [http://semantic-mediawiki.org/wiki/User:WolfgangFahl Wolfgang] [mailto:wf@bitplan.com wf@bitplan.com] is from Willich/Germany.
 +
* I am a teacher for [http://training.bitplan.com/index.php/Software_Architektur_(CPSA-F) software architecture]
 +
* My first contact with MediaWiki was [http://www.waihekepedia.org/index.php/Main_Page about the Waiheke Island community wiki] in 2008
 +
* You'll find the electric vehicles of our company and family on the internet:
 +
|-
 +
| [[File:Ion2017-02-04.png|250px|link=http://ion.bitplan.com/index.php/Ion2017-02-04|Peugeot Ion]]<br>Peugeot Ion
 +
| [[File:Explore2018-06Portobello.png|link=http://ebike.bitplan.com|250px|Giant Explore]]<br>Giant Explore
 +
|}
  
−
Von Markus Bernet - Eigenes Werk, CC BY-SA 2.5, https://commons.wikimedia.org/w/index.php?curid=1137376
+
=== ⌘⌘ Previous SMW Talks ===
  
−
= SPARQL Query =
+
{| class="wikitable"
 +
|-
 +
| [[File:wikicms.png|200px|frame|WikiCMS|link=http://royal-family.bitplan.com/index.php?title=WikiCMS&action=slide]]
 +
Wiki Content Management System
 +
|[[File:QuizcardExample.jpeg|200px|frame|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2016-09&action=slide|Using Semantic MediaWiki for managing quizzes for knowledge examination and evaluation]]
 +
SMW Quiz
 +
| [[File:officelogos.png|200px|frame|Office integragion=|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05&action=slide|Office integration]]
 +
Smart and professional integration of office documents
 +
| [[File:cat20170811_125134.jpg|200px|frame|Introduction to Semantic Concepts|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05-01&action=slide]]
 +
Introduction to Semantic Concepts
 +
[http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05&action=slide smartMediaWiki]
 +
|-
 +
| [[File:IMG 0865 Shark.JPG|200px|frame|SMWCon Fall 2017 Rotterdam|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2017]]
 +
SMWCon Fall 2017 Rotterdam
 +
| [[File:FrauRauscher.png|200px|frame|SWMCon Fall 2016 Frankfurt|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016]]
 +
SWMCon Fall 2016 Frankfurt
 +
| [[File:fcb.png|200px|frame|SMWCon Fall 2015 Barcelona|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2015]]
 +
SMWCon Fall 2015 Barcelona
 +
| [[File:route66.png|200px|frame|SMWCon Spring 2016 St. Louis|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Spring_2015]]SMWCon Spring 2015 St. Louis
 +
|}
 +
 
 +
===⌘⌘ Agenda ===
 +
* What is a Graph?
 +
* The Simple Graph Navigation Language Idea
 +
* What is Apache TinkerPop/Gremlin?
 +
* What is SimpleGraph?
 +
* Example: Planning bike tours
 +
 
 +
===⌘⌘ What is a graph? ===
 +
{{Link|target=Graph}}
 +
<graphviz>
 +
digraph Tuscany {
 +
  Tuscany [ URL="https://en.wikipedia.org/wiki/Tuscany" ]
 +
 +
  Arezzo [ URL="https://en.wikipedia.org/wiki/Province_of_Arezzo" ]
 +
  Florence [ URL="https://en.wikipedia.org/wiki/Province_of_Florence" ]
 +
  Grossetto [ URL="https://en.wikipedia.org/wiki/Province_of_Grosseto" ]
 +
  Livorno [ URL="https://en.wikipedia.org/wiki/Province_of_Livorno" ]
 +
  Lucca [ URL="https://en.wikipedia.org/wiki/Province_of_Lucca" ]
 +
  Massa [ label="Massa and Carrara" URL="https://en.wikipedia.org/wiki/Province_of_Massa_and_Carrara" ]
 +
  Pisa [ URL="https://en.wikipedia.org/wiki/Province_of_Pisa" ]
 +
  Pistoia [ URL="https://en.wikipedia.org/wiki/Province_of_Pistoia" ]
 +
  Prato [ URL="https://en.wikipedia.org/wiki/Province_of_Prato" ]
 +
  Siena [ URL="https://en.wikipedia.org/wiki/Province_of_Siena" ]
 +
 
 +
  Saturnia [ URL="https://en.wikipedia.org/wiki/Saturnia" ]
 +
  BagniDiLucca [ label="Bagni di Lucca" URL="https://de.wikipedia.org/wiki/Bagni_di_Lucca" ]
 +
 
 +
  ThermalBath [URL="https://de.wikipedia.org/wiki/Liste_der_Thermalb%C3%A4der_in_der_Toskana"]
 +
  Provinces [ URL="https://en.wikipedia.org/wiki/Category:Provinces_of_Tuscany"]
 +
 
 +
  ThermalBath -> Saturnia
 +
  ThermalBath -> BagniDiLucca
 +
 
 +
  Saturnia -> Grossetto
 +
  BagniDiLucca -> Lucca
 +
 
 +
  Provinces -> Tuscany
 +
  Tuscany -> ThermalBath
 +
  Arezzo -> Provinces
 +
  Florence  -> Provinces
 +
  Grossetto  -> Provinces
 +
  Livorno  -> Provinces
 +
  Lucca  -> Provinces
 +
  Massa  -> Provinces
 +
  Pisa  -> Provinces
 +
  Pistoia  -> Provinces
 +
  Prato  -> Provinces
 +
  Siena  -> Provinces
 +
}
 +
</graphviz>
 +
 
 +
===⌘⌘ The Simple Graph Navigation Language Idea ===
 +
* [http://wiki.bitplan.com/index.php/SiGNaL SiGNaL]
 +
<graphviz>
 +
digraph EM {
 +
  rankdir="LR"
 +
  Earth [ fontcolor="white"  fontsize="32" URL="https://www.wikidata.org/wiki/Q2" image="Earth200.jpeg" ]
 +
  Moon  [ fontcolor="white"  fontsize="32" URL="https://www.wikidata.org/wiki/Q405" image="Moon200.jpeg" ]
 +
  Moon -> Earth [ label="orbits" fontsize="32"]
 +
}
 +
</graphviz>
 +
 
 +
===⌘⌘ What is Apache TinkerPop/Gremlin? ===
 +
[[File:Gremlin programming language.png|400px]]
 +
{{Link|target=http://tinkerpop.apache.org/|title=Apache Tinkerpop}} is an  Open Source project.
 +
* [https://en.wikipedia.org/wiki/Online_transaction_processing OLTP - Online Transaction Processing - Navigation and Processing]
 +
* [https://en.wikipedia.org/wiki/Online_analytical_processing OLAP - Online Analytical Processing - Queries]
 +
* [https://www.wikidata.org/wiki/Q79972 - Example - Ancestors of King James]
 +
 
 +
==⌘⌘ What is SimpleGraph? ==
 +
[[File:toskana2019planning.png|800px|center|link=http://www.bitplan.com/index.php/SimpleGraph#Module_Hub_and_Spoke]]
 +
 
 +
== ⌘⌘  Example: Planning bike tours ==
 +
[[File:explore2018-06Portobello.png|300px|link=http://ebike.bitplan.com/index.php/Main_Page]]
 +
 
 +
* 2018: [http://wiki.bitplan.com/index.php/SPARQL#Whisky_Distilleries_in_Scotland_by_geographic_coordinates Scotland: Visiting Whisky-distilleries]
 +
* 2019: [http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_in_Italy Tuscany: Visiting hotsprings/thermal bath]
 +
Tools:
 +
* [http://www.bitplan.com/index.php/SimpleGraph-HTML HTML (Web)]
 +
* [http://wiki.bitplan.com/index.php/SimpleGraph-WikiData Wikidata (SPARQL)]
 +
* [http://www.bitplan.com/index.php/SimpleGraph-MediaWiki Mediawiki (Wikipedia)]
 +
* [http://wiki.bitplan.com/index.php/SimpleGraph-SMW Semantic Media Wiki]
 +
* [http://wiki.bitplan.com/index.php/SimpleGraph-Excel Excel]
 +
 
 +
== ⌘⌘  SPARQL Query Hot Springs in Italy ==
 +
[https://query.wikidata.org/#%23%20Find%20Italian%20hot%20springs%20using%20the%20Wikidata%20Query%20service%0A%23%20taken%20from%0A%23%20http%3A%2F%2Fwiki.bitplan.com%2Findex.php%2FSPARQL%23Hotsprings_worldwide%0A%23%20Created%202018-11%20by%20Wolfgang%20Fahl%20BITPlan%20GmbH%0A%23%20%0A%23%20display%20the%20results%20as%20a%20map%0A%23defaultView%3AMap%0A%23%0A%23%20select%20the%20hot%20spring%20and%20its%20coordinates%0ASELECT%20%3Fhotspring%20%3Fcoord%20%3Frange%20WHERE%20%7B%0A%20%20%3Fhotspring%20wdt%3AP31%20wd%3AQ177380.%0A%20%20%3Fhotspring%20%3Frange%20wd%3AQ38.%0A%20%20%3Fhotspring%20wdt%3AP625%20%3Fcoord.%0A%7D%0A try it!]
 +
[[File:MapOfThermalBathsTuscanyWikiData.png|400px|left]]
 
<source lang='sparql'>
 
<source lang='sparql'>
 
# Find Italian hot springs using the Wikidata Query service
 
# Find Italian hot springs using the Wikidata Query service
 +
# display the results as a map
 +
#defaultView:Map
 +
# select the hot spring and its coordinates
 +
SELECT ?hotspring ?coord ?range WHERE {
 +
  ?hotspring wdt:P31 wd:Q177380.
 +
  ?hotspring ?range wd:Q38.
 +
  ?hotspring wdt:P625 ?coord.
 +
}
 +
</source>
 +
 +
== ⌘⌘ SPARQL Query Hotsprings in Tuscany ==
 +
[https://query.wikidata.org/#%23%20Find%20Tuscany%20hot%20springs%20using%20the%20Wikidata%20Query%20service%0A%23%20taken%20from%0A%23%20http%3A%2F%2Fwiki.bitplan.com%2Findex.php%2FSPARQL%23Hotsprings_tuscany%0A%23%20Created%202018-12-07%20by%20Wolfgang%20Fahl%20BITPlan%20GmbH%0A%23%20%0A%23%20display%20the%20results%20as%20a%20map%0A%23defaultView%3AMap%0A%23%0A%23%20select%20the%20hot%20spring%20and%20its%20coordinates%0ASELECT%20%3Fhotspring%20%3Fcoord%20%20WHERE%20%7B%0A%20%20%23%20Ravenna%0A%20%20wd%3AQ13364%20wdt%3AP625%20%3FNECorner%20.%0A%20%20%23%20Aleria%20Corsica%0A%20%20wd%3AQ212399%20%20wdt%3AP625%20%3FSWCorner%20.%0A%20%20%3Fhotspring%20wdt%3AP31%20wd%3AQ177380.%0A%20%20%3Fhotspring%20wdt%3AP625%20%3Fcoord.%0A%20%20SERVICE%20wikibase%3Abox%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP625%20%3Fcoord%20.%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3AcornerSouthWest%20%3FSWCorner%20.%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3AcornerNorthEast%20%3FNECorner%20.%0A%20%20%20%20%7D%0A%7D%0A try it!]
 +
<source lang='sparql'>
 +
# Find Tuscany hot springs using the Wikidata Query service
 
# taken from
 
# taken from
−
# http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_in_Italy
+
# http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_tuscany
−
# Created 2018-11 by Wolfgang Fahl BITPlan GmbH
+
# Created 2018-12-07 by Wolfgang Fahl BITPlan GmbH
 
#  
 
#  
 
# display the results as a map
 
# display the results as a map
Line 24: Line 155:
 
#
 
#
 
# select the hot spring and its coordinates
 
# select the hot spring and its coordinates
−
SELECT ?hotspring ?coord ?range WHERE {
+
SELECT ?hotspring ?coord WHERE {
 +
  # Ravenna
 +
  wd:Q13364 wdt:P625 ?NECorner .
 +
  # Aleria Corsica
 +
  wd:Q212399  wdt:P625 ?SWCorner .
 
   ?hotspring wdt:P31 wd:Q177380.
 
   ?hotspring wdt:P31 wd:Q177380.
−
  ?hotspring ?range wd:Q38.
 
 
   ?hotspring wdt:P625 ?coord.
 
   ?hotspring wdt:P625 ?coord.
 +
  SERVICE wikibase:box {
 +
      ?item wdt:P625 ?coord .
 +
      bd:serviceParam wikibase:cornerSouthWest ?SWCorner .
 +
      bd:serviceParam wikibase:cornerNorthEast ?NECorner .
 +
    }
 
}
 
}
 
</source>
 
</source>
 +
== ⌘⌘ Combining 5 modules ==
 +
[[File:NiftyExcelTrick.png|400px|right]]
 +
 +
#[https://github.com/BITPlan/com.bitplan.simplegraph/blob/master/simplegraph-bundle/src/test/java/com/bitplan/simplegraph/bundle/TestThermalBathInTuscany.java SimpleGraph-Bundle Junit TestCase]
 +
#[[:File:TuscanyPlan2018-12-13.xlsx]]
 +
 +
== ⌘⌘ Outlook: Dragtop ==
 +
[[File:DragTopExample1.png|400px|left]]
 +
The [http://www.bitplan.com/index.php/Dragtop Dragtop Open Source Software] makes the [http://www.bitplan.com/index.php/SimpleGraph SimpleGraph] modules available for direct access from your Desktop.
 +
By simple drag and drop of the input onto the dragtop and then dropping a "tool" onto the dragtop you can combine the module functionality as you see fit.
 +
 +
== ⌘⌘ Questions/Discussion ==
 +
[[File:Bitplanpartner.png]]
 +
<youtube>PiNJZ4vg5ts</youtube>
 +
 +
http://wiki.bitplan.com

Latest revision as of 11:47, 13 December 2018

<slideshow style="bitplan" headingmark="⌘⌘" incmark="…" scaled="true" font="Comic Sans MS, Calibri, cursive" >

title

SimpleGraph Semantic Media Wiki ModuleProfiwikiicon.png
author
Wolfgang Fahl info@bitplan.com
footer
Integrating Semantic Media Wiki with multiple other systems via Apache TinkerPop/Gremlin
subfooter
SMW CON Fall 2018 Regensburg

</slideshow>

⌘⌘ Wolfgang Fahl

Wfjuggling.png
Peugeot Ion
Peugeot Ion 		Giant Explore
Giant Explore

⌘⌘ Previous SMW Talks

WikiCMS

Wiki Content Management System

Using Semantic MediaWiki for managing quizzes for knowledge examination and evaluation

SMW Quiz

Office integration

Smart and professional integration of office documents

Introduction to Semantic Concepts

Introduction to Semantic Concepts smartMediaWiki

SMWCon Fall 2017 Rotterdam

SMWCon Fall 2017 Rotterdam

SWMCon Fall 2016 Frankfurt

SWMCon Fall 2016 Frankfurt

SMWCon Fall 2015 Barcelona

SMWCon Fall 2015 Barcelona

SMWCon Spring 2016 St. Louis
SMWCon Spring 2015 St. Louis

⌘⌘ Agenda

  • What is a Graph?
  • The Simple Graph Navigation Language Idea
  • What is Apache TinkerPop/Gremlin?
  • What is SimpleGraph?
  • Example: Planning bike tours

⌘⌘ What is a graph?

Graph

⌘⌘ The Simple Graph Navigation Language Idea

⌘⌘ What is Apache TinkerPop/Gremlin?

Gremlin programming language.png Apache Tinkerpop is an Open Source project.

⌘⌘ What is SimpleGraph?

Toskana2019planning.png

⌘⌘ Example: Planning bike tours

Explore2018-06Portobello.png

Tools:

⌘⌘ SPARQL Query Hot Springs in Italy

try it!

MapOfThermalBathsTuscanyWikiData.png
# Find Italian hot springs using the Wikidata Query service
# display the results as a map
#defaultView:Map
# select the hot spring and its coordinates
SELECT ?hotspring ?coord ?range WHERE {
  ?hotspring wdt:P31 wd:Q177380.
  ?hotspring ?range wd:Q38.
  ?hotspring wdt:P625 ?coord.
}

⌘⌘ SPARQL Query Hotsprings in Tuscany

try it! 

# Find Tuscany hot springs using the Wikidata Query service
# taken from
# http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_tuscany
# Created 2018-12-07 by Wolfgang Fahl BITPlan GmbH
# 
# display the results as a map
#defaultView:Map
#
# select the hot spring and its coordinates
SELECT ?hotspring ?coord  WHERE {
  # Ravenna
  wd:Q13364 wdt:P625 ?NECorner .
  # Aleria Corsica
  wd:Q212399  wdt:P625 ?SWCorner .
  ?hotspring wdt:P31 wd:Q177380.
  ?hotspring wdt:P625 ?coord.
  SERVICE wikibase:box {
      ?item wdt:P625 ?coord .
      bd:serviceParam wikibase:cornerSouthWest ?SWCorner .
      bd:serviceParam wikibase:cornerNorthEast ?NECorner .
    }
}

⌘⌘ Combining 5 modules

NiftyExcelTrick.png
  1. SimpleGraph-Bundle Junit TestCase
  2. File:TuscanyPlan2018-12-13.xlsx

⌘⌘ Outlook: Dragtop

DragTopExample1.png

The Dragtop Open Source Software makes the SimpleGraph modules available for direct access from your Desktop. By simple drag and drop of the input onto the dragtop and then dropping a "tool" onto the dragtop you can combine the module functionality as you see fit.

⌘⌘ Questions/Discussion

Bitplanpartner.png

http://wiki.bitplan.com

Retrieved from "https://ebike.bitplan.com/index.php?title=SimpleGraph_Semantic_Media_Wiki_Module&oldid=1691"